Re: Oracle on VMS performance issue

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 Sat Sep 26 1998 - 00:00:00 CDT