| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Re: Has anybody encountered problems with HISTGRM$ ?
>----- Original Message -----
>From: Gene Gurevich <g_u_r_e_v_i_c_h_at_yahoo.com>
>To: Multiple recipients of list ORACLE-L
><ORACLE-L_at_fatcity.com>
>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
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroul INET: sfaroult_at_oriolecorp.com 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: ListGuru_at_fatcity.com (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).Received on Mon Dec 17 2001 - 10:56:44 CST
 |
 |