Re: same sql, same execution plan, but the time to complete is very different when run in different time.
From: "Michael McMullen" <ganstadba@xxxxxxxxxxx>
To: "oracle-l" <oracle-l@xxxxxxxxxxxxx>
Date: Mon, 12 Nov 2007 07:59:28 -0500
Any way you can change your loop through a cursor to single sql. Looks like
you're looping. Or even bulk load. Even if you find your problem it still
won't scale. What about your commits, where are they?
----- Original Message -----
From: qihua wu
To: oracle-l
Sent: Saturday, November 10, 2007 2:12 AM
Subject: same sql, same execution plan, but the time to complete is very
different when run in different time.