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 -> Re: huge sga

Re: huge sga

From: Beverly Hom <bhom_at_sprintmail.com>
Date: Thu, 04 Jun 1998 08:54:27 -0700
Message-ID: <3576C332.6BC6A50F@sprintmail.com>


You really need to look at how your database will be used. The shared pool contains
shared cursors and stored procedures. Larger values improve performance in multi-user
systems. Smaller values use less memory. Therefore, if you are going to utilize stored
procedures or your users will execute the same sql over and over, it is a good idea to
have a large shared_pool_size. You can see how your system is performing by querying some of the V$ tables, for example, the v$sesstat table.

Ed Lufker wrote:

> Hi All;
>
> Does a shared pool size of 150000000 and db_block_buffers set to
> 150000 seem unrealistic for a db that has over 2000 indexes and about 450
> tables. This creates about a 1.2GB sga.
>
> thanks for any help here.
> eddie lufker
Received on Thu Jun 04 1998 - 10:54:27 CDT

Original text of this message

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