OraFAQ Forum: Server Administration » advice on Extent size in tablespace in 10.2.0.2

Home » RDBMS Server » Server Administration » advice on Extent size in tablespace in 10.2.0.2

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

advice on Extent size in tablespace in 10.2.0.2 [message #176048]

Tue, 06 June 2006 10:39

puneetsachar
Messages: 97
Registered: March 2005
Location: New Delhi, India

Member

Hi

We are migrating to OATM and for that we are creating new tablepsace, could anyone guide how to calculate the extend size for the new table space.

I will be going for option U(niform Extent Size) so all I need to claculate the Uniform Extent Size for the Tablespaces. so that my new tablespace can be utilised well.

Please respond ..

waiting

Puneet

Report message to a moderator

Re: advice on Extent size in tablespace in 10.2.0.2 [message #176060 is a reply to message #176048]

Tue, 06 June 2006 13:12

smartin
Messages: 1803
Registered: March 2005
Location: Jacksonville, Florida

Senior Member

If you have no idea where to start in the extent size estimate, then just use autoallocate; that is what it is for. Over time you can check out the usage and pick a uniform extent size if one shows itself to be more appropriate.

Report message to a moderator

Re: advice on Extent size in tablespace in 10.2.0.2 [message #176162 is a reply to message #176048]

Wed, 07 June 2006 04:16

puneetsachar
Messages: 97
Registered: March 2005
Location: New Delhi, India

Member

hi

i get this by one of my frd but no idea how to start

If you take the table size and divide by the uniform extent size and it should give the number of extent
s. As per your requirement , you can find out what would be best for your databa
se.If you use auto allocate instead it uses a sliding size based on the size of
the table specified.

Report message to a moderator

Previous Topic:	database patches
Next Topic:	oracle partition by list for multiples colonnes

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 11:25:53 CDT 2024