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 |
What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA
What is the dataguard background process??
Where in the Oracle directory tree structure are audit traces placed?
Query processing is slow(eg select query)how will u solve that
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
What is transparent data encryption? : sql server DBA
What purpose does the model database server? : sql server DBA
Explain the difference between $ORACLE_HOME and $ORACLE_BASE.
how to copy(migrate) the database one server to another server without using expdp/impdp how it is possible.
Can you redefine a table online?
What are the commands you'd issue to show the explain plan for "select * from dual"?
SUPPOSE AS A DBA YOU CREATED ONE USER BY DEFAULT HOW MANY PRIVILIZES WILL COME TO USER & WHERE CAN YOU SEE THAT PRIVILIZES.
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)