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 |
How would you extract DDL of a table without using a GUI tool?
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
What is blocking and how would you troubleshoot it?
How do you resize a data file?
What is the difference between the SQL Loader and IMPORT utilities?
why we use cursors
Give two examples of how you might determine the structure of the table DEPT.
How many memory layers are in the shared pool?
any body know about orawaves do they really provide placements in their unique placement program
How can you gather statistics on a table?
What is a deadlock and what is a live lock? How will you go about resolving deadlocks?
What the different components in replication and what is their use? : 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)