Re: A potential bug (infinite loop) in Oracle: querying v$access
From: <titan4_at_gmail.com>
Date: Wed, 26 Dec 2012 04:44:03 -0800 (PST)
Message-ID: <ab1d0a28-bec2-4843-a2f9-94d022f063d1_at_googlegroups.com>
On Wednesday, December 26, 2012 6:41:37 PM UTC+6, tit..._at_gmail.com wrote:
> But I can't create fixed index on X$KGLOB, because this is 9.2.0.8.
ERROR at line 1:
PL/SQL: Statement ignored Received on Wed Dec 26 2012 - 13:44:03 CET
Date: Wed, 26 Dec 2012 04:44:03 -0800 (PST)
Message-ID: <ab1d0a28-bec2-4843-a2f9-94d022f063d1_at_googlegroups.com>
On Wednesday, December 26, 2012 6:41:37 PM UTC+6, tit..._at_gmail.com wrote:
> But I can't create fixed index on X$KGLOB, because this is 9.2.0.8.
Sorry, I mean that I can't collect statistics on the fixed objects:
SQL> EXEC DBMS_STATS.GATHER_FIXED_OBJECTS_STATS('ALL'); BEGIN DBMS_STATS.GATHER_FIXED_OBJECTS_STATS('ALL'); END;
*
ERROR at line 1:
ORA-06550: line 1, column 18: PLS-00302: component 'GATHER_FIXED_OBJECTS_STATS' must be declared ORA-06550: line 1, column 7:
PL/SQL: Statement ignored Received on Wed Dec 26 2012 - 13:44:03 CET