Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> extensive CPU rate

extensive CPU rate

From: tshen <tshen01_at_hotmail.com>
Date: Wed, 30 Jan 2002 02:27:38 GMT
Message-ID: <uSI58.27292$ff5.4466997@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 - 20:27:38 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US