oracle的使用心得

《oracle的使用心得》由会员上传分享，免费在线阅读，更多相关内容在行业资料-天天文库。

1、oracle的使用心得oracle的使用心得1、DDL(DataDefinitionLanguage)Command  create,alter,dropobjects;  grant,revokeprivilegesandroles;  establishingauditingoptions;  addcommentstothedatadictionary;  BeforeandaftereachDDLstatement,Oracleimplicitlycommitthecurrenttrans

2、actions.2、DML(DataManipulationLanguage)Command  QueryandModifydatawithinexistingschemaobjects;  DMLstatementsconsistofDELETE,INSERT,SELECTandUPDATEstatements;            EXPLAINPLANstatements;            LOCKTABLEstatements;  UnlikeDDLCommand,acommiti

3、snotimplicit,afterexecuteDDLCommand,mustexecutecommitcommand  tocommitatransaction;3、DynamicPerformanceTables  Thesetablesarecreatedattheinstancestartupandusedtostoreinformationabouttheperformance  oftheinstance.Thisinformationincludesconnectioninform

4、atioion,I/OS,initializationparameter  valuesandsoon..4、ProcedureandFunctionareidenticalexceptthatFounctionarealwaysreturnavalue(Proceduredonot).5、SchemaisacollectionofObjectsthatassociatedwiththeDataBase.6、SGAismadeupof:  DataBaseBuffers;  RedoLogBuff

5、ers;  TheSharedPool;7、TransactionisalogicalunitofworkconsistingofoneormoreSQLstatements,endinginacommitorrollback.8、TheDataBaseThePhysicalLayer（1）Oneormoredatafiles;（2）Twoormoreredologfiles;（3）Oneormorecontrolfiles;TheLogicalLayer（1）Oneormoretablespac

6、es;（2）Thedatabaseschema;9、Thedatabaseisdevidedintooneormorelogicalpiecesknownastablespace;10、RecommendthateveryoneneedDBArolesshouldhaveadifferentaccount,thus,ifauditingisenabled,thereisarecordwhomadethesesystemchanges.11、TheInstanceisthelogicaltermth

7、atreferstothecomponentsnecessarytoaccessthedatainadatabase.12、数据库实例（也称为服务器Server），是用来访问一个数据库文件集的一个存储结构及后台进程的集合。Oralce并行服务器是指一个单独的数据库可以被多个实例访问。13、查询实例名：  selectinstance_namefromv$instance；14、查询动态视图v$waitstat、v$system_event、v$session_event、v$session_wai

8、t和v$buffer_pool_statistics（在Oracle8中通过catperf.sql脚本创建）以获取下面所的统计信息，目的是为了检查服务器进程是否正等待DBWR（对单个会话而言，也对整个数据库而言）。15、(1)SMON：系统监控程序(2)PMON：进程监控程序(3)DBWR：数据库写入程序(4)LGWR：日志写入程序(5)CKPT：检查点进程(6)ARCH：归档日志(7)RECO：恢复进程(8)SNPn：快照进程(9)LCKn：锁定进程(10)Dnnn：调度程序进程