Tuning Over a DB Link (redux)
- From: "Uzzell, Stephan" <SUzzell@xxxxxxxxxx>
- To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 19 Feb 2014 18:33:35 +0000
I've asked bits about this before, but I feel like I finally have made some
headway... And I think it points at the DB Link as the culprit in our
performance issue. We managed to trace one of our problem queries today, and we
managed to find the session it spawned in the remote database and trace that
too.
Locally:
SQL*Net message from dblink 1013412 0.51 807.41
SQL*Net more data from dblink 3586 0.19 13.56
That's pretty clear I think.
One the remote side:
SQL*Net message to client 983709 0.00 2.13
SQL*Net message from client 983709 23.26 479.04
My assumption here is that the local is waiting on the remote, but the remote
is also waiting on the local? If that's the case, if the db link in and of
itself is a big part of our problem we will move the local schema into the
remote database.
I guess my question is - am I interpreting the SQL*Net message from client on
the remote side correctly? If the remote waits said "dblink" I'd consider that
case closed. As it is, I still think the remote waits are from the incoming
connection over the dblink - but not certain.
Can anyone confirm that? Or set me straight?
Thanks!
Stephan Uzzell
Other related posts:
