Return
-
Title
Optimization, unexpected strange autotrace output -
Description
When running this script in TOAD, the autotrace output is unexpected.
It looks fine in SQL*Plus.TOAD example: Statistics
-----------------------------------------------------------
29 recursive calls
0 spare statistic
4 0 gets messages sent
0 db block gets direct
0 calls to kcmgrs
0 PX remote messages recv'd
0 buffer is pinned count
55 buffer is not pinned count
2 workarea executions - optimal
0 workarea executions - onepassThe same strange results atre in SQL Developer
-
Cause
When posted to the Oracle forum, Oracle moderators explained that the underlying row IDs had changed in the stats view.
Oracle had to make a code change (version 4) to fix it.
(SQL Developer forum thread, https://forums.oracle.com/message/11124453#11124453 ) -
Resolution
WORKAROUND:
NoneSTATUS:
This issue was fixed in Toad 12.1. The latest version of Toad can be downloaded here. -
Defect ID
111562 -
Additional Information
The script: CREATE TABLE t ( id NUMBER, a VARCHAR2 (100), b DATE ); INSERT INTO t SELECT ROWNUM, LPAD ('a', 100), SYSDATE FROM all_objects; set autotrace on update t set id =1 where rownum < 2; SQL*Plus example: Statistics ---------------------------------------------------------- 29 recursive calls 2 db block gets 88 consistent gets 0 physical reads 424 redo size 827 bytes sent via SQL*Net to client 696 bytes received via SQL*Net from client 3 SQL*Net roundtrips to/from client 1 sorts (memory) 0 sorts (disk) 1 rows processed