Re: v$sqltext

From: Richard G. Ramirez <ou79138_at_deere.com>
Date: 1997/02/12
Message-ID: <01bc1917$30681140$6ef179a4@proxy.dx.deere.com.wdm.deere.com>#1/1

I had a similar problem. I found that you need to have a line like this in your INIT.ORA. I am not sure which one of the parameters does the trick but it is one of them.

EVENT                           = "10052 TRACE NAME CONTEXT FOREVER"

I use 7.1.4 on AIX .

Richard

Wes Riding <wriding_at_shl.com> wrote in article <32FFB120.2BD5_at_shl.com>...
> I am using 7.0.16 and my documentation describes the dynamic view
> "V$SQLTEXT".
> However, I am unable to access (describe, select) this object as SYS.
> Is there a script that should exist to create the view?
> Should I not be able to see its base table?
> Is this object not supported under 7.0.16?
>
> Thanks
> Wes
> mailto:wriding_at_shl.com
>
Received on Wed Feb 12 1997 - 00:00:00 CST