select SEGMENT_NAME, OWNER, TABLESPACE_NAME, SEGMENT_ID, FILE

How the status of the Rollback segment can be viewed ?

Question Posted / guest

1 Answers
4790 Views
I also Faced
E-Mail Answers

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 is the difference between case version and decode version?

1090

What is data independence and also explain its types?

976

What is entity and its types?

978

What are good databases?

979

What is data management process?

1006

Explain dml compiler?

1130

What is metadata and why should I use it?

982

What is the largest component of a database?

1369

How to find the size of database?

1101

What is the biggest advantage of rdbms?

1111

Does any body has ORACLE Certification latest Dumps on 1) Oracle - 10g DBA, 2) Oracle - 9i DBA, 3) Oracle - Internet Application Developer, 4) OCA, 5) OCP 8i to 10g DBA Upgrade, 6) Oracle - 10g,7) Other Oracle Certification, if any body has please send it to taruni_2k8@yahoo.com

2705

Can we store images in database?

919

What are the different types of keys in database?

932

What are dml and ddl statements?

1037

What is delimiter in dbms?

952