PL/SQL (MOSC)

MOSC Banner

case when then

edited Feb 18, 2010 2:59AM in PL/SQL (MOSC) 6 commentsAnswered ✓
 Hi, I download the following script print out the usage of the current tablespace in oracle db. how do I make the change to only print out any tablespace with pct_used above 70%, instead of print out everything ? thanks.

=================================================================

REM
REM Script: ts_used.sql
REM
REM Function: Display tablespace usage with graph
REM
REM
column tablespace format a20
column total_GB format 999,999,999,999.99
column used_GB format 999,999,999,999.99
column free_GB format 999,999,999.99
column pct_used format 999.99
column graph format a25 heading "GRAPH (X=5%)"
compute sum of total_GB on report
compute sum of used_GB on report
compute sum of free_GB on report

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center