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?
- 1 Answers
- 4408 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 View All Answers
How can you tell how much space is left on a given file system and how much space each of the file system's subdirectories take-up?
What are the different types of upgrades that can be performed in sql server? : sql server DBA
can u plz tell me what r the mandatory skills for getting job as a sql dba......plz send me all details thank you my id :k.mohann.mohan@gmail.com
How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?
What is the importance of a recovery model? : sql server DBA
How would you go about verifying the network name that the local_listener is currently using?
what is grd?
what are the types of connection load-balancing?
which background process invoke at the time of upgradation tell me???
How do you trace the traffic hitting a sql server? : sql server DBA
I have A,B,C servers.i want to 3 servers jobs move to D server(target server)..how? note: i said that take the backup of msdb and restore to the target server..he said while restoring jobs replaced. what is the solution
Which autogrowth database setting is good? : sql server DBA
What the different components in replication and what is their use? : sql server DBA
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
What is dcl? : sql server DBA
