What query tells you how much space a tablespace named
"test" is taking up, and how much space is remaining?
- 1 Answers
- 3956 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 to start SQL Server in minimal configuration mode?
how can you find out if a table can be redefined?
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?
Explain about your sql server dba experience? : sql server DBA
What would you do with an "in-doubt" distributed transaction?
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
how can you generate profile of pl/sql applications to identify performance bottlenecks?
What happens on checkpoint? : sql server DBA
What is the default port no on which sql server listens? : sql server DBA
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 operating modes in which database mirroring runs? : 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?
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?
How do you trace the traffic hitting a sql server? : sql server DBA
