How the status of the Rollback segment can be viewed ?



How the status of the Rollback segment can be viewed ?..

Answer / guest

select SEGMENT_NAME,
OWNER,
TABLESPACE_NAME,
SEGMENT_ID,
FILE_ID,
BLOCK_ID,
INITIAL_EXTENT,
NEXT_EXTENT,
MIN_EXTENTS,
MAX_EXTENTS,
PCT_INCREASE,
STATUS,
INSTANCE_NUM
from dba_rollback_segs
order by SEGMENT_NAME

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More Database Management Interview Questions

From which command ENQUEUE_RESOURCES parameter information is derived from ?

1 Answers  


What is sonicmq?

1 Answers  


What is dbms used for?

1 Answers  


What is use of dbms?

1 Answers  


What does you mean by s4 super key?

1 Answers  


What are notification services?

1 Answers  


How to use multiple database server in back end ?

1 Answers   MCN Solutions,


Is dynamodb a document database?

1 Answers  


Difference between file system and relational database.

1 Answers  


Explain what are the types of transparencies?

1 Answers  


why an information gap exists in most organizations.

1 Answers  


How to get a book from database MS access that contain 'i' charactor in it's name like internetbook or networkingbook. what will be java query for this purpose?

1 Answers   PUCIT,


Categories