Re: Updates with correlated subqueries slow after 9.2->10.2 upgrade
- From: Sandra Becker <sbecker6925@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Fri, 11 Dec 2009 09:14:22 -0700
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.
Other related posts:
- » Updates with correlated subqueries slow after 9.2->10.2 upgrade - Neil Kodner
- » RE: Updates with correlated subqueries slow after 9.2->10.2 upgrade - Allen, Brandon
- » Re: Updates with correlated subqueries slow after 9.2->10.2 upgrade - Greg Rahn
- » Re: Updates with correlated subqueries slow after 9.2->10.2 upgrade - Neil Kodner
- » Re: Updates with correlated subqueries slow after 9.2->10.2 upgrade - Stephane Faroult
- » RE: Updates with correlated subqueries slow after 9.2->10.2 upgrade - Allen, Brandon
- » Re: Updates with correlated subqueries slow after 9.2->10.2 upgrade - Greg Rahn
- » Re: Updates with correlated subqueries slow after 9.2->10.2 upgrade - Stephane Faroult
- » Re: Updates with correlated subqueries slow after 9.2->10.2 upgrade - Neil Kodner
- » Re: Updates with correlated subqueries slow after 9.2->10.2 upgrade - Neil Kodner
- » Re: Updates with correlated subqueries slow after 9.2->10.2 upgrade - Greg Rahn
- » Re: Updates with correlated subqueries slow after 9.2->10.2 upgrade - David Lord
- » RE: Updates with correlated subqueries slow after 9.2->10.2 upgrade - Randolf Geist
- » Re: Updates with correlated subqueries slow after 9.2->10.2 upgrade - Robert Freeman
- » Re: Updates with correlated subqueries slow after 9.2->10.2 upgrade - Neil Kodner
- » RE: Updates with correlated subqueries slow after 9.2->10.2 upgrade - Vordos, Suzy
- » Re: Updates with correlated subqueries slow after 9.2->10.2 upgrade - Greg Rahn
- » Re: Updates with correlated subqueries slow after 9.2->10.2 upgrade - Sandra Becker