DBA Tip of the Month

From: <steveadams_at_acslink.net.au>
Date: Mon, 20 Apr 1998 07:52:15 -0600
Message-ID: <6hfgdv$su7$1@nnrp1.dejanews.com>

Cam and others,

> For latch tuning: if your ratio of timeouts to immediates is greater than
> 10%, increase the initialization parameter ENQUEUE_RESOURCES.

THIS TIP IS TRASH. The enqueue_resources parameter sets the size of the x$ksqrs table. This table is protected by a latch, however there is NO relationship between the size of the table and the activity on the latch. Also, your terminology of 'timeouts' and 'immediates' is at best ambiguous.

If the folk at RevealNet cannot come up with decent technical content, then I believe that their use of this newsgroup should be censured as advertising in the same way that the Platinum posting were recently.

Regards,
Steve Adams
steveadams_at_acslink.net.au

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Mon Apr 20 1998 - 08:52:15 CDT