RE: SQL in Sproc runs 10x longer than sql at a prompt
Date: Tue, 9 Jun 2009 18:10:33 -0400
Message-ID: <46732D8B0755664E87B4276E3C2FF60593BE3D6467_at_EXM-OMF-06.Ceg.Corp.Net>
I'm sorry, actually no, we didn't get to the bottom of the problem.
Part of my role is as an internal help desk. When I went back to the project team to solve this, they had recontextualized the problem into a new format and no longer had the issue. So I asked if they wanted to solve this purely for academics and it was the persons last day on the job and didn't have the time to find the old code that had the problem.
Thanks for the support!
From: Tony Adolph [mailto:tony.adolph.dba_at_gmail.com]
Sent: Wednesday, June 03, 2009 5:59 AM
To: Brady, Mark
Cc: oracle-l_at_freelists.org
Subject: Re: SQL in Sproc runs 10x longer than sql at a prompt
Hi Mark,
Did you get to the bottom of the problem?
Tony
>>> This e-mail and any attachments are confidential, may contain legal, professional or other privileged information, and are intended solely for the addressee. If you are not the intended recipient, do not use the information in this e-mail in any way, delete this e-mail and notify the sender. CEG-IP1
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Jun 09 2009 - 17:10:33 CDT