RE: big disks..OFA??

From: DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM>
Date: Fri, 28 Mar 2003 07:18:41 -0800
Message-ID: <F001.005753AE.20030328071841@fatcity.com>

Peter

   Welcome to the modern DBA's challenge.
- Consider RAID

• Pay attention to your cache size (battery-backed, of course)
• Test
• Eternally the System administrator would prefer you to use fewer devices, makes his/her life easier. The DBA wants many devices. Negotiate. Share.
• What performance is required of this database? As was discussed yesterday on this list, a lower-performance database will be okay on a single device. Put control files, redo on separate devices. If really good performance / high transaction rates are required, then lobby for more devices.

Dennis Williams
DBA, 40%OCP, 100% DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com

-----Original Message-----
Sent: Thursday, March 27, 2003 8:49 PM
To: Multiple recipients of list ORACLE-L

Hi Friends

Now a days the disks are coming with 36/73Gb sizes for AIX, How can I make small filesystems to put data and indexes separately?? Although I have FastT700 controller, Is it okay putting all dbf files under one filesytem?? Does it affect performance, How about putting rbs/temp/redo?? Do I need to put under different filesystems?? Suppose I have two controller, How can I know, How many channels are there??

I have 25Gb table, what is the methodology for setting initial and next extents?? My DB is OLTP its conitousely growing on AIX 5L with Oracle 817.

TIA
peter.

---

The new MSN 8: smart spam protection and 2 months FREE* http://join.msn.com/?page=features/junkmail

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Peter R
  INET: niagarap_at_hotmail.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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.net
-- 
Author: DENNIS WILLIAMS
  INET: DWILLIAMS_at_LIFETOUCH.COM

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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 Mar 28 2003 - 09:18:41 CST