What view would you use to determine free space in a tablespace?
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
What is the difference between the 2 operating modes of database mirroring? : sql server DBA
Can you redefine a table online?
What is the importance of a recovery model? : sql server DBA
What the different types of replication and why are they used? : sql server DBA
I have kept recovery catalog on same target database and taken backup of target DB to disk. deleted the target DB & tried to restore and revoer DB using the backup on disk but it is not possible, how do we restore & recover DB
In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?
What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
How do you open a cluster administrator? : sql server DBA
what is the use of recording information about current session?
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?
how can you find out if a table can be redefined?
How can you control the amount of free space in your index pages? : sql server DBA
how can you schedule a job in database?
Where do you find the default index fill factor and how to change it? : sql server DBA