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...


What query tells you how much space a tablespace named
"test" is taking up, and how much space is remaining?



What query tells you how much space a tablespace named "test" is taking up, and how much ..

Answer / jaleel

TO CHECK TAKINGUP SPACE
SQL> select sum(bytes)/1024/1024 "TABLESPACESIZE:MB"
from dba_segments where tablespace_name='TEST';

TO CHECK FREE SPACE
SQL> select sum(bytes)/1024/1024 "TABLESPACESIZE:MB"
from dba_free_space where tablespace_name='TEST';

Is This Answer Correct ?    3 Yes 0 No

Post New Answer

More DB Administration Interview Questions

how do we explain a project in cognos in an interview? please help me. Also how do we perform testing in cognos after creating reports?

0 Answers   HSBC,


What would you do with an "in-doubt" distributed transaction?

0 Answers  


How would you determine the time zone under which a database was operating?

2 Answers  


what do you understand by flashback feature of oracle?

0 Answers   Oracle,


How would you best determine why your MVIEW couldn't FAST REFRESH?

0 Answers  


How do you add a data file to a tablespace?

3 Answers  


wat is global index and local indes

1 Answers   Oracle,


Explain the use of table functions.

1 Answers  


who owns the operating system files created by the utl_file package?

0 Answers   Oracle,


How can we know the exact updation date of a particular database?

2 Answers   Satyam,


Which types of backups you can take in Oracle? 2. A database is running in NOARCHIVELOG mode then which type of backups you can take? 3. Can you take partial backups if the Database is running in NOARCHIVELOG mode?

1 Answers  


how can you implement fine-grained auditing?

0 Answers   Oracle,


Categories