Just recently we have been getting the following (lots) errors on different instances that we have.
ORA-01536: space quota exceeded for tablespace 'xyz'
Can someone direct me to a script that will help me monitor the space quota?
I appreciate all you help!
TS quota monitor
Hi, 16th May 2001 13:56 hrs *******
There are several scripts like this available from third parties.
set verify on
set feedback off
set wrap off
set pagesize 60
set linesize 72
set newpage 0
set space 10
set trimout on
set underline =
set echo off
set termout off
whenever sqlerror exit failure
ttitle center 'TSQUOTA - DBA TS Quotas Report ' skip 1 -
left "PAGE:" sql.pno format 999 -
right CWS_DATE skip 2
col username format A8
col tablespace_name format A14 heading Tablespace
col bytes format 999,999,999
col blocks format 999,999
compute sum of bytes on tablespace_name
compute sum of blocks on tablespace_name
break on tablespace_name skip 1
where tablespace_name <> 'SYSTEM'
order by tablespace_name,
Attitude:Attack every problem with enthusiasam ...as if your survival depends upon it
Click Here to Expand Forum to Full Width