What query tells you how much space a tablespace named
"test" is taking up, and how much space is remaining?
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
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
What are the different types of upgrades that can be performed in sql server? : sql server DBA
What is dcl? : sql server DBA
what is logical system in sap basis
who owns the operating system files created by the utl_file package?
internal architecture
You create a private database link and upon
connection, fails with: ORA-2085: connects to
What are the commands used in dcl? : sql server DBA
how can you find out if a table can be redefined?
I got an error SQL1042C. An unexpected system error occurred. Explanation: A system error occurred. One possible reason for this error is that the database manager is not installed correctly or the environment is not set up correctly. On OS/2, while trying to start the database manager, a very common reason for this error is a corrupted NET.ACC file. The command cannot be processed. The tables and views would not be opened. What is the way to open the dataase? pls help me
Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA
What are the different ways you can create databases in sql server? : sql server DBA
What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA
What authentication modes does sql server support? : sql server DBA
how can you record information about current session?