说明：该文档来自网络，为方便查看本人对格式进行了调整，完全为方便大家学习使用。如有侵权请告知。 oracle数据库巡检优化-快速定位数据库瓶颈 数据库巡检或性能优化方法各异，但首要的是要发现数据库性能瓶颈，系统自带的statspack,或awr太耗时， --以下是本人常用的方法，共享之 --1、查询数据库等待事件 top10,关注前几个等待事件，关注前三个等待事件是否有因果或关联关系 --oracle 9i select t2.event, round(100 * t2.time_waited / (t1.w1 + t3.cpu), 2) event_wait_percent from (SELECT SUM(time_waited) w1 FROM v$system_event WHERE event NOT IN ('smon timer', 'pmon timer', 'rdbms ipc message', 'Null event', 'parallel query dequeue', 'pipe get', 'client message', 'SQL*Net message to client', 'SQL*Net message from client', 'SQL*Net moredatafrom client', 'dispatcher timer', 'virtual circuit status', 'lock manager wait for remote message', 'PX Idle Wait', 'PX Deq: Execution Msg', 'PX Deq: Table Q Normal', 'wakeup time manager', 'slave wait', 'i/o slave wait', 'jobq slave wait', 'null event', 'gcs remote message', 'gcs for action', 'ges remote message', 'queue messages')) t1, (select * from (select t.event, t.total_waits, t.total_timeouts, t.time_waited, t.average_wait, rownum num from (select event, total_waits, total_timeouts, time_waited, average_wait from v$system_event where event not in ('smon timer', 'pmon timer', 'rdbms ipc message', 'Null event', 'parallel query dequeue', 'pipe get', 'client message', 'SQL*Net message to client', 'SQL*Net message from client', 'SQL*Net more data from client', 'dispatcher timer', 'virtual circuit status', 'lock manager wait for remote message', 'PX Idle Wait', 'PX Deq: Execution Msg', 'PX Deq: Table Q Normal', 'wakeup time manager', 'slave wait', 'i/o slave wait', 'jobq slave wait', 'null event', 'gcs remote message', 'gcs for action', 'ges remote message', ...
