Home » Other » General » maximum limits on extents, segments
maximum limits on extents, segments [message #232295] Fri, 20 April 2007 01:26 Go to next message
Dipali Vithalani
Messages: 278
Registered: March 2007
Location: India
Senior Member

hi dear friends,
I read that, the maximum limit on a number of extents in any segment in oracle 10g is 2 billion..
But during yesterday's seminar in our company, one sir was talking about other figure, i.e 256 or 255. Is is the limitation of older version of oracle?

The other thing is :
What is the maximum number of segments in oracle 10g?
I think like this : The segment in oracle is associated with the oracle schema object.. We can create any number of objects as required, so there may be no limitation on number of object.

Am i thinking in a right way?

Please help me clear my understanding..

Regards..
Re: maximum limits on extents, segments [message #234297 is a reply to message #232295] Mon, 30 April 2007 14:31 Go to previous messageGo to next message
andrew again
Messages: 2577
Registered: March 2000
Senior Member
Oracle 7 or so used to have a default max-extents setting that was around 255, but that could be changed. When considering the number of extents, it makes sense to stick within a certain range and not push the limits to whatever the maximum is that the DB allows. Extents up to say 1000 in a segment are traditionally (in 8i, 9i) nothing to worry about. Even if Oracle allows you to have 100k extents in a segment - doesn't mean you should. You'll be in relatively unknown territory and will be the first to encounter bugs & issues.

Allocating & de-allocating extents doesn't come for free. Experiment with truncating a 10000000 extent table to recover the space - it may take a while.

http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:1667293495336







Re: maximum limits on extents, segments [message #234299 is a reply to message #232295] Mon, 30 April 2007 14:40 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
All database limit are there: http://download-uk.oracle.com/docs/cd/B19306_01/server.102/b14237/limits.htm#i287876

Regards
Michel
Re: maximum limits on extents, segments [message #234325 is a reply to message #234299] Mon, 30 April 2007 17:45 Go to previous messageGo to next message
Dipali Vithalani
Messages: 278
Registered: March 2007
Location: India
Senior Member

Great,
After 11 day, at least got the reply...
Thanks for that..
And there is no limit on the number of segments. Right?
Re: maximum limits on extents, segments [message #234348 is a reply to message #234325] Tue, 01 May 2007 00:46 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You should get the answer within a minute with a simple search in the doc, as I did.

There is logically no limit but of course you can't have unlimited space, doesn't it?

Regards
Michel
Re: maximum limits on extents, segments [message #234356 is a reply to message #234325] Tue, 01 May 2007 02:11 Go to previous messageGo to next message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
vithalani_dipali wrote on Tue, 01 May 2007 00:45
Great,
After 11 day, at least got the reply...

So you held your breath for 11 days waiting for someone who was willing to read the documentation for you?

MHE
Re: maximum limits on extents, segments [message #234364 is a reply to message #234356] Tue, 01 May 2007 03:14 Go to previous messageGo to next message
Dipali Vithalani
Messages: 278
Registered: March 2007
Location: India
Senior Member

No dear Maaher and Michel,
It was not the lack of information or the laziness to find or read the documentation..
I did that.
But i need to clear the doubt, that's why i was waiting for the reply of the seniors like you for 11 days..

Thanks..

I am still not clear about the limits of the number of segments..

Thanking you
Re: maximum limits on extents, segments [message #234366 is a reply to message #234364] Tue, 01 May 2007 03:23 Go to previous messageGo to next message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
I *think* that it is virtually unlimited. Each table has at least one data segment and the number of tables per database is virtually unlimited. That's the impression I got when I read the documentation.
Of course you have to consider physical limits like memory, disk space, .... .

Now, that was fast, wasn't it? Razz

MHE

[Updated on: Tue, 01 May 2007 03:24]

Report message to a moderator

Re: maximum limits on extents, segments [message #234368 is a reply to message #234366] Tue, 01 May 2007 03:43 Go to previous message
Dipali Vithalani
Messages: 278
Registered: March 2007
Location: India
Senior Member

yes, quite happy now... Smile Razz
Thanks

[Updated on: Tue, 01 May 2007 03:46]

Report message to a moderator

Previous Topic: problem in printing...
Next Topic: free NFR licenses for Oracle ACEs
Goto Forum:
  


Current Time: Sat Dec 03 05:37:43 CST 2016

Total time taken to generate the page: 0.10585 seconds