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
- 4515 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 many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database? : sql server DBA
what is asm?
What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA
What is a correlated sub-query? : sql server DBA
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.
how does an oracle clusterware manage crs resources?
what is ora 24313?what is the procedure to exclude that error?
How to start SQL Server in minimal configuration mode?
what functionality does oracle provide to secure sensitive information?
Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down? : sql server DBA
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
What is the default port no on which sql server listens? : sql server DBA
What the different components in replication and what is their use? : sql server DBA
