`

SP2-0618: 无法找到会话标识符

阅读更多

SQL> set autotrace on;
SP2-0618: 无法找到会话标识符。启用检查 PLUSTRACE 角色
SP2-0611: 启用 STATISTICS 报告时出错


SQL>conn / as sysdba
已连接。
SQL> grant select any dictionary to user;
授权成功。
SQL> conn  user/password
已连接。
SQL> set autotrace  on;
SQL> select * from v$version;

BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi
PL/SQL Release 10.2.0.4.0 - Production
CORE    10.2.0.4.0      Production
TNS for IBM/AIX RISC System/6000: Version 10.2.0.4.0 - Productio
NLSRTL Version 10.2.0.4.0 - Production


执行计划
----------------------------------------------------------
Plan hash value: 2696698428

------------------------------------------------------------------------------
| Id  | Operation        | Name      | Rows  | Bytes | Cost (%CPU)| Time     |
------------------------------------------------------------------------------
|   0 | SELECT STATEMENT |           |     1 |    47 |     0   (0)| 00:00:01 |
|*  1 |  FIXED TABLE FULL| X$VERSION |     1 |    47 |     0   (0)| 00:00:01 |
------------------------------------------------------------------------------

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

   1 - filter("INST_ID"=USERENV('INSTANCE'))


统计信息
----------------------------------------------------------
        250  recursive calls
          0  db block gets
         56  consistent gets
          0  physical reads
          0  redo size
        470  bytes sent via SQL*Net to client
        243  bytes received via SQL*Net from client
          2  SQL*Net roundtrips to/from client
          9  sorts (memory)
          0  sorts (disk)
          5  rows processed

 

分享到:
评论

相关推荐

Global site tag (gtag.js) - Google Analytics