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.
[EMAIL PROTECTED]
-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: [EMAIL PROTECTED]
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: [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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: DENNIS WILLIAMS
INET: [EMAIL PROTECTED]
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: [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).