just remmeber to NOT put your redologs and system tablespace
on the stripes disk. put them only on regular one.
Asaf.
Phil Cook wrote in message <01bde997$eb7ccc80$cd85410c_at_default>...
>You don't want an Oracle block to span multiple stripes. Your real problem
>is how much IO your applications are performing. I would start looking
>at v$sqlarea and the number of IOs. Run explain plans on the top
>statements, and see if these can be tuned.
>
>If you really want to brute force the application with hardware add more
>memory cache at the disk or OS level. Adding more buffer cache to
>the sga may help, look at your buffer hit ratio.
>
>Zeth Johansson <zejo_at_usa.net> wrote in article
<360A792E.44A07A45_at_usa.net>...
>> Hi there!
>>
>> We're running Oracle 7.3.2 on OpenVMS 7.1 (Alpha Server). The database
>> resides on a stripe-set. We suffer from performance problems related to
>> disk I/O. How does stripe size affect performance? I belive 64k stripes
>> are common with VMS. What would be the recommended stripe size, with
>> Oracle using 4k block-size? Does anyone have experience with this
>> configuration?
>>
>> Thank you for your help!
>>
>> Zeth Johansson
>>
>>
Received on Tue Sep 29 1998 - 00:00:00 CDT
