Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Shared Pool: Can it be filled *over* 100% ?
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