How to generate Statspack Report
==================================
For general Report:
sqlplus perfstat/my_perfstat_password @$ORACLE_HOME/rdbms/admin/spreport.sql
For specific SQL Report:
sqlplus perfstat/my_perfstat_password @$ORACLE_HOME/rdbms/admin/sprepsql.sql
References to the complete Statspack Reports
==================================
This is a link to full Statspack Report
This is a link to full Statspack SQL Report
==================================
Important parts of Statspack Report
==================================
STATSPACK report for
Database DB Id Instance Inst Num Startup Time Release RAC
~~~~~~~~ ----------- ------------ -------- --------------- ----------- ---
1066102538 igt 1 15-Sep-15 08:45 11.2.0.4.0 NO
Host Name Platform CPUs Cores Sockets Memory (G)
~~~~ ---------------- ---------------------- ----- ----- ------- ------------
my_server-aps-1 Linux x86 64-bit 12 6 1 31.3
Snapshot Snap Id Snap Time Sessions Curs/Sess Comment
~~~~~~~~ ---------- ------------------ -------- --------- ------------------
Begin Snap: 6693 31-Jan-16 00:00:03 153 5.5
End Snap: 6723 01-Feb-16 00:00:02 153 5.5
Elapsed: 1,439.98 (mins) Av Act Sess: 0.0
DB time: 10.30 (mins) DB CPU: 19.78 (mins)
Cache Sizes Begin End
~~~~~~~~~~~ ---------- ----------
Buffer Cache: 72M Std Block Size: 8K
Shared Pool: 552M Log Buffer: 5,120K
Load Profile Per Second Per Transaction Per Exec Per Call
~~~~~~~~~~~~ ------------------ ----------------- ----------- -----------
DB time(s): 0.0 0.0 0.00 0.00
DB CPU(s): 0.0 0.0 0.00 0.00
Redo size: 11,431.3 20,020.5
Logical reads: 302.2 529.3
Block changes: 51.1 89.4
Physical reads: 17.5 30.7
Physical writes: 2.0 3.5
User calls: 7.2 12.7
Parses: 10.6 18.6
Hard parses: 0.2 0.4
W/A MB processed: 0.1 0.1
Logons: 0.8 1.5
Executes: 21.2 37.1
Rollbacks: 0.0 0.0
Transactions: 0.6
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Buffer Nowait %: 100.00 Redo NoWait %: 100.00
Buffer Hit %: 98.68 Optimal W/A Exec %: 100.00
Library Hit %: 90.53 Soft Parse %: 97.76
Execute to Parse %: 49.94 Latch Hit %: 99.99
Parse CPU to Parse Elapsd %: 72.11 % Non-Parse CPU: 89.51
Top 5 Timed Events Avg %Total
~~~~~~~~~~~~~~~~~~ wait Call
Event Waits Time (s) (ms) Time
----------------------------------------- ------------ ----------- ------ ------
CPU time 524 88.6
control file parallel write 74,394 24 0 4.1
log file parallel write 61,304 10 0 1.6
log file sync 27,068 6 0 1.1
db file async I/O submit 3,216 6 2 1.0
Time Model System Stats DB/Inst: IGT/igt Snaps: 6693-6723
-> Ordered by % of DB time desc, Statistic name
Statistic Time (s) % DB time
----------------------------------- -------------------- ---------
DB CPU 1,186.7 192.1
sql execute elapsed time 196.7 31.8
connection management call elapsed 156.6 25.3
parse time elapsed 43.7 7.1
PL/SQL execution elapsed time 25.0 4.0
hard parse elapsed time 16.8 2.7
RMAN cpu time (backup/restore) 6.4 1.0
hard parse (sharing criteria) elaps 1.9 .3
PL/SQL compilation elapsed time 0.7 .1
repeated bind elapsed time 0.3 .0
failed parse elapsed time 0.1 .0
sequence load elapsed time 0.1 .0
hard parse (bind mismatch) elapsed 0.0 .0
inbound PL/SQL rpc elapsed time 0.0 .0
DB time 617.8
background elapsed time 974.1
background cpu time 610.1
Foreground Wait Events DB/Inst: IGT/igt Snaps: 6693-6723
-> Only events with Total Wait Time (s) >= .001 are shown
-> ordered by Total Wait Time desc, Waits desc (idle events last)
Avg %Total
%Tim Total Wait wait Waits Call
Event Waits out Time (s) (ms) /txn Time
---------------------------- ------------ ---- ---------- ------ -------- ------
log file sync 27,042 0 6 0 0.5 1.1
PL/SQL lock timer 12 100 2 176 0.0 .4
enq: TM - contention 1 0 2 1557 0.0 .3
cursor: pin S wait on X 58 0 1 25 0.0 .2
db file sequential read 121,513 0 1 0 2.5 .1
db file scattered read 8,143 0 0 0 0.2 .0
Disk file operations I/O 2,218 0 0 0 0.0 .0
kksfbc child completion 4 75 0 38 0.0 .0
local write wait 323 0 0 0 0.0 .0
enq: RO - fast object reuse 161 0 0 1 0.0 .0
enq: TQ - DDL contention 1 0 0 104 0.0 .0
latch: shared pool 417 0 0 0 0.0 .0
kupp process wait 1 100 0 101 0.0 .0
undo segment extension 18 100 0 5 0.0 .0
control file sequential read 26,352 0 0 0 0.5 .0
enq: KO - fast object checkp 1 0 0 54 0.0 .0
utl_file I/O 15,325 0 0 0 0.3 .0
SQL ordered by CPU DB/Inst: IGT/igt Snaps: 6693-6723
-> Total DB CPU (s): 1,187
-> Captured SQL accounts for 13.5% of Total DB CPU
-> SQL reported below exceeded 1.0% of Total DB CPU
CPU CPU per Elapsd Old
Time (s) Executions Exec (s) %Total Time (s) Buffer Gets Hash Value
---------- ------------ ---------- ------ ---------- --------------- ----------
337.71 159,917 0.00 28.5 404.33 112,917,673 3851979199
Module: dbrefresh@my_server-aps-1 (TNS V1-V3)
SELECT TABLE_ID, ISN, MAP_NAME FROM REFRESH_LOG ORDER BY TABLE_
ID, MAP_NAME
318.37 1 318.37 26.8 319.34 16,027,104 3774594237
BEGIN SYS.KUPW$WORKER.MAIN('SYS_EXPORT_FULL_01', 'SHDAEMON',
0); END;
SQL ordered by Elapsed time for DB: IGT Instance: igt Snaps: 6693 -6723
-> Total DB Time (s): 618
-> Captured SQL accounts for 30.1% of Total DB Time
-> SQL reported below exceeded 1.0% of Total DB Time
Elapsed Elap per CPU Old
Time (s) Executions Exec (s) %Total Time (s) Physical Reads Hash Value
---------- ------------ ---------- ------ ---------- --------------- ----------
404.33 159,917 0.00 65.4 337.71 1,011,306 3851979199
Module: dbrefresh@my_server-aps-1 (TNS V1-V3)
SELECT TABLE_ID, ISN, MAP_NAME FROM REFRESH_LOG ORDER BY TABLE_
ID, MAP_NAME
319.34 1 319.34 51.7 318.37 228,875 3774594237
BEGIN SYS.KUPW$WORKER.MAIN('SYS_EXPORT_FULL_01', 'SHDAEMON',
0); END;
SQL ordered by Gets DB/Inst: IGT/igt Snaps: 6693-6723
-> End Buffer Gets Threshold: 10000 Total Buffer Gets: 26,112,113
-> Captured SQL accounts for 18.7% of Total Buffer Gets
-> SQL reported below exceeded 1.0% of Total Buffer Gets
` CPU Elapsd Old
Buffer Gets Executions Gets per Exec %Total Time (s) Time (s) Hash Value
--------------- ------------ -------------- ------ -------- --------- ----------
112,917,673 159,917 706.1 454.5 337.71 404.33 3851979199
Module: dbrefresh@my_server-aps-1 (TNS V1-V3)
SELECT TABLE_ID, ISN, MAP_NAME FROM REFRESH_LOG ORDER BY TABLE_
ID, MAP_NAME
16,027,104 1 16,027,104.0 64.5 318.37 319.34 3774594237
BEGIN SYS.KUPW$WORKER.MAIN('SYS_EXPORT_FULL_01', 'SHDAEMON',
0); END;
SQL ordered by Reads DB/Inst: IGT/igt Snaps: 6693-6723
-> End Disk Reads Threshold: 1000 Total Disk Reads: 1,515,068
-> Captured SQL accounts for 71.6% of Total Disk Reads
-> SQL reported below exceeded 1.0% of Total Disk Reads
CPU Elapsd
Physical Rds Executions Rds per Exec %Total Time (s) Time (s) Hash Value
--------------- ------------ -------------- ------ -------- --------- ----------
1,011,306 159,917 6.3 66.7 337.71 404.33 3851979199
Module: dbrefresh@my_server-aps-1 (TNS V1-V3)
SELECT TABLE_ID, ISN, MAP_NAME FROM REFRESH_LOG ORDER BY TABLE_
ID, MAP_NAME
228,875 1 228,875.0 15.1 318.37 319.34 3774594237
BEGIN SYS.KUPW$WORKER.MAIN('SYS_EXPORT_FULL_01', 'SHDAEMON',
0); END;
SQL ordered by Executions DB/Inst: IGT/igt Snaps: 6693-6723
-> End Executions Threshold: 100 Total Executions: 1,829,377
-> Captured SQL accounts for 37.3% of Total Executions
-> SQL reported below exceeded 1.0% of Total Executions
CPU per Elap per Old
Executions Rows Processed Rows per Exec Exec (s) Exec (s) Hash Value
------------ --------------- ---------------- ----------- ---------- ----------
1,241,703 622,549 0.5 0.00 0.00 2275360153
select /*+ connect_by_filtering */ privilege#,level from sysauth
$ connect by grantee#=prior privilege# and privilege#>0 start wi
th grantee#=:1 and privilege#>0
620,874 1,241,674 2.0 0.00 0.00 3840591838
select privilege# from sysauth$ where (grantee#=:1 or grantee#=1
) and privilege#>0
SQL ordered by Parse Calls DB/Inst: IGT/igt Snaps: 6693-6723
-> End Parse Calls Threshold: 1000 Total Parse Calls: 915,778
-> Captured SQL accounts for 31.7% of Total Parse Calls
-> SQL reported below exceeded 1.0% of Total Parse Calls
% Total Old
Parse Calls Executions Parses Hash Value
------------ ------------ -------- ----------
1,241,704 1,241,703 135.59 2275360153
select /*+ connect_by_filtering */ privilege#,level from sysauth
$ connect by grantee#=prior privilege# and privilege#>0 start wi
th grantee#=:1 and privilege#>0
620,886 620,874 67.80 3840591838
select privilege# from sysauth$ where (grantee#=:1 or grantee#=1
) and privilege#>0
SQL ordered by Sharable Memory DB/Inst: IGT/igt Snaps: 6693-6723
-> End Sharable Memory Threshold(KB): 1024
Max End
Sharable Sharable Old
Memory (KB) Memory (KB) Parse Calls Executions % Total Hash Value
----------- ----------- ------------ ------------ ------- ----------
7,527 7,527 2,414 2,415 1.3 3285818817
select owner#,name,namespace,remoteowner,linkname,p_timestamp,p_
obj#, nvl(property,0),subname,type#,d_attrs from dependency$ d,
obj$ o where d_obj#=:1 and p_obj#=obj#(+) order by order#
6,879 6,879 2,414 2,415 1.2 1198893840
select order#,columns,types from access$ where d_obj#=:1
Instance Activity Stats DB/Inst: IGT/igt Snaps: 6693-6723
Statistic Total per Second per Trans
--------------------------------- ------------------ -------------- ------------
IMU Redo allocation size 54,640,188 632.4 1,107.6
IMU undo allocation size 251,500,832 2,910.9 5,098.1
buffer is not pinned count 12,549,684 145.3 254.4
buffer is pinned count 14,893,313 172.4 301.9
bytes received via SQL*Net from c 275,505,855 3,188.8 5,584.7
bytes received via SQL*Net from d 0 0.0 0.0
bytes sent via SQL*Net to client 169,289,043 1,959.4 3,431.6
bytes sent via SQL*Net to dblink 0 0.0 0.0
calls to get snapshot scn: kcmgss 3,589,570 41.6 72.8
calls to kcmgas 160,032 1.9 3.2
calls to kcmgcs 408,012 4.7 8.3
cell physical IO interconnect byt 35,763,218,944 413,930.9 724,949.7
file io wait time 642,373,752 7,435.0 13,021.4
frame signature mismatch 0 0.0 0.0
free buffer inspected 415,174 4.8 8.4
free buffer requested 557,486 6.5 11.3
heap block compress 40,673 0.5 0.8
hot buffers moved to head of LRU 78,002 0.9 1.6
immediate (CR) block cleanout app 6,276 0.1 0.1
immediate (CURRENT) block cleanou 189,097 2.2 3.8
in call idle wait time 209,922,933 2,429.7 4,255.3
Instance Activity Stats DB/Inst: IGT/igt Snaps: 6693-6723
-> Statistics with absolute values (should not be diffed)
Statistic Begin Value End Value
--------------------------------- --------------- ---------------
logons current 153 153
opened cursors current 840 839
session cursor cache count 197,821,840 198,297,069
workarea memory allocated 1,739 2,486
-------------------------------------------------------------
OS Statistics DB/Inst: IGT/igt Snaps: 6693-6723
-> ordered by statistic type (CPU use, Virtual Memory, Hardware Config), Name
Statistic Total
------------------------- ----------------------
BUSY_TIME 1,490,571
IDLE_TIME 101,992,240
IOWAIT_TIME 3,310
NICE_TIME 81
SYS_TIME 511,948
USER_TIME 960,197
RSRC_MGR_CPU_WAIT_TIME 0
VM_IN_BYTES 454,656
VM_OUT_BYTES 0
PHYSICAL_MEMORY_BYTES 33,627,045,888
NUM_CPUS 12
NUM_CPU_CORES 6
NUM_CPU_SOCKETS 1
GLOBAL_RECEIVE_SIZE_MAX 4,194,304
GLOBAL_SEND_SIZE_MAX 1,048,576
TCP_RECEIVE_SIZE_DEFAULT 87,380
TCP_RECEIVE_SIZE_MAX 4,194,304
TCP_RECEIVE_SIZE_MIN 4,096
TCP_SEND_SIZE_DEFAULT 16,384
TCP_SEND_SIZE_MAX 4,194,304
TCP_SEND_SIZE_MIN 4,096
OS Statistics - detail DB/Inst: IGT/igt Snaps: 6693-6723
Snap Snapshot
Id Day Time Load %Busy %User %System %WIO %WCPU
------ --------------- ------ ------ ------ ------- ------ ------
6693 Sun 31 00:00:03 .0
6694 Sun 31 01:00:04 .0 1.2 .7 .4 0.0
6695 Sun 31 02:00:00 .0 1.1 .7 .4 0.0
6696 Sun 31 03:00:01 .0 1.1 .6 .4 0.0
6697 Sun 31 04:00:02 .1 1.1 .7 .4 0.0
6698 Sun 31 05:00:02 .0 1.1 .6 .4 0.0
6699 Sun 31 06:00:03 .1 1.1 .7 .4 0.0
6700 Sun 31 07:00:04 .0 1.2 .7 .4 0.0
IO Stat by Function - summary DB/Inst: IGT/igt Snaps: 6693-6723
->Data Volume values suffixed with M,G,T,P are in multiples of 1024,
other values suffixed with K,M,G,T,P are in multiples of 1000
->ordered by Data Volume (Read+Write) desc
---------- Read --------- --------- Write -------- --- Wait ----
Data Requests Data Data Requests Data Avg
Function Volume /sec Vol/sec Volume /sec Vol/sec Count Tm(ms)
--------------- ------ -------- -------- ------ -------- -------- ------ ------
RMAN 7247M .2 .1M 2375M .0 .0M 2771 0.0
Direct Reads 8110M .8 .1M 0.0
LGWR 2462M 1.8 .0M 3002M 2.6 .0M 262K 0.0
Others 2793M 1.3 .0M 2465M 1.1 .0M 143K 0.0
Buffer Cache Re 2330M 2.1 .0M 175K 0.0
Data Pump 1397M 1.3 .0M 829M .5 .0M 76K 0.0
Streams AQ .0 3 0.0
Tablespace IO Stats DB/Inst: IGT/igt Snaps: 6693-6723
->ordered by IOs (Reads + Writes) desc
Tablespace
------------------------------
Av Av Av Av Buffer Av Buf
Reads Reads/s Rd(ms) Blks/Rd Writes Writes/s Waits Wt(ms)
-------------- ------- ------ ------- ------------ -------- ---------- ------
IGT_TABLE
183,162 2 0.0 7.5 44,196 1 0 0.0
WORKAREA
93,828 1 0.0 2.5 46,917 1 0 0.0
SYSTEM
55,301 1 0.0 3.2 1,535 0 29 0.0
IGT_INDEX
17,357 0 0.2 8.3 3,379 0 0 0.0
SYSAUX
12,802 0 0.1 6.8 4,311 0 0 0.0
UNDOTBS
1,334 0 1.4 48.2 5,146 0 17 0.0
DWH_TABLE
1,271 0 0.2 12.0 287 0 0 0.0
DWH_INDEX
768 0 0.5 17.5 214 0 0 0.0
GIN
258 0 1.2 49.8 48 0 0 0.0
GININDEX
258 0 1.7 49.8 48 0 0 0.0
TEMPORARY
155 0 0.0 5.2 98 0 0 0.0
Instance Recovery Stats DB/Inst: IGT/igt Snaps: 6693-6723
-> B: Begin snapshot, E: End snapshot
Targt Estd Log File Log Ckpt Log Ckpt
MTTR MTTR Recovery Actual Target Size Timeout Interval
(s) (s) Estd IOs Redo Blks Redo Blks Redo Blks Redo Blks Redo Blks
- ----- ----- ---------- --------- --------- ---------- --------- ------------
B 0 0 782 19239 19018 1658880 19018
E 0 0 993 18686 17347 1658880 17347
Advisory statistics
Memory Target Advice DB/Inst: IGT/igt Snaps: 6693-6723
Memory Dynamic Components DB/Inst: IGT/igt Snaps: 6693-6723
Buffer Pool Advisory DB/Inst: IGT/igt End Snap: 6723
Buffer Pool Statistics DB/Inst: IGT/igt Snaps: 6693-6723
Buffer wait Statistics DB/Inst: IGT/igt Snaps: 6693-6723
PGA Aggr Target Histogram DB/Inst: IGT/igt Snaps: 6693-6723
PGA Memory Advisory DB/Inst: IGT/igt End Snap: 6723
Process Memory Summary Stats DB/Inst: IGT/igt Snaps: 6693-6723
Top Process Memory (by component) DB/Inst: IGT/igt Snaps: 6693-6723
Undo Segment Summary DB/Inst: IGT/igt Snaps: 6693-6723
Undo Segment Stats DB/Inst: IGT/igt Snaps: 6693-6723
Latch Activity DB/Inst: IGT/igt Snaps: 6693-6723
Segments by Logical Reads DB/Inst: IGT/igt Snaps: 6693-6723
-> End Segment Logical Reads Threshold: 10000
-> Pct Total shows % of logical reads for each top segment compared with total
logical reads for all segments captured by the Snapshot
Subobject Obj. Logical Pct
Owner Tablespace Object Name Name Type Reads Total
---------- ---------- -------------------- ------------ ----- ------------ -----
SYS SYSTEM COL$ TABLE 278,324,368 93.4
SYS SYSTEM METANAMETRANS$ TABLE 3,725,952 1.2
SYS SYSTEM I_SYSAUTH1 INDEX 1,139,264 .4
SYS SYSTEM PROPS$ TABLE 1,137,440 .4
SYS SYSTEM SERVICE$ TABLE 1,136,704 .4
Segments by Physical Reads DB/Inst: IGT/igt Snaps: 6693-6723
-> End Segment Physical Reads Threshold: 1000
Subobject Obj. Physical Pct
Owner Tablespace Object Name Name Type Reads Total
---------- ---------- -------------------- ------------ ----- ------------ -----
SYS SYSTEM COL$ TABLE 406,270 67.0
LKA_MOBIT_ IGT_TABLE SGA_W_PSMS_SUBSCRIBE TABLE 120,817 19.9
SYS SYSTEM HISTGRM$ TABLE 12,548 2.1
SYS SYSTEM SEG$ TABLE 10,998 1.8
Segments by Row Lock Waits DB/Inst: IGT/igt Snaps: 6693-6723
Segments by Buffer Busy Waits DB/Inst: IGT/igt Snaps: 6693-6723
SGA Target Advisory DB/Inst: IGT/igt End Snap: 6723
init.ora Parameters DB/Inst: IGT/igt Snaps: 6693-6723
End value
Parameter Name Begin value (if different)
----------------------------- --------------------------------- --------------
archive_lag_target 1800
audit_file_dest /software/oracle/admin/igt/adump
audit_trail NONE
compatible 11.2.0.4.0
control_files /oracle_db/db1/db_igt/ora_control
_01.ctl, /oracle_db/db1/db_igt/or
a_control_02.ctl, /oracle_db/db1/
db_igt/ora_control_03.ctl
db_block_size 8192
db_domain
db_name igt
diagnostic_dest /software/oracle
dispatchers (PROTOCOL=TCP) (SERVICE=igtXDB)
fast_start_mttr_target 0
filesystemio_options asynch
log_archive_dest_1 location=/oracle_db/db2/db_igt/ar
ch
log_archive_format arch%T_%s_%r.arc
memory_target 1073741824
nls_length_semantics char
open_cursors 300
open_links 24
os_authent_prefix
processes 1000
recyclebin OFF
remote_login_passwordfile EXCLUSIVE
session_cached_cursors 100
spfile /software/oracle/admin/igt/pfile/
spfileigt.ora
undo_retention 3600
undo_tablespace UNDOTBS
-------------------------------------------------------------
End of Report ( SRL_perfstat_02.txt )
Important parts of Statspack SQL Report
STATSPACK SQL report for Old Hash Value: 3851979199 Module: dbrefresh@my_server-aps-1 (TNS V1-V3)
DB Name DB Id Instance Inst Num Release RAC Host
------------ ----------- ------------ -------- ----------- --- ----------------
IGT 1066102538 igt 1 11.2.0.4.0 NO my_server-aps-1
Start Id Start Time End Id End Time Duration(mins)
--------- ------------------- --------- ------------------- --------------
6693 31-Jan-16 00:00:03 6723 01-Feb-16 00:00:02 1,439.98
SQL Statistics
~~~~~~~~~~~~~~
-> CPU and Elapsed Time are in seconds (s) for Statement Total and in
milliseconds (ms) for Per Execute
% Snap
Statement Total Per Execute Total
--------------- --------------- ------
Buffer Gets: 965,026 648.1 3.70
Disk Reads: 1,011,306 679.2 66.75
Rows processed: 0 0.0
CPU Time(s/ms): 3 2.1
Elapsed Time(s/ms): 4 2.5
Sorts: 1,489 1.0
Parse Calls: 1,489 1.0
Invalidations: 0
Version count: 3
Sharable Mem(K): 78
Executions: 1,489
SQL Text
~~~~~~~~
SELECT TABLE_ID, ISN, MAP_NAME FROM REFRESH_LOG ORDER BY TABLE_
ID, MAP_NAME
Known Optimizer Plan(s) for this Old Hash Value
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Shows all known Optimizer Plans for this database instance, and the Snap Id's
they were first found in the shared pool. A Plan Hash Value will appear
multiple times if the cost has changed
-> ordered by Snap Id
First First Last Plan
Snap Id Snap Time Active Time Hash Value Cost
--------- --------------- --------------- ------------ ----------
6306 18-Jan-16 03:00 01-Feb-16 12:59 826343889 171
6306 18-Jan-16 03:00 01-Feb-16 12:59 826343889 205
6306 18-Jan-16 03:00 01-Feb-16 12:53 826343889 6
6647 29-Jan-16 08:00 30-Jan-16 07:29 826343889
Plans in shared pool between Begin and End Snap Ids
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Shows the Execution Plans found in the shared pool between the begin and end
snapshots specified. The values for Rows, Bytes and Cost shown below are those
which existed at the time the first-ever snapshot captured this plan - these
values often change over time, and so may not be indicative of current values
-> Rows indicates Cardinality, PHV is Plan Hash Value
-> ordered by Plan Hash Value
--------------------------------------------------------------------------------
| Operation | PHV/Object Name | Rows | Bytes| Cost |
--------------------------------------------------------------------------------
|SELECT STATEMENT |----- 826343889 -----| | | 967 |
|SORT ORDER BY | | 172K| 1M| 967 |
| TABLE ACCESS FULL |REFRESH_LOG | 172K| 1M| 206 |
--------------------------------------------------------------------------------
End of Report
No comments:
Post a Comment