Hi Lisetrs, I have enough free memory from shared_pool_size and I run stats every week but the BD still shows up the low hit ratio and some times the later full down to 15%! Here is some informations:
Obj mem: 79503437 bytes Shared sql: 23852410 bytes Cursors: 244875 bytes Free memory: 204512816 bytes (195.04MB) Shared pool utilization (total): 124320866 bytes (118.56MB) Shared pool allocation (actual): 300000000 bytes (286.1MB) Percentage Utilized: 41% Hit Ratio : 74.2249062 I appreciate to give me some guidelines. Thanks, Ben __________________________________________________ Do you Yahoo!? Yahoo! Tax Center - forms, calculators, tips, more http://taxes.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kader Ben INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).