Re: problem with GATHER_STATS_JOB
- From: TESTAJ3@xxxxxxxxxxxxxx
- To: joe_dba@xxxxxxxxxxx
- 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!
Other related posts:
