解决direct path read 与 direct path write问题
1.这个问题主要与sort有关。2.确定对象的sql:SELECT segment_name, partition_name, p1, p2, wait1.sql_hash_value FROM dba_extents, wait1 WHERE wait1.p2 BETWEEN block_id AND (block_id + blocks - 1) ...
owI 事件的收集
1。首先建立表create table wait1 asSELECT a.SID, a.seq#, a.event, a.p1text, a.p1, a.p1raw, a.p2text, a.p2, a.p2raw, a.p3text, a.p3, a.p3raw, a.wait_time, a.seconds_in_wait, a.state, b.seria...
解决db file sequential read与db file scattered read
1.根据收集的等待事件,分析是那些对象以及对应的sql。2.确定是那些对象,执行如下:SELECT segment_name, partition_name, p1, p2 FROM dba_extents, wait1 WHERE wait1.p2 BETWEEN block_id AND (block_id ...
看看当前某个用户执行什么
SELECT r.name, s.sid, s.serial#, s.username, s.machine, t.status, t.cr_get, t.phy_io, t.used_ublk, t.noundo, substr(s.program, 1, 78) "COMMAND", s.USERNAME "DB User", t.start_time, ...
OWI的等待事件的简单收集
-- Assumption is that you have TOOLS tablespace in your database.-- Create Begin and End tables to store V$SYSTEM_EVENT contents for-- time T1 and T2 to compute delta. -- ============================...