SQL Script Undo Statistics

Updated: 08-Apr-2003
Version: 1.0

Description

This script provides a summary of the values in the v$undostat table. This table records an entry every 10 minutes

Parameters

None

SQL Source

REM Copyright (C) Think Forward.com 1998- 2005. All rights reserved. 

set verify off

var ur_val number
col ur_val NOPRINT new_value ur_val

col max_bytes_per_min form 999,999,999
col avg_bytes_per_min form 999,999,999
col max_undo_space form 9,999 heading "Max Space (Mb)"
col avg_undo_space form 9,999 heading "Avg Space (Mb)"

select value/60 ur_val from v$parameter where name ='undo_retention' ;

spool undostat.lst

SELECT max(undoblks)*8*1024/10 max_bytes_per_min
   ,avg(undoblks)*8*1024/10 avg_bytes_per_min
   ,max(undoblks)*8*1024/10 * &ur_val /1024/1024 max_undo_space
   ,avg(undoblks)*8*1024/10 * &ur_val /1024/1024 avg_undo_space
FROM v$undostat
/

spool off

Return to Index of SQL Scripts

Site Map

General Information : Home | Company Profile | Contact Us | Legal
Database Support : Proactive Support | Pay Per Incident Support
Expert Services : High Availability | Creative Solutions | Training
Build Services : Oracle Installations | Revive your Oracle Setup | Low Cost Development
Free Oracle Resources: DBA Scripts | Oracle Links