OraFAQ Forum: Server Administration » What is the max number of extents in Locally Manage TBS?

Home » RDBMS Server » Server Administration » What is the max number of extents in Locally Manage TBS?

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

What is the max number of extents in Locally Manage TBS? [message #111773]

Sat, 19 March 2005 15:41

rassabi
Messages: 2
Registered: March 2005

Junior Member

Hi all...

Is the Locally manage tablespace suffer from lack of performance with high number of extents... Let say above 10,000?

Thanks

Report message to a moderator

Re: What is the max number of extents in Locally Manage TBS? [message #111781 is a reply to message #111773]

Sun, 20 March 2005 00:12

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

Senior Member

Try to keep it under 10,000. At one meg each, thats 10 gigs, which is time for partitioning and/or larger extent sizes.

Report message to a moderator

Re: What is the max number of extents in Locally Manage TBS? [message #111789 is a reply to message #111781]

Sun, 20 March 2005 04:32

rassabi
Messages: 2
Registered: March 2005

Junior Member

Do you have experience with large number of extents?
Isn't the locally manage technology solve the extents number issue?

10X

Report message to a moderator

Re: What is the max number of extents in Locally Manage TBS? [message #111794 is a reply to message #111773]

Sun, 20 March 2005 16:46

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

Senior Member

It solves it within reason, but my question would be why 10,000? What is it you are trying to do? What are you planning for and what is your configuration? How many objects do you have and how are they accessed?

My first thought is that if you are trying to deal with 10,000 extents then you are probably doing something else wrong with your system. If you have a 10 gig object, why use 1 meg extents instead of a 32 meg. Why not partition? Why not use table compression and cut everything down in size?

It all depends on your system....

Report message to a moderator

Re: What is the max number of extents in Locally Manage TBS? [message #111974 is a reply to message #111794]

Tue, 22 March 2005 03:23

d.c.b.a
Messages: 44
Registered: March 2005
Location: China

Member

We faced this problem on dictionary managed tablespace, the extent number is about 60k, and we issue truncate table, the session blocked many other session, and take about 4 hours to finish this operation, and I think local management have many enhancement for this operation, but if extent number is too large, it do have some negative affection to the database.

Most of problem occurs when you database have thousands of connections.

Report message to a moderator

Previous Topic:	When is a extent added?
Next Topic:	NLS question?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Apr 07 10:52:24 CDT 2025