Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Unexplainable: "Beautified" code runs slower
On Oct 1, 7:53 am, Maxim Demenko <mdeme..._at_gmail.com> wrote:
> Yet one possibility - go to Debugger tab page, disable the "Add debug
> information when compiling" and recompile.
>
> Best regards
>
> Maxim
John
You need to run the traces. You are surely looking at one or more resulting changes in the plans being the cause of the difference in run time.
One possible cause would be the use of stored outlines associated with the SQL in the reformatted procedures. It would be worth checking to see if any stored outlines or Profiles are in use.
HTH -- Mark D Powell -- Received on Mon Oct 01 2007 - 08:27:58 CDT
![]() |
![]() |