資源描述:
《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)