Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: SQL*Net Message to client wait on batch job
Are you sure that the "sql*net wait to client" are the problem? I mean they ARE
a problem, but I can't see that they are responsible for the slowdown as they
would have been there in 8i as well, unless sqr and the 8i database were
running on the same host using two_task protocol and the Oracle 9i database is
now on a different host and you have network latency to deal with.
I noticed that the one select in you trace snipped took 13 seconds elapsed and
cpu, 177,000 consistent reads and 3 physical reads to fetch 3 rows. If that is
an isolated sql it won't be a concern (although 177,000 cr to get 3 rows seems
a bit excessive) but if the sqr is doing 10s or 100s of them they add up.
Compare the plan for this, and other sql, with the plans in 8i. There were lots
of changes in the 9i optimizer and some of them may bite you, particularly in a
Peoplesoft environment.
Quoting Thomas Biju <BThomas_at_br-inc.com>:
> Thank you. Unfortunately, this SQR was working good in Oracle8i and not so =
> good in Oracle9i. So it is "obviously" a database issue. :-)
-- regards Wolfgang Breitling Oracle 7,8,8i,9i OCP DBA Centrex Consulting Corporation www.centrexcc.com ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------Received on Mon Aug 23 2004 - 10:29:04 CDT
![]() |
![]() |