ORACLE教程DBA_les02_instance.ppt

《ORACLE教程DBA_les02_instance.ppt》由会员上传分享，免费在线阅读，更多相关内容在行业资料-天天文库。

1、ManaginganOracleInstanceObjectivesAftercompletingthislesson,youshouldbeabletodothefollowing:IdentifycommondatabaseadministrationtoolsavailabletoaDBACreateandmanageinitializationparameterfilesStartupandshutdownaninstanceMonitorandusediagnosticfilesDatabaseAdminis

2、trationToolsToolDescriptionOracleUniversalInstaller(OUI)Usedtoinstall,upgrade,orremovesoftwarecomponentsRecoveryManager(RMAN)UtilitytobackupandrestoretheOracledatabasePasswordFileUtilityUtilityforcreatingadatabasepasswordfileSQL*PlusAutilitytoaccessdatainanOracl

3、edatabaseOracleEnterpriseManagerAgraphicalinterfaceusedtoadminister,monitor,andtuneoneormoredatabasesSQL*PlusSQL*PlusisanOracletoolthatprovidesthecapabilitytointeractwithandmanipulatethedatabase.Providestheabilitytostartupandshutdownthedatabase,createandrunqueri

4、es,addrows,modifydata,andwritecustomizedreportsSubsetofthestandardSQLlanguagewithspecificaddonsDataDictionaryThedatadictionaryisasetofread-onlytablesandviewsthatrecord,verify,andprovideinformationaboutitsassociateddatabase.DescribesthedatabaseanditsobjectsInclud

5、estwotypesofobjects:BasetablesStoredescriptionofdatabaseCreatedwithCREATEDATABASEDataDictionaryviewsSummarizebasetableinformationCreatedusingcatalog.sqlscriptDataDictionaryContentsThedatadictionaryprovidesinformationabout:LogicalandphysicaldatabasestructureDefin

6、itionsandspaceallocationsofobjectsIntegrityconstraintsUsersRolesPrivilegesAuditingHowtheDataDictionaryIsUsedThedatadictionaryhasthreeprimaryuses:TheOracleserverusesittofindinformationabout:UsersSchemaobjectsStoragestructuresTheOracleservermodifiesitwhenaDDLstate

7、mentisexecuted.UsersandDBAscanuseitasaread-onlyreferenceforinformationaboutthedatabase.DataDictionaryViewCategoriesThedatadictionaryconsistsofthreemainsetsofstaticviewsdistinguishedfromeachotherbytheirscope:DBA:WhatisinalltheschemasALL:WhattheusercanaccessUSER:W

8、hatisintheuser'sschemaDBA_xxxUSER_xxxALL_xxxObjectsownedbythecurrentuserObjectsaccessiblebythecurrentuserAlloftheobjectsinthedatabaseDynamicPerformanceTablesDynamicpe