Re: Q: VPD - how we can see full sql after the policy

  • From: Laimutis.Nedzinskas@xxxxxx
  • To: Amihay.Gonen@xxxxxxxxxxx
  • Date: Thu, 19 Feb 2009 11:56:53 +0200

v$plan may show it

V$VPD_POLICY does show it.




                                                                           
             Amihay Gonen                                                  
             <Amihay.Gonen@eci                                             
             tele.com>                                                  To 
             Sent by:                  "oracle-l@xxxxxxxxxxxxx"            
             oracle-l-bounce@f         <oracle-l@xxxxxxxxxxxxx>            
             reelists.org                                               cc 
                                       Tali Poliak                         
                                       <tali.poliak@xxxxxxxxxx>            
             2009.02.19 11:12                                      Subject 
                                       Q: VPD - how we can see full sql    
                                       after the policy                    
             Please respond to                                             
             Amihay.Gonen@ecit                                             
                  ele.com                                                  
                                                                           
                                                                           
                                                                           




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 ?


--
//www.freelists.org/webpage/oracle-l


Other related posts: