Re: Oracle 10g on AIX 5.2 - i/o configuration

"DA Morgan" <damorgan_at_psoug.org> wrote in message news:1118717739.121453_at_yasure...
> Matthias Hoys wrote:
>> Hi,
>>
>> I'm currently preparing for the (first) installation of Oracle 10g on one
>> of our AIX 5.2 servers.
>> I'm a bit confused by all the different i/o configurations that are
>> possible :
>> - JFS or JFS2 ? (enhanced JFS)
>> - direct i/o yes or no ? if no, what should be the optimal vmtune
>> settings ?
>> - async i/o ? how many async i/o servers and requests ?
>> - db_cache_size ? 4K or 8K ? or is this not important anymore ?
>>
>> Oh yes, our datafiles reside on SAN storage boxes (EMC Symmetrix) with
>> 8GB memory caches ...
>>
>> Thanks in advance,
>> Matthias
>
> If storage is on the Symmetrix then check with your Sales Engineer at
> EMC for help with optimal configuration based on how you will be using
> the array.
>
> You didn't even indicate, for example, whether you are doing stand-alone
> or RAC. Be sure you give a lot of thought to Flashback area too.
> --
> Daniel A. Morgan
> http://www.psoug.org
> damorgan_at_x.washington.edu
> (replace x with u to respond)

Our Symmetrix has already been configured and I believe all meta-devices are RAID-1. No RAC, only stand-alone. I'm not sure if we're going to use a flashback area since it eats a lot of diskspace and fast recovery is not really an issue (backups are stored on tape with cross-backups to a library in another building). We do want to use flashback table, and I guess this alone will require a decent amount of extra undo diskspace. But I believe this will eliminate the need to do extra exports (data pump ?) for the restore of individual tables ?

Matthias Received on Tue Jun 14 2005 - 12:56:29 CDT