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.

internal architecture

0 Answers   CSC,

---

Oracle 11g new features?

2 Answers  

---

You're getting high "busy buffer waits" - how can you find what's causing it?

1 Answers  

---

Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracle's. What database recovery options are available? Database is in archive log mode.

0 Answers   Infosys,

---

i need a brief information about db2 dba course and realtime experts if any plz inform me nareshbhupathi93@gmail.com plzzz urgent

1 Answers   TCS,

---

When creating a user, what permissions must you grant to allow them to connect to the database?

3 Answers  

---

Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?

0 Answers  

---

Hot backup procedure?

2 Answers  

---

what is the purpose of catlaog in oracle rman?

2 Answers   Value Labs,

---

what is the role of dip user in our database?

0 Answers  

---

hi, suppose i created one table after few days i did some insert,update how can i know when will i did ddl or dml operation is undergone on that table

3 Answers   IBM,

---

Which dictionary tables and/or views would you look at to diagnose a locking issue?

2 Answers  

---