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 can you initialize log miner?

1 Answers   Oracle,

---

Datapump backup steps?

1 Answers  

---

Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.

1 Answers  

---

What view would you use to determine free space in a tablespace?

3 Answers  

---

How would you determine the time zone under which a database was operating?

2 Answers  

---

What is dcl? : sql server DBA

1 Answers  

---

if monday take full backup and tuesday it was cumulative backup and wednesday we taken incremental backup, thursday some disaster happen then what type of recovery and how it will take?

1 Answers  

---

If you're unsure in which script a sys or system-owned object is created, but you know it's in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?

1 Answers  

---

What would you use to improve performance on an insert statement that places millions of rows into that table?

2 Answers   TCS,

---

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

1 Answers  

---

How can you tell how much space is left on a given file system and how much space each of the file system's subdirectories take-up?

1 Answers  

---

Explain the concept of the DUAL table.

3 Answers  

---