MY BUSINESS DAY IS YOU!

SQL> select name, value from v$sysstat 2 where name like 'session%' order by name; NAME VALUE ---------------------------------------------------------------- ---------- session connect time 2.3017E+12 session cursor cache count 1029 session cursor cache hits 1444889 session logical reads 292519432 session pga memory 3589314472 session pga memory max 3822966956 session stored procedure space 0 session uga memory 2.5830E+10 session uga memory max 383812564 9 rows selected.

1. show datafilename : SQL> col NAME for a60 SQL> set lines 200 SQL> select file#, name, status, enabled from v$datafile; 2. show logfile and status logfile : SQL> col MEMBER for a60 SQL> set lines 200 SQL> select * from v$logfile; GROUP# STATUS MEMBER ---------- ------- ------------------------------------------------------------ 1 /oravl02/ORACLE/XLTST8I/log/logXLTST8I_A1.dbf 1 /oravl02/ORACLE/XLTST8I/log/logXLTST8I_A2.dbf 2 /oravl03/ORACLE/XLTST8I/log/logXLTST8I_B1.dbf 2 /oravl03/ORACLE/XLTST8I/log/logXLTST8I_B2.dbf 3 /oravl04/ORACLE/XLTST8I/log/logXLTST8I_C1.dbf 3 /oravl04/ORACLE/XLTST8I/log/logXLTST8I_C2.dbf 6 rows selected. SQL> select * from v$log; GROUP# THREAD# SEQUENCE# BYTES MEMBERS ARC STATUS FIRST_CHANGE# FIRST_TIM ---------- ---------- ---------- ---------- ---------- --- ---------------- ---...