RE: Large DB Size? Manage datafiles?

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).