Re: Disappearing Sessions - Part 2

From: joel garry <joel-garry_at_home.com>
Date: Tue, 12 Feb 2008 17:29:57 -0800 (PST)
Message-ID: <fd9f002b-e34d-4415-8381-b7dc7e588414@y5g2000hsf.googlegroups.com>


On Feb 8, 2:07 pm, "Dereck L. Dietz" <diet..._at_ameritech.net> wrote:
> Oracle 10.2.0.3.0
> Windows Server 2003
> 16 GB of memory
>
> Our off-site DBA had this to say about the disappearing sessions and
> ORA-07445 errors:
>
> "I think the problem with disappearing sessions is the dispatcher process.
>
> when we increased the session limit, I did not take into account that there
> are web connections coming in also.
>
> ORA-07445 is defenitely points back to Hardware/OS. Since the memory
> upgrade (16 which will need to go to 32), we have not seen any errors."
>
> Does this make sense when:
>
> 1. I'm running my process in Dedicated Server mode, not Shared Server.

Kind of a weird long-shot, since you are seeing a different error, but see metalink Note:371983.1 for some other ideas.

jg

--
@home.com is bogus.
"I'm on the road 300 days a year.  My entire life is in my BlackBerry
- my family life, my professional life, my emotional life,
everything... They're not allowed to do this to me." - Stuart Gold,
who says he gets 1,000 e-mails a day as director of field marketing
for Web analytics company Omniture
Received on Tue Feb 12 2008 - 19:29:57 CST

Original text of this message