DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: rollback segments

  1. #1
    Join Date
    Apr 2001
    Posts
    47

    Red face

    I'm working on Oracle7.1 database in unix platform. In my database on an average
    20 users will be connecting daily. I'm facing a unique problem.

    I'm having 9 rollback segments. And for past few days the rollback segments are getting offline automatically and sometimes getting dropped.

    It is giving lot of overhead when the database is shutdown and restarted. Becuase the init.ora file will refer that segments. And sometimes only system rollback segment is there and all the others are offline or dropped automatically.

    How this is happening and how to avoid that? Or how to prevent that?

    Immediate help please...

  2. #2
    Join Date
    Aug 2001
    Posts
    111
    Hi,

    First check to see who as privileges to perform these type of actions

    Check the dba_role_privs to see if anyone else has the DBA privilege

    select grantee from dba_role_privs
    where granted_role = 'DBA'

    Next alter system privilege DROP ROLLBACK SEGMENT
    also check ALTER ROLLBACK SEGMENT the same way

    select grantee from dba_sys_privs
    where privilege like 'DROP ROLLBACK%'

    If you find someone has the privileges who shouldn't (apart from the IMP_FULL_DATABASE role. Communicate your concerns the offending parties.... be nice ;>

    Next if this is not the problem,
    Check the alert log for any trace files or errors which might have caused this to happen

    I never heard of rbs going offline unless on restart they are no specified correctly in the init.ora file.
    Being dropped automatically sounds fishy.

    This might sound like Oracle Support, but it would be better to get moving on an upgrade, as from the end of September 8.1.7 will the designated stable and free bug fix version.
    Performance... Push the envelope!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width