Re: What server 9.2.0 read?

Guys,

    just use the "rule" hint, and it will come back right away. Tested on Oracle 9iR2/Win 2000:

SQL> set timing on
SQL> set autotrace traceonly

SQL> select /*+ rule */ l.sid from v$lock l, v$session s where l.sid = s.sid;

15 rows selected.

Elapsed: 00:00:00.03

Execution Plan

   0 SELECT STATEMENT Optimizer=HINT: RULE    1 0 MERGE JOIN

   2    1     SORT (JOIN)
   3    2       MERGE JOIN
   4    3         SORT (JOIN)
   5    4           MERGE JOIN
   6    5             FIXED TABLE (FULL) OF 'X$KSUSE'
   7    5             SORT (JOIN)
   8    7               FIXED TABLE (FULL) OF 'X$KSUSE'
   9    3         SORT (JOIN)
  10    9           VIEW OF 'GV$_LOCK'
  11   10             UNION-ALL
  12   11               VIEW OF 'GV$_LOCK1'
  13   12                 UNION-ALL
  14   13                   FIXED TABLE (FULL) OF 'X$KDNSSF'
  15   13                   FIXED TABLE (FULL) OF 'X$KSQEQ'
  16   11               FIXED TABLE (FULL) OF 'X$KTADM'
  17   11               FIXED TABLE (FULL) OF 'X$KTCXB'
  18    1     SORT (JOIN)
  19   18       FIXED TABLE (FULL) OF 'X$KSQRS'

Statistics

          0  recursive calls
          0  db block gets
          0  consistent gets
          0  physical reads
          0  redo size
          0  bytes sent via SQL*Net to client
          0  bytes received via SQL*Net from client
          0  SQL*Net roundtrips to/from client
          0  sorts (memory)
          0  sorts (disk)
         15  rows processed

Daniel Received on Fri May 23 2003 - 09:16:16 CDT