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
- 4482 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
. 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?
What is the importance of a recovery model? : sql server DBA
what functionality does oracle provide to secure sensitive information?
how can you implement fine-grained auditing?
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
What is the difference between the 2 operating modes of database mirroring? : sql server DBA
how can you communicate with operating system files from oracle?
What are the different types of upgrades that can be performed in sql server? : sql server DBA
If you are given access to a sql server, how do you find if the sql instance is a named instance or a default instance? : sql server DBA
What is dcl? : sql server DBA
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?
What the different topologies in which replication can be configured? : sql server DBA
what is logical system in sap basis
