Re: Tablespaces 100%

Oops .. Forgot to put the link
http://[1]www.geocities.com/dba_assist/dba_scripts/de.html

Run the following script as SYSTEM or any DBA priv accoutn; It will give you breakup of all tbs; Besides it prompts for the USER/SCHEMA name to be investigated. Once the username is supplied , it gives object type Vs Size Vs Tbs breakup. Run this query at regular intervals to see which object is growing and giving you trouble.
HTH
GovindanK
Oracle Certified Professional
On Mon, 6 Sep 2004 07:43:58 -0600 , "Wells, Bryan" <[2]Bryan.Wells_at_sunmed.com> said:
> All -
>
> Being new to dba, I was curious about my tablespaces reaching
100%. This
> is
> a 9i warehouse environment utilizing partitioniing and
transportable
> tablespaces. Would it be normal to see 100% utilizatin on the
> partitioned
> tables? What about the others? I could add a datafile but my
disk space
> is
> shrinking. Probabluy because my tablespaces are growingn eh.
>
> Any information, help would be greatly appreciated.
>
> Bryan S Wells

References

References

1. http://www.geocities.com/dba_assist/dba_scripts/de.html

--
To unsubscribe - mailto:oracle-l-request_at_freelists.org&subject=unsubscribe 
To search the archives - http://www.freelists.org/archives/oracle-l/