Sign Up Login


  1. Categories >> Software >> Databases >> Database Management
  2. Suggest New Category

How the status of the Rollback segment can be viewed ?

Question Posted / guest


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

What the default privileges which get assigned ?

0 Answers  

Define fragmentation.

0 Answers  

what is dba_segment

4 Answers  

What do you mean by checkpoints in dbms?

0 Answers  

What is a key in database?

0 Answers  

wat is meant by oracle

3 Answers   Infosys,

What is the use of PARFILE option in EXP command ?

1 Answers  

Compare non-clustered and clustered index

0 Answers  

What do you mean by cardinality and its types?

0 Answers  

What is 3 level architecture dbms?

0 Answers  

What do you mean by index hunting?

0 Answers  

State some commands of ddl in dbms?

0 Answers  

For more Database Management Interview Questions Click Here
Categories