Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Sessions hanging

Re: Sessions hanging

From: Ranko Mosic <ranko.mosic_at_gmail.com>
Date: Tue, 28 Nov 2006 09:54:00 -0500
Message-ID: <367369f10611280653v1cf526b7g495309985513ef99@mail.gmail.com>


No MTS.
There is gather stats job that ran that morning.

On 11/27/06, Mladen Gogala <mgogala_at_verizon.net> wrote:
>
> 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
>
>

-- 
Regards,
Ranko Mosic
Contract Senior Oracle DBA
B. Eng, Oracle 10g, 9i Certified Database Professional
Phone: 416-450-2785
email: mosicr_at_rogers.com
http://ca.geocities.com/mosicr@rogers.com/ContractSeniorOracleDBARankoMosicMain.html
--
http://www.freelists.org/webpage/oracle-l
Received on Tue Nov 28 2006 - 08:54:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US