ORA-01536: space quota exceeded

[agilentfg]

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!

[padmam]

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

spool tsquota.rslt

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

select tablespace_name,
username,
bytes,
blocks
from sys.dba_ts_quotas
where tablespace_name <> 'SYSTEM'
order by tablespace_name,
username;

spool off;
exit

Cheers

padmam