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 -> Toad Server Dump

Toad Server Dump

From: Chong Pok <chongpok18_at_hotmail.com>
Date: Wed, 17 Sep 2003 15:27:46 +0800
Message-ID: <3f680cf2$1@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 - 02:27:46 CDT

Original text of this message

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