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 -> Re: Monitoring I/O in Oracle 7.3.4

Re: Monitoring I/O in Oracle 7.3.4

From: Joe Kazimierczyk <joseph.kazimierczyk_at_bms.com>
Date: Mon, 29 Jan 2001 08:49:06 -0500
Message-ID: <3A7574D2.A667220D@bms.com>

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.

>...

There are some good IO statistics in V$FILESTAT. You could save the values before doing your nightly shutdown, and have a good daily history of overall reads/writes per file.

Other places to look:

v$sysstat - shows physical read/writes, and lots of other intersting stuff

If you enable session auditing, you can get some basic statistics per session. But it sounds like this is more than you need. Received on Mon Jan 29 2001 - 07:49:06 CST

Original text of this message

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