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 would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?

1 Answers  

---

what is the purpose of catlaog in oracle rman?

2 Answers   Value Labs,

---

can u plz tell me what r the mandatory skills for getting job as a sql dba......plz send me all details thank you my id :k.mohann.mohan@gmail.com

0 Answers  

---

what is the diffrence between core dba and apps dba?

0 Answers   Cap Gemini,

---

Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?

0 Answers  

---

---

What view would you use to look at the size of a data file?

3 Answers  

---

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

3 Answers  

---

What is blocking and how would you troubleshoot it?

1 Answers  

---

what is logical system in sap basis

0 Answers  

---

how does an oracle clusterware manage crs resources?

0 Answers   Oracle,

---

How do you find out from the RMAN catalog if a particular archive log has been backed-up?

2 Answers   IBM,

---

how can you process messages in order asynchronously?

0 Answers   Oracle,

---