oracle基本技能技巧

《oracle基本技能技巧》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。

1、基本技能常用技巧主要内容Oracle数据库的组成结构管理临时表空间使用SPFILE作为初始化参数文件使用Profile加强数据库安全数据库监控调优-statspack备份Oracle数据库的基本结构2021/10/6Oracle服务器AnOracleserver:Isadatabasemanagementsystemthatprovidesanopen,comprehensive,integratedapproachtoinformationmanagementConsistsofanOracleinstanc

2、eandanOracledatabaseOracleserverPasswordfileOracle服务器的主要组件InstanceSGARedoLogBufferSharedPoolDataDictionaryCacheLibraryCacheDBWRSMONPMONCKPTLGWROthersUserprocessServerprocessPGAControlfilesDatafilesDatabaseDatabaseBufferCacheRedoLogfilesJavaPoolLargePool

3、ParameterfileArchivedLogfilesOracle实例AnOracleinstance:IsameanstoaccessanOracledatabaseAlwaysopensoneandonlyonedatabaseConsistsofmemoryandbackgroundprocessstructuresBackgroundprocessstructuresInstanceSGARedoLogBufferSharedPoolDataDictionaryCacheLibraryCache

4、DBWRSMONPMONCKPTLGWROthersDatabaseBufferCacheJavaPoolLargePoolMemorystructuresOracleDatabaseAnOracledatabase:IsacollectionofdatathatistreatedasaunitConsistsofthreefiletypesPasswordfileParameterfileArchivedLogfilesControlfilesDatafilesRedoLogfilesOracleDatab

5、aseOracleserverOracledatabaseOracleinstance:DatafilesDatafileRedologControlfileParameterfilePasswordfileArchivedfileSGABackgroundprocessSharedpoolDatafilepoolRedologbufferpoolDatabasewriterLogwriterSystemmonitorProcessormonitorCheckpofintprocess数据库空间==〉表空间（由

6、一个或多个数据文件组成）存放数据对象（表、索引、函数、、、）==〉segment==〉extent服务器进程test:/oracle>ps-ef

7、greporacleoracle290415023798660Jan27-0:06oracletest(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))oracle38667221008:50:21-0:00oracletest(LOCAL=NO)oracle38708461011:34:20-0:00oraclete

8、st(LOCAL=NO)oracle38953881002:37:35-0:00oracletest(LOCAL=NO)oracle39036521020:14:28-1:28oracletest(LOCAL=NO)进程的所有者通常为oracle用户进程的名称为：oracleSID可以被安全的kill服务器进程test:/oracle>topas或psaux

9、greporacleNamePIDCPU%PgSpOwneroracle56124636.67.1oracleoracle27116446.72.3rat

10、eoracle33587742.07.4oracleoracle4546980.116.1oracle察看TopCPU进程找到该进程的SID服务器进程--杀死服务器进程ps-ef

11、grep-vgrep

12、grepLOCAL=NO

13、awk'{print$2}'

14、xargskill-9杀死服务器进程，以加快实例的关闭后台进程test:/oracle>ps-ef

15、grepora_oracle4