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';

How would you extract DDL of a table without using a GUI tool?

0 Answers  

---

Typically, where is the conventional directory structure chosen for Oracle binaries to reside?

0 Answers   Patni,

---

What is blocking and how would you troubleshoot it?

1 Answers  

---

How do you resize a data file?

2 Answers  

---

What is the difference between the SQL Loader and IMPORT utilities?

3 Answers  

---

why we use cursors

1 Answers  

---

Give two examples of how you might determine the structure of the table DEPT.

2 Answers  

---

How many memory layers are in the shared pool?

3 Answers  

---

any body know about orawaves do they really provide placements in their unique placement program

1 Answers   TCS,

---

How can you gather statistics on a table?

3 Answers  

---

What is a deadlock and what is a live lock? How will you go about resolving deadlocks?

1 Answers  

---

What the different components in replication and what is their use? : sql server DBA

0 Answers  

---