Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: huge sga
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