| 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: Large DB Size? Manage datafiles?
Well(a cohort of mine on this list and) I worked with a 3terabyte(3000 gig) db before the project was dunked.
It was interesting to say the least playing with that much data.
it was to be an ODS and i played the dba role and the other guy(you know who you are) played the developer role, he discovered some kewl stuff in dealing with hash partitions and how to determine the hash key beforehand, so that we could load millions of rows via sql*loader direct path into a specific partition.
joe
>From: "Joan Hsieh" <Joan.Hsieh_at_mirror-image.com>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: RE: Large DB Size? Manage datafiles?
>Date: Wed, 14 Mar 2001 05:20:27 -0800
>MIME-Version: 1.0
>Received: from localhost (localhost [127.0.0.1])by parents.the-testas.net
>(8.9.3/8.8.7) with ESMTP id JAA11449for <jtestamail_at_localhost>; Wed, 14 Mar
>2001 09:21:04 -0500
>Received: from mail.the-testas.netby localhost with POP3
>(fetchmail-5.3.1)for jtestamail_at_localhost (multi-drop); Wed, 14 Mar 2001
>09:21:04 -0500 (EST)
>Received: from newsfeed.cts.com (newsfeed.cts.com [209.68.192.199])by
>mail.acfi.net (8.11.0/8.11.0) with ESMTP id f2EFLXw25355for
><oracle-l_at_the-testas.net>; Wed, 14 Mar 2001 09:21:33 -0600
>Received: from fatcity.UUCP (uucp_at_localhost)by newsfeed.cts.com
>(8.9.3/8.9.3) with UUCP id GAA81733;Wed, 14 Mar 2001 06:17:48 -0800 (PST)
>Received: by fatcity.com (26-Feb-2001/v1.0g-b70/bab) via UUCP id 002CC17E;
>Wed, 14 Mar 2001 05:20:27 -0800
>Return-Path: <root_at_fatcity.cts.com>
>Message-ID: <F001.002CC17E.20010314052027_at_fatcity.com>
>X-Comment: Oracle RDBMS Community Forum
>X-Sender: "Joan Hsieh" <Joan.Hsieh_at_mirror-image.com>
>Sender: root_at_fatcity.com
>Errors-To: ML-ERRORS_at_fatcity.com
>Organization: Fat City Network Services, San Diego, California
>X-ListServer: v1.0g, build 70; ListGuru (c) 1996-2001 Bruce A. Bergman
>Precedence: bulk
>X-Fetchmail-Warning: recipient address ORACLE-L_at_fatcity.com didn't match
>any local name
>X-SpamBouncer: 1.2 (10/20/00)
>X-SBPass: NoBounce
>X-SBClass: OK
>Status:
>
>Our typical databases right now are 800gb size. Each datafile is 4gb on raw
>disk (HP or SUNOS). One tablespace can have 85 datafiles. The data we deal
>with are blobs. The performance is not that good. Lots of problem. This
>place is not easy to change things. I think we should partition the table
>or
>at least do parallel query.
>
>Joan
>
>-----Original Message-----
>Sent: Wednesday, March 14, 2001 2:55 AM
>To: Multiple recipients of list ORACLE-L
>
>
>Dear All DBAs,
>
>So far, I only manage small Oracle databases, size between 30-40 GB (all
>datafiles). I just want to know how you will manage large Oracle database
>with 100 or more GB. What size is the largest database size you ever
>manage?
>How much data files and tablespaces you use for that database? Please share
>your experience as enterprise DBA....
>
>Thank you in advance
>
>Yuzzie
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Yuzie
> INET: tekait11_at_bni.co.id
>
>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: Joan Hsieh
> INET: Joan.Hsieh_at_mirror-image.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: Joseph Testa INET: teci_dba1_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 Wed Mar 14 2001 - 09:34:31 CST
 |
 |