欢迎来到天天文库
浏览记录
ID:48819833
大小:227.00 KB
页数:37页
时间:2020-01-29
《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
此文档下载收益归作者所有