Re: Tablespaces 100%

Bryan,
You did not say if any of the tablespaces were READ-ONLY. It is wise
space management
to have the READ-ONLY tablespace a close to 100% as possible as they
will not be changing again.
Also If the tablespace as Local Managed Tablespace (LMT) with
autoextent turned on the tablespace 
should show 100% before extending. 
I am sure that you have heard it before but "Disk is cheap" or maybe
you are keeping to much data
online. 
 Investigate the real reason for the 100% tablespace space usage. Has
the database been around for 
a while and the data storage need change? Has the application changed
to increase the storage needs?
Ron

>>> "Wells, Bryan" <Bryan.Wells@xxxxxxxxxx> 09/06/2004 9:43:58 AM >>>
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.

B the nubie
Bryan S Wells
Sunrise Medical
7477 East Dry Creek Parkway
Longmont, CO  80503
Work:  303.218.4380 
Cell:  720.201.1772
Pager:  1060547@xxxxxxxxxx 
Email:  bryan.wells@xxxxxxxxxx 

NOTE:  This message is confidential to Sunrise.  If you are not the
addressee, don't use or distribute this message; and  please notify
the
sender by return e-mail.
--------------------------
Sent from my BlackBerry Wireless Handheld
--
To unsubscribe -
mailto:oracle-l-request@xxxxxxxxxxxxx&subject=unsubscribe 
To search the archives - http://www.freelists.org/archives/oracle-l/
--
To unsubscribe - mailto:oracle-l-request@xxxxxxxxxxxxx&subject=unsubscribe 
To search the archives - http://www.freelists.org/archives/oracle-l/

Other related posts: