Java Mailing List Archive

http://www.dba.5341.com/

Home » Home (12/2007) » oracle l »

Re: log file sync event

Alexander Gorbachev

2006-06-09

Replies:

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@(protected)>:
> >>>
> >>>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


©2008 dba.5341.com - Jax Systems, LLC, U.S.A.