Добро пожаловать в форум, Guest  >>   Войти | Регистрация | Поиск | Правила | В избранное | Подписаться
Все форумы / Oracle Новый топик    Ответить
 Глюк autotrace?  [new]
SQL>
Guest
Глюк autotrace?

SQL> select  count(*) from t, t1 d where t.a >1 and d.a < 12;

  COUNT(*)
----------
       109


Execution Plan
----------------------------------------------------------
Plan hash value: 780066650

------------------------------------------------------------------------------
| Id  | Operation             | Name | Rows  | Bytes | Cost (%CPU)| Time     |
------------------------------------------------------------------------------
|   0 | SELECT STATEMENT      |      |     1 |     4 |     5   (0)| 00:00:01 |
|   1 |  SORT AGGREGATE       |      |     1 |     4 |            |          |
|   2 |   MERGE JOIN CARTESIAN|      |   109 |   436 |     5   (0)| 00:00:01 |
|*  3 |    INDEX RANGE SCAN   | DDSS |     1 |     2 |     1   (0)| 00:00:01 |
|   4 |    BUFFER SORT        |      |   109 |   218 |     4   (0)| 00:00:01 |
|*  5 |     TABLE ACCESS FULL | T    |   109 |   218 |     4   (0)| 00:00:01 |
------------------------------------------------------------------------------

Predicate Information (identified by operation id):
---------------------------------------------------

   3 - access("D"."A"<12)
   5 - filter("T"."A">1)


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)
          1  rows processed
8 июн 08, 23:04    [5779512]     Ответить | Цитировать Сообщить модератору
 Re: Глюк autotrace?  [new]
Elic
Member

Откуда:
Сообщений: 29977
STFF SQL*Plus 9.2.0.1 жгёт
9 июн 08, 08:30    [5779892]     Ответить | Цитировать Сообщить модератору
 Re: Глюк autotrace?  [new]
Вячеслав Любомудров
Member

Откуда: Владивосток
Сообщений: 18483
Смех-смехом, а у меня одно окошечко sqlplusw тоже перестало сегодня статистику показывать (я уж точно его не менял), причем независимо от переподключений и на любых БД от любых юзеров
Очень похоже на глюк самого плюса
OEMREPT> set autotrace on
OEMREPT> select * from dual;

D
-
X


Execution Plan
----------------------------------------------------------
   0      SELECT STATEMENT Optimizer=ALL_ROWS (Cost=2 Card=1 Bytes=2)
   1    0   TABLE ACCESS (FULL) OF 'DUAL' (TABLE) (Cost=2 Card=1 Bytes=2)




Statistics
----------------------------------------------------------
         24  recursive calls
          0  db block gets
          6  consistent gets
          1  physical reads
          0  redo size
        332  bytes sent via SQL*Net to client
        492  bytes received via SQL*Net from client
          2  SQL*Net roundtrips to/from client
          0  sorts (memory)
          0  sorts (disk)
          1  rows processed
через некоторое время (баловался со всякими логинами, базами)
OEMREPT> select * from v$mystat where value>0;

       SID STATISTIC#      VALUE
---------- ---------- ----------
       132          0          1
       132          1          1
       132          2         91
...
       132        351        144

80 rows selected.


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)
         80  rows processed
9 июн 08, 09:41    [5780072]     Ответить | Цитировать Сообщить модератору
 Re: Глюк autotrace?  [new]
Вячеслав Любомудров
Member

Откуда: Владивосток
Сообщений: 18483
Кстати, полная демонстрация (вроде нашел, когда ломается):
SQL*Plus: Release 9.2.0.7.0 - Production on Mon Jun 9 16:48:11 2008

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Production
With the Partitioning, OLAP and Data Mining options

OEMREPT> connect sys/CORRECT_PASSWORD@oemrept2 as sysdba
Connected.
OEMREPT> set autotrace on stat
OEMREPT> select * from dual;

D
-
X


Statistics
----------------------------------------------------------
          0  recursive calls
          0  db block gets
          3  consistent gets
          0  physical reads
          0  redo size
        332  bytes sent via SQL*Net to client
        492  bytes received via SQL*Net from client
          2  SQL*Net roundtrips to/from client
          0  sorts (memory)
          0  sorts (disk)
          1  rows processed

OEMREPT> connect sys/BAD_PASSWORD@oemrept2 as sysdba
ERROR:
ORA-01017: invalid username/password; logon denied


Warning: You are no longer connected to ORACLE.
OEMREPT> connect sys/CORRECT_PASSWORD@oemrept2 as sysdba
Connected.
OEMREPT> set autotrace on stat
OEMREPT> select * from dual;

D
-
X


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)
          1  rows processed

OEMREPT> define
DEFINE _CONNECT_IDENTIFIER = "oemrept2" (CHAR)
DEFINE _SQLPLUS_RELEASE = "902000700" (CHAR)
DEFINE _EDITOR         = "Notepad" (CHAR)
DEFINE _O_VERSION      = "Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Production
With the Partitioning, OLAP and Data Mining options" (CHAR)
DEFINE _O_RELEASE      = "1002000300" (CHAR)
DEFINE SQLP            = "OEMREPT" (CHAR)
OEMREPT> 
9 июн 08, 09:53    [5780126]     Ответить | Цитировать Сообщить модератору
Все форумы / Oracle Ответить