Cycles Redo Log Files
Redo Log Info
Extract TS Information
Archive Log List
CKPT Checkpoint Process
dbw0 Database Writer
Writing Dirty Buffers
Oracle Process Monitor
Database Buffer Cache
Oracle Shared Pool
Redo Log File Sizes
Creating Additional Rollback Segments - Exercise
Creating additional rollback segments
Create initial rollback segments
Create some rollback segments for the COIN database.
This exercise is worth a total of 20 points.
Write the necessary CREATE ROLLBACK SEGMENT commands to create four rollback segments in your database. Use an initial extent size of 256k, a next extent size of 256k, and create the segments with a minimum of two extents each.
After you have submitted your statements to the tutors for grading, you will see my solution. Make any changes that you think are necessary to your statements, and execute them against your COIN database. If you run into any problems, don't hesitate to contact your tutor.
Submitting your exercise
Enter your answers into the text box below. Click the
button to submit your answer.