Re: Buffer busy waits...

under the $ORACLE_HOME/rdbms/admin directory there are two scripts : utlbstat.sql and utlestat.sql. Statr svrmgrl and connect internal, then run the first,
utlbbstat. Wait an appropriate time (for enough xactions to complete to give an accurate
picture of what's happening) and then run utlestat.sql. This produces a report.txt
file, and this contains (amongst alot of other info), the various buffer waits that are
affecting te system and which class of blocks is having contention. It also has suggestions
on possible remedies.

Neil Cudd.

Wolf Duttlinger-Manger wrote in message <36DFBA56.2921D370_at_hansgrohe.com>...
>Hi all,
>we are running Oracle 7.3.3.4 in an SAP R/3 3.1i environment. We were
>sold R/3 with Oracle being the "black box". Maybe that's why I have all
>these "stupid" questions...
>
>In R/3 Database monitor: Performance history (ST04) I get displayed a
>list of several performance figures - one column being displayed as
>"Buffer Busy Waits" (do not ask me what "they" mean with it...). These
>numbers do exactly correlate with the R/3 "average response time".
>
>From an earlier posting I learned that there are various buffer wait
>types. What would I have to do to get the buffer busy waits info
>directly from Oracle? Has anybody any URL's to point me any further?
>
>Thanks
>Wolf
>
Received on Fri Mar 05 1999 - 07:52:03 CST