oracle巡检手册资料.docx

Oracle巡检手册第一部分数据库状态监控首先检查oracle的log，在sqlplus中：showparameterbackground_dump_dest;select*fromv$diag_info;可以得到日志路径1:检查oracle监听lsnrtclstatusPs–ef|grepora2:检查oracle初始化参数Select*fromv$parameter;3:检查oracle实例状态Selectinstance_name,version,status,database_statusfromv$instance;selectinst_id,instance_name,host_name,VERSION,TO_CHAR(startup_time,yyyy-mm-ddhh24:mi:ss)startup_time,status,archiver,database_statusFROMgv$instance;4:检查后台进程状态：selectname,DescriptionFromv$BGPROCESSWherePaddr005:查看系统全局区SGA信息select*fromv$sga;6:查看SGA各部分占用内存情况：select*fromv$sgastat;selectrequest_misses,request_failuresfromv$shared_pool_re