What view would you use to determine free space in a tablespace?
- 3 Answers
- 8568 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database? : sql server DBA
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
what is the use of recording information about current session?
What are the different sql server versions you have worked on? : sql server DBA
how can you implement fine-grained auditing?
How would you best determine why your MVIEW couldn't FAST REFRESH?
what do you understand by fine-grained auditing?
how can you process messages in order asynchronously?
how can you initialize log miner?
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
What are the steps you will take to improve performance of a poor performing query?
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
what is the last version,the release date of that version and fix pack of ibm db2 udb?
What is a system database and what is a user database? : sql server DBA
