[20180320]toad環境中一次fetch等於多少
[20180320]toad環境中一次fetch等於多少.txt
--//上午重新看了以前寫的一篇文章,連結:http://blog.itpub.net/267265/viewspace-2150845/
--//裡面提到toad.PLSQLDev執行sql語句與sqlplus存在小量的不同,好奇心想測試toad下一次fetch是多少.
1.環境:
SCOTT@book> @ &r/ver1
PORT_STRING VERSION BANNER
------------------------------ -------------- --------------------------------------------------------------------------------
x86_64/Linux 2.4.xx 11.2.0.4.0 Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
SCOTT@test01p> create table t as select * from all_objects order by DBMS_RANDOM.random;
Table created.
SCOTT@test01p> create index i_t_object_id on t(object_id);
Index created.
SCOTT@test01p> select data_object_id,object_id from dba_objects where owner=user and object_name='T';
DATA_OBJECT_ID OBJECT_ID
-------------- ----------
107151 107151
--//分析.
execute sys.dbms_stats.gather_table_stats ( OwnName => nvl('',user),TabName => 't',Estimate_Percent => NULL,Method_Opt => 'FOR ALL COLUMNS SIZE 1 ',Cascade => True ,No_Invalidate => false)
2.在toad下跟蹤sql語句.
--//我在toad,選擇execute as script,執行如下:
show array
--//輸出:
arraysize 15
--//不知道是否就是15.
begin dbms_monitor.session_trace_enable(session_id => 54,serial_num => 137 , waits => true , binds => true);
select * from t;
begin dbms_monitor.session_trace_disable(session_id => 54,serial_num => 137);
--//注:先執行select * from t;多次避免一些不必要的遞迴語句執行.另外在執行前選擇右鍵"auto trace".這樣避免僅僅fetch 500行的情況.
--//檢查轉儲檔案內容:
=====================
PARSING IN CURSOR #140244900879464 len=15 dep=0 uid=83 oct=3 lid=83 tim=1521532392894843 hv=1134051363 ad='7c5fc930' sqlid='89km4qj1thh13'
select * from t
END OF STMT
PARSE #140244900879464:c=0,e=96,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=1,plh=1601196873,tim=1521532392894842
WAIT #140244900879464: nam='SQL*Net message to client' ela= 2 driver id=1413697536 #bytes=1 p3=0 obj#=90485 tim=1521532392894952
WAIT #140244900879464: nam='SQL*Net message from client' ela= 1386 driver id=1413697536 #bytes=1 p3=0 obj#=90485 tim=1521532392896418
EXEC #140244900879464:c=0,e=39,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=1,plh=1601196873,tim=1521532392896549
WAIT #140244900879464: nam='SQL*Net message to client' ela= 3 driver id=1413697536 #bytes=1 p3=0 obj#=90485 tim=1521532392897127
WAIT #140244900879464: nam='SQL*Net more data to client' ela= 32 driver id=1413697536 #bytes=8154 p3=0 obj#=90485 tim=1521532392897366
WAIT #140244900879464: nam='SQL*Net more data to client' ela= 20 driver id=1413697536 #bytes=8144 p3=0 obj#=90485 tim=1521532392897582
WAIT #140244900879464: nam='SQL*Net more data to client' ela= 17 driver id=1413697536 #bytes=8141 p3=0 obj#=90485 tim=1521532392897819
WAIT #140244900879464: nam='SQL*Net more data to client' ela= 22 driver id=1413697536 #bytes=8150 p3=0 obj#=90485 tim=1521532392898066
WAIT #140244900879464: nam='SQL*Net more data to client' ela= 20 driver id=1413697536 #bytes=8141 p3=0 obj#=90485 tim=1521532392898300
WAIT #140244900879464: nam='SQL*Net more data to client' ela= 19 driver id=1413697536 #bytes=8151 p3=0 obj#=90485 tim=1521532392898527
WAIT #140244900879464: nam='SQL*Net more data to client' ela= 33 driver id=1413697536 #bytes=8138 p3=0 obj#=90485 tim=1521532392898776
WAIT #140244900879464: nam='SQL*Net more data to client' ela= 32 driver id=1413697536 #bytes=8141 p3=0 obj#=90485 tim=1521532392899015
WAIT #140244900879464: nam='SQL*Net more data to client' ela= 20 driver id=1413697536 #bytes=8161 p3=0 obj#=90485 tim=1521532392899230
WAIT #140244900879464: nam='SQL*Net more data to client' ela= 21 driver id=1413697536 #bytes=8146 p3=0 obj#=90485 tim=1521532392899499
FETCH #140244900879464:c=3000,e=2977,p=28,cr=17,cu=0,mis=0,r=1001,dep=0,og=1,plh=1601196873,tim=1521532392899589
WAIT #140244900879464: nam='SQL*Net message from client' ela= 192337 driver id=1413697536 #bytes=1 p3=0 obj#=90485 tim=1521532393091994
WAIT #140244900879464: nam='SQL*Net message to client' ela= 2 driver id=1413697536 #bytes=1 p3=0 obj#=90485 tim=1521532393092110
WAIT #140244900879464: nam='SQL*Net more data to client' ela= 33 driver id=1413697536 #bytes=8147 p3=0 obj#=90485 tim=1521532393092334
WAIT #140244900879464: nam='SQL*Net more data to client' ela= 23 driver id=1413697536 #bytes=8147 p3=0 obj#=90485 tim=1521532393092552
WAIT #140244900879464: nam='SQL*Net more data to client' ela= 20 driver id=1413697536 #bytes=8144 p3=0 obj#=90485 tim=1521532393092768
WAIT #140244900879464: nam='SQL*Net more data to client' ela= 33 driver id=1413697536 #bytes=8147 p3=0 obj#=90485 tim=1521532393093192
WAIT #140244900879464: nam='SQL*Net more data to client' ela= 21 driver id=1413697536 #bytes=8146 p3=0 obj#=90485 tim=1521532393093401
WAIT #140244900879464: nam='SQL*Net more data to client' ela= 20 driver id=1413697536 #bytes=8147 p3=0 obj#=90485 tim=1521532393093620
WAIT #140244900879464: nam='SQL*Net more data to client' ela= 20 driver id=1413697536 #bytes=8144 p3=0 obj#=90485 tim=1521532393093842
WAIT #140244900879464: nam='SQL*Net more data to client' ela= 20 driver id=1413697536 #bytes=8146 p3=0 obj#=90485 tim=1521532393094084
WAIT #140244900879464: nam='SQL*Net more data to client' ela= 30 driver id=1413697536 #bytes=8142 p3=0 obj#=90485 tim=1521532393094309
WAIT #140244900879464: nam='SQL*Net more data to client' ela= 21 driver id=1413697536 #bytes=8140 p3=0 obj#=90485 tim=1521532393094610
FETCH #140244900879464:c=3000,e=2565,p=30,cr=15,cu=0,mis=0,r=1000,dep=0,og=1,plh=1601196873,tim=1521532393094649
...
--//第1次r=1001,以後都是1000.
$ egrep "FETCH #140244900879464" /u01/app/oracle/diag/rdbms/book/book/trace/book_ora_15945.trc
FETCH #140244900879464:c=3000,e=2977,p=28,cr=17,cu=0,mis=0,r=1001,dep=0,og=1,plh=1601196873,tim=1521532392899589
FETCH #140244900879464:c=3000,e=2565,p=30,cr=15,cu=0,mis=0,r=1000,dep=0,og=1,plh=1601196873,tim=1521532393094649
FETCH #140244900879464:c=3000,e=2300,p=0,cr=15,cu=0,mis=0,r=1000,dep=0,og=1,plh=1601196873,tim=1521532393102406
FETCH #140244900879464:c=1998,e=2479,p=15,cr=16,cu=0,mis=0,r=1000,dep=0,og=1,plh=1601196873,tim=1521532393109269
FETCH #140244900879464:c=3000,e=2389,p=15,cr=15,cu=0,mis=0,r=1000,dep=0,og=1,plh=1601196873,tim=1521532393116160
FETCH #140244900879464:c=2000,e=2429,p=15,cr=15,cu=0,mis=0,r=1000,dep=0,og=1,plh=1601196873,tim=1521532393123639
FETCH #140244900879464:c=2000,e=2361,p=7,cr=15,cu=0,mis=0,r=1000,dep=0,og=1,plh=1601196873,tim=1521532393130497
FETCH #140244900879464:c=3999,e=3473,p=134,cr=16,cu=0,mis=0,r=1000,dep=0,og=1,plh=1601196873,tim=1521532393138503
FETCH #140244900879464:c=2999,e=3536,p=126,cr=15,cu=0,mis=0,r=1000,dep=0,og=1,plh=1601196873,tim=1521532393146483
FETCH #140244900879464:c=2000,e=2341,p=0,cr=15,cu=0,mis=0,r=1000,dep=0,og=1,plh=1601196873,tim=1521532393153398
FETCH #140244900879464:c=2999,e=2391,p=0,cr=16,cu=0,mis=0,r=1000,dep=0,og=1,plh=1601196873,tim=1521532393160251
FETCH #140244900879464:c=2000,e=2305,p=0,cr=15,cu=0,mis=0,r=1000,dep=0,og=1,plh=1601196873,tim=1521532393167181
FETCH #140244900879464:c=3000,e=2306,p=0,cr=15,cu=0,mis=0,r=1000,dep=0,og=1,plh=1601196873,tim=1521532393174194
FETCH #140244900879464:c=2000,e=2308,p=0,cr=15,cu=0,mis=0,r=1000,dep=0,og=1,plh=1601196873,tim=1521532393181731
FETCH #140244900879464:c=2999,e=2296,p=0,cr=16,cu=0,mis=0,r=1000,dep=0,og=1,plh=1601196873,tim=1521532393188953
FETCH #140244900879464:c=2000,e=2317,p=0,cr=15,cu=0,mis=0,r=1000,dep=0,og=1,plh=1601196873,tim=1521532393195957
FETCH #140244900879464:c=2999,e=2296,p=0,cr=15,cu=0,mis=0,r=1000,dep=0,og=1,plh=1601196873,tim=1521532393202949
FETCH #140244900879464:c=3000,e=2770,p=126,cr=16,cu=0,mis=0,r=1000,dep=0,og=1,plh=1601196873,tim=1521532393210398
....
FETCH #140244900879464:c=2999,e=2290,p=0,cr=15,cu=0,mis=0,r=1000,dep=0,og=1,plh=1601196873,tim=1521532393632623
FETCH #140244900879464:c=2000,e=2394,p=0,cr=15,cu=0,mis=0,r=1000,dep=0,og=1,plh=1601196873,tim=1521532393639568
FETCH #140244900879464:c=3000,e=2336,p=0,cr=16,cu=0,mis=0,r=1000,dep=0,og=1,plh=1601196873,tim=1521532393646568
FETCH #140244900879464:c=1999,e=2321,p=0,cr=15,cu=0,mis=0,r=1000,dep=0,og=1,plh=1601196873,tim=1521532393653672
FETCH #140244900879464:c=3000,e=2350,p=0,cr=15,cu=0,mis=0,r=1000,dep=0,og=1,plh=1601196873,tim=1521532393660515
FETCH #140244900879464:c=2000,e=2308,p=0,cr=16,cu=0,mis=0,r=1000,dep=0,og=1,plh=1601196873,tim=1521532393667897
FETCH #140244900879464:c=1999,e=2292,p=0,cr=15,cu=0,mis=0,r=1000,dep=0,og=1,plh=1601196873,tim=1521532393674933
FETCH #140244900879464:c=2000,e=1846,p=0,cr=12,cu=0,mis=0,r=760,dep=0,og=1,plh=1601196873,tim=1521532393681423
--//檢查記錄總數:
SCOTT@book> select count(*) from t;
COUNT(*)
----------
84761
$ egrep "FETCH #140244900879464" /u01/app/oracle/diag/rdbms/book/book/trace/book_ora_15945.trc|wc
85 170 9541
--//83*1000+1001+760 = 84761,正好一致.toad工具與sqlplus在fetch上存在不同.這樣可以推斷一般情況下語句toad下執行,
--//邏輯讀少1個.
--//在sqlplus下:
alter session set statistics_level=all;
set array 1000
select * from emp;
Plan hash value: 3956160932
--------------------------------------------------------------------------------------------------------------------
| Id | Operation | Name | Starts | E-Rows |E-Bytes| Cost (%CPU)| E-Time | A-Rows | A-Time | Buffers |
--------------------------------------------------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | 1 | | | 3 (100)| | 14 |00:00:00.01 | 7 |
| 1 | TABLE ACCESS FULL| EMP | 1 | 14 | 532 | 3 (0)| 00:00:01 | 14 |00:00:00.01 | 7 |
--------------------------------------------------------------------------------------------------------------------
--//邏輯讀是6個.
--//在toad下執行:
alter session set statistics_level=all;
set array 1000
Select /*+aaaaaa */ * from emp;
--//查詢字串aaaaa,定位sql_id=0uqyfh37y1khk.
SCOTT@book> @ &r/dpc 0uqyfh37y1khk ''
PLAN_TABLE_OUTPUT
-------------------------------------
SQL_ID 0uqyfh37y1khk, child number 0
-------------------------------------
Select /*+aaaaaa */ * from emp
Plan hash value: 3956160932
--------------------------------------------------------------------------------------------------------------------
| Id | Operation | Name | Starts | E-Rows |E-Bytes| Cost (%CPU)| E-Time | A-Rows | A-Time | Buffers |
--------------------------------------------------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | 1 | | | 3 (100)| | 14 |00:00:00.01 | 6 |
| 1 | TABLE ACCESS FULL| EMP | 1 | 14 | 532 | 3 (0)| 00:00:01 | 14 |00:00:00.01 | 6 |
--------------------------------------------------------------------------------------------------------------------
Query Block Name / Object Alias (identified by operation id):
-------------------------------------------------------------
1 - SEL$1 / EMP@SEL$1
select * from v$sql where sql_id='0uqyfh37y1khk';
Record View
As of: 2018/3/20 16:04:30
SQL_TEXT: Select /*+aaaaaa */ * from emp
SQL_FULLTEXT: Select /*+aaaaaa */ * from emp
SQL_ID: 0uqyfh37y1khk
SHARABLE_MEM: 19703
PERSISTENT_MEM: 6032
RUNTIME_MEM: 4328
SORTS: 0
LOADED_VERSIONS: 1
OPEN_VERSIONS: 0
USERS_OPENING: 0
FETCHES: 1
EXECUTIONS: 1
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
PX_SERVERS_EXECUTIONS: 0
END_OF_FETCH_COUNT: 1
USERS_EXECUTING: 0
LOADS: 1
FIRST_LOAD_TIME: 2018-03-20/16:03:29
INVALIDATIONS: 0
PARSE_CALLS: 1
DISK_READS: 0
DIRECT_WRITES: 0
BUFFER_GETS: 6
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
APPLICATION_WAIT_TIME: 0
CONCURRENCY_WAIT_TIME: 0
CLUSTER_WAIT_TIME: 0
USER_IO_WAIT_TIME: 0
PLSQL_EXEC_TIME: 0
JAVA_EXEC_TIME: 0
ROWS_PROCESSED: 14
COMMAND_TYPE: 3
OPTIMIZER_MODE: ALL_ROWS
OPTIMIZER_COST: 3
OPTIMIZER_ENV: E289FB89E426A8004E011000AEF9C3E2CFFA335056414555519521105555551545545558591556449665851D5511058555555155515122555415A0EA0C5551454265455454449081566E001696C6A35545150102541550441615579110A8456E820A508021000020000000000100001000000002002080007D000000000004C0CCCC001010000080830F4000006066660000000002406E820A50464626202040262320030020003020A0A05050A04001200000401F000000A5A0A0A040863E000040060C382000200000F0FF0F000083210304000200403600
OPTIMIZER_ENV_HASH_VALUE: 4224879066
PARSING_USER_ID: 83
PARSING_SCHEMA_ID: 83
PARSING_SCHEMA_NAME: SCOTT
KEPT_VERSIONS: 0
ADDRESS: 000000007D140228
TYPE_CHK_HEAP: 00
HASH_VALUE: 3487615506
OLD_HASH_VALUE: 1453398800
PLAN_HASH_VALUE: 3956160932
CHILD_NUMBER: 0
SERVICE: SYS$USERS
SERVICE_HASH: 0
MODULE: TOAD 12.0.0.61
MODULE_HASH: -2129441675
ACTION:
ACTION_HASH: 0
SERIALIZABLE_ABORTS: 0
OUTLINE_CATEGORY:
CPU_TIME: 1999
ELAPSED_TIME: 1615
OUTLINE_SID:
CHILD_ADDRESS: 000000007E18BC80
SQLTYPE: 6
REMOTE: N
OBJECT_STATUS: VALID
LITERAL_HASH_VALUE: 0
LAST_LOAD_TIME: 2018-03-20/16:03:29
IS_OBSOLETE: N
IS_BIND_SENSITIVE: N
IS_BIND_AWARE: N
IS_SHAREABLE: Y
CHILD_LATCH: 0
SQL_PROFILE:
SQL_PATCH:
SQL_PLAN_BASELINE:
PROGRAM_ID: 0
PROGRAM_LINE#: 0
EXACT_MATCHING_SIGNATURE: 14172186495060009189
FORCE_MATCHING_SIGNATURE: 14172186495060009189
LAST_ACTIVE_TIME: 2018/3/20 16:03:29
BIND_DATA:
TYPECHECK_MEM: 0
IO_CELL_OFFLOAD_ELIGIBLE_BYTES: 0
IO_INTERCONNECT_BYTES: 0
PHYSICAL_READ_REQUESTS: 0
PHYSICAL_READ_BYTES: 0
PHYSICAL_WRITE_REQUESTS: 0
PHYSICAL_WRITE_BYTES: 0
OPTIMIZED_PHY_READ_REQUESTS: 0
LOCKED_TOTAL: 1
PINNED_TOTAL: 2
IO_CELL_UNCOMPRESSED_BYTES: 0
IO_CELL_OFFLOAD_RETURNED_BYTES: 0
--//BUFFER_GETS:6.說明toad與sqlplus在fetch不同.
3.測試toad下不開啟auto trace的情況,從顯示上fetch=500,看看是否一致:
=====================
PARSING IN CURSOR #139777480832064 len=15 dep=0 uid=83 oct=3 lid=83 tim=1521533343854177 hv=2195969672 ad='7b5c7a50' sqlid='5y59up61f7pn8'
Select * from t
END OF STMT
PARSE #139777480832064:c=22996,e=22741,p=1,cr=98,cu=0,mis=1,r=0,dep=0,og=1,plh=1601196873,tim=1521533343854175
WAIT #139777480832064: nam='SQL*Net message to client' ela= 1 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=1521533343854316
WAIT #139777480832064: nam='SQL*Net message from client' ela= 1846 driver id=1413697536 #bytes=1 p3=0 obj#=-1 tim=1521533343856234
EXEC #139777480832064:c=1000,e=37,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=1,plh=1601196873,tim=1521533343856364
WAIT #139777480832064: nam='Disk file operations I/O' ela= 37 FileOperation=2 fileno=4 filetype=2 obj#=90485 tim=1521533343856773
WAIT #139777480832064: nam='SQL*Net message to client' ela= 2 driver id=1413697536 #bytes=1 p3=0 obj#=90485 tim=1521533343857163
WAIT #139777480832064: nam='SQL*Net more data to client' ela= 33 driver id=1413697536 #bytes=8154 p3=0 obj#=90485 tim=1521533343857408
WAIT #139777480832064: nam='SQL*Net more data to client' ela= 14 driver id=1413697536 #bytes=8144 p3=0 obj#=90485 tim=1521533343857616
WAIT #139777480832064: nam='SQL*Net more data to client' ela= 17 driver id=1413697536 #bytes=8141 p3=0 obj#=90485 tim=1521533343857889
WAIT #139777480832064: nam='SQL*Net more data to client' ela= 38 driver id=1413697536 #bytes=8150 p3=0 obj#=90485 tim=1521533343858147
WAIT #139777480832064: nam='SQL*Net more data to client' ela= 19 driver id=1413697536 #bytes=8141 p3=0 obj#=90485 tim=1521533343858381
WAIT #139777480832064: nam='SQL*Net more data to client' ela= 19 driver id=1413697536 #bytes=8151 p3=0 obj#=90485 tim=1521533343858603
WAIT #139777480832064: nam='SQL*Net more data to client' ela= 21 driver id=1413697536 #bytes=8138 p3=0 obj#=90485 tim=1521533343858847
WAIT #139777480832064: nam='SQL*Net more data to client' ela= 21 driver id=1413697536 #bytes=8141 p3=0 obj#=90485 tim=1521533343859087
WAIT #139777480832064: nam='SQL*Net more data to client' ela= 19 driver id=1413697536 #bytes=8161 p3=0 obj#=90485 tim=1521533343859313
WAIT #139777480832064: nam='SQL*Net more data to client' ela= 22 driver id=1413697536 #bytes=8146 p3=0 obj#=90485 tim=1521533343859590
FETCH #139777480832064:c=3000,e=3213,p=28,cr=17,cu=0,mis=0,r=1001,dep=0,og=1,plh=1601196873,tim=1521533343859647
WAIT #139777480832064: nam='SQL*Net message from client' ela= 119119 driver id=1413697536 #bytes=1 p3=0 obj#=90485 tim=1521533343978817
=====================
--//fetch=1001.
4.順便看看PLSQLDev的情況:
--//測試結果應該是100.
$ grep "FETCH #139965460872664" /u01/app/oracle/diag/rdbms/book/book/trace/book_ora_16109.trc
FETCH #139965460872664:c=1000,e=695,p=20,cr=4,cu=0,mis=0,r=100,dep=0,og=1,plh=1601196873,tim=1521533779598271
FETCH #139965460872664:c=0,e=307,p=0,cr=2,cu=0,mis=0,r=100,dep=0,og=1,plh=1601196873,tim=1521533782180292
FETCH #139965460872664:c=1000,e=279,p=0,cr=3,cu=0,mis=0,r=100,dep=0,og=1,plh=1601196873,tim=1521533782206909
FETCH #139965460872664:c=0,e=290,p=0,cr=2,cu=0,mis=0,r=100,dep=0,og=1,plh=1601196873,tim=1521533782224681
FETCH #139965460872664:c=0,e=232,p=0,cr=3,cu=0,mis=0,r=100,dep=0,og=1,plh=1601196873,tim=1521533782243138
FETCH #139965460872664:c=0,e=282,p=0,cr=2,cu=0,mis=0,r=100,dep=0,og=1,plh=1601196873,tim=1521533782261461
FETCH #139965460872664:c=999,e=290,p=0,cr=3,cu=0,mis=0,r=100,dep=0,og=1,plh=1601196873,tim=1521533782279416
FETCH #139965460872664:c=0,e=280,p=0,cr=2,cu=0,mis=0,r=100,dep=0,og=1,plh=1601196873,tim=1521533782296539
...
FETCH #139965460872664:c=0,e=282,p=0,cr=3,cu=0,mis=0,r=100,dep=0,og=1,plh=1601196873,tim=1521533797337787
FETCH #139965460872664:c=0,e=280,p=0,cr=2,cu=0,mis=0,r=100,dep=0,og=1,plh=1601196873,tim=1521533797357360
FETCH #139965460872664:c=0,e=282,p=0,cr=3,cu=0,mis=0,r=100,dep=0,og=1,plh=1601196873,tim=1521533797376466
FETCH #139965460872664:c=1000,e=701,p=0,cr=2,cu=0,mis=0,r=100,dep=0,og=1,plh=1601196873,tim=1521533797397126
FETCH #139965460872664:c=0,e=285,p=0,cr=3,cu=0,mis=0,r=100,dep=0,og=1,plh=1601196873,tim=1521533797418411
FETCH #139965460872664:c=0,e=286,p=0,cr=2,cu=0,mis=0,r=100,dep=0,og=1,plh=1601196873,tim=1521533797431384
FETCH #139965460872664:c=0,e=198,p=0,cr=2,cu=0,mis=0,r=61,dep=0,og=1,plh=1601196873,tim=1521533797456034
$ grep "FETCH #139965460872664" /u01/app/oracle/diag/rdbms/book/book/trace/book_ora_16109.trc |wc
848 1696 90671
--//847*100+61 = 84761,也與總記錄一致.
--//不過PLSQLDev也與toad不同前面每次都是100.
--//不知道這些引數是否可以修改,不熟悉toad以及PLSQLDev這方面內容.
來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/267265/viewspace-2152038/，如需轉載，請註明出處，否則將追究法律責任。
相關文章
- [20180321]toad下execute as script的fetch
- 1111 & 0110 等於多少？
- Linux中的環境變數知多少？Linux變數
- 直播系統開發中關於開發環境你瞭解多少？開發環境
- openEuler網路配置+換源+桌面環境ukui等基本環境部署UI
- 關於QGis1.8二次開發的環境配置
- java中的Math.round(-1.5)等於多少Java
- 一次對requirements環境的配置UIREM
- 【二級等保】二級等保安全物理環境要求有哪些？
- 基於vscode搭建freertos環境VSCode
- 關於：laravel開發環境Laravel開發環境
- 關於“心流”與“環境”
- GPU 環境搭建指南：如何在裸機、Docker、K8s 等環境中使用 GPUGPUDockerK8S
- Superset Windows二次開發環境搭建Windows開發環境
- 一次生產環境OOM排查OOM
- 基於ubuntu如何搭建TensorFlow環境Ubuntu
- 基於ECS快速搭建Docker環境Docker
- UG 2406 python 二次開發環境配置Python開發環境
- SQL稽核 | SQLE 二次開發環境搭建SQL開發環境
- 配置開發環境、生成環境、測試環境開發環境
- 基於 Xcode 搭建 OpenCV 開發環境XCodeOpenCV開發環境
- 基於Docker的LNMP開發環境DockerLNMP開發環境
- 基於 Laradock 環境 Project 的總結Project
- 基於Webpack搭建React開發環境WebReact開發環境
- 【QT6】pycharm整合qt desinger（非anaconda等環境下）QTPyCharm
- SMM（spring +springmvc+mybatis）依賴註解等環境配置SpringMVCMyBatis
- Mac 修改Java環境變數 pod brew等其他不能用MacJava變數
- Anaconda建立環境、刪除環境、環境重新命名、檢視環境名
- 記錄一次預釋出環境的 Bug
- 一次生產環境的docker MySQL故障DockerMySql
- 記錄一次 LNMP 環境搭建到 Https 配置LNMPHTTP
- [20180830]工作中一次失誤.txt
- 基於 Fetch 的請求封裝封裝
- （轉）git中關於fetch的使用Git
- 面試中一個暴露能力等級的問題面試
- FreeRtos於嵌入式環境的應用
- OpenShift 本地開發環境配置(基於 Minishift)開發環境
- lnmp 環境的 docker 可用於 Laravel 和 hyperfLNMPDockerLaravel