Home » RDBMS Server » Server Administration » extent size
extent size [message #243607] Fri, 08 June 2007 00:19 Go to next message
risy_s
Messages: 44
Registered: September 2005
Location: Mumbai
Member
how can i calculate the correct extent size for the tablespace ? (oracle9i)

Report message to a moderator

Re: extent size [message #243608 is a reply to message #243607] Fri, 08 June 2007 00:41 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>how can i calculate the correct extent size for the tablespace ? (oracle9i)
Quanify/define "correct"

Report message to a moderator

Re: extent size [message #243614 is a reply to message #243607] Fri, 08 June 2007 00:57 Go to previous message
Michel Cadot
Messages: 68686
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Use AUTOALLOCATE LOCALLY MANAGED TABLESPACE and don't care about your extent size.

Regards
Michel

Report message to a moderator

Previous Topic: Oracle 11g Installation on RHEL 4...OUI issue
Next Topic: How to make the database to store foreighn chars
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Sep 19 22:42:59 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.