What view would you use to determine free space in a tablespace?
Answers were Sorted based on User's Feedback
Answer / guest
It is dba_free_space which gives u the info about free
space in any tablespace
Regards
Abhinav
| Is This Answer Correct ? | 9 Yes | 2 No |
Answer / rajesh naidu
SELECT TABLESPACE_NAME,SUM(BYTES/1024/1024) FROM
DBA_FREE_SPACE GROUP BY TABLESPACE_NAME;
AND THE VIEW IS DESC DBA_FREE_SPACE;
| Is This Answer Correct ? | 2 Yes | 2 No |
How would you best determine why your MVIEW couldn't FAST REFRESH?
Query processing is slow(eg select query)how will u solve that
how can you connect from 10g user to 11g user??
What is database replicaion? What are the different types of replication you can set up in SQL Server?
What is the default port no on which sql server listens? : sql server DBA
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 difference between off-line back up and on-line back up in ibm db2 udb?
i had backup last manday.now i need back monday to now ..how do get backup?
What query tells you how much space a tablespace named "test" is taking up, and how much space is remaining?
What is the difference between online backup & offline backup?
how can you enable flashback feature?
How can you rebuild an index?
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)