What query tells you how much space a tablespace named
"test" is taking up, and how much space is remaining?
Answer / 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 |
i want export 50gb data in datapump it will take 2 hours time to complete that how can u export that tell me script ???
Explain an ORA-01555
what is the use of recording information about current session?
what functionality does oracle provide to secure sensitive information?
what is the use of home directory???
what is asm?
Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
What are the operating modes in which database mirroring runs? : sql server DBA
What is the importance of a recovery model? : sql server DBA
Explain CREATE DATABASE syntax?
How do you open a cluster administrator? : sql server DBA
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)