Well, oraperf is pretty impressive!
I ran my report.txt through it and it basically told me what I suspected -
that I am having issues with SQL*net connections. There are excessive waits
for the client. I posted previous regarding what parameters I can play with
to tune the ODBC/SQL*net portion of this show.
I looked on tahiti and it did not talk about 8.0.6, so I am still looking
for information regarding sql*net and any tuning parameters I can use to
make my system more efficient!
Thanks to everyone who recommended oraperf.com!!!!!
Jerry
"Anton Buijs" <aammbuijs_at_xs4all.nl> wrote in message
news:3dd29de0$0$46612$e4fe514c_at_news.xs4all.nl...
> Visit http://www.oraperf.com You can upload the bstat/estat report.txt
file
> and get an immediate response back including advices and explainations of
> each item of the report.
> Same goes for statspack output.
>
> Jerry D <jdubuke_at_notme.gpdservices.com> schreef in berichtnieuws
> 3dd26650$0$29939$4c41069e_at_reader0.ash.ops.us.uu.net...
> | Hi all,
> | I don't want to appear as though I am trying to get something for
nothing
> | here, but I was wondering if anyone has any info regardgint the bstat
and
> | estat utility dumps? I have a sampling output for 30 minutes and looked
> | through it, but I would like to understand what all the parameters mean.
> Is
> | there documentation for this report available? I would like to verify
> that
> | my database is running efficiently.
> | Thx in advance,
> | Jerry D.
> |
> |
> |
>
Received on Wed Nov 13 2002 - 15:00:24 CST
