Current Position:Home > Roll back segment

Roll back segment

Update:11-30Source: network consolidation
Advertisement
Thanks for advance.
I am learing Oracle8 database management. I am wondering if I create 5 roll back seg but only bring one of them online when starting up instance. Are the left four can be brought
online automaticly when the first seg is full?
Or it is a must to wake all roll back seg when you start the instance?
Thanks again.

The Best Answer

Advertisement
You can edit initorcl.ora to increase "transactions" parameter.
The formula of 'rollback segments goes online on restart' = transactions / transactions_per_rollback_segment
RDBMS does not remember what rollback segment was online before restart.
  • How to remove a roll back segment file in 8.1.7 Update:10-11

    Hi, How to remove a roll back segment file in 8.1.7 ? My RBS tablespace has two datafiles, how can I delete one of them ? Thank you.You would a. Create a new tablespace to hold rollback segments b. Create rollback segments in the new tablespace c. Br

  • Managing Undo tablespace & roll back segments Update:11-30

    Hi, I have oracle 9.1 version and have created 5g undo tablespace apart from 20m rbs tablespace for 15 rollback segments. But it is seen that whenever i give UNDO_MANAGEMENT=AUTO then rollback segments are created using undo tablespace and not allowi

  • Dump roll back segment too small Update:11-30

    Hii All, From last week i am getting this dump in my production system. Database error text........: "ORA-01555: snapshot too old: rollback segment number 20 with name "PRS_18" too small#" Internal call code.........: "[RSQL/FTCH/

  • Roll back segment usage Update:11-30

    Hi, i have a script which will report usage of roll back segments in my db, it gives me rb name #, username, and the table/schema. I want to have a script which i can maybe enter a variable into (say, concurrent program id) and then have a list of th

  • Roll back segment Update:11-30

    Thanks for advance. I am learing Oracle8 database management. I am wondering if I create 5 roll back seg but only bring one of them online when starting up instance. Are the left four can be brought online automaticly when the first seg is full? Or i

  • Short dump - reading from roll back segment Update:11-30

    Hi All, I am getting this short dump for few loads.The error is : "(FUNCTION)", or declared in the procedure's RAISING clause.                         To prevent the exception, note the following:                                        Database

  • Roll back segments into READ-ONLY Mode Update:11-30

    To bring an v8 database into READ-ONLY Mode do we need to put the Roll back tablespace RBS also into READ-ONLY Mode?You can put database in READ ONLY mode in Oracle 8i READ ONLY / READ WRITE Example The first statement below opens the database in rea

  • Roll back segments - Oracle 8i Update:11-30

    Hi : i am running my production db on 8i and i am noticing that my roll back tablespace is running out of space. I want to add a datafile to the tablespace. Can i do this while keeping the tablespace online ? - BMPIn Oracle 9i Database and below, you

  • How to online datafile of rollback segment of NO archive log available Update:11-30

    I set offline datafile of rool back segement and rename it but when I try to online , get error to recover I try to recover but unfortunately all archive log was deleted ( kind of cron job in unix aotu delete these file) Pls advice how can I set this

  • Undo segment & Rollback segment Update:11-30

    Hi, What is the difference between Undo segment & Rollback segment?Is it a standard practice of creating roll back segments for each tablespace? Regards, CherryWhat is the difference between Undo segment & Rollback segment? Undo Mode Undo mode pro