Search This Blog

Total Pageviews

Friday 15 July 2011

session IO info

SQL> select * from v$sess_io where sid in (select sid from v$session where username is not NULL) order by physical_reads;

SID BLOCK_GETS CONSISTENT_GETS PHYSICAL_READS BLOCK_CHANGES CONSISTENT_CHANGES OPTIMIZED_PHYSICAL_READS
---------- ---------- --------------- -------------- ------------- ------------------ ------------------------
29 0 53 3 0 0 0

Oracle installation logs

Location of Oracle installation logs




Installation logs dir - $ORACLE_HOME/cfgtoologs/oui.

Make.log. Directory is in $ORACLE_HOME/install.

Oracle DBA

anuj blog Archive