What view would you use to determine free space in a tablespace?
- 3 Answers
- 8563 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
when we login sql editor using username and password then it says this error "could not resolve service name" then what can we do at client side.( here thing is tnsnames.ora file is ok till yesterday and worked well, but now it giving error.
What is fill factor? : sql server DBA
Explain materialized views and how they are used.
What are statistics, under what circumstances they go out of date, how do you update them?
What the different topologies in which replication can be configured? : sql server DBA
What view(s) do you use to associate a user's SQLPLUS session with his o/s process?
what are the benefits of flashback feature?
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
What are the commands you'd issue to show the explain plan for "select * from dual"?
What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA
A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?
what do you understand by fine-grained auditing?
What is the default port no on which sql server listens? : sql server DBA
What are the operating modes in which database mirroring runs? : sql server DBA
Why would you use sql agent? : sql server DBA
