Return-Path: Delivered-To: 2-oracle-l@orafaq.com Received: (qmail 18611 invoked from network); 16 Apr 2008 12:51:32 -0500 Received: from freelists-180.iquest.net (HELO turing.freelists.org) (206.53.239.180) by static-ip-69-64-49-119.inaddr.server4you.com with SMTP; 16 Apr 2008 12:51:32 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 47FA7841E76; Wed, 16 Apr 2008 13:51:32 -0400 (EDT) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 02269-05; Wed, 16 Apr 2008 13:51:32 -0400 (EDT) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id B5B69841E08; Wed, 16 Apr 2008 13:51:31 -0400 (EDT) Received: with ECARTIS (v1.0.0; list oracle-l); Wed, 16 Apr 2008 13:13:18 -0400 (EDT) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 89D4984161B; Wed, 16 Apr 2008 12:40:16 -0400 (EDT) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 24060-08; Wed, 16 Apr 2008 12:40:16 -0400 (EDT) Received: from blu139-omc3-s21.blu139.hotmail.com (blu139-omc3-s21.blu139.hotmail.com [65.55.175.221]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id B25DF840578; Wed, 16 Apr 2008 12:40:15 -0400 (EDT) Received: from BLU108-W27 ([65.55.162.189]) by blu139-omc3-s21.blu139.hotmail.com with Microsoft SMTPSVC(6.0.3790.3959); Wed, 16 Apr 2008 09:40:13 -0700 Message-ID: Content-Type: multipart/alternative; boundary="_445f05f3-0adf-4f5d-9b66-0ddaee7c9a68_" X-Originating-IP: [66.236.147.253] From: Joe Smith To: CC: , Subject: RE: problem with GATHER_STATS_JOB Date: Wed, 16 Apr 2008 11:40:13 -0500 In-Reply-To: References: MIME-Version: 1.0 X-OriginalArrivalTime: 16 Apr 2008 16:40:13.0838 (UTC) FILETIME=[8B4932E0:01C89FE0] X-archive-position: 7221 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: joe_dba@hotmail.com Precedence: normal Reply-to: joe_dba@hotmail.com List-help: List-unsubscribe: List-software: Ecartis version 1.0.0 List-Id: oracle-l X-List-ID: oracle-l List-subscribe: List-owner: List-post: List-archive: X-list: oracle-l X-Virus-Scanned: Debian amavisd-new at localhost.localdomain --_445f05f3-0adf-4f5d-9b66-0ddaee7c9a68_ Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable No. It shows up in user_objects and user_segments execute by the same user= , i.e. the schema owner. To: joe_dba@hotmail.comCC: oracle-l@freelists.org; oracle-l-bounce@freelist= s.orgSubject: Re: problem with GATHER_STATS_JOBFrom: TESTAJ3@nationwide.com= Date: Wed, 16 Apr 2008 12:22:42 -0400its not one of those indexes "owned" b= y some other schema is it? Thanks, Joe------------------------------------= ---You can have it: Fast, Right or Cheap, pick 2 of the 3.Fast + Right is E= xpensiveFast + Cheap will be incorrect.Right + Cheap will take a while.=20 Joe Smith Sent by: oracle-l-bounce@freelists.org 04= /16/2008 12:15 PM Please respond to joe_dba@hotmail.com=20 From Joe Smith =20 To =20 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-1= 5 22:00:03.888*** MODULE NAME:(DBMS_SCHEDULER) 2008-04-15 22:00:03.888*** S= ERVICE NAME:(SYS$USERS) 2008-04-15 22:00:03.888*** SESSION ID:(463.126) 200= 8-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_M= ETRICS_PK"','""', ...)ORA-20000: Unable to analyze INDEX "SCHEMA"."F_MTH_MB= R_RPT_METRICS_PK", insufficient privileges or does not existthanks. Use video conversation to talk face-to-face with Windows Live Messenger. Ge= t started!=20 _________________________________________________________________ Get in touch in an instant. Get Windows Live Messenger now. http://www.windowslive.com/messenger/overview.html?ocid=3DTXT_TAGLM_WL_Refr= esh_getintouch_042008= --_445f05f3-0adf-4f5d-9b66-0ddaee7c9a68_ Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable No.  It shows up in user_objects and user_segments execute by the same= user, i.e. the schema owner.

To: joe_dba@hotmail.com
CC: oracle-l@freelists.org; oracle-l-bounce@free= lists.org
Subject: Re: problem with GATHER_STATS_JOB
From: TESTAJ3@na= tionwide.com
Date: Wed, 16 Apr 2008 12:22:42 -0400


its not one of those indexes "owned" by some other s= chema is it?

Thanks,  = Joe

---------------------------------------
You can have it: Fast= , Right or Cheap, pick 2 of the 3.
Fast + Right is Expensive
Fast + C= heap will be incorrect.
Right + Cheap will take a while.

=




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:(4= 63.126) 2008-04-15 22:00:03.888
ORA-20000: Unable to analyze INDEX "SCHE= MA"."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('"SCH= EMA"','"F_MTH_MBR_RPT_METRICS_PK"','""', ...)
ORA-20000: Unable to analy= ze INDEX "SCHEMA"."F_MTH_MBR_RPT_METRICS_PK", insufficient privileges or do= es not exist


thanks.



Use video conversation to talk face-to-face wi= th Windows Live Messenger. Get star= ted!

Get in touch in an instant= . Get Windows Live Messen= ger now.= --_445f05f3-0adf-4f5d-9b66-0ddaee7c9a68_-- -- http://www.freelists.org/webpage/oracle-l
Joe S= mith <joe_dba@hotmail.com>
 
Sent by: oracle-l-bounce@freelists.org<= /I>




04/16/20= 08 12:15 PM
Please respond = to joe_dba@hotmail.com=20
From
Joe Smith <joe_dba@hotmail.com&g= t;=20
To
<oracle-l@freelists.org>= =20
cc
Subject
problem with GATHER_ST= ATS_JOB