Thank you Sergey ..
Bunyamin K. Karadeniz
Oracle DBA / Developer
Civilian IT Department
Havelsan A.S. Eskisehir yolu
7.km Ankara Turkey
Phone: +90 312 2873565 / 1217
Mobile : +90 535 3357729
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Saturday,
Dear Gurus , I need your help ..
I run UTLBSTAT and then after 2 hour run the
UTLESTAT.sql scripts as internal and look at the report.txt generated
...
On report.txt , I see that
System wide wait events for background processes:
System wide wait events for non-background
processes :
Bunyamin - I went to http://www.google.com http://www.google.com and
searched for utlbstat and received 1,050 results. I would recommend that
you try the same and read up on the resources available over the Internet. I
would also recommend the book Oracle Performance Tuning 101 by Gaja Krishna
Hello Bunyamin,
1) These values are values between starting utlbstat and utlestat (not
from database startup).
2) It's impossible to make all wait events=0. Importance of different
events depends on what database you have (OLTP, DSS, mixed).
Optimims for wait events are zero wait time :-)
You