Re: Optimizing performance

[Quoted] On 29 Apr 1997 10:10:00 GMT, "Luis Servan" <lservan_at_mx2.redestb.es> wrote:

>I'd like to know how can I optimize the time response of database queries
>from applications developed with Designer/2000
>

One way to determine if the query is optimized, it to isolate either the session, or the query itself and run through TKPROF. This will tell you if you are using the proper index, if the sql is efficient, etc.. To islolate the query, use the stored procedure: EXECUTE DBMS_SYSTEM.SET_SQL_TRACE_IN_SESSION(A,B,TRUE); Where a is the sid (session id), and b is the serial number. This can be found in the v$session table.

Sheilah Scheurich
DBA
scheuric_at_sprynet.com Received on Wed May 07 1997 - 00:00:00 CEST