Home » RDBMS Server » Server Administration » EXTENT MANAGEMENT LOCAL AUTOALLOCATE
EXTENT MANAGEMENT LOCAL AUTOALLOCATE [message #554908] Fri, 18 May 2012 14:03 Go to next message
BeefStu
Messages: 208
Registered: October 2011
Senior Member
When a TS is defined like this EXTENT MANAGEMENT LOCAL UNIFORM SIZE 10M
each extent will be 10M.

If I have a tablespace defined as EXTENT MANAGEMENT LOCAL AUTOALLOCATE
is there anyway I can tell how big the next extent will be?

Report message to a moderator

Re: EXTENT MANAGEMENT LOCAL AUTOALLOCATE [message #554909 is a reply to message #554908] Fri, 18 May 2012 14:10 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>is there anyway I can tell how big the next extent will be?
It will be at least as large MAX(BYTES) from DBA_EXTENTS for that tablespace.

Report message to a moderator

Re: EXTENT MANAGEMENT LOCAL AUTOALLOCATE [message #554914 is a reply to message #554908] Sat, 19 May 2012 00:52 Go to previous message
Michel Cadot
Messages: 68732
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
http://www.dba-village.com/village/dvp_forum.OpenThread?ThreadIdA=21844#74868

Regards
Michel

Report message to a moderator

Previous Topic: Oracle 10g server went in hanging condition
Next Topic: catalog.sql & catproc.sql
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Jan 27 03:59:06 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.