select SEGMENT_NAME, OWNER, TABLESPACE_NAME, SEGMENT_ID, FILE

How the status of the Rollback segment can be viewed ?

Question Posted / guest

1 Answers
4706 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

Explain about the properties of cursors?

1024

What is vacuum in database?

872

Give the cobol definition of a varchar field 177 when can an insert of a new primary key value threaten referential integrity?

947

What are the parts of a table?

999

Explain relational algebra?

935

How to unzip a file in ssis?

1065

What are different cursor types in dbms?

1043

What do you know about Master Data & Transaction Info Package?

997

Which free database is best?

856

What are the steps to follow when preparing to create a table?

890

What are the applications of database management system?

891

What are the ways to tune reporting services?

1001

Is sql is a dbms?

910

What is the most popular database?

937

What are the drawback of rdbms?

942