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