Re: Sessions hanging

From: Mladen Gogala <mgogala_at_verizon.net>
Date: Mon, 27 Nov 2006 17:33:31 -0500
Message-id: <1164666811l.2703l.0l@medo.noip.com>

On 11/27/2006 05:23:23 PM, Ranko Mosic wrote:
> Oracle is 9204
> Problem segment is table.

Hmmmm, that is strange. Are you doing anything special, like distributed transaction or object tables? At any rate, you have only around 10MB of free space, which is probably further fragmented. I'd check V$SHARED_POOL_RESERVED for any failures and see how much memory you have on the reserved list and would increase shared pool significantly. Large pool is on the default value. Are you using MTS? Do you need it for RMAN?

-- 
Mladen Gogala
http://www.mladen-gogala.com

--
http://www.freelists.org/webpage/oracle-l

Received on Mon Nov 27 2006 - 16:33:31 CST