【oracle 】怪異的資訊統計 結果全為0
SQL> conn scott/yang
已連線。
SQL> set linesize 120
SQL> set autot on
SQL> select id ,name from t;
ID NAM
---------- ---
1 a1
1 a1
1 a1
1 a2
1 a2
1 a2
2 a2
2 a2
2 a2
已選擇9行。
執行計劃
----------------------------------------------------------
Plan hash value: 1601196873
--------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time |
--------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | 9 | 54 | 3 (0)| 00:00:01 |
| 1 | TABLE ACCESS FULL| T | 9 | 54 | 3 (0)| 00:00:01 |
--------------------------------------------------------------------------
統計資訊
----------------------------------------------------------
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)
9 rows processed
SQL> select id ,name from t;
ID NAM
---------- ---
1 a1
1 a1
1 a1
1 a2
1 a2
1 a2
2 a2
2 a2
2 a2
已選擇9行。
執行計劃
----------------------------------------------------------
Plan hash value: 1601196873
--------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time |
--------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | 9 | 54 | 3 (0)| 00:00:01 |
| 1 | TABLE ACCESS FULL| T | 9 | 54 | 3 (0)| 00:00:01 |
--------------------------------------------------------------------------
統計資訊
----------------------------------------------------------
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)
9 rows processed
SQL> create table t as select object_id id ,object_name name from dba_objects;
表已建立。
SQL> set timing on
SQL> set autot traceonly
SQL> select id ,name from t;
已選擇68374行。
已用時間: 00: 00: 01.42
執行計劃
----------------------------------------------------------
Plan hash value: 1601196873
--------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time |
--------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | 60934 | 4700K| 95 (2)| 00:00:02 |
| 1 | TABLE ACCESS FULL| T | 60934 | 4700K| 95 (2)| 00:00:02 |
--------------------------------------------------------------------------
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)
68374 rows processed
已連線。
SQL> set linesize 120
SQL> set autot on
SQL> select id ,name from t;
ID NAM
---------- ---
1 a1
1 a1
1 a1
1 a2
1 a2
1 a2
2 a2
2 a2
2 a2
已選擇9行。
執行計劃
----------------------------------------------------------
Plan hash value: 1601196873
--------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time |
--------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | 9 | 54 | 3 (0)| 00:00:01 |
| 1 | TABLE ACCESS FULL| T | 9 | 54 | 3 (0)| 00:00:01 |
--------------------------------------------------------------------------
統計資訊
----------------------------------------------------------
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)
9 rows processed
SQL> select id ,name from t;
ID NAM
---------- ---
1 a1
1 a1
1 a1
1 a2
1 a2
1 a2
2 a2
2 a2
2 a2
已選擇9行。
執行計劃
----------------------------------------------------------
Plan hash value: 1601196873
--------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time |
--------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | 9 | 54 | 3 (0)| 00:00:01 |
| 1 | TABLE ACCESS FULL| T | 9 | 54 | 3 (0)| 00:00:01 |
--------------------------------------------------------------------------
統計資訊
----------------------------------------------------------
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)
9 rows processed
SQL> create table t as select object_id id ,object_name name from dba_objects;
表已建立。
SQL> set timing on
SQL> set autot traceonly
SQL> select id ,name from t;
已選擇68374行。
已用時間: 00: 00: 01.42
執行計劃
----------------------------------------------------------
Plan hash value: 1601196873
--------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time |
--------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | 60934 | 4700K| 95 (2)| 00:00:02 |
| 1 | TABLE ACCESS FULL| T | 60934 | 4700K| 95 (2)| 00:00:02 |
--------------------------------------------------------------------------
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)
68374 rows processed
遇見bug了!解決辦法: 斷開當前連線,重新連入就可以解決~
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/22664653/viewspace-677784/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- 使用mysql 統計函式 結果為null時返回值改為0MySql函式Null
- js new Date怪異行為JS
- 【統計資訊】Oracle統計資訊Oracle
- Oracle的統計資訊Oracle
- 統一返回結果狀態資訊類
- 收集全庫統計資訊
- 【統計資訊】Oracle常用的收集統計資訊方式Oracle
- mavn 執行 junit 單元測試的結果為 Tests run: 0, Failures: 0, Errors: 0, Skipped: 0AIError
- 解析Oracle執行計劃的結果Oracle
- ORACLE表統計資訊與列統計資訊、索引統計資訊Oracle索引
- python技巧 python2中的除法結果為0Python
- Oracle查詢結果 儲存為XMLOracleXML
- 修改oracle 的統計資訊Oracle
- 記錄oracle中查詢資料0.xx結果為.xx的解決辦法Oracle
- Oracle 統計資訊Oracle
- Oracle統計資訊Oracle
- [Oracle] “表中有資料,但select count(*)的結果為0”問題的解決辦法Oracle
- ORACLE表統計資訊與列統計資訊Oracle
- js中自執行函式的怪異行為研究JS函式
- Oracle系統統計資訊Oracle
- relink oracle的結果Oracle
- oracle執行計劃與統計資訊的一些總結Oracle
- Oracle收集統計資訊Oracle
- Oracle 統計資訊收集Oracle
- 收集oracle統計資訊Oracle
- ORACLE 收集統計資訊Oracle
- oracle統計資訊(四)Oracle
- oracle統計資訊(三)Oracle
- oracle統計資訊(二)Oracle
- oracle統計資訊(一)Oracle
- 以太坊實踐經驗之《eth.blockNumber結果為0》BloC
- 論資訊系統的定位--業務活動結果的記錄工具
- 為毛 "typeof null" 的結果為 "object" ?NullObject
- 10大怪異的程式語言
- 怪異的COM 執行緒模型執行緒模型
- 自定義統計結果指令碼mystat指令碼
- [Oracle] Oracle收集統計資訊的取樣比例Oracle
- ORACLE 統計資訊的收集與管理Oracle