Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Toad Server Dump
The most likely things to look at would be
-- Niall Litchfield Oracle DBA Audit Commission UK "Chong Pok" <chongpok18_at_hotmail.com> wrote in message news:3f680cf2$1_at_shknews01... I have got the following Red Dots in Toad Server Stats. library cache get hit ratio 81.4550 dynamic or unshareable SQL? library cache pin hit ratio 84.29 Shared Pool area too small chained fetch ratio 3.8507 PCTFREE too low for a table parse/execute ratio 138.5849 high parse to execute ratio DBWR avg scan depth 623.4747 #DB_FILES too high? My server is slowing down in the past few days. Any suggestion to improve the situation?Received on Wed Sep 17 2003 - 04:47:24 CDT