>----- Original Message -----
>From: Gene Gurevich <[EMAIL PROTECTED]>
>To: Multiple recipients of list ORACLE-L
><[EMAIL PROTECTED]>
>Sent: Mon, 17 Dec 2001 05:35:22
>
>Stephane,
>
>I was reading a forum on Oracle Metalink, which may
>
>be related to your issue. The Forum's subject is
>"What is SYS.OBJ#_INTCOL#"? There is a reference
>to " analyze tables for all indexed columns" witt
>size 1 instead of default 75. Take a look may be it
>
>will be helpful for you
>
>I was wondering what did you mean by "looped on
>hist_head#"? Did you just remove rows from it?
>Could
>you elaborate, please?
>
>
>Thanks
>
>Gene
Thanks for the pointer to Metalink, I am going to have a look. Not the same cluster,
but it may be related. What I meant about my questionable cleaning method (to my
defence, all attempts to clean up statistics with dbms_stats() ended with ORA-600) I
just selected all obj# from hist_head$, and, for each of them, first deleted the rows
with the same obj# in histgrm$ before deleting the row in hist_head$ - kind of manual
DELETE CASCADE, if you like. The surprising thing was that after all this (which
worked without any problem), I no longer had any row in hist_head$ but still had a lot
in histgrm$, whereas I would have expected none. Looks to me like foreign keys without
any parent. I then deleted (run-of-the-mill DELETE) histmgr$. No error. SELECT
COUNT(*) was returning 0, but SELECT * from the same table was still returning
ORA-600, and I only get rid of them when I truncated the cluster in which HISTGRM$ is
stored (alone). I wish I had run dbverify, but as the priority was to!
!
put the database back in CBO mode and as this is one of their main production
databases, shutting it down to dissecate it quietly was a bit of a luxury. Which is
why similar experiences interest me highly.
Stephane Faroult
Oriole Corporation
Performance Tools & Free Scripts
--------------------------------------------------------------
http://www.oriole.com, designed by Oracle DBAs for Oracle DBAs
--------------------------------------------------------------
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Stephane Faroul
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
