Home » RDBMS Server » Server Administration » how to know the default next_extent, pct_increace on tables? (Oracle 9i on Solaris 10)
how to know the default next_extent, pct_increace on tables? [message #280929] Thu, 15 November 2007 03:59 Go to next message
thorin666
Messages: 144
Registered: March 2007
Senior Member

Hi
i have a problem. My boss ask me for the max(next_extent) of each table and tablespace
i was searching on dba_tables, dba_segments, and dba_tablespaces
but i dind nulls values on all that tables
i find that when you create a table, storage clause is not a must,
in this case i think that oracle takes the default or the tablespace default but if you create a tablespace without the storage clause, oracle takes the default next_extent and pct_increase


Does anyone knows how to determine the default next_extent
Re: how to know the default next_extent, pct_increace on tables? [message #280934 is a reply to message #280929] Thu, 15 November 2007 04:07 Go to previous messageGo to next message
Michel Cadot
Messages: 64120
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
If you are using locally managed tablespaces, these parameters are no more used.

Regards
Michel
Re: how to know the default next_extent, pct_increace on tables? [message #280938 is a reply to message #280934] Thu, 15 November 2007 04:10 Go to previous messageGo to next message
thorin666
Messages: 144
Registered: March 2007
Senior Member

Michel Cadot wrote on Thu, 15 November 2007 04:07

If you are using locally managed tablespaces, these parameters are no more used.

Regards
Michel


sorry, yes in my laptop i am using oracle9
but in the clients i have oracle oracle 7 and 8
i think that in the clients are dictionary management


if it's the case, i must to search into dba_tables, after that dba_segment and finaly dba_tablespaces?
or i am wrong?

Regards
Re: how to know the default next_extent, pct_increace on tables? [message #280944 is a reply to message #280938] Thu, 15 November 2007 04:18 Go to previous messageGo to next message
Michel Cadot
Messages: 64120
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
dba_segments.
If null (and dictionary managed tablespace) then table is partitioned, so search for the same thing for the (sub)partitions.

Regards
Michel
Re: how to know the default next_extent, pct_increace on tables? [message #280956 is a reply to message #280934] Thu, 15 November 2007 04:30 Go to previous messageGo to next message
thorin666
Messages: 144
Registered: March 2007
Senior Member

Michel Cadot wrote on Thu, 15 November 2007 04:07

If you are using locally managed tablespaces, these parameters are no more used.

Regards
Michel


Michael, and if is local management? how can i determine the size of the extents?
Re: how to know the default next_extent, pct_increace on tables? [message #280967 is a reply to message #280956] Thu, 15 November 2007 05:00 Go to previous message
Michel Cadot
Messages: 64120
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Depends on the type of your LMT.
UNIFORM: all extents have the same size.
SYSTEM: extent size depends on an internal algorithm that depends on version.

Regards
Michel
Previous Topic: dataabse size
Next Topic: newbie: total memory for an instance?
Goto Forum:
  


Current Time: Tue Dec 06 14:27:19 CST 2016

Total time taken to generate the page: 0.08716 seconds