Home » RDBMS Server » Server Administration » extent size (windows 2000, oracle 9.2.0.8)
extent size [message #323603] Thu, 29 May 2008 00:12 Go to next message
seema.taunk
Messages: 96
Registered: October 2006
Member
Hi all,

Db version : 9.2.0.8 on windows

Will extent size matter to database performance??
I have read somewhere that it doesn't matter.
But somewhere I read that you create separate big tablespace(having extent extent big)for big tables & small for small tables.
But I think that blocks of extents spread anywhere on disk & so it shouldn't matter if no. of extents are more or less.
Am I right??
Will performance of database deteriotes if no. of extents are more than 100?


Re: extent size [message #323605 is a reply to message #323603] Thu, 29 May 2008 00:15 Go to previous messageGo to next message
BlackSwan
Messages: 25033
Registered: January 2009
Location: SoCal
Senior Member
seema.taunk wrote on Wed, 28 May 2008 22:12
Hi all,

Db version : 9.2.0.8 on windows

Will extent size matter to database performance??
I have read somewhere that it doesn't matter.
But somewhere I read that you create separate big tablespace(having extent extent big)for big tables & small for small tables.
But I think that blocks of extents spread anywhere on disk & so it shouldn't matter if no. of extents are more or less.
Am I right??
Will performance of database deteriotes if no. of extents are more than 100?




What do your benchmark comparison tests show?
Re: extent size [message #323609 is a reply to message #323603] Thu, 29 May 2008 00:17 Go to previous messageGo to next message
Michel Cadot
Messages: 64102
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Use a locally managed tablespace with system autoallocate/system extents (unless you have very precise reasons to not do so).

LMT does not suffer from thousands of extents.

Regards
Michel
Re: extent size [message #323611 is a reply to message #323605] Thu, 29 May 2008 00:21 Go to previous message
seema.taunk
Messages: 96
Registered: October 2006
Member
Dear anacedent ,
I haven't done any tests. But I have read it.

Thanks to you all..
Previous Topic: Moving data files.
Next Topic: Split Partitioning a MAX VALUE partition
Goto Forum:
  


Current Time: Fri Dec 02 18:46:08 CST 2016

Total time taken to generate the page: 0.45541 seconds