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
What are queries in dbms?
Explain what are called fat clients and fat servers?
What is mean by dbms?
Mention the differences between unique key and primary key
Is google scholar a database?
What is an advantage of a database?
Why indexing is used in database?
What is 2nf and 3nf?
What integrity rules exist in the dbms?
Define dml compiler.
What are the functions of a database?
What is rank in database?
What is the purpose of database?
Why do we need database normalization?
Explain the syntax of named procedure?