Re: A potential bug (infinite loop) in Oracle: querying v$access

From: <titan4_at_gmail.com>
Date: Wed, 26 Dec 2012 04:41:37 -0800 (PST)
Message-ID: <380f4156-c113-4735-b010-2d51cc89441d_at_googlegroups.com>

Hi all,
I have same problem with fixed tables

Oracle9i Enterprise Edition Release 9.2.0.8.0 - 64bit Production OS AIX 5.3 SQL_TEXT

---

SELECT * FROM V$DB_PIPES WHERE NAME NOT LIKE '%LOCK%' ORDER BY PIPE_SIZE DESC Plan:

---

Rows Row Source Operation

-------  ---------------------------------------------------

    191 SORT ORDER BY (cr=0 r=0 w=0 time=32691509 us)     191 FIXED TABLE FULL X$KGLOB (cr=0 r=0 w=0 time=32678781 us)

Elapsed times include waiting on following events:

  Event waited on                             Times   Max. Wait  Total Waited
  ----------------------------------------   Waited  ----------  ------------
  SQL*Net message to client                      14        0.00          0.00
  latch free                                     75        0.29         11.75
  SQL*Net message from client                    14        2.15          2.16


********************************************************************************

But I can't create fixed index on X$KGLOB, because this is 9.2.0.8. What can I do to eliminate this problem? Received on Wed Dec 26 2012 - 13:41:37 CET