Interested to Buy Any Domain ? << Click Here >> for more details...
What view would you use to determine free space in a tablespace?
- 3 Answers
- 9354 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
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
Which autogrowth database setting is good? : sql server DBA
Draft one mock email requesting your non-technical management grant you downtime to (provide justification where applicable) complete the following tasks: (1) Generate statistics on a large table; (2) Generate an RDA – if you don't know what an RDA is please say so. (3) Rename datafiles.
What are the commands you'd issue to show the explain plan for "select * from dual"?
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
What are the recovery models for a database? : sql server DBA
how can you schedule a job in database?
What the different components in replication and what is their use? : sql server DBA
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
What are statistics, under what circumstances they go out of date, how do you update them?
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?
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 is the difference between the 2 operating modes of database mirroring? : sql server DBA
Where would you look for errors from the database engine?
Query processing is slow(eg select query)how will u solve that
