Statspack Report.
OS - win2003 server
DB - 9.2.0.5.0
Can you have a look on Statspack Report and offer your valuable suggestions?
```
Current Instance
~~~~~~~~~~~~~~~~
DB Id DB Name Inst Num Instance
----------- ------------ -------- ------------
340547761 CHRYSLER 1 chrysler
Instances in this Statspack schema
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
DB Id Inst Num DB Name Instance Host
----------- -------- ------------ ------------ ------------
340547761 1 CHRYSLER chrysler NOID2K36BGTP
B1
Using 340547761 for database Id
Using 1 for instance number
Completed Snapshots
Snap Snap
Instance DB Name Id Snap Started Level Comment
------------ ------------ ----- ----------------- ----- ----------------------
chrysler CHRYSLER 1 17 Jan 2008 10:05 5
2 17 Jan 2008 10:09 5
3 17 Jan 2008 10:16 5
4 17 Jan 2008 10:48 5
5 17 Jan 2008 11:02 5
6 17 Jan 2008 11:12 5
Specify the Begin and End Snapshot Ids
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Enter value for begin_snap: 4
Begin Snapshot Id specified: 4
Enter value for end_snap: 6
End Snapshot Id specified: 6
PAR VERSN
--- -----------------
HOST_NAME DB Name
---------------------------------------------------------------- ------------
Instance BTIME
------------ -----------------
NO 9.2.0.5.0
NOID2K36BGTPB1 CHRYSLER
chrysler 20080117 10:48:11
ETIME
-----------------
20080117 11:12:09
Specify the Report Name
~~~~~~~~~~~~~~~~~~~~~~~
The default report file name is sp_4_6. To use this name,
press <return> to continue, otherwise enter an alternative.
Enter value for report_name: Statspack Report
Using the report name Statspack Report
SP2-0333: Illegal spool file name: "Statspack Report" (bad character: ' ')
STATSPACK report for
DB Name DB Id Instance Inst Num Release Cluster Host
------------ ----------- ------------ -------- ----------- ------- ------------
CHRYSLER 340547761 chrysler 1 9.2.0.5.0 NO NOID2K36BGTP
B1
Snap Id Snap Time Sessions Curs/Sess Comment
------- ------------------ -------- --------- -------------------
Begin Snap: 4 17-Jan-08 10:48:11 22 6.5
End Snap: 6 17-Jan-08 11:12:09 27 7.4
Elapsed: 23.97 (mins)
Cache Sizes (end)
~~~~~~~~~~~~~~~~~
Buffer Cache: 184M Std Block Size: 8K
Shared Pool Size: 904M Log Buffer: 512K
Load Profile
~~~~~~~~~~~~ Per Second Per Transaction
--------------- ---------------
Redo size: 10,225.13 4,901,244.00
Logical reads: 700.13 335,593.67
Block changes: 68.68 32,918.67
Physical reads: 15.03 7,206.67
Physical writes: 14.41 6,906.00
User calls: 1.22 584.00
Parses: 0.73 349.33
Hard parses: 0.03 13.67
Sorts: 0.40 193.00
Logons: 0.01 4.67
Executes: 1.46 701.67
Transactions: 0.00
% Blocks changed per Read: 9.81 Recursive Call %: 91.60
Rollback per transaction %: 0.00 Rows per Sort: 1016.53
Instance Efficiency Percentages (Target 100%)
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Buffer Nowait %: 100.00 Redo NoWait %: 100.00
Buffer Hit %: 99.57 In-memory Sort %: 99.65
Library Hit %: 100.00 Soft Parse %: 96.09
Execute to Parse %: 50.21 Latch Hit %: 99.98
Parse CPU to Parse Elapsd %: 56.76 % Non-Parse CPU: 99.34
Shared Pool Statistics Begin End
------ ------
Memory Usage %: 53.83 53.90
% SQL with executions>1: 84.54 84.53
% Memory for SQL w/exec>1: 62.62 62.65
Top 5 Timed Events
~~~~~~~~~~~~~~~~~~ % Total
Event Waits Time (s) Ela Time
-------------------------------------------- ------------ ----------- --------
CPU time 32 79.76
direct path read 390 3 7.21
db file scattered read 275 2 3.78
log file parallel write 515 1 2.44
db file sequential read 365 1 2.07
-------------------------------------------------------------
Wait Events for DB: CHRYSLER Instance: chrysler Snaps: 4 -6
-> s - second
-> cs - centisecond - 100th of a second
-> ms - millisecond - 1000th of a second
-> us - microsecond - 1000000th of a second
-> ordered by wait time desc, waits desc (idle events last)
Avg
Total Wait wait Waits
Event Waits Timeouts Time (s) (ms) /txn
---------------------------- ------------ ---------- ---------- ------ --------
direct path read 390 0 3 7 130.0
db file scattered read 275 0 2 5 91.7
log file parallel write 515 449 1 2 171.7
db file sequential read 365 0 1 2 121.7
control file parallel write 467 0 0 1 155.7
control file sequential read 294 0 0 1 98.0
db file parallel write 35 0 0 10 11.7
db file parallel read 1 0 0 251 0.3
LGWR wait for redo copy 19 1 0 12 6.3
SQL*Net message from dblink 18 0 0 4 6.0
latch free 14 0 0 5 4.7
log file sync 14 0 0 1 4.7
SQL*Net break/reset to clien 36 0 0 0 12.0
log buffer space 19 0 0 1 6.3
SQL*Net more data to client 103 0 0 0 34.3
direct path write 8 0 0 1 2.7
SQL*Net message to dblink 18 0 0 0 6.0
SQL*Net message from client 1,606 0 11,104 6914 535.3
wakeup time manager 47 47 2,580 54895 15.7
SQL*Net more data from clien 11 0 0 14 3.7
SQL*Net message to client 1,611 0 0 0 537.0
-------------------------------------------------------------
Background Wait Events for DB: CHRYSLER Instance: chrysler Snaps: 4 -6
-> ordered by wait time desc, waits desc (idle events last)
Avg
Total Wait wait Waits
Event Waits Timeouts Time (s) (ms) /txn
---------------------------- ------------ ---------- ---------- ------ --------
log file parallel write 515 449 1 2 171.7
control file parallel write 467 0 0 1 155.7
db file parallel write 35 0 0 10 11.7
control file sequential read 188 0 0 2 62.7
LGWR wait for redo copy 19 1 0 12 6.3
latch free 4 0 0 17 1.3
rdbms ipc message 2,392 1,859 9,366 3916 797.3
pmon timer 487 487 2,651 5443 162.3
smon timer 4 4 2,307 ###### 1.3
-------------------------------------------------------------
SQL ordered by Gets for DB: CHRYSLER Instance: chrysler Snaps: 4 -6
-> End Buffer Gets Threshold: 10000
-> Note that resources reported for PL/SQL includes the resources used by
all SQL statements called within the PL/SQL code. As individual SQL
statements are also reported, it is possible and valid for the summed
total % to exceed 100
CPU Elapsd
Buffer Gets Executions Gets per Exec %Total Time (s) Time (s) Hash Value
--------------- ------------ -------------- ------ -------- --------- ----------
415,514 2 207,757.0 41.3 5.45 5.44 1116368370
Module: SQL*Plus
INSERT INTO STATS$SQLTEXT ( HASH_VALUE , TEXT_SUBSET , PIECE , S
QL_TEXT , ADDRESS , COMMAND_TYPE , LAST_SNAP_ID ) SELECT ST1.HAS
H_VALUE , SS.TEXT_SUBSET , ST1.PIECE , ST1.SQL_TEXT , ST1.ADDRES
S , ST1.COMMAND_TYPE , SS.SNAP_ID FROM V$SQLTEXT ST1 , STATS$SQL
SUMMARY SS WHERE SS.SNAPID = :B3 AND SS.DBID = :B2 AND SS.INST
223,045 2 111,522.5 22.2 1.09 1.38 3446574552
Module: SQL Developer
select column_name from all_updatable_columns where TABLE_NAME
= :OBJECT_NAME and owner = :OBJECT_OWNER and updatable = 'YES'
208,951 1 208,951.0 20.8 10.42 14.21 1240367379
Module: SQL*Plus
BEGIN statspack.snap ; END;
208,539 1 208,539.0 20.7 10.47 14.11 2522684317
Module: sqlplus.exe
BEGIN statspack.snap; END;
81,198 1 81,198.0 8.1 0.73 0.73 401938015
Module: Oracle SQL Developer
SELECT s.owner, s.synonym_name, 'SYNONYM' as object_type FROM sy
s.all_synonyms s, sys.all_objects o WHERE s.table_name = o.objec
t_name AND s.table_owner = o.owner AND object_type IN ('PACKAGE'
, 'PROCEDURE', 'SEQUENCE', 'TABLE', 'TYPE', 'VIEW', 'FUNCTION' )
ORDER BY s.owner, s.synonym_name
58,656 10 5,865.6 5.8 3.34 3.33 3247664323
insert into source$(obj#,line,source) values (:1,:2,:3)
57,404 2 28,702.0 5.7 0.28 0.30 3259503395
Module: SQL Developer
select * from (SELECT OBJECT_NAME, OBJECT_ID ,'' short_name,
decode(( SELECT count (1) FROM SYS.ALL_TAB_PARTITIONS WHERE TAB
LE_OWNER =owner AND TABLE_NAME = object_name ),0,'FALSE','TRUE'
) partition, OWNER OBJECT_OWNER
FROM SYS.ALL_OBJECTS O WHERE O.OWNE
51,583 1 51,583.0 5.1 0.77 0.75 2077069258
Module: Oracle SQL Developer
SELECT owner, object_name, object_type FROM sys.all_objects WHER
E object_type IN ('PACKAGE', 'PROCEDURE', 'SEQUENCE', 'TABLE', '
TYPE', 'VIEW', 'FUNCTION' ) ORDER BY owner, object_name
41,310 2 20,655.0 4.1 0.27 0.29 1607513402
Module: SQL Developer
SELECT OWNER,TABLE_NAME FROM all_external_tables
SQL ordered by Gets for DB: CHRYSLER Instance: chrysler Snaps: 4 -6
-> End Buffer Gets Threshold: 10000
-> Note that resources reported for PL/SQL includes the resources used by
all SQL statements called within the PL/SQL code. As individual SQL
statements are also reported, it is possible and valid for the summed
total % to exceed 100
CPU Elapsd
Buffer Gets Executions Gets per Exec %Total Time (s) Time (s) Hash Value
--------------- ------------ -------------- ------ -------- --------- ----------
20,776 1 20,776.0 2.1 0.20 0.21 1305228895
Module: SQL*Plus
select owner , object_name , object_type from dba_objects where
object_type = 'TABLE'
15,709 10 1,570.9 1.6 0.97 1.07 3098922061
delete from source$ where obj#=:1
11,854 1 11,854.0 1.2 0.11 0.21 4208944292
Module: SQL Developer
with pri_cols as ( SELECT cols.column_name column_name, cols.pos
ition column_position FROM all_constraints cons, al
l_cons_columns cols WHERE cons.constraint_type = 'P'
AND cons.constraint_name = cols.constraint_name
AND cons.owner = cols.owner and cols.table_name
7,493 1 7,493.0 0.7 0.17 1.87 1279266739
Module: SQL Developer
select count(*) from IMP_TEMPSS_PARTSLANG
3,904 47 83.1 0.4 0.00 0.14 815501214
select t.schema, t.name, t.flags, q.name from system.aq$_queue_t
ables t, sys.aq$_queue_table_affinities aft, system.aq$_que
ues q where aft.table_objno = t.objno and aft.owner_instance = :
1 and q.table_objno = t.objno and q.usage = 0 and b
itand(t.flags, 4+16+32+64+128+256) = 0 for update of t.name, aft
3,467 14 247.6 0.3 0.50 0.53 1554250272
Module: SQL Developer
select count(1) from all_objects where owner <> 'PUBLIC' and ob
ject_name in (:S0)
1,694 4 423.5 0.2 0.08 0.08 1547382267
Module: SQL Developer
select object_type,owner,object_name,rank from ( select objec
t_type,owner,object_name,0 rank from all_objects where obj
ect_name = :NAME and UPPER(owner) = nvl(:OWNER,UPPER(sys_cont
ext('USERENV', 'CURRENT_SCHEMA'))) and object_type not in ( '
SYNONYM' ) union all select ao.object_type,ao.owner,ao.ob
1,317 188 7.0 0.1 0.00 0.03 3371479671
select t.name, (select owner_instance from sys.aq$_queue_table_
affinities where table_objno = t.objno) from system.aq$_queue
_tables t where t.name = :1 and t.schema = :2 for update skip lo
cked
892 1 892.0 0.1 0.02 0.01 3021556466
Module: SQL Developer
SELECT OBJECT_NAME, OBJECT_ID, DECODE(STATUS, 'INVAL
ID', 'TRUE', 'FALSE') INVALID, 'TRUE' runnable,
SQL ordered by Gets for DB: CHRYSLER Instance: chrysler Snaps: 4 -6
-> End Buffer Gets Threshold: 10000
-> Note that resources reported for PL/SQL includes the resources used by
all SQL statements called within the PL/SQL code. As individual SQL
statements are also reported, it is possible and valid for the summed
total % to exceed 100
CPU Elapsd
Buffer Gets Executions Gets per Exec %Total Time (s) Time (s) Hash Value
--------------- ------------ -------------- ------ -------- --------- ----------
NVL( b.HAS_BODY, 'FALSE') HAS_BODY FROM SYS.ALL_OBJECTS
a, (SELECT 'TRUE' HAS_BODY, object_name tmp_name FROM SYS.
ALL_OBJECTS WHERE OWNER = :SCHEMA AND OBJECT_TYPE = 'PACKAGE BOD
890 2 445.0 0.1 0.09 0.10 1201167771
Module: SQL Developer
SELECT T.TABLE_NAME, 'TABLE' OBJECT_TYPE , (SELECT O.OBJ
ECT_ID FROM ALL_OBJECTS O WHERE O.OWNER = T.OWNER
AND O.OBJECT_TYPE = 'TABLE' AND O.OBJECT_NAME = T.
TABLE_NAME) OBJECT_ID FROM ALL_TABLES T WHERE T.OWNER = :1 AN
D T.TABLE_NAME LIKE :2 AND T.IOT_NAME IS NULL AND T.NES
779 10 77.9 0.1 0.02 0.05 3067006941
delete from dependency$ where d_obj#=:1
748 146 5.1 0.1 0.05 0.05 3951809012
insert into dependency$(d_obj#,d_timestamp,order#,p_obj#,p_times
tamp,d_owner#, property)values (:1,:2,:3,:4,:5,:6, :7)
632 2 316.0 0.1 10.53 17.92 4043595143
Module: SQL*Plus
INSERT INTO STATS$SQL_SUMMARY ( SNAP_ID , DBID , INSTANCE_NUMBER
, TEXT_SUBSET , SHARABLE_MEM , SORTS , MODULE , LOADED_VERSIONS
-------------------------------------------------------------
SQL ordered by Reads for DB: CHRYSLER Instance: chrysler Snaps: 4 -6
-> End Disk Reads Threshold: 1000
CPU Elapsd
Physical Reads Executions Reads per Exec %Total Time (s) Time (s) Hash Value
--------------- ------------ -------------- ------ -------- --------- ----------
17,317 2 8,658.5 80.1 10.53 17.92 4043595143
Module: SQL*Plus
INSERT INTO STATS$SQL_SUMMARY ( SNAP_ID , DBID , INSTANCE_NUMBER
, TEXT_SUBSET , SHARABLE_MEM , SORTS , MODULE , LOADED_VERSIONS
, FETCHES , EXECUTIONS , LOADS , INVALIDATIONS , PARSE_CALLS ,
DISK_READS , BUFFER_GETS , ROWS_PROCESSED , COMMAND_TYPE , ADDRE
SS , HASH_VALUE , VERSION_COUNT , CPU_TIME , ELAPSED_TIME , OUTL
8,659 1 8,659.0 40.1 10.42 14.21 1240367379
Module: SQL*Plus
BEGIN statspack.snap ; END;
8,658 1 8,658.0 40.0 10.47 14.11 2522684317
Module: sqlplus.exe
BEGIN statspack.snap; END;
3,880 1 3,880.0 17.9 0.17 1.87 1279266739
Module: SQL Developer
select count(*) from IMP_TEMPSS_PARTSLANG
299 2 149.5 1.4 1.09 1.38 3446574552
Module: SQL Developer
select column_name from all_updatable_columns where TABLE_NAME
= :OBJECT_NAME and owner = :OBJECT_OWNER and updatable = 'YES'
12 5 2.4 0.1 0.05 0.13 3444463493
Module: SQL Developer
SELECT TEXT FROM SYS.ALL_SOURCE WHERE TYPE = :TYPE AND OWNER =
:OWNER AND NAME = :NAME ORDER BY LINE
12 4 3.0 0.1 0.03 0.13 3833423502
Module: SQL Developer
SELECT TEXT FROM SYS.ALL_SOURCE WHERE TYPE = :1 AND OWNER = :2 A
ND NAME = :3 ORDER BY LINE
9 1 9.0 0.0 0.00 0.07 3687727603
insert into col$(obj#,name,intcol#,segcol#,type#,length,precisio
n#,scale,null$,offset,fixedstorage,segcollength,deflength,defaul
t$,col#,property,charsetid,charsetform,spare1,spare2,spare3)valu
es(:1,:2,:3,:4,:5,:6,decode(:7,0,null,:7),decode(:5,2,decode(:8,
-127/*MAXSB1MINAL*/,null,:8),178,:8,179,:8,180,:8,181,:8,182,:8,
8 2 4.0 0.0 0.28 0.30 3259503395
Module: SQL Developer
select * from (SELECT OBJECT_NAME, OBJECT_ID ,'' short_name,
decode(( SELECT count (1) FROM SYS.ALL_TAB_PARTITIONS WHERE TAB
LE_OWNER =owner AND TABLE_NAME = object_name ),0,'FALSE','TRUE'
) partition, OWNER OBJECT_OWNER
FROM SYS.ALL_OBJECTS O WHERE O.OWNE
7 5 1.4 0.0 0.02 0.06 3508476732
insert into idl_ub1$(obj#,part,version,piece#,length,piece) valu
es(:1,:2,:3,:4,:5,:6)
SQL ordered by Reads for DB: CHRYSLER Instance: chrysler Snaps: 4 -6
-> End Disk Reads Threshold: 1000
CPU Elapsd
Physical Reads Executions Reads per Exec %Total Time (s) Time (s) Hash Value
--------------- ------------ -------------- ------ -------- --------- ----------
5 8 0.6 0.0 0.00 0.03 1008661772
update idl_ub1$ set piece#=:1 ,length=:2 , piece=:3 where obj#=:
4 and part=:5 and piece#=:6 and version=:7
5 1 5.0 0.0 0.11 0.21 4208944292
Module: SQL Developer
with pri_cols as ( SELECT cols.column_name column_name, cols.pos
ition column_position FROM all_constraints cons, al
l_cons_columns cols WHERE cons.constraint_type = 'P'
AND cons.constraint_name = cols.constraint_name
AND cons.owner = cols.owner and cols.table_name
2 3 0.7 0.0 0.00 0.01 761440199
insert into idl_ub2$(obj#,part,version,piece#,length,piece) valu
es(:1,:2,:3,:4,:5,:6)
1 3 0.3 0.0 0.00 0.01 1249304535
update idl_ub2$ set piece#=:1 ,length=:2 , piece=:3 where obj#=:
4 and part=:5 and piece#=:6 and version=:7
1 2 0.5 0.0 0.27 0.29 1607513402
Module: SQL Developer
SELECT OWNER,TABLE_NAME FROM all_external_tables
1 10 0.1 0.0 0.03 0.02 1825174980
delete from access$ where d_obj#=:1
1 10 0.1 0.0 0.02 0.05 3067006941
delete from dependency$ where d_obj#=:1
1 10 0.1 0.0 3.34 3.33 3247664323
insert into source$(obj#,line,source) values (:1,:2,:3)
1 146 0.0 0.0 0.05 0.05 3951809012
insert into dependency$(d_obj#,d_timestamp,order#,p_obj#,p_times
tamp,d_owner#, property)values (:1,:2,:3,:4,:5,:6, :7)
0 2 0.0 0.0 0.00 0.00 10821553
Module: SQL Developer
ALTER SESSION SET TIME_ZONE = '05:30'
0 3 0.0 0.0 0.00 0.01 66972507
Module: SQL Developer
SELECT TO_DATE(TIMESTAMP, 'YYYY-MM-DD:HH24:MI:SS') FROM SYS.ALL_
OBJECTS WHERE OWNER = :1 AND OBJECT_NAME = :2 AND OBJECT_TYPE =
:3
0 2 0.0 0.0 0.02 0.00 80089551
Module: SQL Developer
SELECT LAST_DDL_TIME FROM SYS.ALL_OBJECTS WHERE OWNER = :1 AND O
BJECT_NAME = :2 AND OBJECT_TYPE = :3
0 1 0.0 0.0 0.00 0.00 120978412
select col#,intcol#,ntab# from ntab$ where obj#=:1 order by intc
SQL ordered by Reads for DB: CHRYSLER Instance: chrysler Snaps: 4 -6
-> End Disk Reads Threshold: 1000
CPU Elapsd
Physical Reads Executions Reads per Exec %Total Time (s) Time (s) Hash Value
--------------- ------------ -------------- ------ -------- --------- ----------
ol# asc
0 5 0.0 0.0 0.00 0.00 130926350
select count(*) from sys.job$ where next_date < :1 and (field1 =
:2 or (field1 = 0 and 'Y' = :3))
0 5 0.0 0.0 0.00 0.00 155765854
select count(*),min(piece#),max(piece#) from idl_ub1$ where obj#
=:1 and part=:2 and version=:3
0 1 0.0 0.0 0.00 0.00 162044583
select col#,intcol#,charsetid,charsetform from col$ where obj#=:
1 order by intcol# asc
0 2 0.0 0.0 0.00 0.00 179957765
select count(*),min(piece#),max(piece#) from idl_char$ where obj
#=:1 and part=:2 and version=:3
0 3 0.0 0.0 0.00 0.00 204386021
select col#, grantee#, privilege#,max(mod(nvl(option$,0),2)) fro
m objauth$ where obj#=:1 and col# is not null group by privilege
#, col#, grantee# order by col#, grantee#
0 10 0.0 0.0 0.00 0.00 292617943
delete from vtable$ where obj#=:1
0 1 0.0 0.0 0.73 0.73 401938015
Module: Oracle SQL Developer
SELECT s.owner, s.synonym_name, 'SYNONYM' as object_type FROM sy
-------------------------------------------------------------
SQL ordered by Executions for DB: CHRYSLER Instance: chrysler Snaps: 4 -6
-> End Executions Threshold: 100
CPU per Elap per
Executions Rows Processed Rows per Exec Exec (s) Exec (s) Hash Value
------------ --------------- ---------------- ----------- ---------- ----------
280 0 0.0 0.00 0.00 1316169839
select job, nvl2(last_date, 1, 0) from sys.job$ where (((:1 <= n
ext_date) and (next_date < :2)) or ((last_date is null) and
(next_date < :3))) and (field1 = :4 or (field1 = 0 and 'Y' = :5)
) and (this_date is null) order by next_date, job
280 280 1.0 0.00 0.00 1693927332
select count(*) from sys.job$ where (next_date > sysdate) and (n
ext_date < (sysdate+5/86400))
188 188 1.0 0.00 0.00 3371479671
select t.name, (select owner_instance from sys.aq$_queue_table_
affinities where table_objno = t.objno) from system.aq$_queue
_tables t where t.name = :1 and t.schema = :2 for update skip lo
cked
146 146 1.0 0.00 0.00 3951809012
insert into dependency$(d_obj#,d_timestamp,order#,p_obj#,p_times
tamp,d_owner#, property)values (:1,:2,:3,:4,:5,:6, :7)
76 76 1.0 0.00 0.00 2997854589
insert into access$(d_obj#,order#,columns,types) values (:1,:2,:
3,:4)
47 0 0.0 0.00 0.00 633914867
select q_name, state, delay, expiration, rowid, msgid, dequeu
e_msgid, chain_no, local_order_no, enq_time, enq_tid, step_no,
priority, exception_qschema, exception_queue, retry_count, corr
id, time_manager_info from SYS.AQ_EVENT_TABLE where time
managerinfo <= :1 and state != :2 for update skip locked
47 188 4.0 0.00 0.00 815501214
select t.schema, t.name, t.flags, q.name from system.aq$_queue_t
ables t, sys.aq$_queue_table_affinities aft, system.aq$_que
ues q where aft.table_objno = t.objno and aft.owner_instance = :
1 and q.table_objno = t.objno and q.usage = 0 and b
itand(t.flags, 4+16+32+64+128+256) = 0 for update of t.name, aft
47 0 0.0 0.00 0.00 870116171
select q_name, state, delay, expiration, rowid, msgid, dequeu
e_msgid, chain_no, local_order_no, enq_time, enq_tid, step_no,
priority, exception_qschema, exception_queue, retry_count, corr
id, time_manager_info from SYSTEM.DEF$_AQERROR where tim
e_manager_info <= :1 and state != :2 for update skip locked
47 0 0.0 0.00 0.00 1153132087
select q_name, state, delay, expiration, rowid, msgid, dequeu
e_msgid, chain_no, local_order_no, enq_time, enq_tid, step_no,
priority, exception_qschema, exception_queue, retry_count, corr
id, time_manager_info from SYSTEM.DEF$_AQCALL where time
managerinfo <= :1 and state != :2 for update skip locked
47 0 0.0 0.00 0.00 3920324236
select q_name, state, delay, expiration, rowid, msgid, dequeue
SQL ordered by Executions for DB: CHRYSLER Instance: chrysler Snaps: 4 -6
-> End Executions Threshold: 100
CPU per Elap per
Executions Rows Processed Rows per Exec Exec (s) Exec (s) Hash Value
------------ --------------- ---------------- ----------- ---------- ----------
msgid, chainno, local_order_no, enq_time, enq_tid, step_no,
priority, exception_qschema, exception_queue, retry_count, corri
d, time_manager_info, sender_name, sender_address, sender_prot
ocol from SYS.AQ_SRVNTFN_TABLE where time_manager_info <= :1
30 30 1.0 0.00 0.00 2201541053
insert into error$(obj#,sequence#,line,position#,textlength,text
) values (:1,:2,:3,:4,:5,:6)
26 115 4.4 0.00 0.00 1749333492
select position#,sequence#,level#,argument,type#,charsetid,chars
etform,properties,nvl(length, 0), nvl(precision#, 0),nvl(scale,
0),nvl(radix, 0), type_owner,type_name,type_subname,type_linknam
e,pls_type from argument$ where obj#=:1 and procedure#=:2 order
by sequence# desc
21 0 0.0 0.00 0.00 1683508596
delete from idl_sb4$ where obj#=:1 and part=:2
21 0 0.0 0.00 0.00 1894783783
delete from idl_char$ where obj#=:1 and part=:2
21 0 0.0 0.00 0.00 2479503691
delete from idl_ub1$ where obj#=:1 and part=:2
21 0 0.0 0.00 0.00 3926364396
delete from idl_ub2$ where obj#=:1 and part=:2
20 20 1.0 0.00 0.00 3401267293
insert into settings$(obj#, param, value) values (:1, :2, :3)
14 62 4.4 0.00 0.00 1356713530
select privilege#,level from sysauth$ connect by grantee#=prior
privilege# and privilege#>0 start with (grantee#=:1 or grantee#=
1) and privilege#>0
14 14 1.0 0.04 0.04 1554250272
Module: SQL Developer
select count(1) from all_objects where owner <> 'PUBLIC' and ob
ject_name in (:S0)
13 13 1.0 0.00 0.00 3468666020
select text from view$ where rowid=:1
12 12 1.0 0.00 0.00 825987371
Module: SQL Developer
declare l_line varchar2(255); l_done number; l_buffe
r long; begin loop exit when length(l_buffer)+255 > :maxby
tes OR l_done = 1; dbms_output.get_line( l_line, l_done );
l_buffer := l_buffer || l_line || chr(10); end loop; :done
:= l_done; :buffer := l_buffer; end;
12 0 0.0 0.00 0.00 2222871512
Module: SQL Developer
SQL ordered by Executions for DB: CHRYSLER Instance: chrysler Snaps: 4 -6
-> End Executions Threshold: 100
CPU per Elap per
Executions Rows Processed Rows per Exec Exec (s) Exec (s) Hash Value
------------ --------------- ---------------- ----------- ---------- ----------
SELECT LINE,POSITION,TEXT FROM USER_ERRORS WHERE TYPE=:1AND NAME
=:2
-------------------------------------------------------------
SQL ordered by Parse Calls for DB: CHRYSLER Instance: chrysler Snaps: 4 -6
-> End Parse Calls Threshold: 1000
% Total
Parse Calls Executions Parses Hash Value
------------ ------------ -------- ----------
47 47 4.48 633914867
select q_name, state, delay, expiration, rowid, msgid, dequeu
e_msgid, chain_no, local_order_no, enq_time, enq_tid, step_no,
priority, exception_qschema, exception_queue, retry_count, corr
id, time_manager_info from SYS.AQ_EVENT_TABLE where time
managerinfo <= :1 and state != :2 for update skip locked
47 47 4.48 815501214
select t.schema, t.name, t.flags, q.name from system.aq$_queue_t
ables t, sys.aq$_queue_table_affinities aft, system.aq$_que
ues q where aft.table_objno = t.objno and aft.owner_instance = :
1 and q.table_objno = t.objno and q.usage = 0 and b
itand(t.flags, 4+16+32+64+128+256) = 0 for update of t.name, aft
47 47 4.48 870116171
select q_name, state, delay, expiration, rowid, msgid, dequeu
e_msgid, chain_no, local_order_no, enq_time, enq_tid, step_no,
priority, exception_qschema, exception_queue, retry_count, corr
id, time_manager_info from SYSTEM.DEF$_AQERROR where tim
e_manager_info <= :1 and state != :2 for update skip locked
47 47 4.48 1153132087
select q_name, state, delay, expiration, rowid, msgid, dequeu
e_msgid, chain_no, local_order_no, enq_time, enq_tid, step_no,
priority, exception_qschema, exception_queue, retry_count, corr
id, time_manager_info from SYSTEM.DEF$_AQCALL where time
managerinfo <= :1 and state != :2 for update skip locked
47 188 4.48 3371479671
select t.name, (select owner_instance from sys.aq$_queue_table_
affinities where table_objno = t.objno) from system.aq$_queue
_tables t where t.name = :1 and t.schema = :2 for update skip lo
cked
47 47 4.48 3920324236
select q_name, state, delay, expiration, rowid, msgid, dequeue
msgid, chainno, local_order_no, enq_time, enq_tid, step_no,
priority, exception_qschema, exception_queue, retry_count, corri
d, time_manager_info, sender_name, sender_address, sender_prot
ocol from SYS.AQ_SRVNTFN_TABLE where time_manager_info <= :1
21 21 2.00 1683508596
delete from idl_sb4$ where obj#=:1 and part=:2
21 21 2.00 1894783783
delete from idl_char$ where obj#=:1 and part=:2
21 21 2.00 2479503691
delete from idl_ub1$ where obj#=:1 and part=:2
21 21 2.00 3926364396
delete from idl_ub2$ where obj#=:1 and part=:2
14 14 1.34 1356713530
SQL ordered by Parse Calls for DB: CHRYSLER Instance: chrysler Snaps: 4 -6
-> End Parse Calls Threshold: 1000
% Total
Parse Calls Executions Parses Hash Value
------------ ------------ -------- ----------
select privilege#,level from sysauth$ connect by grantee#=prior
privilege# and privilege#>0 start with (grantee#=:1 or grantee#=
1) and privilege#>0
14 14 1.34 1554250272
Module: SQL Developer
select count(1) from all_objects where owner <> 'PUBLIC' and ob
ject_name in (:S0)
13 13 1.24 3468666020
select text from view$ where rowid=:1
12 12 1.15 825987371
Module: SQL Developer
declare l_line varchar2(255); l_done number; l_buffe
r long; begin loop exit when length(l_buffer)+255 > :maxby
tes OR l_done = 1; dbms_output.get_line( l_line, l_done );
l_buffer := l_buffer || l_line || chr(10); end loop; :done
:= l_done; :buffer := l_buffer; end;
12 12 1.15 2222871512
Module: SQL Developer
SELECT LINE,POSITION,TEXT FROM USER_ERRORS WHERE TYPE=:1AND NAME
=:2
11 11 1.05 701589132
Module: SQL Developer
BEGIN /* NOP UNLESS A TABLE OBJECT */ IF dictionary_
obj_type = 'TABLE' AND sys.dbms_cdc_publish.active > 0 THE
N sys.dbms_cdc_publish.change_table_trigger(dictionary_o
bj_owner,dictionary_obj_name,sysevent); END IF; END;
11 11 1.05 4144490151
delete from error$ where obj#=:1
11 11 1.05 4151580176
update obj$ set obj#=:6,type#=:7,ctime=:8,mtime=:9,stime=:10,sta
tus=:11,dataobj#=:13,flags=:14,oid$=:15,spare1=:16, spare2=:17 w
here owner#=:1 and name=:2 and namespace=:3 and(remoteowner=:4 o
r remoteowner is null and :4 is null)and(linkname=:5 or linkname
is null and :5 is null)and(subname=:12 or subname is null and :
10 10 0.95 292617943
delete from vtable$ where obj#=:1
10 10 0.95 412513799
select o.owner#, u.name, o.name, o.namespace,
o.obj#, d.d_timestamp, nvl(d.property,0), o.type#, o.s
ubname from dependency$ d, obj$ o, user$ u where d.p_obj#=:1
and (d.p_timestamp=:2 or d.property=2) and d.d_obj#=o.obj#
and o.owner#=u.user# and decode(:3,0,0,o.type#)=:3
10 10 0.95 1077743770
SQL ordered by Parse Calls for DB: CHRYSLER Instance: chrysler Snaps: 4 -6
-> End Parse Calls Threshold: 1000
% Total
Parse Calls Executions Parses Hash Value
------------ ------------ -------- ----------
delete from argument$ where obj#=:1
-------------------------------------------------------------
SQL ordered by Sharable Memory for DB: CHRYSLER Instance: chrysler Snaps: 4 -6
-> End Sharable Memory Threshold: 1048576
Sharable Mem (b) Executions % Total Hash Value
---------------- ------------ ------- ------------
3,898,908 2 0.4 3259503395
Module: SQL Developer
select * from (SELECT OBJECT_NAME, OBJECT_ID ,'' short_name,
decode(( SELECT count (1) FROM SYS.ALL_TAB_PARTITIONS WHERE TAB
LE_OWNER =owner AND TABLE_NAME = object_name ),0,'FALSE','TRUE'
) partition, OWNER OBJECT_OWNER
FROM SYS.ALL_OBJECTS O WHERE O.OWNE
2,519,473 1 0.3 680078008
Module: SQL Developer
SELECT O.OBJECT_NAME, O.OBJECT_TYPE, O.OBJECT_ID FROM ALL_OBJE
CTS O WHERE O.OWNER = :1 AND O.OBJECT_NAME LIKE :2 AND O.
OBJECT_TYPE IN (:3) AND O.SUBOBJECT_NAME IS NULL AND O.SEC
ONDARY = 'N' AND ( O.OBJECT_TYPE <> 'INDEX' OR (
EXISTS (SELECT 1 FROM ALL_INDEXES I
1,882,420 1 0.2 4208944292
Module: SQL Developer
with pri_cols as ( SELECT cols.column_name column_name, cols.pos
ition column_position FROM all_constraints cons, al
l_cons_columns cols WHERE cons.constraint_type = 'P'
AND cons.constraint_name = cols.constraint_name
AND cons.owner = cols.owner and cols.table_name
1,687,994 4 0.2 1547382267
Module: SQL Developer
select object_type,owner,object_name,rank from ( select objec
t_type,owner,object_name,0 rank from all_objects where obj
ect_name = :NAME and UPPER(owner) = nvl(:OWNER,UPPER(sys_cont
ext('USERENV', 'CURRENT_SCHEMA'))) and object_type not in ( '
SYNONYM' ) union all select ao.object_type,ao.owner,ao.ob
1,406,016 2 0.1 2033073833
Module: SQL Developer
select parameter,value from nls_session_parameters union all SE
LECT 'DB_TIMEZONE' name, DBTIMEZONE value FROM DUAL union all S
ELECT parameter, value FROM nls_database_parameters WHERE parame
ter='NLS_CHARACTERSET'
-------------------------------------------------------------
SQL ordered by Version Count for DB: CHRYSLER Instance: chrysler Snaps: 4 -6
-> End Version Count Threshold: 20
Version
Count Executions Hash Value
-------- ------------ ------------
53 2 2033073833
Module: SQL Developer
select parameter,value from nls_session_parameters union all SE
LECT 'DB_TIMEZONE' name, DBTIMEZONE value FROM DUAL union all S
ELECT parameter, value FROM nls_database_parameters WHERE parame
ter='NLS_CHARACTERSET'
-------------------------------------------------------------
Instance Activity Stats for DB: CHRYSLER Instance: chrysler Snaps: 4 -6
Statistic Total per Second per Trans
--------------------------------- ------------------ -------------- ------------
CPU used by this session 3,185 2.2 1,061.7
CPU used when call started 3,185 2.2 1,061.7
CR blocks created 48 0.0 16.0
Cached Commit SCN referenced 0 0.0 0.0
Commit SCN cached 0 0.0 0.0
DBWR buffers scanned 0 0.0 0.0
DBWR checkpoint buffers written 22 0.0 7.3
DBWR checkpoints 0 0.0 0.0
DBWR free buffers found 0 0.0 0.0
DBWR lru scans 0 0.0 0.0
DBWR make free requests 0 0.0 0.0
DBWR revisited being-written buff 0 0.0 0.0
DBWR summed scan depth 0 0.0 0.0
DBWR transaction table writes 6 0.0 2.0
DBWR undo block writes 12 0.0 4.0
SQL*Net roundtrips to/from client 1,570 1.1 523.3
SQL*Net roundtrips to/from dblink 18 0.0 6.0
active txn count during cleanout 188 0.1 62.7
background checkpoints completed 0 0.0 0.0
background checkpoints started 0 0.0 0.0
background timeouts 1,682 1.2 560.7
branch node splits 0 0.0 0.0
buffer is not pinned count 436,985 303.9 145,661.7
buffer is pinned count 948,328 659.5 316,109.3
bytes received via SQL*Net from c 803,800 559.0 267,933.3
bytes received via SQL*Net from d 6,405 4.5 2,135.0
bytes sent via SQL*Net to client 831,677 578.4 277,225.7
bytes sent via SQL*Net to dblink 3,735 2.6 1,245.0
calls to get snapshot scn: kcmgss 7,027 4.9 2,342.3
calls to kcmgas 763 0.5 254.3
calls to kcmgcs 208 0.1 69.3
change write time 375 0.3 125.0
cleanout - number of ktugct calls 3,728 2.6 1,242.7
cleanouts and rollbacks - consist 0 0.0 0.0
cleanouts only - consistent read 3,527 2.5 1,175.7
cluster key scan block gets 27,451 19.1 9,150.3
cluster key scans 12,274 8.5 4,091.3
commit cleanout failures: block l 0 0.0 0.0
commit cleanout failures: buffer 0 0.0 0.0
commit cleanout failures: callbac 2 0.0 0.7
commit cleanout failures: cannot 0 0.0 0.0
commit cleanouts 1,219 0.9 406.3
commit cleanouts successfully com 1,217 0.9 405.7
commit txn count during cleanout 3,574 2.5 1,191.3
consistent changes 95 0.1 31.7
consistent gets 926,553 644.3 308,851.0
consistent gets - examination 304,799 212.0 101,599.7
current blocks converted for CR 0 0.0 0.0
cursor authentications 13 0.0 4.3
data blocks consistent reads - un 95 0.1 31.7
db block changes 98,756 68.7 32,918.7
db block gets 80,228 55.8 26,742.7
deferred (CURRENT) block cleanout 613 0.4 204.3
dirty buffers inspected 3,379 2.4 1,126.3
enqueue conversions 90 0.1 30.0
enqueue releases 2,288 1.6 762.7
Instance Activity Stats for DB: CHRYSLER Instance: chrysler Snaps: 4 -6
Statistic Total per Second per Trans
--------------------------------- ------------------ -------------- ------------
enqueue requests 2,290 1.6 763.3
enqueue timeouts 0 0.0 0.0
enqueue waits 0 0.0 0.0
execute count 2,105 1.5 701.7
free buffer inspected 3,379 2.4 1,126.3
free buffer requested 4,937 3.4 1,645.7
hot buffers moved to head of LRU 243 0.2 81.0
immediate (CR) block cleanout app 3,527 2.5 1,175.7
immediate (CURRENT) block cleanou 240 0.2 80.0
index fast full scans (full) 0 0.0 0.0
index fetch by key 248,987 173.2 82,995.7
index scans kdiixs1 457,728 318.3 152,576.0
leaf node 90-10 splits 1 0.0 0.3
leaf node splits 36 0.0 12.0
logons cumulative 14 0.0 4.7
messages received 553 0.4 184.3
messages sent 553 0.4 184.3
no buffer to keep pinned count 0 0.0 0.0
no work - consistent read gets 483,400 336.2 161,133.3
opened cursors cumulative 806 0.6 268.7
parse count (failures) 14 0.0 4.7
parse count (hard) 41 0.0 13.7
parse count (total) 1,048 0.7 349.3
parse time cpu 21 0.0 7.0
parse time elapsed 37 0.0 12.3
physical reads 21,620 15.0 7,206.7
physical reads direct 17,317 12.0 5,772.3
physical writes 20,718 14.4 6,906.0
physical writes direct 17,317 12.0 5,772.3
physical writes non checkpoint 20,698 14.4 6,899.3
pinned buffers inspected 0 0.0 0.0
prefetched blocks 3,662 2.6 1,220.7
prefetched blocks aged out before 0 0.0 0.0
process last non-idle time 16,807,669,922 11,688,226.7 ############
recovery blocks read 0 0.0 0.0
recursive calls 19,103 13.3 6,367.7
recursive cpu usage 2,568 1.8 856.0
redo blocks written 29,780 20.7 9,926.7
redo buffer allocation retries 19 0.0 6.3
redo entries 51,190 35.6 17,063.3
redo log space requests 0 0.0 0.0
redo log space wait time 0 0.0 0.0
redo ordering marks 17 0.0 5.7
redo size 14,703,732 10,225.1 4,901,244.0
redo synch time 0 0.0 0.0
redo synch writes 14 0.0 4.7
redo wastage 82,340 57.3 27,446.7
redo write time 418 0.3 139.3
redo writer latching time 20 0.0 6.7
redo writes 515 0.4 171.7
rollback changes - undo records a 0 0.0 0.0
rollbacks only - consistent read 95 0.1 31.7
rows fetched via callback 141,462 98.4 47,154.0
session connect time 16,807,669,922 11,688,226.7 ############
session logical reads 1,006,781 700.1 335,593.7
session pga memory 1,701,124 1,183.0 567,041.3
Instance Activity Stats for DB: CHRYSLER Instance: chrysler Snaps: 4 -6
Statistic Total per Second per Trans
--------------------------------- ------------------ -------------- ------------
session pga memory max 5,043,244 3,507.1 1,681,081.3
session uga memory 554,544 385.6 184,848.0
session uga memory max 2,976,568 2,069.9 992,189.3
shared hash latch upgrades - no w 458,297 318.7 152,765.7
shared hash latch upgrades - wait 0 0.0 0.0
sorts (disk) 2 0.0 0.7
sorts (memory) 577 0.4 192.3
sorts (rows) 588,568 409.3 196,189.3
summed dirty queue length 3,954 2.8 1,318.0
switch current to new buffer 218 0.2 72.7
table fetch by rowid 317,993 221.1 105,997.7
table fetch continued row 1 0.0 0.3
table scan blocks gotten 16,911 11.8 5,637.0
table scan rows gotten 963,164 669.8 321,054.7
table scans (long tables) 3 0.0 1.0
table scans (rowid ranges) 0 0.0 0.0
table scans (short tables) 1,878 1.3 626.0
transaction rollbacks 0 0.0 0.0
transaction tables consistent rea 0 0.0 0.0
transaction tables consistent rea 0 0.0 0.0
user calls 1,752 1.2 584.0
user commits 3 0.0 1.0
user rollbacks 0 0.0 0.0
workarea executions - onepass 2 0.0 0.7
workarea executions - optimal 464 0.3 154.7
write clones created in backgroun 0 0.0 0.0
write clones created in foregroun 0 0.0 0.0
-------------------------------------------------------------
Tablespace IO Stats for DB: CHRYSLER Instance: chrysler Snaps: 4 -6
->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)
-------------- ------- ------ ------- ------------ -------- ---------- ------
CHRY_HARNEET
325 0 27.7 12.0 3,379 2 0 0.0
TEMP03
1,074 1 6.6 16.1 695 0 0 0.0
SYSTEM
369 0 2.2 1.1 4 0 0 0.0
UNDOTBS1
0 0 0.0 18 0 0 0.0
QLINK_STAGING
2 0 10.0 1.0 0 0 0 0.0
-------------------------------------------------------------
File IO Stats for DB: CHRYSLER Instance: chrysler Snaps: 4 -6
->ordered by Tablespace, File
Tablespace Filename
------------------------ ----------------------------------------------------
Av Av Av Av Buffer Av Buf
Reads Reads/s Rd(ms) Blks/Rd Writes Writes/s Waits Wt(ms)
-------------- ------- ------ ------- ------------ -------- ---------- ------
CHRY_HARNEET C:\CHRYSLER_DATA\CHRY_HARNEET.ORA
325 0 27.7 12.0 3,379 2 0
QLINK_STAGING D:\ORACLE\ORADATA\CHRYSLER\QLINK_STAGING.ORA
2 0 10.0 1.0 0 0 0
SYSTEM D:\ORACLE\ORADATA\CHRYSLER\SYSTEM01.DBF
369 0 2.2 1.1 4 0 0
TEMP03 D:\ORACLE\ORADATA\CHRYSLER\TEMP03.ORA
1,074 1 6.6 16.1 695 0 0
UNDOTBS1 D:\ORACLE\ORADATA\CHRYSLER\UNDOTBS01.DBF
0 0 18 0 0
-------------------------------------------------------------
Buffer Pool Statistics for DB: CHRYSLER Instance: chrysler Snaps: 4 -6
-> Standard block size Pools D: default, K: keep, R: recycle
-> Default Pools for other block sizes: 2k, 4k, 8k, 16k, 32k
Free Write Buffer
Number of Cache Buffer Physical Physical Buffer Complete Busy
P Buffers Hit % Gets Reads Writes Waits Waits Waits
--- ---------- ----- ----------- ----------- ---------- ------- -------- ------
D 23,023 99.6 1,006,892 4,303 3,401 0 0 0
-------------------------------------------------------------
Instance Recovery Stats for DB: CHRYSLER Instance: chrysler Snaps: 4 -6
-> 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 91 44 264 1562 1099 184320 1099
E 91 48 1446 30626 30167 184320 30167
-------------------------------------------------------------
Buffer Pool Advisory for DB: CHRYSLER Instance: chrysler End Snap: 6
-> Only rows with estimated physical reads >0 are displayed
-> ordered by Block Size, Buffers For Estimate
Size for Size Buffers for Est Physical Estimated
P Estimate (M) Factr Estimate Read Factor Physical Reads
--- ------------ ----- ---------------- ------------- ------------------
D 16 .1 2,002 5.79 83,132,791
D 32 .2 4,004 3.71 53,177,131
D 48 .3 6,006 2.22 31,800,013
D 64 .3 8,008 1.37 19,672,880
D 80 .4 10,010 1.28 18,345,716
D 96 .5 12,012 1.22 17,451,709
D 112 .6 14,014 1.17 16,817,743
D 128 .7 16,016 1.13 16,184,953
D 144 .8 18,018 1.11 15,923,932
D 160 .9 20,020 1.07 15,318,263
D 176 1.0 22,022 1.01 14,501,142
D 184 1.0 23,023 1.00 14,346,465
D 192 1.0 24,024 0.99 14,131,666
D 208 1.1 26,026 0.95 13,584,642
D 224 1.2 28,028 0.93 13,272,152
D 240 1.3 30,030 0.88 12,651,211
D 256 1.4 32,032 0.86 12,353,842
D 272 1.5 34,034 0.84 12,072,408
D 288 1.6 36,036 0.83 11,934,902
D 304 1.7 38,038 0.82 11,770,561
D 320 1.7 40,040 0.81 11,667,956
-------------------------------------------------------------
PGA Aggr Target Stats for DB: CHRYSLER Instance: chrysler Snaps: 4 -6
-> B: Begin snap E: End snap (rows dentified with B or E contain data
which is absolute i.e. not diffed over the interval)
-> PGA cache hit % - percentage of W/A (WorkArea) data processed only in-memory
-> Auto PGA Target - actual workarea memory target
-> W/A PGA Used - amount of memory used for all Workareas (manual + auto)
-> %PGA W/A Mem - percentage of PGA memory allocated to workareas
-> %Auto W/A Mem - percentage of workarea memory controlled by Auto Mem Mgmt
-> %Man W/A Mem - percentage of workarea memory under manual control
PGA Cache Hit % W/A MB Processed Extra W/A MB Read/Written
--------------- ---------------- -------------------------
56.5 86 66
%PGA %Auto %Man
PGA Aggr Auto PGA PGA Mem W/A PGA W/A W/A W/A Global Mem
Target(M) Target(M) Alloc(M) Used(M) Mem Mem Mem Bound(K)
- --------- --------- ---------- ---------- ------ ------ ------ ----------
B 650 578 24.8 0.0 .0 .0 .0 33,280
E 650 577 26.5 0.0 .0 .0 .0 33,280
-------------------------------------------------------------
PGA Aggr Target Histogram for DB: CHRYSLER Instance: chrysler Snaps: 4 -6
-> Optimal Executions are purely in-memory operations
Low High
Optimal Optimal Total Execs Optimal Execs 1-Pass Execs M-Pass Execs
------- ------- -------------- ------------- ------------ ------------
8K 16K 354 354 0 0
16K 32K
```