problem with GATHER_STATS_JOB
From: Joe Smith <joe_dba_at_hotmail.com>
Date: Wed, 16 Apr 2008 11:15:45 -0500
Message-ID: <BLU108-W751F2EF7F480B9226ACF397EA0@phx.gbl>
Use video conversation to talk face-to-face with Windows Live Messenger. http://www.windowslive.com/messenger/connect_your_way.html?ocid=TXT_TAGLM_WL_Refresh_messenger_video_042008
Date: Wed, 16 Apr 2008 11:15:45 -0500
Message-ID: <BLU108-W751F2EF7F480B9226ACF397EA0@phx.gbl>
Has anybody ever seen this in their alert log before?
This is 10.2.0.3.0 EE on AIX 5.3L.
I don't see any note on metalink about it.
The index exists in user_objects and user_segments.
- ACTION NAME:(GATHER_STATS_JOB) 2008-04-15 22:00:03.888*** MODULE NAME:(DBMS_SCHEDULER) 2008-04-15 22:00:03.888*** SERVICE NAME:(SYS$USERS) 2008-04-15 22:00:03.888*** SESSION ID:(463.126) 2008-04-15 22:00:03.888ORA-20000: Unable to analyze INDEX "SCHEMA"."F_MTH_MBR_RPT_METRICS_PK", insufficient privileges or does not exist*** 2008-04-15 22:00:03.897GATHER_STATS_JOB: GATHER_INDEX_STATS('"SCHEMA"','"F_MTH_MBR_RPT_METRICS_PK"','""', ...)ORA-20000: Unable to analyze INDEX "SCHEMA"."F_MTH_MBR_RPT_METRICS_PK", insufficient privileges or does not exist
thanks.
Use video conversation to talk face-to-face with Windows Live Messenger. http://www.windowslive.com/messenger/connect_your_way.html?ocid=TXT_TAGLM_WL_Refresh_messenger_video_042008
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Apr 16 2008 - 11:15:45 CDT