Oracle LGWR process does continuous direct I/O's

mcbill20@yahoo.com · *nix forums beginner Joined: 24 Mar 2005 Posts: 36

I saw this problem once before with Oracle 7.? or 8.? I believe. The
database works OK but the Oracle LGWR process runs constantly, even
with no database activity.

The last time (several years ago), I was told that this was an Oracle
bug and I just needed to get a patch. That turned out to be correct.

Here is my current config:

OpenVMS 7.3-1
Oracle 9.2.0.2

As far as I can tell, this time the problem started when I installed
VMS731_UPDATE V5.0. I assumed I could just go to the Oracle website and
get the latest patches, but the metalink website has recently purged
their user/password database. I tried to reregister but it requires a
valid CSID, which I don't have anymore, as a home user.

I don't know why they would have a policy like this. It's kind of
funny-- just the opposite of the OpenVMS policy. With VMS, you have to
pay for the original software (other than hobbyist) but you then get
free access to bug fixes. With Oracle, you can download all their
products for free but can't get bug fixes without paying.

And of course, they appear to be way behind in porting. I noticed
Oracle 10g available for download on just about every platform except
VMS.

Any suggestions?

Thanks.
Bill

Google