| maximum limits on extents, segments [message #232295] |
Fri, 20 April 2007 01:26  |
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  |
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 #234364 is a reply to message #234356] |
Tue, 01 May 2007 03:14 |
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 |
 |
Maaher
Messages: 7065
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? 
MHE
[Updated on: Tue, 01 May 2007 03:24] Report message to a moderator |
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
