Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Monitoring I/O in Oracle 7.3.4

Monitoring I/O in Oracle 7.3.4

From: fooguy <jweisen_at_my-deja.com>
Date: Mon, 29 Jan 2001 02:11:52 GMT
Message-ID: <952jh5$oup$1@nnrp1.deja.com>

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US