Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Slow Crystal Reports with Oracle
Will try, thank you!
kp
> I can't tell you how to perform an odbc trace.
> If you connect using a native driver, tracing the session (sql_trace)
> from the oracle server side while the report runs (set event 10046,
> waits=>true) will provide you with the raw data as to why the query
> runs slow. Using tkprof on the resulting trace file will provide you
> with a nicely formatted report with summary data.
>
> There exist a great many papers out there on the net for how to trace
> a session in oracle. I'd start at the AskTom Site:
> http://asktom.oracle.com.
>
> You can compile the package dbms_support as a convenient method to
> enable tracing in another session.
>
> have fun.
>
> Pd
Received on Mon Oct 20 2003 - 12:59:24 CDT