Re: Monitoring I/O in Oracle 7.3.4

fooguy wrote:

> We are currently running Oracle 7.3.4 on OpenVMS Alpha. In
> order to decide how much hardware we need in our new system
> and in what configuration, I need to know how much I/O goes
> through the DB every day. We have under 2GB of data, and our
> rollback segments are 5MB each. We have maybe 10 or 15 people
> who use this DB all day every day. I can sort of watch the VMS
> monitor, and I can look at how many times the archive logs
> switched each day, but I'd prefer something more scientific
> (perhaps a data dictionary view)? We shut the DB down every
> night for cold backups.
>
> I'm looking at 12 disks in a RAID 10 configuration, but we're
> torn between an optimal disk config and software RAID vs. a
> not-so-optimal disk config with hardware RAID 10. If you're
> interested in the history:
>
>

 http://www.deja.com/viewthread.xp?AN=720136983.1&search=thread&recnum=%3
>

 c94pigv$io6$1_at_nnrp1.deja.com%3e%231/1&group=comp.os.vms&frpage=viewthrea
> d.xp
>
>

 http://www.deja.com/viewthread.xp?AN=720881597.1&search=thread&recnum=%3
>

 c94usjg$vak$1_at_nnrp1.deja.com%3e%231/1&group=comp.os.vms&frpage=viewthrea
> d.xp
>
>

 http://x55.deja.com/threadmsg_ct.xp?AN=691351487.1&mhitnum=1&CONTEXT=980
> 734228.2024931447
>
> Thanks,
> John
>
> --
> *********************************************
> "All I every wanted from life was to see
> Larry Wall give Bill Gates a Perl Necklace."
>
>
> Sent via Deja.com
> http://www.deja.com/

OraSnap which can be found at www.stewartmc.com/oracle/orasnap/ includes queries that will provide you with database I/O data. Just set up the VMS equivalent of a Unix chron job to kick off the OraSnap queries every night just before you shut down the database for backup. (Once you install OraSnap run it during the day in order to get a worst case timing so that you determine when to have it kicked off at night.)

-- 
Jerry Gitomer
Once I learned how to spell DBA, I became one