資源描述：
《Oracle學(xué)習(xí)筆記-好處多多.doc》由會(huì)員上傳分享，免費(fèi)在線閱讀，更多相關(guān)內(nèi)容在工程資料-天天文庫。
1、1、DDL(DataDefinitionLanguage)Commandcreate,alter,dropobjects;grant,revokeprivilegesandroles;establishingauditingoptions;addcommentstothedatadictionary;BeforeandaftereachDDLstatement,Oracleimplicitlycommitthecurrenttransactions.2、DML(DataManipulationLanguage)
2、CommandQueryandModifydatawithinexistingschemaobjects;DMLstatementsconsistofDELETE,INSERT,SELECTandUPDATEstatements;EXPLAINPLANstatements;LOCKTABLEstatements;UnlikeDDLCommand,acommitisnotimplicit,afterexecuteDDLCommand,mustexecutecommitcommandtocommitatransac
3、tion;3、DynamicPerformanceTablesThesetablesarecreatedattheinstancestartupandusedtostoreinformationabouttheperformanceoftheinstance.Thisinformationincludesconnectioninformatioion,I/OS,initializationparametervaluesandsoon..4、ProcedureandFunctionareidenticalexce
4、ptthatFounctionarealwaysreturnavalue(Proceduredonot).5、SchemaisacollectionofObjectsthatassociatedwiththeDataBase.6、SGAismadeupof:DataBaseBuffers;RedoLogBuffers;TheSharedPool;7、TransactionisalogicalunitofworkconsistingofoneormoreSQLstatements,endinginacommito
5、rrollback.8、TheDataBaseThePhysicalLayer（1）Oneormoredatafiles;（2）Twoormoreredologfiles;（3）Oneormorecontrolfiles;TheLogicalLayer（1）Oneormoretablespaces;（2）Thedatabaseschema;9、Thedatabaseisdevidedintooneormorelogicalpiecesknownastablespace;10、Recommendthatevery
6、oneneedDBArolesshouldhaveadifferentaccount,thus,ifauditingisenabled,thereisarecordwhomadethesesystemchanges.11、TheInstanceisthelogicaltermthatreferstothecomponentsnecessarytoaccessthedatainadatabase.12、數(shù)據(jù)庫實(shí)例（也稱為服務(wù)器Server），是用來訪問一個(gè)數(shù)據(jù)庫文件集的一個(gè)存儲(chǔ)結(jié)構(gòu)及后臺(tái)進(jìn)程的集合。Oralce并
7、行服務(wù)器是指一個(gè)單獨(dú)的數(shù)據(jù)庫可以被多個(gè)實(shí)例訪問。13、查詢實(shí)例名：selectinstance_namefromv$instance；14、查詢動(dòng)態(tài)視圖v$waitstat、v$system_event、v$session_event、v$session_wait和v$buffer_pool_statistics（在Oracle8中通過catperf.sql腳本創(chuàng)建）以獲取下面所的統(tǒng)計(jì)信息，目的是為了檢查服務(wù)器進(jìn)程是否正等待DBWR（對(duì)單個(gè)會(huì)話而言，也對(duì)整個(gè)數(shù)據(jù)庫而言）。15、(1)SMON：系統(tǒng)監(jiān)控程序(2)
8、PMON：進(jìn)程監(jiān)控程序(3)DBWR：數(shù)據(jù)庫寫入程序(4)LGWR：日志寫入程序(5)CKPT：檢查點(diǎn)進(jìn)程(6)ARCH：歸檔日志(7)RECO：恢復(fù)進(jìn)程(8)SNPn：快照進(jìn)程(9)LCKn：鎖定進(jìn)程(10)Dnnn：調(diào)度程序進(jìn)程(11)Snnn：服務(wù)器進(jìn)程(12)Pnnn：并行查詢服務(wù)器進(jìn)程16、數(shù)據(jù)庫備份之前，若使用了shutdownabort命令，則需要進(jìn)行如下操作，然后才能進(jìn)
