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;

currently iam working in mnc as a oracleappsdba,please send the EXPERIENCE RESUME those who r worked as a oracle apps dba

1871

---

how can you connect from 10g user to 11g user??

1681

---

what are the differences of where and if in SAS?

1664

---

How do you troubleshoot errors in a sql server agent job? : sql server DBA

567

---

how can you enable flashback feature?

536

---

---

how can you find out if a table can be redefined?

597

---

How can you control the amount of free space in your index pages? : sql server DBA

737

---

What are the different sql server versions you have worked on? : sql server DBA

545

---

What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA

550

---

What are the recovery models for a database? : sql server DBA

593

---

Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down? : sql server DBA

582

---

How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?

1589

---

How do you trace the traffic hitting a sql server? : sql server DBA

843

---

What happens on checkpoint? : sql server DBA

564

---

how can you implement fine-grained auditing?

606

---