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

i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?

0 Answers   IBM,

---

what are the performance views in an oracle rac environment?

0 Answers   Oracle,

---

What's the benefit of "dbms_stats" over "analyze"?

1 Answers  

---

Give the stages of instance startup to a usable state where normal users may access it.

1 Answers  

---

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

0 Answers  

---

---

Describe what redo logs are.

1 Answers  

---

i want export 50gb data in datapump it will take 2 hours time to complete that how can u export that tell me script ???

1 Answers   iGate,

---

Can you redefine a table online?

0 Answers   Oracle,

---

Explain the use of table functions.

1 Answers  

---

Name a tablespace automatically created when you create a database.

5 Answers  

---

Explain the difference between $ORACLE_HOME and $ORACLE_BASE.

3 Answers  

---

What is checkpoint?

3 Answers   Accenture,

---