Go back to the developers and ask if they used bind variables. My guess is
they will look at you as if you have 2 heads. (What's a bind variable?).
v$sqlarea has the querys.
Jim
"tshen" <tshen01_at_hotmail.com> wrote in message
news:uSI58.27292$ff5.4466997_at_news02.optonline.net...
> hi, Guys:
>
> I have one production DB runing on a dedicate unix box, the application
> using "connection pools" to connect to DB, today the "top" shows there
were
> almost
> 99.9% usr CPU rate, and the DB almost hanging there for several mins, then
I
> found the SQL parsing used almost 98% CPU time, but how can I identify
those
> trouble making SQL statements?
>
>
> Tao
>
>
>
Received on Tue Jan 29 2002 - 21:35:09 CST
