Answer / jaleel

TO CHECK TAKINGUP SPACE
SQL> select sum(bytes)/1024/1024 "TABLESPACESIZE:MB"
from dba_segments where tablespace_name='TEST';

TO CHECK FREE SPACE
SQL> select sum(bytes)/1024/1024 "TABLESPACESIZE:MB"
from dba_free_space where tablespace_name='TEST';

What are the operating modes in which database mirroring runs? : sql server DBA

0 Answers  

---

What the different topologies in which replication can be configured? : sql server DBA

0 Answers  

---

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

0 Answers  

---

What are the different types of database compression introduced in sql server 2008? : sql server DBA

0 Answers  

---

how can you initialize log miner?

0 Answers   Oracle,

---

What is the dataguard background process??

1 Answers   iGate,

---

what is the diffrence between core dba and apps dba?

0 Answers   Cap Gemini,

---

Give the two types of tables involved in producing a star schema and the type of data theyhold.

2 Answers  

---

how will u see whether the dabase is in archive log mode or not?

2 Answers   CSC,

---

who owns the operating system files created by the utl_file package?

0 Answers   Oracle,

---

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?

0 Answers  

---

Explain about your sql server dba experience? : sql server DBA

0 Answers  

---