I have 160Gb database size doing great with 150Mb of SGA, You are saying
700Mb SGA to support 150Gb database size?? Is there any white paper
available for any criteria??? Let me know If you got any stuff.
Thanks
Raghu.
>From: Dave Morgan <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: Size, what is it?
>Date: Fri, 01 Jun 2001 09:41:11 -0800
>
>Hi All,
> Being able to lift my head from the problems at my new
> job finally. I would like to get some definitions of
> what is a "large" database and the hardware that it is
> running on. There are multiple different types of "large",
> transactions, physical size, number of objects,
> number of connections, SGA size, etc.
>
> My current database is a heavy transaction site but small in
> other respects.
>
> Oracle 8.1.7, 150GB physical size, 700MB SGA, 10 GB per day redo,
> 300-700 OLTP connections at any time all on a SUN E450, 2 CPU's, 4 GB
>RAM,
> Baydel disk array (RAID 3). The machine is relativiely idle,
> or I/O bound, memory starts becomming a limit above 700 connections.
>
>
> A previous large database was
> Oracle 8.0.5, 50 GB physical, associated with 4 TB of image files
> on the filesystem, 350 GB SGA, 2 GB per day redo, 100 DSS connections,
> all on a SUN E5000, 6 CPU's 6 GB RAM, many hardware RAID arrays,
> machine was CPU bound almost all the time.
>
> Most of the database I have seen have been on machines that are grossly
> over powered for the work that they do so I am hoping I can determine
> some figures for hardware vs workload based on real data.
>
> Your assistance would be appreciated. Please include as many details
> as possible including why you think it is a "large database" and
> machine utilization.
>
> Also, does anyone have experience with Baydel disk arrays. They seem
> to be a happening setup even if they are hardwired RAID 3 :(
>
>TIA
>Dave
>
>--
>Dave Morgan
>DBA, Cybersurf
>Office: 403 777 2000 ext 284
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Dave Morgan
> INET: [EMAIL PROTECTED]
>
>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: [EMAIL PROTECTED] (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).
_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Raghu Kota
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
