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 do you troubleshoot errors in a sql server agent job? : sql server DBA

0 Answers  

---

what is the use of home directory???

1 Answers   HP,

---

what is meant by gateway

1 Answers   IBM,

---

what is ora 24313?what is the procedure to exclude that error?

0 Answers  

---

how can you get actual data change values from previous transactions in oracle?

0 Answers   Oracle,

---

why Datapump is faster than traditional export and import

4 Answers   Mphasis,

---

I want to export only structure of the table from oracle database. In that table to used the some partition. To export the table in general way then compilation error was occured i.e-EXP-00003: no storage definition found for segment(11, 2771). Please tell me the correct export command parameter to export the partitioned table. Thanks in Advance..........

1 Answers  

---

how can you generate profile of pl/sql applications to identify performance bottlenecks?

0 Answers   Oracle,

---

How to bind a cobol module to a given job? I am not able to understand this concept.Can anyone help me out as how to carry out this task?

0 Answers   EDS,

---

Which environment variables are absolutely critical in order to run the OUI?

2 Answers  

---

which background process invoke at the time of upgradation tell me???

0 Answers   iGate,

---

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

0 Answers  

---