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

What are queries in dbms?

694


Explain what are called fat clients and fat servers?

701


What is mean by dbms?

667


Mention the differences between unique key and primary key

641


Is google scholar a database?

692


What is an advantage of a database?

709


Why indexing is used in database?

664


What is 2nf and 3nf?

709


What integrity rules exist in the dbms?

734


Define dml compiler.

808


What are the functions of a database?

690


What is rank in database?

664


What is the purpose of database?

649


Why do we need database normalization?

670


Explain the syntax of named procedure?

762