Re: How create a trigger on a system view ??

If you want to save the sqlstatements you can better trace that session. Refer to the set_sql_trace_in_session procedure in dbms_utility or dbms_system.
This does exactly what you need.
What you want with system views is impossible and rightly so.

Hth,

Sybrand Bakker, Oracle DBA

"PhilBzh" <stabiloNOstSPAM_at_mailcity.com.invalid> wrote in message news:15f5621a.ab018fdf_at_usw-ex0108-062.remarq.com...
> I work on Oracle v8.0.5.1.0
> I want to install a trigger on V$session to save the
> address of the current SQL request but I can't on v8.0.5
> If someone can keep by another solution ?
> I want to associate the osuser in v$session and the SQL
> text in v$sqltext and save it in a file.
>
> Please Help Me !
> Phil.
>
>
>
> * Sent from AltaVista http://www.altavista.com Where you can also find
related Web Pages, Images, Audios, Videos, News, and Shopping. Smart is Beautiful Received on Mon Jun 26 2000 - 00:00:00 CEST