 |
|
ss
Oracle Tips by Burleson |
Chapter 6 Oracle Tablespace and File
Internals Scripts
sys.v_$log
ORDER BY
thread#,
group#;
SPOOL OFF
PAUSE Press Enter to continue
SET PAGES 22 LINES 80 FEEDBACK ON
CLEAR BREAKS
CLEAR COLUMNS
TTILE OFF
Here is a sample listing:
Switch
Th# Grp# Seq#
BYTES Mem Arc? STATUS Change# Time
--- ----
----- ------- -------- -------- ------- ------------------
1 1
4,489 1048576 2 NO INACTIVE 719114 15-JUN-97
16:54:23
2
4,490 1048576 2 NO INACTIVE 719117 15-JUN-97
16:56:10
3
4,491 1048576 2 NO CURRENT 719120 15-JUN-97
17:02:22
Monitoring Redo Log
Switches
In addition to the alert logs, the frequency of
log switches can also be monitored via the v$log_history and v$archived_log DPTs. A script using these
DPTs for that purpose is shown in below. An example of output from
an archive log switch script is also shown below.
The Oracle script collection contains more than 600 working Oracle scripts. You can download them immediately at this link:
|
