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
- 4595 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 communicate with operating system files from oracle?
what is logical system in sap basis
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
I have kept recovery catalog on same target database and taken backup of target DB to disk. deleted the target DB & tried to restore and revoer DB using the backup on disk but it is not possible, how do we restore & recover DB
how can you implement fine-grained auditing?
what is the role of dip user in our database?
Where do you find the default index fill factor and how to change it? : sql server DBA
what is ora 24313?what is the procedure to exclude that error?
A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
What is the difference between the 2 operating modes of database mirroring? : sql server DBA
What authentication modes does sql server support? : sql server DBA
What are the commands used in dcl? : sql server DBA
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
