Daily correction
SELECT s.paddr, s.sid, s.audsid, s.serial#, s.osuser, s.sql_id
FROM v$session s, v$process p
WHERE s.paddr = p.addr
--AND audsid = userenv('sessionid')
AND EXISTS
(SELECT 1 FROM v$session_longops
WHERE sid = audsid
AND audsid = userenv('sessionid'))
UNION
SELECT s.paddr, s.sid, s.audsid, s.serial#, s.osuser, s.sql_id
FROM v$session s, v$process p
WHERE s.paddr = p.addr
AND EXISTS
(SELECT 1 FROM V$transaction t
WHERE s.paddr =t.addr )
- Check current sql
SELECT b.osuser, b.program, a.MODULE, a.first_load_time, sql_text, rows_processed, sid, serial#
FROM v$sqlarea a , v$session b
WHERE a.address=b.SQL_ADDRESS AND b.osuser IN ('orbit');
- Check long pending session sql
SELECT * FROM v$session_longops where SOFAR < TOTALWORK;
- Online fix
create index idx_DRI_392_DIC_CIF_20110114 on DRI_392_DIC_CIF_20110114(DICCIF_NUMBER) online;
http://blog.163.com/laorenyuhai126@126/blog/static/1935077920103182220853/
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/781883/viewspace-683998/ ，如需转载，请注明出处，否则将追究法律责任。
