Well, as usual it depends. In my experience in well designed OLTP
system top event is db_file_sequential_read, some CPU. Of course,
SQL*Net message from client if you look at statspack but surely we
shouldn't ignore it in properly scoped stats collection.
2006/6/9, Kevin Closson <kevinc_at_polyserve.com>:
> >>>
> >>>My experience has been that this is often the top event in a
> >>>well running system. After all, something has to be the top wait.
> >>>
> >>>Keith
>
> yep...sql*net message from client is a good one to shoot for
>
> :-)
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
--
Best regards,
Alex Gorbachev
http://oracloid.blogspot.com
--
http://www.freelists.org/webpage/oracle-l
Received on Fri Jun 09 2006 - 00:38:51 CDT
