| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Size, what is it?
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 <dave.morgan_at_cybersurf.net>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>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: dave.morgan_at_cybersurf.net
>
>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: Raghu Kota INET: raghukota_at_hotmail.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).Received on Fri Jun 01 2001 - 14:15:27 CDT
 |
 |