Eason [資料科學//Python學習/資料庫] & [拍片&剪片]

  

 

參考:

http://blog.itpub.net/12679300/viewspace-1124357/

 

select * from v$log;

select * from v$logfile;

SELECT a.sid, decode(b.class,1,'User',2,'Redo',4,'Enqueue',8,'Cache',16,'OS',32,'ParallelServer',64,'SQL',128,'Debug',72,'SQL Cache',40,'ParallelServer Cache') class,
b.name, a.value
from v$sesstat a, v$statname b
where a.statistic# = b.statistic#