Home » RDBMS Server » Performance Tuning » How much used% we need to keep for this tablespace?
How much used% we need to keep for this tablespace? [message #65855] Thu, 13 January 2005 09:15 Go to next message
Kelly Luo
Messages: 8
Registered: January 2005
Junior Member
The size of this tablespace is 61,801.105M and from 11/8/2004 to 01/3/2005 the used% grows 3.72%, that is 2300M. Can you give me a suggestion on how much used% I should keep for this tablespace? In other words, which used% space this tablespace hit, we need to add more space to this tablespace? Thank you very much!
Re: How much used% we need to keep for this tablespace? [message #65856 is a reply to message #65855] Thu, 13 January 2005 11:17 Go to previous message
Mahesh Rajendran
Messages: 10694
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
upto you.
Depends on how fast the tablepspace grows and how you feel about it.
If the tablespace/schema is active, I prefer to have a minimum of 10% free ( or max 90% utilized).
But that is UPTO ME. NO rules apply
Previous Topic: Count(*) performance
Next Topic: how to enable tracing via ODBC
Goto Forum:
  


Current Time: Sat Sep 19 01:59:36 CDT 2020