Answer / braj123

1.By using statspack report find buffer busy wait events.

2.>select * from V$system_event where event like '%wait%';

3.>select * from v$waitstat;

Solutions:
* Identify and eliminate hot blocks from the application
via changing the PCTFREE and PCTUSED values to reduce the
number of rows per data block.
* Each instance has its own freelist groups.
* Increase the number of rollback segments.

how can you implement fine-grained auditing?

0 Answers   Oracle,

---

What query tells you how much space a tablespace named "test" is taking up, and how much space is remaining?

1 Answers  

---

how can you process messages in order asynchronously?

0 Answers   Oracle,

---

when does an alert gets signaled?

0 Answers   Oracle,

---

what is difference between user managed backup and rman backup?

1 Answers   CTS,

---

---

Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).

0 Answers  

---

I lost one datafile i dont have backup how can you recover that???

2 Answers   HP,

---

What is the dataguard background process??

1 Answers   iGate,

---

What are the different ways you can create databases in sql server? : sql server DBA

0 Answers  

---

what is the use of ocr?

0 Answers   Oracle,

---

What the different types of replication and why are they used? : sql server DBA

0 Answers  

---

Explian different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?

1 Answers  

---