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: <zigzagdna_at_yahoo.com>
Date: 30 May 2007 18:57:48 -0700
Message-ID: <1180576668.809512.226590@m36g2000hse.googlegroups.com>


On May 30, 9:35 pm, zigzag..._at_yahoo.com wrote:
> On May 30, 11:31 am, DA Morgan <damor..._at_psoug.org> wrote:
>
>
>
>
>
> > 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.
>
> > select view_name from dba_views
> > where view_name like '%BIND%';
> > --
> > Daniel A. Morgan
> > University of Washington
> > damor..._at_x.washington.edu
> > (replace x with u to respond)
> > Puget Sound Oracle Users Groupwww.psoug.org
>
> I did look into these views, I still did not see the sql satements. I
> am on Oracle 9.2.0.6 on Windows Server.
> Really appareciate if you can provide more information.- Hide quoted text -
>
> - Show quoted text -

I do see v$sql_bind_data which has a column value which probably should give value of bind variable. Bust since this values is blank, not sure what the column represents. Received on Wed May 30 2007 - 20:57:48 CDT

Original text of this message

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