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 >> DB Administration
  2. Suggest New Category

What view would you use to determine free space in a tablespace?

Question Posted / guest

Answers were Sorted based on User's Feedback



What view would you use to determine free space in a tablespace?..

Answer / guest

It is dba_free_space which gives u the info about free
space in any tablespace

Regards
Abhinav

Is This Answer Correct ?    9 Yes 2 No

What view would you use to determine free space in a tablespace?..

Answer / shruthi

It is sm$ts_free.......

Is This Answer Correct ?    4 Yes 2 No

What view would you use to determine free space in a tablespace?..

Answer / rajesh naidu

SELECT TABLESPACE_NAME,SUM(BYTES/1024/1024) FROM
DBA_FREE_SPACE GROUP BY TABLESPACE_NAME;

AND THE VIEW IS DESC DBA_FREE_SPACE;

Is This Answer Correct ?    2 Yes 2 No

Post New Answer

More DB Administration Interview Questions

when does an alert gets signaled?

0 Answers   Oracle,

how can you process messages in order asynchronously?

0 Answers   Oracle,

How will u copy the objects of one schema to another schema in datapump & export/import?

1 Answers  

how can you communicate with operating system files from oracle?

0 Answers   Oracle,

what is rebuild index??

2 Answers   IBM, Sapient,

1)how to Take Backup in sql server 2005 from Flash Drive

1 Answers  

Oracle 11g new features?

2 Answers  

how can a session indicate its interest in receiving alerts?

0 Answers   Oracle,

Describe what redo logs are.

1 Answers  

. I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?

0 Answers  

Why would you use sql agent? : sql server DBA

0 Answers  

How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?

0 Answers  

For more DB Administration Interview Questions Click Here
Categories