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

Home -> Community -> Mailing Lists -> Oracle-L -> Who and What is using the shared pool.

Who and What is using the shared pool.

From: Terry Ball <terry_ball_at_csgsystems.com>
Date: Mon, 21 Aug 2000 09:09:57 -0500
Message-Id: <10596.115091@fatcity.com> 





Recently we have had occurances where our shared pool fills up and we
have to flush the shared pool.  The head of the product support group
wants us to kill any process that is using "too much" of the shared
pool.  Is there any way we can identify which user/what query is using
the shared pool by percentage of shared pool used?  Steve?



Terry Ball
Received on Mon Aug 21 2000 - 09:09:57 CDT












Original text of this message













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