Re: How do you get trace statistics on a VMS V7 instance?
Date: Fri, 28 Oct 1994 23:58:43 GMT
Message-ID: <James.Lawrence.25.0012FB20_at_epamail.epa.gov>
In article <1994Oct26.110539.2293_at_mwk.com> richardsro_at_mwk.com writes:
>From: richardsro_at_mwk.com
>Subject: How do you get trace statistics on a VMS V7 instance?
>Date: 26 Oct 94 11:05:39 CST
> We are trying to get SQL trace statistics to analyze how a query is
>performing. This is on a VMS instance using Oracle version 7.0.16.4.0. We do
>not have SQL trace enabled for the entire instance. What we are doing is this:
>- The user defines ora_dump and/or user_dump_dest to be their sys$login
> directory:
> $ define ora_dump sys$login
> $ define user_dump_dest sys$login
Don't know about VMS but on Netware user_dump_dest is a INIT.ORA parameter not a symbol.
>- The user then goes into sqlplus and enables trace for the session:
> SQL> alter session set sql_trace = true;
>- The user then does a query, exits sqlplus, and there is nothing new in their
> sys$login directory.
> We are not running multi-threaded servers, if that matters. What else do I
>need to do to get trace statistics?
>--
>Bobby Richards
>richardsro_at_mwk.com
Received on Sat Oct 29 1994 - 00:58:43 CET