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 -> Re: Shared Pool: Can it be filled *over* 100% ?

Re: Shared Pool: Can it be filled *over* 100% ?

From: omlet <notrolls_at_notrolls.omlet.org.notrolls>
Date: Fri, 13 Aug 2004 07:43:17 -0400
Message-ID: <9fb4f0b7458e3a927f1fd3f39c8097d2@localhost.talkaboutdatabases.com> 





If you issue the same query 10 times a second; you are likely to have most
of them unfinished; latches aquired but not released yet. and of course
stats accumulated beyond 100% dependent on which stat you queried first!



You should be dis-barred from your job; fired! and Mike Ault should pay a
heavy fine for providing you with the script!



At least you should have cached the cursor!!!!!!!!!!!!
Received on Fri Aug 13 2004 - 06:43:17 CDT












Original text of this message













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