Re: problem with GATHER_STATS_JOB
- From: "Riyaj Shamsudeen" <riyaj.shamsudeen@xxxxxxxxx>
- To: joe_dba@xxxxxxxxxxx
- Date: Wed, 16 Apr 2008 12:38:51 -0500
Just a guess, are the schema or table statistics locked ?
Thanks
Riyaj
On Wed, Apr 16, 2008 at 11:40 AM, Joe Smith <joe_dba@xxxxxxxxxxx> wrote:
> No. It shows up in user_objects and user_segments execute by the same
> user, i.e. the schema owner.
>
> ------------------------------
> To: joe_dba@xxxxxxxxxxx
> CC: oracle-l@xxxxxxxxxxxxx; oracle-l-bounce@xxxxxxxxxxxxx
> Subject: Re: problem with GATHER_STATS_JOB
> From: TESTAJ3@xxxxxxxxxxxxxx
> Date: Wed, 16 Apr 2008 12:22:42 -0400
>
>
>
> its 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 Expensive
> Fast + Cheap will be incorrect.
> Right + Cheap will take a while.
>
>
> *Joe Smith <joe_dba@xxxxxxxxxxx>*
>
> *Sent by:** **oracle-l-bounce@xxxxxxxxxxxxx*
>
>
>
>
> *04/16/2008 12:15 PM*
> Please respond to joe_dba@xxxxxxxxxxx From
> *Joe Smith <joe_dba@xxxxxxxxxxx>* To
> <oracle-l@xxxxxxxxxxxxx> cc
> Subject
> problem with GATHER_STATS_JOB
>
>
>
>
>
> 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.888
> ORA-20000: Unable to analyze INDEX "SCHEMA"."F_MTH_MBR_RPT_METRICS_PK",
> insufficient privileges or does not exist
> *** 2008-04-15 22:00:03.897
> GATHER_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. *Get
> started!*<http://www.windowslive.com/messenger/connect_your_way.html?ocid=TXT_TAGLM_WL_Refresh_messenger_video_042008>
>
>
> ------------------------------
> Get in touch in an instant. Get Windows Live Messenger
> now.<http://www.windowslive.com/messenger/overview.html?ocid=TXT_TAGLM_WL_Refresh_getintouch_042008>
>
Other related posts:
