Re: Init.ora configuration

From: Sean Hull <shull_at_panix.com>
Date: 1998/02/25
Message-ID: <6d1qan$9vi@panix.com>#1/1

In article <34F45BA9.14E4_at_ictgroup.com>, Jerry Gitomer <jgitomer_at_ictgroup.com> wrote:

>Increasing the shared pool size will reduce disk I/O by allowing more of
>the sorts generated by order by and group by clauses to be done in
>memory.

This reduces recursive SQL, which is the disk I/O associated with resolving objects, permissions etc. Also the shared pool keeps PL/SQL stored procedures, and SQL queries. The sort_area_size parameter affects the cache memory for sorting.

Sean Hull

Received on Wed Feb 25 1998 - 00:00:00 CST