Re: extensive CPU rate

From: Andre van Winssen $andrew$ <andrew_at_info.nl>
Date: Wed, 30 Jan 2002 11:44:46 +0100
Message-ID: <3c57ce9e$0$223$4d4ebb8e@news.nl.uu.net>

If you cannot convince them to use bind variables, try forcing it by setting CURSOR_SHARING=FORCE in init.ora file. This setting causes the oracle rdbms to rewrite each sql statement that uses harcoded values with bind variables. Starting with 8.1.7.2 this feature seems to run without bugs. And it's transparent for any application code !

Regards,
Andre van Winssen

"Jim Kennedy" <kennedy-family_at_attbi.com> wrote in message news:NRJ58.2296$iY1.8861_at_rwcrnsc53...
> 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 Wed Jan 30 2002 - 04:44:46 CST