Interested to Buy Any Domain ? << Click Here >> for more details...
What view would you use to determine free space in a tablespace?
- 3 Answers
- 9425 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
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
What are the different types of database compression introduced in sql server 2008? : sql server DBA
Explain about your sql server dba experience? : sql server DBA
What the different topologies in which replication can be configured? : sql server DBA
Why would you call update statistics? : sql server DBA
suppose you want to audit specific activities on sensitive data. How can you achieve that?
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracle's. What database recovery options are available? Database is in archive log mode.
Can you redefine a table online?
how can you implement fine-grained auditing?
How do you troubleshoot errors in a sql server agent job? : sql server DBA
How can you control the amount of free space in your index pages? : sql server DBA
In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?
what is the diffrence between core dba and apps dba?
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
What the different types of replication and why are they used? : sql server DBA
