Re: Sessions hanging
- From: "Ranko Mosic" <ranko.mosic@xxxxxxxxx>
- To: "Mladen Gogala" <mgogala@xxxxxxxxxxx>
- Date: Tue, 28 Nov 2006 09:54:00 -0500
No MTS.
There is gather stats job that ran that morning.
On 11/27/06, Mladen Gogala <mgogala@xxxxxxxxxxx> 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@xxxxxxxxxx
http://ca.geocities.com/mosicr@xxxxxxxxxx/ContractSeniorOracleDBARankoMosicMain.html
--
//www.freelists.org/webpage/oracle-l
Other related posts:
