OraFAQ Forum: Server Administration » calculating maxextents for rollback segments.

Home » RDBMS Server » Server Administration » calculating maxextents for rollback segments.

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

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

Report message to a moderator

Re: calculating maxextents for rollback segments. [message #265451 is a reply to message #265449]

Thu, 06 September 2007 06:07

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Don't use rollback segments, use undo tablespace.

Regards
Michel

Report message to a moderator

Re: calculating maxextents for rollback segments. [message #265515 is a reply to message #265451]

Thu, 06 September 2007 09:20

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

Report message to a moderator

Re: calculating maxextents for rollback segments. [message #265519 is a reply to message #265515]

Thu, 06 September 2007 09:37

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

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

Regards
Taj

Report message to a moderator

Re: calculating maxextents for rollback segments. [message #265532 is a reply to message #265515]

Thu, 06 September 2007 10:38

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Previous Topic:	Options of starting oracle.........
Next Topic:	new database

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 02 07:48:22 CST 2024