Re: Performance Problems on VAX6640

In article <mburkeCn6848.n31_at_netcom.com>, mburke_at_netcom.com (Matthew J. Burke) writes...
>
> I have a DEC Vax 6640 running VMS with a relatively small
>Oracle database. There is a little less than 1gigabyte of tablespace and I
>have allocated over 40MB to the SGA. There is a total of 348MB of
>memory. All of the database kernel and hit ratio statistics look
>good, if not excellent. In addition, I have two DSSI connections with
>the datafiles spread between them.
 ...
> Unfortunately, when I get more than 20 users on the system
>connected to Oracle, the performance degrades exponentially. Some
>users have complained that it can take over 2 minutes to simply enter
>SQL*Plus.
...

That machine should be carrying more than six times as many users, for that kind of response time. The first things I'd check for would be:

    Overworked disks ($ mon disk/it=que)
    Heavy paging     ($ mon pag)
    CPU saturation   ($ mon mod/all)





Ed Quinn                               "That's from me, not my employer."
OpenVMS Development -- Nashua, NH