RE: problem with GATHER_STATS_JOB

From: Joe Smith <>
Date: Wed, 16 Apr 2008 11:40:13 -0500
Message-ID: <BLU108-W2709F945C4703E64A2E1FD97EA0@phx.gbl>

No. It shows up in user_objects and user_segments execute by the same user, i.e. the schema owner.

To: joe_dba_at_hotmail.comCC:; oracle-l-bounce_at_freelists.orgSubject: Re: problem with GATHER_STATS_JOBFrom: TESTAJ3_at_nationwide.comDate: Wed, 16 Apr 2008 12:22:42 -0400its not one of those indexes "owned" by some other schema is it? Thanks,  Joe---------------------------------------You can have it: Fast, Right or Cheap, pick 2 of the 3.Fast + Right is ExpensiveFast + Cheap will be incorrect.Right + Cheap will take a while. 

Joe Smith <> Sent by: 04/16/2008 12:15 PM Please respond to

Joe Smith <>



problem with GATHER_STATS_JOB

Has anybody ever seen this in their alert log before? This is 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 existthanks.

Use video conversation to talk face-to-face with Windows Live Messenger. Get started!

Get in touch in an instant. Get Windows Live Messenger now.
Received on Wed Apr 16 2008 - 11:40:13 CDT

Original text of this message