How the status of the Rollback segment can be viewed ?

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

does pl/sql support “overloading”? Explain

788


What is cold backup, hot backup, warm backup recovery?

647


Differentiate nested loop, hash join and merge join.

827


Enlist the disadvantages of query.

954


Define database model.

835


Explain top-n analysis in DBMS.

1330


What is domain in dbms?

750


What are the five steps of data modeling?

685


What is data in dbms?

706


Where is database data stored?

686


What do you mean by buffer manager?

769


Is it possible to declare or create a cursor for update of table? If yes tell me how?

662


Define object-oriented model.

753


What are the limitations of rdbms?

739


What are the different stages in 'data warehousing'?

699