Home » RDBMS Server » Server Administration » calculating maxextents for rollback segments.
calculating maxextents for rollback segments. [message #265449] Thu, 06 September 2007 06:05 Go to next message
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 #265451 is a reply to message #265449] Thu, 06 September 2007 06:07 Go to previous messageGo to next message
Michel Cadot
Messages: 64153
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Don't use rollback segments, use undo tablespace.

Regards
Michel
Re: calculating maxextents for rollback segments. [message #265515 is a reply to message #265451] Thu, 06 September 2007 09:20 Go to previous messageGo to next message
muralikumarg
Messages: 33
Registered: August 2005
Location: Chennai
Member
Hi Michel,

I am using oracle 8 series where we do not have undo segment.

Regards
Murali
Re: calculating maxextents for rollback segments. [message #265519 is a reply to message #265515] Thu, 06 September 2007 09:37 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi,
Then upgrade your database...why your using desupported database ???


Regards
Taj
Re: calculating maxextents for rollback segments. [message #265532 is a reply to message #265515] Thu, 06 September 2007 10:38 Go to previous message
Michel Cadot
Messages: 64153
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
Previous Topic: Options of starting oracle.........
Next Topic: new database
Goto Forum:
  


Current Time: Sun Dec 11 08:33:59 CST 2016

Total time taken to generate the page: 0.05948 seconds