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 a file in a database?

816

How do I delete a database in phpmyadmin?

842

What are the types of database?

855

List few disadvantages of file processing system.

873

Where is database stored?

822

What's the difference between star and snow flake schema?

974

What do you mean by deadlock dbms?

1024

Explain why an information gap exists in most organizations.

861

Why is foreign key used?

784

Compare a hierarchical and network database model?

930

What is index and also explain types of indexing in dbms?

891

What are the three types of databases?

877

What is pcbs (program communication blocks)?

946

What are the advantages of using Query Strings?

1021

Enlist various types of interactions created by dbms?

923