Re: How to trace SQL calls?

In article <814169205snz_at_ahardy.demon.co.uk>, Andy Hardy <aph_at_ahardy.demon.co.uk> writes:
> In article <464b4k$9r9_at_inet-nntp-gw-1.us.oracle.com>
> tkyte_at_us.oracle.com "Thomas J Kyte" writes:
> Thomas,
>
> > Andy Hardy <aph_at_ahardy.demon.co.uk> wrote:
> >
> > In your init$ORACLE_HOME.ora file set:
> >
> > time_statistics=true
> > sql_trace=true
>
> Thanks for this info, very useful!
>
> Andy

Now if you want to be efficient, put a trace on that single Oracle session rather than the whole database.

1. Wait for Oracle 7.3 and you will be able to do it in a supported way.
2. Use the 'alter session set event command'. This is not supported by Oracle.

ta
tony

-- 
 _____       ________ / ___ |Tony Jambu, Database Consultant
  /_  _        /_ __ /      |Wizard Consulting,Aust (ACN 065934778)
 /(_)/ )(_/ \_/(///(/_)/_(  |CIS: 100250.2003_at_compuserve.com FAX: +61-3-4163559
 \_______/                  |EMAIL:TJambu_at_wizard.com.au PHONE: +61-3-4122905