| calculating maxextents for rollback segments. [message #265449] |
Thu, 06 September 2007 06:05  |
muralikumarg
Messages: 33
Registered: August 2005
Location: Chennai
|
Member |
|
|
Dear Gurus,
Could anyone let me know how to arrive at a value for maxextents for rollback segment. I am currently need help in calculate the maxextents value of rollback segment that handles batch jobs.
Could anyone let me know whether any direct formula is available for calculating the value for maxextents.
Regards
Murali
|
|
|
|
|
|
|
|
|
|
| Re: calculating maxextents for rollback segments. [message #265532 is a reply to message #265515] |
Thu, 06 September 2007 10:38  |
 |
Michel Cadot
Messages: 68686
Registered: March 2007
Location: Nanterre, France, http://...
|
Senior Member
Account Moderator |
|
|
If you read the guidelines, you saw that you MUST post your Oracle version FIRST.
You can also set "unlimited_rollback_segments" to true.
Otherwise, the formula is:
SQL> with block_size as (select 1024*power(2,level-1) KB from dual connect by level <= 7)
2 select kb, trunc(kb/16)-7 max_ext
3 from block_size
4 order by kb
5 /
KB MAX_EXT
---------- ----------
1024 57
2048 121
4096 249
8192 505
16384 1017
32768 2041
65536 4089
Where KB is the block size in KB.
Regards
Michel
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
