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

huge sga

From: Ed Lufker <elufker_at_swcp.com>
Date: 3 Jun 1998 21:01:42 GMT
Message-ID: <6l4djm$pgs$1@sloth.swcp.com>


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 Wed Jun 03 1998 - 16:01:42 CDT

Original text of this message

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