Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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

How the status of the Rollback segment can be viewed ?

Question Posted / guest

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 purpose of database management system?

1105

What do you understand by sub-queries in sql?

989

What is the best free database?

952

How can you perform pattern matching in sql?

1041

what are the differences between network and hierarchical database model?

1170

Explain what are the types of transparencies?

978

Explain the terms specialization and generalization.

994

Differentiate table scan from index scan.

1095

Describe and contrast sql and qbe.

981

write a query to retrieve the last day of next month in oracle.

986

What is maintaining database?

944

How many types of database languages are?

978

How view is related to data independence?

1036

How do you handle your own transaction?

1049

What are different relationships existing in database?

1049