Home » RDBMS Server » Performance Tuning » Advice
Advice [message #176412] Thu, 08 June 2006 04:15 Go to next message
puneetsachar
Messages: 97
Registered: March 2005
Location: New Delhi, India
Member
What is differenec between creating a tablespace with uniform extend or with auto allocate extend while going for OATM.

Puneet

Report message to a moderator

Re: Advice [message #176453 is a reply to message #176412] Thu, 08 June 2006 06:19 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
quoting the dreaded documentation
Quote:

Simplified space allocation--when the AUTOALLOCATE clause is specified, appropriate extent size is automatically selected.
To create a locally managed tablespace, specify LOCAL in the EXTENT MANAGEMENT clause of the CREATE TABLESPACE statement.
You then have two options. You can have Oracle manage extents for you automatically with the AUTOALLOCATE option (the default),
or you can specify that the tablespace is managed with uniform extents of a specific size (UNIFORM SIZE).

>> OATM
what is that?

Report message to a moderator

Re: Advice [message #176675 is a reply to message #176453] Fri, 09 June 2006 02:53 Go to previous message
JSI2001
Messages: 1016
Registered: March 2005
Location: Scotland
Senior Member
Quote:

>> OATM
what is that?


Over At The Market?
Oracle Automatic Tablespace Management?
Our Allies The Meerkats?
Only Architects Tease Me?

Laughing

Jim

Report message to a moderator

Previous Topic: From where can I get all available SQL tuning HINTS for Oracle?
Next Topic: PL/SQL code review tool
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 26 14:15:33 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.