	\| Worldwide
	Secure Search
PRODUCTS AND SERVICES INDUSTRIES SUPPORT PARTNERS COMMUNITIES ABOUT

ORACLE CORPORATION

Legal | Privacy

AWR Report

WORKLOAD REPOSITORY report for

DB Name DB Id Instance Inst num Release RAC Host

VIS 192418558 VISA 1 10.2.0.3.0 YES oracle16.engr.sgi.com

Snap Id Snap Time Sessions Cursors/Session

Begin Snap: 1 08-Jan-08 10:19:53 1078 131.3

End Snap: 3 08-Jan-08 11:23:05 1028 134.5

Elapsed: 63.21 (mins)

DB Time: 480.63 (mins)

Report Summary

Cache Sizes

Begin End

Buffer Cache: 8,000M 8,000M Std Block Size: 8K

Shared Pool Size: 3,008M 3,008M Log Buffer: 30,736K

Load Profile

Per Second Per Transaction

Redo size: 7,447,860.79 58,271.85

Logical reads: 293,945.80 2,299.82

Block changes: 44,183.35 345.69

Physical reads: 169.35 1.33

Physical writes: 1,133.09 8.87

User calls: 2,486.31 19.45

Parses: 1,211.88 9.48

Hard parses: 1.20 0.01

Sorts: 1,539.85 12.05

Logons: 1.94 0.02

Executes: 13,706.40 107.24

Transactions: 127.81

% Blocks changed per Read: 15.03 Recursive Call %: 90.27

Rollback per transaction %: 4.01 Rows per Sort: 10.40

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 99.93 Redo NoWait %: 100.00

Buffer Hit %: 99.96 In-memory Sort %: 100.00

Library Hit %: 100.02 Soft Parse %: 99.90

Execute to Parse %: 91.16 Latch Hit %: 98.01

Parse CPU to Parse Elapsd %: 81.07 % Non-Parse CPU: 97.32

Shared Pool Statistics

Begin End

Memory Usage %: 42.58 58.74

% SQL with executions>1: 60.31 81.64

% Memory for SQL w/exec>1: 51.44 48.25

Top 5 Timed Events

Event Waits Time(s) Avg Wait(ms) % Total Call Time Wait Class

CPU time 24,483 84.9

gc buffer busy 100,080 831 8 2.9 Cluster

latch: cache buffers chains 4,524,602 663 0 2.3 Concurrency

enq: HW - contention 90,582 344 4 1.2 Configuration

gc cr block busy 182,115 269 1 .9 Cluster

RAC Statistics

Begin End

Number of Instances: 2 2

Global Cache Load Profile

Per Second Per Transaction

Global Cache blocks received: 150.27 1.18

Global Cache blocks served: 76.75 0.60

GCS/GES messages received: 645.08 5.05

GCS/GES messages sent: 769.70 6.02

DBWR Fusion writes: 10.21 0.08

Estd Interconnect traffic (KB) 2,092.45

Global Cache Efficiency Percentages (Target local+remote 100%)

Buffer access - local cache %: 99.91

Buffer access - remote cache %: 0.05

Buffer access - disk %: 0.04

Global Cache and Enqueue Services - Workload Characteristics

Avg global enqueue get time (ms): 0.2

Avg global cache cr block receive time (ms): 1.1

Avg global cache current block receive time (ms): 1.1

Avg global cache cr block build time (ms): 0.2

Avg global cache cr block send time (ms): 0.1

Global cache log flushes for cr blocks served %: 22.6

Avg global cache cr block flush time (ms): 2.6

Avg global cache current block pin time (ms): 0.4

Avg global cache current block send time (ms): 0.1

Global cache log flushes for current blocks served %: 2.8

Avg global cache current block flush time (ms): 3.4

Global Cache and Enqueue Services - Messaging Statistics

Avg message sent queue time (ms): 0.1

Avg message sent queue time on ksxp (ms): 0.3

Avg message received queue time (ms): 0.1

Avg GCS message process time (ms): 0.0

Avg GES message process time (ms): 0.0

% of direct sent messages: 39.35

% of indirect sent messages: 29.57

% of flow controlled messages: 31.08

Main Report

Report Summary
Wait Events Statistics
SQL Statistics
Instance Activity Statistics
IO Stats
Buffer Pool Statistics
Advisory Statistics
Wait Statistics
Undo Statistics
Latch Statistics
Segment Statistics
Dictionary Cache Statistics
Library Cache Statistics
Memory Statistics
Streams Statistics
Resource Limit Statistics
init.ora Parameters

Wait Events Statistics

Time Model Statistics
Wait Class
Wait Events
Background Wait Events
Operating System Statistics
Service Statistics
Service Wait Class Stats

Time Model Statistics

Total time in database user-calls (DB Time): 28838.1s
Statistics including the word "background" measure background process time, and so do not contribute to the DB time statistic
Ordered by % or DB time desc, Statistic name

Statistic Name	Time (s)	% of DB Time
sql execute elapsed time	26,982.24	93.56
DB CPU	24,482.67	84.90
PL/SQL execution elapsed time	3,612.44	12.53
Java execution elapsed time	2,893.61	10.03
inbound PL/SQL rpc elapsed time	2,205.15	7.65
parse time elapsed	836.60	2.90
hard parse elapsed time	586.68	2.03
sequence load elapsed time	79.90	0.28
repeated bind elapsed time	23.84	0.08
connection management call elapsed time	23.14	0.08
PL/SQL compilation elapsed time	4.40	0.02
hard parse (sharing criteria) elapsed time	3.76	0.01
hard parse (bind mismatch) elapsed time	1.38	0.00
failed parse elapsed time	0.06	0.00
DB time	28,838.09
background elapsed time	1,635.62
background cpu time	1,033.53

Back to Wait Events Statistics
Back to Top

Wait Class

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

Wait Class	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	Waits /txn
Cluster	1,079,680	0.06	1,732	2	2.23
Concurrency	5,362,084	0.23	1,118	0	11.06
Other	1,170,400	32.49	669	1	2.41
Configuration	202,891	42.38	364	2	0.42
System I/O	750,879	0.00	330	0	1.55
User I/O	241,263	0.00	321	1	0.50
Application	43,702	0.89	292	7	0.09
Commit	126,619	0.00	262	2	0.26
Network	11,149,871	0.00	62	0	23.00

Back to Wait Events Statistics
Back to Top

Wait Events

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)

Event	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	Waits /txn
gc buffer busy	100,080	0.67	831	8	0.21
latch: cache buffers chains	4,524,602	0.00	663	0	9.33
enq: HW - contention	90,582	0.00	344	4	0.19
gc cr block busy	182,115	0.00	269	1	0.38
log file sync	126,619	0.00	262	2	0.26
db file sequential read	156,439	0.00	237	2	0.32
gc cr multi block request	64,583	0.00	228	4	0.13
enq: UL - contention	34,928	0.78	222	6	0.07
log file parallel write	482,918	0.00	195	0	1.00
gc cr block 2-way	236,074	0.00	154	1	0.49
cursor: pin S wait on X	13,229	92.72	132	10	0.03
db file parallel write	256,327	0.00	130	1	0.53
wait for scn ack	355,323	0.00	108	0	0.73
enq: TX - index contention	33,832	0.03	107	3	0.07
gcs log flush sync	79,999	18.03	103	1	0.17
DFS lock handle	82,865	0.00	99	1	0.17
buffer busy waits	656,147	0.00	96	0	1.35
cr request retry	99	85.86	76	770	0.00
latch: undo global data	17,057	0.00	74	4	0.04
gc current block 2-way	112,487	0.00	74	1	0.23
read by other session	75,906	0.00	70	1	0.16
row cache lock	119,031	0.00	63	1	0.25
enq: FB - contention	27,715	0.04	58	2	0.06
gc current multi block request	243,259	0.00	54	0	0.50
gc current grant busy	38,585	0.01	50	1	0.08
enq: TX - row lock contention	999	7.21	40	40	0.00
SQL*Net more data to client	948,689	0.00	35	0	1.96
gc current block busy	2,095	0.00	32	15	0.00
latch: object queue header operation	13,452	0.00	27	2	0.03
library cache lock	2,171	0.28	27	12	0.00
enq: TX - contention	6,225	0.11	26	4	0.01
gc cr grant 2-way	57,803	0.00	19	0	0.12
enq: SQ - contention	25,662	0.00	18	1	0.05
enq: KO - fast object checkpoint	95	33.68	18	188	0.00
SQL*Net more data from client	289,520	0.00	17	0	0.60
library cache load lock	725	0.00	16	22	0.00
gc current grant 2-way	40,099	0.00	14	0	0.08
SQL*Net message to client	9,911,662	0.00	10	0	20.45
global enqueue expand wait	1,199	75.98	10	8	0.00
gcs drm freeze in enter server mode	26	50.00	10	375	0.00
db file scattered read	4,384	0.00	10	2	0.01
latch: redo allocation	14,342	0.00	9	1	0.03
buffer deadlock	51,218	98.40	8	0	0.11
enq: RO - fast object reuse	103	11.65	8	77	0.00
latch: cache buffers lru chain	6,055	0.00	8	1	0.01
latch: library cache	6,136	0.00	6	1	0.01
kksfbc child completion	159	70.44	6	35	0.00
latch free	6,856	0.00	5	1	0.01
reliable message	417	0.72	5	12	0.00
wait list latch free	1,789	0.00	4	2	0.00
enq: US - contention	6,531	0.00	3	1	0.01
SQL*Net break/reset to client	7,404	0.00	3	0	0.02
db file parallel read	278	0.00	3	12	0.00
LGWR wait for redo copy	23,776	0.10	3	0	0.05
name-service call wait	55	0.00	3	58	0.00
enq: DV - contention	332	0.00	3	10	0.00
gc cr block congested	1,228	0.00	3	3	0.00
PX Deq Credit: send blkd	3,628	37.51	3	1	0.01
os thread startup	27	0.00	3	111	0.00
PX Deq: Signal ACK	102	29.41	3	26	0.00
control file sequential read	9,871	0.00	2	0	0.02
ksxr poll remote instances	250,722	50.15	2	0	0.52
lock deadlock retry	36	88.89	2	55	0.00
control file parallel write	1,763	0.00	2	1	0.00
library cache pin	2,157	0.00	2	1	0.00
latch: library cache pin	2,499	0.00	2	1	0.01
gc current block congested	582	0.00	2	3	0.00
latch: ges resource hash list	6,222	0.00	1	0	0.01
rdbms ipc reply	1,303	0.00	1	1	0.00
latch: gcs resource hash	1,177	0.00	1	1	0.00
lock escalate retry	21	90.48	1	47	0.00
gc recovery quiesce	9	11.11	1	109	0.00
gc quiesce wait	4	25.00	1	244	0.00
latch: cache buffer handles	1,832	0.00	1	0	0.00
enq: TX - allocate ITL entry	462	0.00	1	2	0.00
enq: TM - contention	173	0.00	1	4	0.00
CGS wait for IPC msg	80,936	99.73	1	0	0.17
gc cr grant congested	309	0.00	1	2	0.00
latch: row cache objects	918	0.00	1	1	0.00
enq: WF - contention	19	0.00	1	27	0.00
ges global resource directory to be frozen	38	100.00	0	12	0.00
PX qref latch	87,184	99.92	0	0	0.18
local write wait	239	0.00	0	2	0.00
gc current grant congested	208	0.00	0	2	0.00
PX Deq: reap credit	22,398	85.31	0	0	0.05
cursor: pin S	15,452	0.00	0	0	0.03
enq: PS - contention	184	0.00	0	2	0.00
undo segment extension	86,037	99.93	0	0	0.18
latch: session allocation	931	0.00	0	0	0.00
enq: CF - contention	153	0.00	0	2	0.00
L1 validation	30	80.00	0	9	0.00
latch: KCL gc element parent latch	719	0.00	0	0	0.00
latch: checkpoint queue latch	267	0.00	0	1	0.00
latch: redo writing	142	0.00	0	1	0.00
latch: library cache lock	147	0.00	0	1	0.00
latch: messages	944	0.00	0	0	0.00
enq: TT - contention	79	0.00	0	1	0.00
latch: shared pool	200	0.00	0	1	0.00
gc current split	25	0.00	0	3	0.00
enq: TO - contention	37	0.00	0	2	0.00
kjbdrmcvtq lmon drm quiesce: ping completion	38	55.26	0	2	0.00
enq: TA - contention	97	0.00	0	1	0.00
latch: enqueue hash chains	115	0.00	0	1	0.00
IPC send completion sync	83	92.77	0	1	0.00
gc current retry	22	0.00	0	2	0.00
gc cr failure	95	0.00	0	0	0.00
latch: object queue header heap	35	0.00	0	1	0.00
cursor: mutex S	150	0.00	0	0	0.00
enq: DR - contention	3	0.00	0	7	0.00
enq: KM - contention	1	0.00	0	20	0.00
enq: MD - contention	9	0.00	0	2	0.00
enq: CU - contention	1	0.00	0	16	0.00
enq: PI - contention	7	0.00	0	2	0.00
cursor: mutex X	113	0.00	0	0	0.00
KJC: Wait for msg sends to complete	71	0.00	0	0	0.00
enq: AF - task serialization	2	0.00	0	6	0.00
gc current block unknown	15	0.00	0	1	0.00
direct path read	3,857	0.00	0	0	0.01
write complete waits	6	0.00	0	1	0.00
ges2 LMON to wake up LMD - mrcvr	13	7.69	0	1	0.00
enq: TQ - TM contention	9	0.00	0	1	0.00
enq: TQ - DDL contention	4	0.00	0	1	0.00
enq: MW - contention	3	0.00	0	1	0.00
enq: DL - contention	4	0.00	0	0	0.00
direct path write temp	37	0.00	0	0	0.00
gc cr block lost	2	0.00	0	1	0.00
enq: FU - contention	1	0.00	0	1	0.00
direct path write	117	0.00	0	0	0.00
gc cr disk read	1	0.00	0	0	0.00
direct path read temp	6	0.00	0	0	0.00
SQL*Net message from client	9,911,717	0.00	2,057,527	208	20.45
pipe get	40,288	47.80	57,901	1437	0.08
gcs remote message	2,289,042	76.62	14,460	6	4.72
Streams AQ: waiting for messages in the queue	1,662	98.50	9,841	5921	0.00
PX Idle Wait	2,704	95.67	6,425	2376	0.01
jobq slave wait	1,547	49.97	3,747	2422	0.00
DIAG idle wait	18,751	0.00	3,701	197	0.04
ges remote message	383,590	39.85	3,676	10	0.79
Streams AQ: qmn slave idle wait	134	0.00	3,676	27431	0.00
Streams AQ: qmn coordinator idle wait	264	50.76	3,676	13923	0.00
Streams AQ: waiting for time management or cleanup tasks	63	26.98	3,658	58068	0.00
PL/SQL lock timer	291	95.88	3,083	10596	0.00
PX Deq: Execution Msg	1,062	7.44	21	20	0.00
PX Deq: Execute Reply	4,359	28.06	14	3	0.01
PX Deq: Parse Reply	124	20.97	4	33	0.00
PX Deq Credit: need buffer	1,787	31.67	1	0	0.00
PX Deq: Join ACK	166	33.73	0	3	0.00
PX Deq: Msg Fragment	550	1.64	0	1	0.00
PX Deq: Table Q Normal	483	2.90	0	1	0.00
class slave wait	3	0.00	0	1	0.00
Streams AQ: RAC qmn coordinator idle wait	269	100.00	0	0	0.00

Back to Wait Events Statistics
Back to Top

Background Wait Events

ordered by wait time desc, waits desc (idle events last)

Event	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	Waits /txn
events in waitclass Other	828,922	26.77	253	0	1.71
log file parallel write	482,904	0.00	195	0	1.00
db file parallel write	256,322	0.00	130	1	0.53
latch: cache buffers chains	3,867	0.00	14	4	0.01
db file parallel read	233	0.00	3	12	0.00
db file scattered read	586	0.00	2	4	0.00
gc cr multi block request	3,510	0.00	2	1	0.01
control file sequential read	7,572	0.00	2	0	0.02
control file parallel write	1,763	0.00	2	1	0.00
os thread startup	18	0.00	2	97	0.00
db file sequential read	174	0.00	0	3	0.00
gc cr block 2-way	723	0.00	0	1	0.00
gc current block 2-way	598	0.00	0	1	0.00
row cache lock	345	0.00	0	1	0.00
latch: redo writing	142	0.00	0	1	0.00
buffer busy waits	536	1.49	0	0	0.00
gc current grant busy	94	0.00	0	0	0.00
gc current grant 2-way	74	0.00	0	1	0.00
enq: RO - fast object reuse	23	0.00	0	2	0.00
library cache lock	26	0.00	0	1	0.00
enq: KO - fast object checkpoint	14	0.00	0	2	0.00
latch: row cache objects	17	0.00	0	1	0.00
gc current block congested	4	0.00	0	3	0.00
latch: shared pool	6	0.00	0	2	0.00
enq: TM - contention	14	0.00	0	1	0.00
gc cr block congested	4	0.00	0	2	0.00
gc cr grant 2-way	27	0.00	0	0	0.00
latch: library cache	2	0.00	0	3	0.00
library cache pin	1	0.00	0	1	0.00
log file sync	1	0.00	0	0	0.00
rdbms ipc message	1,505,400	3.99	39,510	26	3.11
gcs remote message	2,288,838	76.62	14,460	6	4.72
DIAG idle wait	18,751	0.00	3,701	197	0.04
pmon timer	3,341	92.64	3,683	1102	0.01
ges remote message	383,546	39.85	3,676	10	0.79
Streams AQ: qmn slave idle wait	134	0.00	3,676	27431	0.00
Streams AQ: qmn coordinator idle wait	264	50.76	3,676	13923	0.00
Streams AQ: waiting for time management or cleanup tasks	63	26.98	3,658	58068	0.00
smon timer	138,767	0.00	3,654	26	0.29
PX Deq: Join ACK	33	42.42	0	8	0.00
PX Deq: Parse Reply	34	41.18	0	2	0.00
PX Deq: Execute Reply	29	27.59	0	0	0.00
Streams AQ: RAC qmn coordinator idle wait	269	100.00	0	0	0.00

Back to Wait Events Statistics
Back to Top

Operating System Statistics

Statistic	Total
BUSY_TIME	29,300,846
IDLE_TIME	32,763,876
IOWAIT_TIME	388,663
NICE_TIME	0
SYS_TIME	2,725,574
USER_TIME	24,879,623
LOAD	3
RSRC_MGR_CPU_WAIT_TIME	0
PHYSICAL_MEMORY_BYTES	1,588,192
NUM_CPUS	16
NUM_CPU_SOCKETS	8

Back to Wait Events Statistics
Back to Top

Service Statistics

ordered by DB Time

Service Name	DB Time (s)	DB CPU (s)	Physical Reads	Logical Reads
VIS	28,654.80	24,322.00	536,862	1,104,990,112
SYS$USERS	197.30	166.30	87,831	8,112,822
SYS$BACKGROUND	0.00	0.00	17,613	1,758,841

Back to Wait Events Statistics
Back to Top

Service Wait Class Stats

Wait Class info for services in the Service Statistics section.
Total Waits and Time Waited displayed for the following wait classes: User I/O, Concurrency, Administrative, Network
Time Waited (Wt Time) in centisecond (100th of a second)

Service Name	User I/O Total Wts	User I/O Wt Time	Concurcy Total Wts	Concurcy Wt Time	Network Total Wts	Network Wt Time
VIS	230265	30035	5346023	109680	11129957	6197
SYS$USERS	9829	1501	10952	386	6025	2
SYS$BACKGROUND	1172	581	5141	1689	0	0

Back to Wait Events Statistics
Back to Top

SQL Statistics

SQL ordered by Elapsed Time
SQL ordered by CPU Time
SQL ordered by Gets
SQL ordered by Reads
SQL ordered by Executions
SQL ordered by Parse Calls
SQL ordered by Sharable Memory
SQL ordered by Version Count
SQL ordered by Cluster Wait Time
Complete List of SQL Text

SQL ordered by Elapsed Time

Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code.
% Total DB Time is the Elapsed Time of the SQL statement divided into the Total Database Time multiplied by 100

Elapsed Time (s)	CPU Time (s)	Executions	Elap per Exec (s)	% Total DB Time	SQL Id	SQL Module	SQL Text
3,817	3,651	8	477.18	13.24	ghw9svn8x4vzu	WSHPSRS	BEGIN WSH_PICK_LIST.RELEASE_BA...
2,336	2,223	286	8.17	8.10	0z318y6g3uagc	INCTCW	declare l_retstat varchar2 ( 3...
1,869	1,701	10	186.85	6.48	bkxrrs52m7d8p	WSHINTERFACE	BEGIN WSH_SHIP_CONFIRM_ACTIONS...
1,607	1,071	14	114.81	5.57	8c30hkqv9n7cr	OEHVIMP	BEGIN OE_BULK_ORDER_IMPORT_PVT...
1,438	1,394	62,276	0.02	4.98	60t2tt1564j0k		SELECT SUBSTRB(MACHINE, 1, 60)...
1,024	945	8	127.96	3.55	7g05xfvc5vp74	ARTERRPW	BEGIN arp_run.revenue_recognit...
979	558	1,362	0.72	3.40	bt0w082dfrm8v	WSHINTERFACE	BEGIN WSH_SHIP_CONFIRM_ACTIONS...
802	535	56,791	0.01	2.78	gksvm8wmzk8w0	WSHINTERFACE	begin OE_INVOICE_WF.INVOICE_IN...
713	642	1,139	0.63	2.47	3cb7xm8ykx1qh	icx.por.req.server.RequisitionAM	begin :1 := POR_UTIL_PKG.subm...
694	552	96	7.22	2.41	37f1qguwxw0sk	RAXTRX	begin IF ( :v_msg_level:i_msg_...
660	634	16	41.24	2.29	5qyckzm5v1qmj	RAXTRX	begin :return_value:i_return_v...
633	616	11	57.57	2.20	1du9v021t8m46	ARGLTP	insert into gl_interface(creat...
590	573	17,503	0.03	2.04	8h16w67202y4g		begin fnd_global.initialize(:s...
561	536	5,000	0.11	1.95	2fjd6cndjby9p	ARTERRPW	INSERT INTO RA_CUST_TRX_LINE_G...
541	485	8	67.66	1.88	8vmj377jqyqwq	WSHASCSRS	BEGIN WSH_BATCH_PROCESS.CONFIR...
472	369	56,806	0.01	1.64	9wdrypwkpf607	WSHINTERFACE	begin OE_FULFILL_WF.START_FULF...
459	403	56,785	0.01	1.59	4yak7x2zqz0dh	WSHFRREL	BEGIN inv_transfer_order_pvt.f...
403	302	16	25.18	1.40	9z9zx4z8j4648	RAXTRX	SELECT ct.customer_trx_id, ...
396	107	63	6.28	1.37	3a7mfaapst783	RAXTRX	update RA_CUSTOMER_TRX T set ...
337	331	11	30.63	1.17	bp8crdjba8zgt	ARGLTP	update ra_cust_trx_line_gl_dis...
330	27	16	20.61	1.14	cz148dcrzr2rw	RAXTRX	UPDATE RA_INTERFACE_LINES SET ...
328	277	10,000	0.03	1.14	64qc329wgjv39	PYUSLV	select /*+ ORDERED INDEX(ASS...
323	314	984	0.33	1.12	0qcpgw43yqj5r	WSHPSRS	( SELECT DISTINCT WDD.SOURCE_L...
322	293	7,968	0.04	1.12	6h2tpcxpymqu7	JDBC Thin Client	BEGIN :1 := FND_AOLJ_UTIL.is_V...
309	207	777,210	0.00	1.07	gnhmcahkmrnzs		INSERT INTO WF_ITEM_ACTIVITY_S...
300	66	16	18.76	1.04	g2at0k65a0g59	RAXTRX	INSERT INTO RA_INTERFACE_ERRO...
290	167	69,590	0.00	1.01	3vy5h9xkfv1s5		INSERT INTO WF_ITEM_ATTRIBUTE_...

Back to SQL Statistics
Back to Top

SQL ordered by CPU Time

Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code.
% Total DB Time is the Elapsed Time of the SQL statement divided into the Total Database Time multiplied by 100

CPU Time (s)