Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: SGA QUESTION

Re: SGA QUESTION

From: Bunyamin K. Karadeniz <bunyamink_at_havelsan.com.tr>
Date: Mon, 25 Jun 2001 02:04:01 -0700
Message-ID: <F001.00335F0E.20010625015527@fatcity.com>

HERE IS THE KNOWLEDGE, my database is nearly 700 tables where 2 of it is 3 gb growing per year. My total disk is 400 GB.
Total number physical users which will connect to database is 1000 but will be
20000 for 2 years.
Total number of database users is 30.
Oracle is on NT.
Oracle Version is 8.1.7
My RAM is 8 GB.

Thank you .....
----- Original Message -----
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Sent: Sunday, June 24, 2001 2:15 AM

> On Saturday 23 June 2001 15:15, Greg Moore wrote:
> > If he has 8GB of memory, why not allocate 4GB to the data buffer instead
of
> > 200MB? I realize simply adding memory is not the solution for fixing a
> > poorly tuned database, but on the other hand, if you have a lot of
memory
> > why not use it?
>
> Because it my just be a waste of memory.
>
> Really, he hasn't given any information about his database, number
> of users, type of queries, etc.
>
> So I am guessing at a size, and using up 4 gig for data base block
> buffers is a *LOT* of memory that would probably be more useful
> elsewhere.
>
> Jared
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Jared Still
> INET: jkstill_at_cybcon.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Bunyamin K. Karadeniz
  INET: bunyamink_at_havelsan.com.tr

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
Received on Mon Jun 25 2001 - 04:04:01 CDT

Original text of this message

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