Hi all,
could you please clarify me what these might mean (and how to tune the db in order to avoid those).
So I have done a performance report with statspack and the instance is 9.2.0.3 on Solaris8 box. On a report there are a couple of issues I don't understand:
Child Get Spin &
Latch Name Num Requests Misses Sleeps Sleeps 1->4
---------------------- ------- ------------ ----------- ---------- ------------
cache buffers chains p; 609 750,125 572 58 0/0/0/0/0
cache buffers chains 610 641,794 673 38 0/0/0/0/0
cache buffers chains 611 508,147 246 23 0/0/0/0/0
cache buffers chains 608 374,928 96 11 0/0/0/0/0
Latch Name Num Requests Misses Sleeps Sleeps 1->4
---------------------- ------- ------------ ----------- ---------- ------------
cache buffers chains p; 609 750,125 572 58 0/0/0/0/0
cache buffers chains 610 641,794 673 38 0/0/0/0/0
cache buffers chains 611 508,147 246 23 0/0/0/0/0
cache buffers chains 608 374,928 96 11 0/0/0/0/0
and
Top 5 Timed Events
~~~~~~~~~~~~~~~~~~ % Total
Event Waits Time (s) Ela Time
-------------------------------------------- ------------ ----------- --------
direct path write (lob) &nbbsp; 101,116 13,637 38.23
~~~~~~~~~~~~~~~~~~ % Total
Event Waits Time (s) Ela Time
-------------------------------------------- ------------ ----------- --------
direct path write (lob) &nbbsp; 101,116 13,637 38.23
and
Event Waits Timeouts Time (s) (ms) /txn
---------------------------- ------------ ---------- ---------- ------ --------
rdbms ipc message &nnbsp; 218,281 202,375 809,339 3708 0.8
---------------------------- ------------ ---------- ---------- ------ --------
rdbms ipc message &nnbsp; 218,281 202,375 809,339 3708 0.8
Sorry for the mess, but please try to read...
TIA
gb
Want to chat instantly with your online friends? Get the FREE Yahoo! Messenger
