Re: Application Tunning

"Harry Sheng" <SHui1002_at_rogers.com> wrote in news:NCHg9.19413$U_.18001_at_news04.bloor.is.net.cable.rogers.com:

> Hi,
> I am tunning a gui application, we expect a database search return in
> 20 secs, but it actually takes 5 times longer than our expection. I
> need to find out SQL statements sumitted by the gui, and if additional
> indexes should be created for better performance.
> So I run "alter system set create_stored_outlines = true" in SQL*PLUS,
> then start the
> gui app. It seems the gui app will hang there waiting for query
> results for ever (more than
> 10 minutes). I have to issue "alter system set create_stored_outlines
> = false" in SQL*PLUS,
> then the gui app displays the query results in seconds. And I get one
> simple single table access
> query captured in OUTLN tables.
> Why "create_stored_outlines" affects the database so badly, Where
> should I look at?
>
> Hu
>
>
>

Enable SQL_TRACE and then run the output *trc file through tkprof. The output file from tkprof should allow you to identify the specific SQL command(s) which are taking a long time to complete.

HTH & YMMV HAND! Received on Sat Sep 14 2002 - 09:45:48 CDT