Re: Capturing SQL commands

> John Douglas <mkelly_at_notes.cc.bellcore.com> writes:
> Chuck Hamilton wrote:
> >
> > Is there a way to capture users' SELECT commands for later analysis?
> > --
> > Chuck Hamilton
> > chuckh_at_dvol.com
> >
> > This message delivered by electronic sled dogs. WOOF!
>
> Sure, just turn on global sql trace in the init.ora file and restart
> oracle.
>
>>>>
Also, Platinum's PLAN ANALYZER can sample sql from the Shared SQL Area.

But if you're dealing with a particular, cooperative user I'd suggest having them issue an ALTER SESSION SET SQL_TRACE = TRUE; That way your DASD won't fill up with a lot of traces you don't have time to read. Received on Wed Sep 11 1996 - 00:00:00 CEST