OraFAQ Forum: Performance Tuning » How much used% we need to keep for this tablespace?

Home » RDBMS Server » Performance Tuning » How much used% we need to keep for this tablespace?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How much used% we need to keep for this tablespace? [message #65855]

Thu, 13 January 2005 09:15

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!

Report message to a moderator

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

Mahesh Rajendran
Messages: 10708
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

Report message to a moderator

Previous Topic:	Count(*) performance
Next Topic:	how to enable tracing via ODBC

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jan 09 06:22:27 CST 2025