On Jan 24, 2:20m, Frank van Bortel < XXXX@XXXXX.COM >
Thanks for the feedback Frank.
That call solved the problem on 64 bit Windows, no more ORA-07445, and
the SQL statement executes quickly. A little more testing to
determine why the following failed:
I found Metalink doc ID 272479.1, which suggests to use:
Then I started to wonder, did I find a work around a couple years ago
for this problem when I migrated to Oracle 10.2.0.2? How to determine
if I collected statistics on the fixed tables? A search on Metalink
found this article from 2004:
In the article, Jonathan Lewis mentioned that tab_stats$ could be
Test database on 64 bit Windows:
The above returned about 582 rows after running:
I then checked a production database, and found no rows returned.
Using the suggestion from the Metalink article:
The stats collection completed much more quickly, as it did not
analyze the full SYS schema, and there were 582 rows returned by the
query on SYS.TAB_STATS$. It looks like this simple query may be used
to determine if fixed object statistics need to be collected.
I am still looking for the source of the suggestion to use 'ALL' as
the parameter for GATHER_FIXED_OBJECTS_STATS - it was apparently not
from "Expert Oracle Database 10g Administation", as that book shows
nothing after GATHER_FIXED_OBJECTS_STATS.
IT Manager/Oracle DBA
K&M Machine-Fabricating, Inc.