Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: When curosr_Sharing=force how to find the original statement

Re: When curosr_Sharing=force how to find the original statement

From: Valentin Minzatu <valentinminzatu_at_yahoo.com>
Date: 30 May 2007 05:25:43 -0700
Message-ID: <1180527943.699198.169720@q66g2000hsg.googlegroups.com> 





On May 29, 9:03 pm, zigzag..._at_yahoo.com wrote:


> I am supporting a ERP application, do not have access to source code.

> crsor_sharing is set to force so when I look in v$sql etc it shows me

> the statement with various bind varaiables. Is there any way to find

> the original query before Oracle replaced literals by bind variables.

>

> Thanks.




Assuming this is a 10g installation, tracing or auditing would do.
Maybe others have more ideas.
Received on Wed May 30 2007 - 07:25:43 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US