Re: Disappearing Sessions - Can Code Alone Cause It?

On Feb 27, 5:00 am, "Dereck L. Dietz" <diet..._at_ameritech.net> wrote:
> Oracle 10.2.0.3.0
> Windows 2003 Server
> 16GB Memory (93% SGA( 93% Buffer Cache,<3% Shared Pool, <3% Large Pool), 7%
> PGA)
>
> Our off-site DBA is saying our code is causing the disappearing sessions
> because, to paraphrase him: that's the database it has to run in.  That's
> why hes telling us to do things like incremental commits.
>
> My question is:  can code alone cause sessions to sometimes run to
> completion but other times just disappear without a trace?
>
> I have a feeling he's trying to make us do work-arounds rather than trying
> to get to the actual root cause of this problem.

I am not sure I understand the memory percentages you posted but if the PGA is 7% of the 16G and the SGA is 93% then the PGA is probably way too small. Plus some memory should be left for the OS and the posted numbers do not show it.

What kind of database is this (OLTP, Warehouse, DSS, OLAP)?

Are there error messages in the alert log related to the "disappeared" sessions? Are there trace files in the udump destination?

There should be clues. Is connection pooling in use?

HTH -- Mark D Powell -- Received on Wed Feb 27 2008 - 08:46:47 CST