ORA-3113, ORA-07445 on Analyze table ... estimate statistics

From: Jan Motin <motin_at_yahoo.com>
Date: 19 Nov 2001 05:14:08 -0800
Message-ID: <2b42998a.0111190514.44099f9c@posting.google.com>

Hi,

We are running the following SQL statement from within SqlPlus:

analyze table TABLENAME estimate statistics sample 100 percent;

We are analyzing several tables but it fails for one of them with the following error message:

ORA 03113: end-of-file on communication channel

The alert logs shows the error message:

ORA-07445: exception encountered: core dump [11] [2122275088] [0] [3472] [] []

The data in the table has a size of 1.4GB.

Analyze with mere 10% works fine.

We have run dbverify and it showed no errors.

Can anyone tell me what the problem could be?

Thanks,
Jan Motin Received on Mon Nov 19 2001 - 07:14:08 CST