Re: Updates with correlated subqueries slow after 9.2->10.2 upgrade
From: Sandra Becker <sbecker6925_at_gmail.com>
Date: Fri, 11 Dec 2009 09:14:22 -0700
Message-ID: <3c5f7820912110814y29c3fffcp6f970a12ecf97cad_at_mail.gmail.com>
Something that would concern me in our environment are the two FTS. Have you run a trace to see what the statements are really doing, where they are spending their time?
--
Sandy
Transzap, Inc.
Date: Fri, 11 Dec 2009 09:14:22 -0700
Message-ID: <3c5f7820912110814y29c3fffcp6f970a12ecf97cad_at_mail.gmail.com>
Something that would concern me in our environment are the two FTS. Have you run a trace to see what the statements are really doing, where they are spending their time?
--
Sandy
Transzap, Inc.
--
http://www.freelists.org/webpage/oracle-l
Received on Fri Dec 11 2009 - 10:14:22 CST