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
does pl/sql support “overloading”? Explain
What is cold backup, hot backup, warm backup recovery?
Differentiate nested loop, hash join and merge join.
Enlist the disadvantages of query.
Define database model.
Explain top-n analysis in DBMS.
What is domain in dbms?
What are the five steps of data modeling?
What is data in dbms?
Where is database data stored?
What do you mean by buffer manager?
Is it possible to declare or create a cursor for update of table? If yes tell me how?
Define object-oriented model.
What are the limitations of rdbms?
What are the different stages in 'data warehousing'?