Home -> Usenet -> comp.databases.oracle -> How do you get trace statistics on a VMS V7 instance?

How do you get trace statistics on a VMS V7 instance?

From: <richardsro_at_mwk.com>
Date: 26 Oct 94 11:05:39 CST
Message-ID: <1994Oct26.110539.2293_at_mwk.com> 






  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:





        $ define ora_dump sys$login
        $ define user_dump_dest sys$login







        SQL> alter session set sql_trace = true;






  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 Wed Oct 26 1994 - 18:05:39 CET












Original text of this message