Re: Speed problem in Pro*C with dynamic SQL update
From: kru <kru_at_messer.de>
Date: Tue, 6 Mar 2001 13:43:45 +0100
Message-ID: <982lvl$rmm$1_at_news.messer.de>
Date: Tue, 6 Mar 2001 13:43:45 +0100
Message-ID: <982lvl$rmm$1_at_news.messer.de>
Hi Gary,
perhaps you can try the sqltrace-option instaed of a simple time statement to find out , where the big delays occure ?
Sqltrace will give you a list of actions , row hits and times. You may set these by alter session or for the whole database within the init.ora file. After running your program(s), you must convert the tracefiles to readable output by tkprof ... (not very funny, I know..)
Rgds
Christian
Received on Tue Mar 06 2001 - 13:43:45 CET