Oracle Server - HELP HELP

From: Norman Dunbar <Norman.Dunbar_at_lfs.co.uk>
Date: Mon, 9 Jun 2003 12:05:35 +0100
Message-ID: <E2F6A70FE45242488C865C3BC1245DA703C3AC70@lnewton.leeds.lfs.co.uk>

Hi Lewis,

The explanation below sounds *exactly* like a fault I had on 64 bit Oracle 8170 running of 64 bit HPUX 11.00.

The fix is to patch to 8174 and it all goes away (on HP anyway). I had a process on my 817 database which would run off with 100% of the CPU making it impossible to login or find out which OS process corresponded to which Oracle process. Not helpful at all. I had to kill the offending OS process and when this happened all would be fine for about 5 mins where another process would take off at 100%. This continued until such time as one of the background processes for the instance took up the baton and sped off into the distance at 100%. At this point, kill the whole plot was the only solution.

Since upgrading to 8174, this is no longer a problem.

Cheers,
Norman.

Norman Dunbar
Database/Unix administrator
Lynx Financial Systems Ltd.
mailto:Norman.Dunbar_at_LFS.co.uk

Tel: 0113 289 6265
Fax: 0113 289 3146
URL: http://www.Lynx-FS.com


-------------------------------------

-----Original Message-----
From: jj [mailto:14g_at_hongkong.com]
Posted At: Saturday, June 07, 2003 1:32 PM Posted To: server
Conversation: Oracle Server - HELP HELP
Subject: Re: Oracle Server - HELP HELP

Dear Hth,

The oracle 8.1.7 release 3, under Solaris 8 on Suncluster 3.0. I use top to see the process ID and when i want to see the detail from v$session, the sesstion suddently disappear and next process pick up the cpu.

sometimes when this problem occur, i cannot even connect to Oracle.

Regards,
Lewis Received on Mon Jun 09 2003 - 06:05:35 CDT