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
