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 is grd?

0 Answers   Oracle,

---

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

0 Answers  

---

Which types of backups you can take in Oracle? 2. A database is running in NOARCHIVELOG mode then which type of backups you can take? 3. Can you take partial backups if the Database is running in NOARCHIVELOG mode? 4. Can you take Online Backups if the the database is running in NOARCHIVELOG mode?

11 Answers  

---

Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?

0 Answers  

---

What is the difference between clustered and non-clustered index? : sql server DBA

0 Answers  

---

---

What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?

0 Answers  

---

what do you understand by fine-grained auditing?

0 Answers   Oracle,

---

how will you see when the database was started using sql prompt?

2 Answers   IBM,

---

What are the commands used in dcl? : sql server DBA

0 Answers  

---

How can you rebuild an index?

6 Answers  

---

Name a tablespace automatically created when you create a database.

5 Answers  

---

An automatic job running via DBMS_JOB has failed. Knowing only that "it's failed", how do you approach troubleshooting this issue?

1 Answers  

---