RE: Q: VPD - how we can see full sql after the policy
- From: Amihay Gonen <Amihay.Gonen@xxxxxxxxxxx>
- To: Karen Funston <Karen.Funston@xxxxxxxxxxxx>, "toon.koppelaars@xxxxxxxxxxx" <toon.koppelaars@xxxxxxxxxxx>
- Date: Sun, 8 Mar 2009 09:03:23 +0200
Thanks . It will help here .
From: Karen Funston [mailto:Karen.Funston@xxxxxxxxxxxx]
Sent: Saturday, March 07, 2009 8:00 PM
To: toon.koppelaars@xxxxxxxxxxx; Amihay Gonen
Cc: oracle-l@xxxxxxxxxxxxx; Tali Poliak
Subject: RE: Q: VPD - how we can see full sql after the policy
I just noticed your post and there's a query that I use to view the predicate
that may help your developer:
select substr(sql_text,1,25) sql_text,
predicate,
policy,
object_name,
s.sql_id
from v$sqlarea s, v$vpd_policy
where hash_value = sql_hash;
Karen
Karen Funston
Information Services
Colorado School of Mines
Phone 303.384.2476
Fax 303.273.3093
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Toon Koppelaars
Sent: Thursday, February 19, 2009 2:20 AM
To: Amihay.Gonen@xxxxxxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx; Tali Poliak
Subject: Re: Q: VPD - how we can see full sql after the policy
Standard sql trace will not show what VPD added to your SQL queries.
You would need to set event 10730 to get a trace file showing what VPD added.
On Thu, Feb 19, 2009 at 10:12 AM, Amihay Gonen
<Amihay.Gonen@xxxxxxxxxxx<mailto:Amihay.Gonen@xxxxxxxxxxx>> wrote:
Hi all,
One of our developers , ask me if there is someone to see the changed sql after
VPD policy.
She need that for debug propose. I guess using sql-trace can be an option ,
but this can be difficult since we've connection pooling + shared server.
Any idea ?
--
Toon Koppelaars
RuleGen BV
+31-615907269
Toon.Koppelaars@xxxxxxxxxxx
www.RuleGen.com<http://www.RuleGen.com>
(co)Author: "Applied Mathematics for Database Professionals"
Other related posts:
