Re: When curosr_Sharing=force how to find the original statement
- From: zigzagdna@xxxxxxxxx
- Date: 30 May 2007 19:18:11 -0700
On May 30, 9:57 pm, zigzag...@xxxxxxxxx wrote:
On May 30, 9:35 pm, zigzag...@xxxxxxxxx wrote:
On May 30, 11:31 am, DA Morgan <damor...@xxxxxxxxx> wrote:
zigzag...@xxxxxxxxx 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...@xxxxxxxxxxxxxxxx
(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.- Hide quoted text -
- Show quoted text -
Mtealink doc 1068973.6 provides what I was looking for. Thanks for the
responses.
.
- References:
- When curosr_Sharing=force how to find the original statement
- From: zigzagdna
- Re: When curosr_Sharing=force how to find the original statement
- From: DA Morgan
- Re: When curosr_Sharing=force how to find the original statement
- From: zigzagdna
- Re: When curosr_Sharing=force how to find the original statement
- From: zigzagdna
- When curosr_Sharing=force how to find the original statement
- Prev by Date: Re: When curosr_Sharing=force how to find the original statement
- Next by Date: Re: Comparison of Oracle commans Vs. SQL Server Commands
- Previous by thread: Re: When curosr_Sharing=force how to find the original statement
- Next by thread: RMAN ADDING TO CATALOG FAILURE
- Index(es):
Relevant Pages
|
