SQL Script High Water Mark Statistics

Updated: 20-Jul-2005
Version: 1.1

Description

Displays the Database High Water mark setting of certain database features.

Parameters

None

SQL Source

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

set pages 300

col description form a40 wrap
col name form a15 

spool hwm.lst

select name, highwater, last_value, description
from dba_high_water_mark_statistics ;

col name form a45

select name, first_usage_date, detected_usages
from dba_feature_usage_statistics
where currently_used = 'TRUE' ;
 
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