Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Monitoring I/O in Oracle 7.3.4
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/Received on Sun Jan 28 2001 - 20:11:52 CST