• 博客访问: 2995109
  • 博文数量: 2166
  • 用 户 组: 普通用户
  • 注册时间: 2008-03-30 17:16
个人简介

暂无介绍

ITPUB论坛APP

ITPUB论坛APP



APP发帖 享双倍积分

文章分类

全部博文(2166)

文章存档

2013年(7)

2012年(29)

2011年(54)

2010年(61)

2009年(200)

2008年(270)

2007年(590)

2006年(557)

2005年(391)

2004年(5)

2003年(2)

我的朋友
微信关注

IT168企业级官微



微信号:IT168qiye



系统架构师大会



微信号:SACC2013

不小心发现个小bug 2009-09-03 15:29:10

分类: IT综合技术

Microsoft Windows XP [版本 5.1.2600]
(C) 版权所有 1985-2001 Microsoft Corp.
C:Documents and Settingszhangrp>d:

D:>cd oracle10gbin
D:oracle10gBIN>set ORACLE_SID=ora10g
D:oracle10gBIN>sqlplus study/study
SQL*Plus: Release 10.2.0.4.0 - Production on 星期三 9月 2 14:20:48 2009
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.

连接到:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Production
With the Partitioning, Oracle Label Security, OLAP, Data Mining
and Real Application Testing options

SQL> conn /as sysdba已连接。
SQL> shutdown immediate;

数据库已经关闭。
已经卸载数据库。
ORACLE 例程已经关闭。
SQL> startup

ORACLE 例程已经启动。
Total System Global Area 247463936 bytes
Fixed Size 1296112 bytes
Variable Size 130025744 bytes
Database Buffers 109051904 bytes
Redo Buffers 7090176 bytes
数据库装载完毕。
数据库已经打开。
SQL> conn study/study已连接。
SQL> set autotrace on

SQL> select * from zrp;
未选定行

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

--------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time |
--------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | 1 | 13 | 2 (0)| 00:00:01 |
| 1 | TABLE ACCESS FULL| ZRP | 1 | 13 | 2 (0)| 00:00:01 |
--------------------------------------------------------------------------

Note
-----
- dynamic sampling used for this statement


统计信息
----------------------------------------------------------
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)
0 rows processed

SQL> set autotrace off
SQL> select * from zrp;

select * from zrp
*
第 1 行出现错误:
ORA-01012: 没有登录


SQL> conn study/study
已连接。
SQL> select * from zrp;

未选定行
SQL>

今天把11gR2装好了,测试了一下,这个问题没有再现,看来在11gR2中已经fix掉了

[oracle@vm11gR2] /oracle> sqlplus study/study
SQL*Plus: Release 11.2.0.1.0 Production on Thu Sep 3 23:26:07 2009

Copyright (c) 1982, 2009, Oracle. All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> conn /as sysdbaConnected.
SQL> shutdown immediate;

Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup

ORACLE instance started.
Total System Global Area 368263168 bytes
Fixed Size 1336596 bytes
Variable Size 121637612 bytes
Database Buffers 239075328 bytes
Redo Buffers 6213632 bytes
Database mounted.
Database opened.
SQL> conn study/study

Connected.
SQL> set autotrace on

SQL> select * from zrp;
NO
----------
1


Execution Plan
----------------------------------------------------------
Plan hash value: 1729665100

--------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time |
--------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | 1 | 13 | 3 (0)| 00:00:01 |
| 1 | TABLE ACCESS FULL| ZRP | 1 | 13 | 3 (0)| 00:00:01 |
--------------------------------------------------------------------------

Note
-----
- dynamic sampling used for this statement (level=2)


Statistics
----------------------------------------------------------
237 recursive calls
0 db block gets
43 consistent gets
8 physical reads
0 redo size
420 bytes sent via SQL*Net to client
419 bytes received via SQL*Net from client
2 SQL*Net roundtrips to/from client
4 sorts (memory)
0 sorts (disk)
1 rows processed

SQL> set autotrace off

SQL> select * from zrp;
NO
----------
1

SQL>

[@more@]
阅读(3296) | 评论(0) | 转发(0) |
给主人留下些什么吧!~~
评论热议
请登录后评论。

登录 注册