WORKLOAD REPOSITORY report for

DB Name DB Id Instance Inst num Startup Time Release RAC

ORC11G 501734497 orc11g 1 16-7�� -12 08:07 11.2.0.1.0 NO

DB Name	DB Id	Instance	Inst num	Startup Time	Release	RAC
ORC11G	501734497	orc11g	1	16-7�� -12 08:07	11.2.0.1.0	NO

Host Name Platform CPUs Cores Sockets Memory (GB)

localhost.localdomain Linux x86 64-bit 8 8 2 7.79

Host Name	Platform	CPUs	Cores	Sockets	Memory (GB)
localhost.localdomain	Linux x86 64-bit	8	8	2	7.79

Snap Id Snap Time Sessions Cursors/Session

Begin Snap: 2468 25-7�� -12 08:00:34 81 2.8

End Snap: 2469 25-7�� -12 09:00:42 105 3.4

Elapsed: 60.13 (mins)

DB Time: 8.76 (mins)

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	2468	25-7�� -12 08:00:34	81	2.8
End Snap:	2469	25-7�� -12 09:00:42	105	3.4
Elapsed:		60.13 (mins)
DB Time:		8.76 (mins)

Report Summary

Cache Sizes

Begin End

Buffer Cache: 1,072M 1,072M Std Block Size: 8K

Shared Pool Size: 944M 944M Log Buffer: 15,960K

	Begin	End
Buffer Cache:	1,072M	1,072M	Std Block Size:	8K
Shared Pool Size:	944M	944M	Log Buffer:	15,960K

Load Profile

Per Second Per Transaction Per Exec Per Call

DB Time(s): 0.2 0.0 0.00 0.01

DB CPU(s): 0.1 0.0 0.00 0.01

Redo size: 25,209.9 2,044.9

Logical reads: 10,037.8 814.2

Block changes: 183.6 14.9

Physical reads: 2.4 0.2

Physical writes: 6.7 0.5

User calls: 27.3 2.2

Parses: 18.0 1.5

Hard parses: 0.1 0.0

W/A MB processed: 0.8 0.1

Logons: 0.5 0.0

Executes: 113.8 9.2

Rollbacks: 0.5 0.0

Transactions: 12.3

	Per Second	Per Transaction	Per Exec	Per Call
DB Time(s):	0.2	0.0	0.00	0.01
DB CPU(s):	0.1	0.0	0.00	0.01
Redo size:	25,209.9	2,044.9
Logical reads:	10,037.8	814.2
Block changes:	183.6	14.9
Physical reads:	2.4	0.2
Physical writes:	6.7	0.5
User calls:	27.3	2.2
Parses:	18.0	1.5
Hard parses:	0.1	0.0
W/A MB processed:	0.8	0.1
Logons:	0.5	0.0
Executes:	113.8	9.2
Rollbacks:	0.5	0.0
Transactions:	12.3

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %: 100.00 Redo NoWait %: 100.00

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

Library Hit %: 99.85 Soft Parse %: 99.57

Execute to Parse %: 84.18 Latch Hit %: 99.94

Parse CPU to Parse Elapsd %: 81.90 % Non-Parse CPU: 99.29

Shared Pool Statistics

Begin End

Memory Usage %: 85.22 84.17

% SQL with executions>1: 96.21 93.26

% Memory for SQL w/exec>1: 90.92 88.37

	Begin	End
Memory Usage %:	85.22	84.17
% SQL with executions>1:	96.21	93.26
% Memory for SQL w/exec>1:	90.92	88.37

Top 5 Timed Foreground Events

Event	Waits	Time(s)	Avg wait (ms)	% DB time	Wait Class
DB CPU		520		98.91
db file sequential read	7,282	14	2	2.69	User I/O
log file sync	4,799	3	1	0.57	Commit
db file parallel read	10	2	195	0.37	User I/O
Disk file operations I/O	1,700	1	1	0.21	User I/O

Host CPU (CPUs: 8 Cores: 8 Sockets: 2)

Load Average Begin Load Average End %User %System %WIO %Idle

0.25 0.07 1.6 0.2 0.1 98.1

Instance CPU

Load Average Begin	Load Average End	%User	%System	%WIO	%Idle
0.25	0.07	1.6	0.2	0.1	98.1

%Total CPU %Busy CPU %DB time waiting for CPU (Resource Manager)

1.8 95.4 0.0

Memory Statistics

%Total CPU	%Busy CPU	%DB time waiting for CPU (Resource Manager)
1.8	95.4	0.0

Begin End

Host Mem (MB): 7,973.8 7,973.8

SGA use (MB): 2,080.0 2,080.0

PGA use (MB): 261.9 295.1

% Host Mem used for SGA+PGA: 29.37 29.79

	Begin	End
Host Mem (MB):	7,973.8	7,973.8
SGA use (MB):	2,080.0	2,080.0
PGA use (MB):	261.9	295.1
% Host Mem used for SGA+PGA:	29.37	29.79

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
Shared Server Statistics
init.ora Parameters

Wait Events Statistics

Time Model Statistics
Operating System Statistics
Operating System Statistics - Detail
Foreground Wait Class
Foreground Wait Events
Background Wait Events
Wait Event Histogram
Wait Event Histogram Detail (64 msec to 2 sec)
Wait Event Histogram Detail (4 sec to 2 min)
Wait Event Histogram Detail (4 min to 1 hr)
Service Statistics
Service Wait Class Stats

Time Model Statistics

Total time in database user-calls (DB Time): 525.9s
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
DB CPU	520.10	98.91
sql execute elapsed time	480.75	91.42
PL/SQL execution elapsed time	20.15	3.83
connection management call elapsed time	10.63	2.02
parse time elapsed	6.80	1.29
hard parse elapsed time	4.05	0.77
hard parse (sharing criteria) elapsed time	1.51	0.29
sequence load elapsed time	0.63	0.12
hard parse (bind mismatch) elapsed time	0.17	0.03
PL/SQL compilation elapsed time	0.09	0.02
repeated bind elapsed time	0.07	0.01
failed parse elapsed time	0.00	0.00
DB time	525.85
background elapsed time	23.87
background cpu time	10.79

Back to Wait Events Statistics
Back to Top

Operating System Statistics

*TIME statistic values are diffed. All others display actual values. End Value is displayed if different
ordered by statistic type (CPU Use, Virtual Memory, Hardware Config), Name

Statistic	Value	End Value
BUSY_TIME	55,622
IDLE_TIME	2,830,313
IOWAIT_TIME	2,210
NICE_TIME	50
SYS_TIME	7,074
USER_TIME	47,386
LOAD	0	0
PHYSICAL_MEMORY_BYTES	8,361,177,088
NUM_CPUS	8
NUM_CPU_CORES	8
NUM_CPU_SOCKETS	2
GLOBAL_RECEIVE_SIZE_MAX	4,194,304
GLOBAL_SEND_SIZE_MAX	1,048,586
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

Back to Wait Events Statistics
Back to Top

Operating System Statistics - Detail

Snap Time	Load	%busy	%user	%sys	%idle	%iowait
25-7�� 08:00:34	0.25
25-7�� 09:00:42	0.07	1.93	1.64	0.25	98.07	0.08

Back to Wait Events Statistics
Back to Top

Foreground Wait Class

s - second, ms - millisecond - 1000th of a second
ordered by wait time desc, waits desc
%Timeouts: value of 0 indicates value was < .5%. Value of null is truly 0
Captured Time accounts for 102.9% of Total DB time 525.85 (s)
Total FG Wait Time: 21.24 (s) DB CPU time: 520.10 (s)

Wait Class	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	%DB time
DB CPU			520		98.91
User I/O	9,566	0	17	2	3.30
Commit	4,799	0	3	1	0.57
Network	94,724	0	0	0	0.06
Concurrency	1,037	0	0	0	0.05
Other	108,034	100	0	0	0.05
Application	9	0	0	1	0.00
System I/O	26	0	0	0	0.00
Configuration	1	0	0	0	0.00

Back to Wait Events Statistics
Back to Top

Foreground Wait Events

s - second, ms - millisecond - 1000th of a second
Only events with Total Wait Time (s) >= .001 are shown
ordered by wait time desc, waits desc (idle events last)
%Timeouts: value of 0 indicates value was < .5%. Value of null is truly 0

Event	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	Waits /txn	% DB time
db file sequential read	7,282	0	14	2	0.16	2.69
log file sync	4,799	0	3	1	0.11	0.57
db file parallel read	10	0	2	195	0.00	0.37
Disk file operations I/O	1,700	0	1	1	0.04	0.21
asynch descriptor resize	108,028	100	0	0	2.43	0.05
SQL*Net message to client	86,960	0	0	0	1.96	0.04
buffer busy waits	446	0	0	0	0.01	0.04
db file scattered read	28	0	0	5	0.00	0.02
SQL*Net more data to client	7,764	0	0	0	0.17	0.02
library cache: mutex X	338	0	0	0	0.01	0.01
latch: cache buffers chains	237	0	0	0	0.01	0.01
direct path read	537	0	0	0	0.01	0.00
SQL*Net break/reset to client	4	0	0	2	0.00	0.00
local write wait	9	0	0	0	0.00	0.00
latch: shared pool	8	0	0	1	0.00	0.00
enq: RO - fast object reuse	5	0	0	1	0.00	0.00
SQL*Net message from client	86,937	0	216,520	2491	1.95
jobq slave wait	7,799	100	3,905	501	0.18

Back to Wait Events Statistics
Back to Top

Background Wait Events

ordered by wait time desc, waits desc (idle events last)
Only events with Total Wait Time (s) >= .001 are shown
%Timeouts: value of 0 indicates value was < .5%. Value of null is truly 0

Event	Waits	%Time -outs	Total Wait Time (s)	Avg wait (ms)	Waits /txn	% bg time
log file parallel write	91,184	0	7	0	2.05	29.76
os thread startup	139	0	3	25	0.00	14.42
db file async I/O submit	5,621	0	2	0	0.13	9.40
control file parallel write	1,813	0	1	0	0.04	3.70
latch free	73	0	0	5	0.00	1.48
Log archive I/O	96	0	0	2	0.00	0.80
db file sequential read	182	0	0	1	0.00	0.67
Disk file operations I/O	194	0	0	1	0.00	0.51
control file sequential read	6,161	0	0	0	0.14	0.29
log file sequential read	45	0	0	1	0.00	0.19
ADR block file read	12	0	0	3	0.00	0.17
latch: call allocation	168	0	0	0	0.00	0.12
reliable message	84	0	0	0	0.00	0.07
asynch descriptor resize	1,604	100	0	0	0.04	0.07
LGWR wait for redo copy	104	0	0	0	0.00	0.05
SQL*Net message to client	4,137	0	0	0	0.09	0.04
db file single write	63	0	0	0	0.00	0.03
rdbms ipc reply	84	0	0	0	0.00	0.03
rdbms ipc message	61,173	25	57,667	943	1.38
DIAG idle wait	7,204	100	7,211	1001	0.16
shared server idle wait	121	100	3,631	30005	0.00
Streams AQ: qmn slave idle wait	129	0	3,613	28009	0.00
Streams AQ: qmn coordinator idle wait	258	50	3,613	14004	0.01
pmon timer	1,290	93	3,609	2797	0.03
Space Manager: slave idle wait	723	99	3,607	4989	0.02
dispatcher timer	60	100	3,600	60003	0.00
smon timer	14	71	3,561	254331	0.00
SQL*Net message from client	5,534	0	23	4	0.12
class slave wait	18	0	0	0	0.00

Back to Wait Events Statistics
Back to Top

Wait Event Histogram

Units for Total Waits column: K is 1000, M is 1000000, G is 1000000000
% of Waits: value of .0 indicates value was <.05%; value of null is truly 0
% of Waits: column heading of <=1s is truly <1024ms, >1s is truly >=1024ms
Ordered by Event (idle events last)

Event	Total Waits	<1ms	<2ms	<4ms	<8ms	<16ms	<32ms	<=1s	>1s
		% of Waits
ADR block file read	12	33.3		25.0	41.7
ADR block file write	5	100.0
ADR file lock	6	100.0
ARCH wait for archivelog lock	3	100.0
Disk file operations I/O	1894	99.0	.7	.3
LGWR wait for redo copy	104	100.0
Log archive I/O	96	6.3	44.8	47.9		1.0
SQL*Net break/reset to client	4	50.0			50.0
SQL*Net message to client	91.1K	100.0
SQL*Net more data from client	6	100.0
SQL*Net more data to client	7770	100.0
asynch descriptor resize	109.6K	100.0
buffer busy waits	447	93.3	5.8	.7	.2
control file parallel write	1814	98.9	.5	.2	.1	.1		.2
control file sequential read	6188	100.0
cursor: pin S	6	100.0
db file async I/O submit	5621	98.1	1.0	.6	.1	.1	.0	.1
db file parallel read	10					20.0		80.0
db file scattered read	28	7.1		32.1	53.6	7.1
db file sequential read	7474	49.6	8.6	25.8	15.4	.5	.1	.0
db file single write	63	98.4	1.6
direct path read	537	99.4		.2	.4
enq: HW - contention	1	100.0
enq: RO - fast object reuse	5	100.0
latch free	74	55.4				44.6
latch: In memory undo latch	1	100.0
latch: cache buffers chains	237	94.5	5.1	.4
latch: call allocation	168	99.4		.6
latch: enqueue hash chains	1	100.0
latch: redo allocation	1	100.0
latch: redo writing	1	100.0
latch: row cache objects	1	100.0
latch: shared pool	9	77.8	22.2
library cache: mutex X	338	95.6	3.3	1.2
local write wait	9	88.9	11.1
log file parallel write	91.2K	99.8	.1	.0	.0	.0	.0	.0
log file sequential read	45	46.7	40.0	13.3
log file single write	6	100.0
log file sync	4800	93.1	3.9	2.0	.6	.1	.1	.2
os thread startup	139						100.0
rdbms ipc reply	84	100.0
reliable message	88	96.6	2.3	1.1
DIAG idle wait	7204							100.0
SQL*Net message from client	92.5K	72.1	5.6	3.2	1.8	.4	.2	5.2	11.6
Space Manager: slave idle wait	723								100.0
Streams AQ: qmn coordinator idle wait	258	50.0							50.0
Streams AQ: qmn slave idle wait	129								100.0
class slave wait	18	100.0
dispatcher timer	60								100.0
jobq slave wait	7799	.0						100.0
pmon timer	1290	6.7							93.3
rdbms ipc message	61.2K	43.5	19.2	1.3	1.1	.4	.6	15.4	18.5
shared server idle wait	121								100.0
smon timer	14								100.0

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (64 msec to 2 sec)

Units for Total Waits column: K is 1000, M is 1000000, G is 1000000000
Units for % of Total Waits: ms is milliseconds s is 1024 milliseconds (approximately 1 second)
% of Total Waits: total waits for all wait classes, including Idle
% of Total Waits: value of .0 indicates value was <.05%; value of null is truly 0
Ordered by Event (only non-idle events are displayed)

Event	Waits 64ms to 2s	<32ms	<64ms	<1/8s	<1/4s	<1/2s
		% of Total Waits
control file parallel write	3	99.8	.1	.1
db file async I/O submit	8	99.9	.1	.0	.0	.0
db file parallel read	8	20.0	20.0	10.0	10.0	40.0
db file sequential read	2	100.0	.0	.0
log file parallel write	13	100.0	.0	.0
log file sync	10	99.8	.0	.1	.0

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (4 sec to 2 min)

No data exists for this section of the report.

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (4 min to 1 hr)

No data exists for this section of the report.

Back to Wait Events Statistics
Back to Top

Service Statistics

ordered by DB Time

Service Name	DB Time (s)	DB CPU (s)	Physical Reads (K)	Logical Reads (K)
SYS$USERS	511	508	7	36,075
orc11g	14	12	2	102
SYS$BACKGROUND	0	0	0	21
orc11gXDB	0	0	0	0

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 seconds

Service Name	User I/O Total Wts	User I/O Wt Time	Concurcy Total Wts	Concurcy Wt Time	Network Total Wts
SYS$USERS	7734	15	1037	0	94348
orc11g	1832	2	0	0	376
SYS$BACKGROUND	436	0	140	3	0

Back to Wait Events Statistics
Back to Top

SQL Statistics

SQL ordered by Elapsed Time
SQL ordered by CPU Time
SQL ordered by User I/O Wait Time
SQL ordered by Gets
SQL ordered by Reads
SQL ordered by Physical Reads (UnOptimized)
SQL ordered by Executions
SQL ordered by Parse Calls
SQL ordered by Sharable Memory
SQL ordered by Version Count
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
%Total - Elapsed Time as a percentage of Total DB time
%CPU - CPU Time as a percentage of Elapsed Time
%IO - User I/O Time as a percentage of Elapsed Time
Captured SQL account for 84.3% of Total DB Time (s): 526
Captured PL/SQL account for 8.2% of Total DB Time (s): 526

Elapsed Time (s)	Executions	Elapsed Time per Exec (s)	%Total	%CPU	%IO	SQL Id	SQL Module	SQL Text
357.19	519	0.69	67.93	99.90	0.00	8fr0psqvxzjsj	JDBC Thin Client	SELECT SUM(B.FEED_IN_POWER) FE...
34.96	1,368	0.03	6.65	99.71	0.15	d4hud7mhyjfbn	JDBC Thin Client	BEGIN SP_T_GENERATED_POWER_DAT...
12.70	2	6.35	2.41	89.10	7.90	c8khjbn635s3c	plsqldev.exe	��D�֣��\�}��͒֏��\��ɢɪ��[��G...
9.86	1	9.86	1.88	86.63	5.49	d335gcvnz7q9a	sqlplus@localhost.localdomain (TNS V1-V3)	SELECT output FROM TABLE (dbms...
8.58	1	8.58	1.63	4.73	97.16	f0f3ch6j2msvm	JDBC Thin Client	SELECT A.DISPLAY_TIME DISPLAY_...
6.90	7,427	0.00	1.31	92.53	0.00	az33m61ym46y4	JDBC Thin Client	ئ��D��b��I�ã����ś��...
6.79	254	0.03	1.29	92.01	7.95	2y05nb0r4m01g	JDBC Thin Client	SELECT SUM(B.FEED_IN_POWER) FE...
5.32	75	0.07	1.01	19.96	82.03	8yz9twtn06qtg	JDBC Thin Client	BEGIN SP_ORIGINAL_DATA_INVERTE...
5.26	19	0.28	1.00	98.76	1.17	fsrpg0kmrtfzu	JDBC Thin Client	SELECT TO_CHAR(A.DISPLAY_TIME,...
5.26	75	0.07	1.00	18.75	83.01	43zjc5653gyk5	JDBC Thin Client	SELECT CEIL(COUNT(1)/NULLIF(:B...

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 - CPU Time as a percentage of Total DB CPU
%CPU - CPU Time as a percentage of Elapsed Time
%IO - User I/O Time as a percentage of Elapsed Time
Captured SQL account for 81.2% of Total CPU Time (s): 520
Captured PL/SQL account for 7.5% of Total CPU Time (s): 520

CPU Time (s)	Executions	CPU per Exec (s)	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
356.82	519	0.69	68.61	357.19	99.90	0.00	8fr0psqvxzjsj	JDBC Thin Client	SELECT SUM(B.FEED_IN_POWER) FE...
34.86	1,368	0.03	6.70	34.96	99.71	0.15	d4hud7mhyjfbn	JDBC Thin Client	BEGIN SP_T_GENERATED_POWER_DAT...
11.31	2	5.66	2.17	12.70	89.10	7.90	c8khjbn635s3c	plsqldev.exe	��D�֣��\�}��͒֏��\��ɢɪ��[��G...
8.54	1	8.54	1.64	9.86	86.63	5.49	d335gcvnz7q9a	sqlplus@localhost.localdomain (TNS V1-V3)	SELECT output FROM TABLE (dbms...
6.39	7,427	0.00	1.23	6.90	92.53	0.00	az33m61ym46y4	JDBC Thin Client	ئ��D��b��I�ã����ś��...
6.25	254	0.02	1.20	6.79	92.01	7.95	2y05nb0r4m01g	JDBC Thin Client	SELECT SUM(B.FEED_IN_POWER) FE...
5.19	19	0.27	1.00	5.26	98.76	1.17	fsrpg0kmrtfzu	JDBC Thin Client	SELECT TO_CHAR(A.DISPLAY_TIME,...
2.25	13,914	0.00	0.43	2.29	98.56	0.00	91f6v8c3dg57k	JDBC Thin Client	SELECT SF_TIME_ZONE_TO_NUMBER(...
2.16	35	0.06	0.42	2.16	100.15	0.00	1bu5pxmd05bsu	JDBC Thin Client	SELECT SUM(B.FEED_IN_POWER) FE...
2.11	166	0.01	0.41	2.14	98.39	1.26	cw9mjyypvma13	JDBC Thin Client	SELECT CASE WHEN NVL(A.INVERTE...

Back to SQL Statistics
Back to Top

SQL ordered by User I/O Wait Time

Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code.
%Total - User I/O Time as a percentage of Total User I/O Wait time
%CPU - CPU Time as a percentage of Elapsed Time
%IO - User I/O Time as a percentage of Elapsed Time
Captured SQL account for 95.8% of Total User I/O Wait Time (s): 18
Captured PL/SQL account for 25.2% of Total User I/O Wait Time (s): 18

User I/O Time (s)	Executions	UIO per Exec (s)	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
8.34	1	8.34	47.31	8.58	4.73	97.16	f0f3ch6j2msvm	JDBC Thin Client	SELECT A.DISPLAY_TIME DISPLAY_...
4.36	75	0.06	24.76	5.26	18.75	83.01	43zjc5653gyk5	JDBC Thin Client	SELECT CEIL(COUNT(1)/NULLIF(:B...
4.36	75	0.06	24.76	5.32	19.96	82.03	8yz9twtn06qtg	JDBC Thin Client	BEGIN SP_ORIGINAL_DATA_INVERTE...
1.00	2	0.50	5.69	12.70	89.10	7.90	c8khjbn635s3c	plsqldev.exe	��D�֣��\�}��͒֏��\��ɢɪ��[��G...
0.99	1	0.99	5.64	1.06	9.37	93.97	gtkz6vhsmthkr	PL/SQL Developer	select * from t_generated_powe...
0.89	1,397	0.00	5.07	1.33	98.29	67.23	459f3z9u4fb3u		��D�֣��[�ԣ��̶��Ô}��ţ��ͣ��U��
0.54	1	0.54	3.07	9.86	86.63	5.49	d335gcvnz7q9a	sqlplus@localhost.localdomain (TNS V1-V3)	SELECT output FROM TABLE (dbms...
0.54	254	0.00	3.06	6.79	92.01	7.95	2y05nb0r4m01g	JDBC Thin Client	SELECT SUM(B.FEED_IN_POWER) FE...
0.06	19	0.00	0.35	5.26	98.76	1.17	fsrpg0kmrtfzu	JDBC Thin Client	SELECT TO_CHAR(A.DISPLAY_TIME,...
0.06	166	0.00	0.34	0.56	99.17	10.54	9ms5u855uytjm	JDBC Thin Client	SELECT X.ETU_ID, B.LOGIN_NAME,...

Back to SQL Statistics
Back to Top

SQL ordered by Gets

Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code.
%Total - Buffer Gets as a percentage of Total Buffer Gets
%CPU - CPU Time as a percentage of Elapsed Time
%IO - User I/O Time as a percentage of Elapsed Time
Total Buffer Gets: 36,215,241
Captured SQL account for 97.8% of Total

Buffer Gets	Executions	Gets per Exec	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
31,227,909	519	60,169.38	86.23	357.19	99.90	0.00	8fr0psqvxzjsj	JDBC Thin Client	SELECT SUM(B.FEED_IN_POWER) FE...
1,069,114	254	4,209.11	2.95	6.79	92.01	7.95	2y05nb0r4m01g	JDBC Thin Client	SELECT SUM(B.FEED_IN_POWER) FE...
995,218	7,427	134.00	2.75	6.90	92.53	0.00	az33m61ym46y4	JDBC Thin Client	ئ��D��b��I�ã����ś��...
943,272	1,368	689.53	2.60	34.96	99.71	0.15	d4hud7mhyjfbn	JDBC Thin Client	BEGIN SP_T_GENERATED_POWER_DAT...
720,930	1	720,930.00	1.99	9.86	86.63	5.49	d335gcvnz7q9a	sqlplus@localhost.localdomain (TNS V1-V3)	SELECT output FROM TABLE (dbms...
129,680	12,968	10.00	0.36	1.42	63.42	0.00	bwfb6assstav1	JDBC Thin Client	UPDATE SYS_TABLE SET T_ID=:B1 ...
103,163	35	2,947.51	0.28	2.16	100.15	0.00	1bu5pxmd05bsu	JDBC Thin Client	SELECT SUM(B.FEED_IN_POWER) FE...
101,926	166	614.01	0.28	2.14	98.39	1.26	cw9mjyypvma13	JDBC Thin Client	SELECT CASE WHEN NVL(A.INVERTE...
100,986	13,358	7.56	0.28	1.71	74.03	0.00	agdnmg75n2p76	JDBC Thin Client	INSERT INTO T_PROTOCOL_DATA_OT...
100,884	75	1,345.12	0.28	5.26	18.75	83.01	43zjc5653gyk5	JDBC Thin Client	SELECT CEIL(COUNT(1)/NULLIF(:B...

Back to SQL Statistics
Back to Top

SQL ordered by Reads

%Total - Physical Reads as a percentage of Total Disk Reads
%CPU - CPU Time as a percentage of Elapsed Time
%IO - User I/O Time as a percentage of Elapsed Time
Total Disk Reads: 8,735
Captured SQL account for 90.7% of Total

Physical Reads	Executions	Reads per Exec	%Total	Elapsed Time (s)	%CPU	%IO	SQL Id	SQL Module	SQL Text
2,850	1	2,850.00	32.63	8.58	4.73	97.16	f0f3ch6j2msvm	JDBC Thin Client	SELECT A.DISPLAY_TIME DISPLAY_...
2,457	75	32.76	28.13	5.26	18.75	83.01	43zjc5653gyk5	JDBC Thin Client	SELECT CEIL(COUNT(1)/NULLIF(:B...
2,457	75	32.76	28.13	5.32	19.96	82.03	8yz9twtn06qtg	JDBC Thin Client	BEGIN SP_ORIGINAL_DATA_INVERTE...
1,291	1	1,291.00	14.78	1.06	9.37	93.97	gtkz6vhsmthkr	PL/SQL Developer	select * from t_generated_powe...
679	2	339.50	7.77	12.70	89.10	7.90	c8khjbn635s3c	plsqldev.exe	��D�֣��\�}��͒֏��\��ɢɪ��[��G...
438	1	438.00	5.01	9.86	86.63	5.49	d335gcvnz7q9a	sqlplus@localhost.localdomain (TNS V1-V3)	SELECT output FROM TABLE (dbms...
183	254	0.72	2.10	6.79	92.01	7.95	2y05nb0r4m01g	JDBC Thin Client	SELECT SUM(B.FEED_IN_POWER) FE...
32	60	0.53	0.37	1.52	99.73	1.28	6gvch1xu9ca3g		��Q�磿�U��ǣ��ꣿ��ͮ�b�}��У��b...
27	1,368	0.02	0.31	34.96	99.71	0.15	d4hud7mhyjfbn	JDBC Thin Client	BEGIN SP_T_GENERATED_POWER_DAT...
13	19	0.68	0.15	5.26	98.76	1.17	fsrpg0kmrtfzu	JDBC Thin Client	SELECT TO_CHAR(A.DISPLAY_TIME,...

Back to SQL Statistics
Back to Top

SQL ordered by Physical Reads (UnOptimized)

UnOptimized Read Reqs = Physical Read Reqts - Optimized Read Reqs
%Opt - Optimized Reads as percentage of SQL Read Requests
%Total - UnOptimized Read Reqs as a percentage of Total UnOptimized Read Reqs
Total Physical Read Requests: 8,552
Captured SQL account for 33.9% of Total
Total UnOptimized Read Requests: 8,552
Captured SQL account for 33.9% of Total
Total Optimized Read Requests: 1
Captured SQL account for 0.0% of Total

UnOptimized Read Reqs	Physical Read Reqs	Executions	UnOptimized Reqs per Exec	%Opt	%Total	SQL Id	SQL Module	SQL Text
2,457	2,457	75	32.76	0.00	28.73	43zjc5653gyk5	JDBC Thin Client	SELECT CEIL(COUNT(1)/NULLIF(:B...
2,457	2,457	75	32.76	0.00	28.73	8yz9twtn06qtg	JDBC Thin Client	BEGIN SP_ORIGINAL_DATA_INVERTE...
428	428	1	428.00	0.00	5.00	d335gcvnz7q9a	sqlplus@localhost.localdomain (TNS V1-V3)	SELECT output FROM TABLE (dbms...
80	80	88	0.91	0.00	0.94	49s332uhbnsma		��ё`�i��V��㠑��H��O�Ԩ...
44	44	60	0.73	0.00	0.51	6gvch1xu9ca3g		��Q�磿�U��ǣ��ꣿ��ͮ�b�}��У��b...
13	13	19	0.68	0.00	0.15	fsrpg0kmrtfzu	JDBC Thin Client	SELECT TO_CHAR(A.DISPLAY_TIME,...
0	0	48,648	0.00		0.00	04r0dd9ht24av	JDBC Thin Client	SELECT TRUNC(:B1 )+(TRUNC((TO_...
0	0	13,036	0.00		0.00	07dbvfqrb5fzn	JDBC Thin Client	INSERT INTO T_PROTOCOL_DATA (I...
0	0	340	0.00		0.00	089dbukv1aanh	EM_PING	ئ��L��磿¼��L�ң��f��ٻ��y��
0	0	189	0.00		0.00	08bqjmf8490s2	SEVERITY EVALUATION	ئ��裿��y��棿��c��磿�Є�...

Back to SQL Statistics
Back to Top

SQL ordered by Executions

%CPU - CPU Time as a percentage of Elapsed Time
%IO - User I/O Time as a percentage of Elapsed Time
Total Executions: 410,560
Captured SQL account for 60.7% of Total

Executions	Rows Processed	Rows per Exec	Elapsed Time (s)	%CPU	SQL Id	SQL Module	SQL Text
48,648	48,648	1.00	1.65	90.52	04r0dd9ht24av	JDBC Thin Client	SELECT TRUNC(:B1 )+(TRUNC((TO_...
16,141	16,140	1.00	0.62	85.09	8xpzjbbvuqx2z	JDBC Thin Client	ئ��c��߼��H�֏��ٵ��߼��...
13,914	13,914	1.00	0.50	94.47	8gdh70znps4y2	JDBC Thin Client	ئ��ǣ��λ��c��܅Џ��
13,914	13,914	1.00	2.29	98.56	91f6v8c3dg57k	JDBC Thin Client	SELECT SF_TIME_ZONE_TO_NUMBER(...
13,864	13,864	1.00	0.57	90.69	0kbtn4wjprtnz	JDBC Thin Client	SELECT TRUNC(:B1 )+(TRUNC((TO_...
13,358	13,358	1.00	1.71	74.03	agdnmg75n2p76	JDBC Thin Client	INSERT INTO T_PROTOCOL_DATA_OT...
13,041	13,041	1.00	0.79	77.50	9rugrgks907mp	JDBC Thin Client	SELECT COUNT(1) FROM T_INVERTE...
13,036	13,036	1.00	1.62	79.16	07dbvfqrb5fzn	JDBC Thin Client	INSERT INTO T_PROTOCOL_DATA (I...
12,968	12,968	1.00	1.39	71.42	1g24uwkv0nmc5	JDBC Thin Client	INSERT INTO T_GENERATED_POWER_...
12,968	12,968	1.00	1.42	63.42	bwfb6assstav1	JDBC Thin Client	UPDATE SYS_TABLE SET T_ID=:B1 ...
12,549	12,549	1.00	0.87	78.10	4xtk7vpt7phmk	JDBC Thin Client	UPDATE T_EVENT_NEWEST SET END_...
12,134	12,134	1.00	0.99	68.57	b0z3an9610nfs	JDBC Thin Client	UPDATE T_INVERTER SET INVERTER...
10,302	10,302	1.00	0.85	85.99	0k76nxtsksvy2	JDBC Thin Client	UPDATE T_POWER_DATA_NEWEST SET...
10,302	10,302	1.00	0.87	68.95	8vskf8pmvgty4	JDBC Thin Client	UPDATE T_DISPLAY_POWER_DATA SE...
7,428	62,069	8.36	1.40	99.36	cm5vu20fhtnq1		��D�� ��P��]�D��D�Y�ᕐ̶��...
7,427	0	0.00	6.90	92.53	az33m61ym46y4	JDBC Thin Client	ئ��D��b��I�ã����ś��...

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

Total Parse Calls: 64,938
Captured SQL account for 44.0% of Total

Parse Calls	Executions	% Total Parses	SQL Id	SQL Module	SQL Text
7,428	7,428	11.44	cm5vu20fhtnq1		��D�� ��P��]�D��D�Y�ᕐ̶��...
7,409	7,427	11.41	az33m61ym46y4	JDBC Thin Client	ئ��D��b��I�ã����ś��...
2,101	2,101	3.24	4m7m0t6fjcs5x		��_��Ԕ��b��ˮ�Ɯ��[�ԣ��³��[�ԣ��ْє�...
1,464	1,464	2.25	0k8522rmdzg4k		��D�֣��]�D��̶��㼬��Ô}��ĵ��꽑]��...
1,397	1,397	2.15	0ws7ahf1d78qa		��D�֣��L��ͅ��ף��j��f��h߲��ǣ��֣�...
1,397	1,397	2.15	459f3z9u4fb3u		��D�֣��[�ԣ��̶��Ô}��ţ��ͣ��U��
1,396	1,396	2.15	4vs91dcv7u1p6	JDBC Thin Client	��Į�G��㼓~��A�J��ᔯ��B�b��I��...
1,396	1,396	2.15	5ur69atw3vfhj		��D�֣�ɢ��ΘH��H�᣿��룿��ܣ��...
524	524	0.81	grwydz59pu6mc		select text from view$ where r...
519	519	0.80	8fr0psqvxzjsj	JDBC Thin Client	SELECT SUM(B.FEED_IN_POWER) FE...

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

Only Statements with Sharable Memory greater than 1048576 are displayed

Sharable Mem (b)	Executions	% Total	SQL Id	SQL Module	SQL Text
4,076,571	2	0.41	c8khjbn635s3c	plsqldev.exe	��D�֣��\�}��͒֏��\��ɢɪ��[��G...
3,910,259	2	0.40	c8khjbn635s3c	plsqldev.exe	��D�֣��\�}��͒֏��\��ɢɪ��[��G...
3,359,986	1	0.34	6wm3n4d7bnddg		��̣�� 񪗣��ɢ�e��଒��M�}...
3,347,098	3	0.34	ab3swhv5g138y		��D�֣��ң��Э��\|�ǣ��v��J��ǧ��...
1,633,616	15	0.17	bn4b3vjw2mj3u		ئ��ң��ң��P��룿�\|...
1,526,614	166	0.15	cw9mjyypvma13	JDBC Thin Client	SELECT CASE WHEN NVL(A.INVERTE...
1,470,579	1	0.15	gjm43un5cy843		ئ��ئ��օͣ��y��ͣ��֣��r��...
1,389,999	2	0.14	69k5bhm12sz98		SELECT dbin.instance_number, d...
1,163,294	8	0.12	6thhhy0du9r98	JDBC Thin Client	update T_USER set LOGIN_NAME=:...

Back to SQL Statistics
Back to Top

SQL ordered by Version Count

Only Statements with Version Count greater than 20 are displayed

Version Count	Executions	SQL Id	SQL Module	SQL Text
34	166	cw9mjyypvma13	JDBC Thin Client	SELECT CASE WHEN NVL(A.INVERTE...
34	166	cw9mjyypvma13	JDBC Thin Client	SELECT CASE WHEN NVL(A.INVERTE...
29	2	69k5bhm12sz98		SELECT dbin.instance_number, d...
29	8	6thhhy0du9r98	JDBC Thin Client	update T_USER set LOGIN_NAME=:...
28	6	fcb5u7n0r523m		ئ��᣿�l��f��ҵͣ��H��ԣ��...
28	6	fcb5u7n0r523m		ئ��᣿�l��f��ҵͣ��H��ԣ��...
27	135	18naypzfmabd6	EM_PING	��ئ�ޣ��Ǵ��L�У��s�֣��ˣ��͏��...
24	1	5s34t44u10q4g		SELECT a.name task_name, nvl(e...
23	5	7gzxf61vj6wq4		SELECT ID FROM SYS.WRI$_ADV_TA...
22	1	6wm3n4d7bnddg		��̣�� 񪗣��ɢ�e��଒��M�}...
22	1	7wwd9zjbvggmh		INSERT INTO SYS.WRI$_ADV_TASKS...
22	35	b2gnxm5z6r51n		�K�У��D��N��Y��}��˯�N
22	169	g00cj285jmgsw		��흙�g��ì��ì��⬣��b��...
21	169	350f5yrnnmshs		�K�У��D��흙�g��Ѯ��P�}䴓��X
21	98	3c1kubcdjnppq		��_��鬟�à��鬟�à�...
21	1	akh9zqqkx3wj7		��D�֣��³b�B��̶���U�T��֪͒e��Š��a�e�B��...

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL Id SQL Text

04r0dd9ht24av SELECT TRUNC(:B1 )+(TRUNC((TO_NUMBER(TO_CHAR(:B1 , 'HH24'))*60+TO_NUMBER(TO_CHAR(:B1 , 'MI')))/15))*15/(24*60) FROM DUAL

07dbvfqrb5fzn INSERT INTO T_PROTOCOL_DATA (ID, PROTOCOL_ID, ETU_ID, INVERTER_ID, INVERTER_LID, DATA_CONTENT, SEND_TIME, RECEIVE_TIME, ELAPSE_TIME, CREATE_TIME) VALUES (SEQ_T_PROTOCOL_DATA.NEXTVAL, 4, :B8 , :B7 , :B6 , :B5 , :B4 , :B3 , :B2 -:B1 , SYSDATE)

089dbukv1aanh ئ��L��磿¼��L�ң��f��ٻ��y��

08bqjmf8490s2 ئ��裿��y��棿��c��磿�Є��U��

0k76nxtsksvy2 UPDATE T_POWER_DATA_NEWEST SET ID=:B21 , SEND_TIME=:B20 , CURRENT_TIME=:B19 , RECEIVE_TIME=:B18 , AREA_TIME=:B17 , PV_VOLTAGE=:B16 , PV_CURRENT=:B15 , CURRENT_POWER=CASE WHEN :B14 =0 THEN CURRENT_POWER ELSE (CURRENT_POWER*INVERTER_NUM+NVL(:B14 , 0))/(INVERTER_NUM+1) END, INVERTER_NUM=CASE WHEN :B14 =0 THEN INVERTER_NUM ELSE INVERTER_NUM+1 END, BASIC_ENERGY=:B12 , CURRENT_ENERGY=CASE WHEN :B11 =3 THEN CURRENT_ENERGY ELSE :B10 END, TODAY_ENERGY=CASE WHEN :B13 =0 THEN CASE WHEN :B11 =2 OR :B11 =3 THEN TODAY_ENERGY ELSE :B10 +:B12 END ELSE :B10 END, TOTAL_ENERGY_LIFE=CASE WHEN :B11 =1 THEN TOTAL_ENERGY_LIFE+:B10 WHEN :B11 =2 OR :B11 =3 THEN TOTAL_ENERGY_LIFE ELSE TOTAL_ENERGY_LIFE+:B10 -:B9 END, CHASSIS_TEMPERATURE=:B8 , GRID_VOLTAGE=:B7 , FEED_IN_CURRENT=:B6 , GRID_FREQUENCY=:B5 , POPULATION_STAMP=SYSDATE WHERE USER_ID=:B4 AND SITE_ID=:B3 AND ETU_ID=:B2 AND INVERTER_ID=:B1

0k8522rmdzg4k ��D�֣��]�D��̶��㼬��Ô}��ĵ��꽑]��]��P�H��

0kbtn4wjprtnz SELECT TRUNC(:B1 )+(TRUNC((TO_NUMBER(TO_CHAR(:B1 , 'HH24'))*60+TO_NUMBER(TO_CHAR(:B1 , 'MI')))/5))*5/(24*60) FROM DUAL

0ws7ahf1d78qa ��D�֣��L��ͅ��ף��j��f��h߲��ǣ��֣�ئ�r�ԣ��¼���U��h߲��ǣ��֣�ئ�r�ԣ��f��L��ͅ��ף��n��҅��ˣ��[��f��Ż��ң��h߲��ǣ��֣�ئ�r�ԣ��λ��ɥ��̶��✯��}��Ô}��f��h߲��ǣ��֣�ئ�r�ԣ��f��

18naypzfmabd6 ��ئ�ޣ��Ǵ��L�У��s�֣��ˣ��͏��ܣ��Ά��ܣ�߲�օͣ��Ǐ��ۆ��L��У��߼����߼��f�٣��ͣ��f�٣��ͣ��f�٣��壿��ͣ��f�٣��ࣿ��

1bu5pxmd05bsu SELECT SUM(B.FEED_IN_POWER) FEED_IN_POWER, SUM(B.TODAY_ENERGY) TODAY_ENERGY, TO_CHAR(A.DISPLAY_TIME, 'YYYY-MM-DD HH24:MI:SS') DISPLAY_TIME FROM (SELECT DISPLAY_TIME FROM (SELECT :B2 +1-ROWNUM/288 DISPLAY_TIME FROM DUAL CONNECT BY LEVEL<=288) WHERE DISPLAY_TIME<:B1 ) A LEFT JOIN (SELECT A.DISPLAY_TIME, A.AREA_TIME, A.FEED_IN_POWER, A.TODAY_ENERGY FROM T_DISPLAY_POWER_DATA A WHERE A.USER_ID=:B5 AND A.SITE_ID=:B4 AND A.ETU_ID=:B3 AND A.AREA_TIME>=:B2 AND A.AREA_TIME<:B1 ) B ON B.AREA_TIME=A.DISPLAY_TIME GROUP BY A.DISPLAY_TIME ORDER BY A.DISPLAY_TIME

1g24uwkv0nmc5 INSERT INTO T_GENERATED_POWER_DATA (ID, SEND_TIME, AREA_TIME, RECEIVE_TIME, SOCKET_TIME, INVERTER_ID, USER_ID, SITE_ID, ETU_ID, PV_VOLTAGE, PV_CURRENT, FEED_IN_POWER, TODAY_ENERGY, CHASSIS_TEMPERATURE, GRID_VOLTAGE, FEED_IN_CURRENT, GRID_FREQUENCY, ENERGY_DATA_TYPE, POPULATION_STAMP) VALUES (:B18 , :B17 , :B16 , :B15 , :B14 , :B13 , :B12 , :B11 , :B10 , :B9 , :B8 , :B7 , :B6 , :B5 , :B4 , :B3 , :B2 , :B1 , SYSDATE)

2y05nb0r4m01g SELECT SUM(B.FEED_IN_POWER) FEED_IN_POWER, SUM(B.TODAY_ENERGY) TODAY_ENERGY, TO_CHAR(A.DISPLAY_TIME, 'YYYY-MM-DD HH24:MI:SS') DISPLAY_TIME FROM (SELECT DISPLAY_TIME FROM (SELECT :B2 +1-ROWNUM/288 DISPLAY_TIME FROM DUAL CONNECT BY LEVEL<=288) WHERE DISPLAY_TIME<=:B1 ) A LEFT JOIN (SELECT A.DISPLAY_TIME, A.AREA_TIME, A.FEED_IN_POWER, A.TODAY_ENERGY FROM T_DISPLAY_POWER_DATA A WHERE A.USER_ID=:B4 AND A.SITE_ID=:B3 AND A.AREA_TIME>=:B2 AND A.AREA_TIME<:B1 UNION ALL SELECT :B1 , :B1 , CASE WHEN ((NVL(B.INVERTER_LID, 0)>0 AND B.POPULATION_STAMP>=SYSDATE-10/24/60) OR (NVL(B.LAST_INVERTER_LID, 0)>0 AND NVL(B.LAST_NET_TIME, TO_DATE('1990-01-01', 'YYYY-MM-DD'))>=SYSDATE-10/24/60)) THEN CASE WHEN A.POPULATION_STAMP>=SYSDATE-10/24/60 THEN CASE WHEN A.CURRENT_POWER>0 THEN A.CURRENT_POWER ELSE CASE WHEN NVL(A.LAST_TIME, TO_DATE('1990-01-01', 'YYYY-MM-DD'))>=SYSDATE-10/24/60 AND NVL(A.LAST_POWER, 0)>0 THEN A.LAST_POWER ELSE 0 END END ELSE 0 END ELSE 0 END CURRENT_POWER, A.TODAY_ENERGY FROM T_POWER_DATA_NEWEST A JOIN T_INVERTER B ON B.USER_ID=A.USER_ID AND B.SITE_ID=A.SITE_ID AND B.ETU_ID=A.ETU_ID AND B.INVERTER_ID=A.INVERTER_ID WHERE A.USER_ID=:B4 AND A.SITE_ID=:B3 ) B ON B.AREA_TIME=A.DISPLAY_TIME GROUP BY A.DISPLAY_TIME ORDER BY A.DISPLAY_TIME

350f5yrnnmshs �K�У��D��흙�g��Ѯ��P�}䴓��X

3c1kubcdjnppq ��_��鬟�à��鬟�à��ғ��N�]��۱��飿��G��Ҟ��e��G��Ҟ��e��ɢ��ۣ��飿��G��Ҟ��e��G��Ҟ��e��ғ��N�]��۱��]��à��]��à��ɢ��ۣ��飿��鲽�à��鲽�à��ғ��N�]��۱��飿��H�à��H�à��ғ��N�]��۱��飿��I��ˣ��ţ��Š��ѣ��]��

43zjc5653gyk5 SELECT CEIL(COUNT(1)/NULLIF(:B4 , 0)) FROM T_PROTOCOL_DATA WHERE CREATE_TIME BETWEEN :B3 AND :B2 AND INVERTER_ID=:B1

459f3z9u4fb3u ��D�֣��[�ԣ��̶��Ô}��ţ��ͣ��U��

49s332uhbnsma ��ё`�i��V��㠑��H��O�Ԩ��e��Ť��`�]��л۰��ê��珲��珲��ʣ��e��ӳ�e��M��󣿮��ᬒ��珲��O��C�⬚��̣��B��e�y���s��B��e�y����C�⬚����n��

4m7m0t6fjcs5x ��_��Ԕ��b��ˮ�Ɯ��[�ԣ��³��[�ԣ��ْє��Δ��D��b�ã��Ħ�b��۪u��Ô}��ӣ�

4vs91dcv7u1p6 ��Į�G��㼓~��A�J��ᔯ��B�b��I��ˣ��ᮒ�×H�B��úƜ��T��ғ��ԒԔ��Ԝ��ţ��➽�P�H��꽑]��󣿲I�ã��󣿑\��g�T��⬪��g��K��ޣ��U��K��ޣ��M�N��K��ޢݔ��қʔ��b��`��锯��᪗�A�J��飿��B��ƘB��B�]�̣��f��B��ݣ��N�B��Ѣ�Ħ��V�N��h߲��߼��ۆ��h�f��ͣ��ˮ��ˮ��磿��أ��ƣ�ף��ˮ��

4xtk7vpt7phmk UPDATE T_EVENT_NEWEST SET END_TIME=:B5 WHERE USER_ID=:B4 AND SITE_ID=:B3 AND ETU_ID=:B2 AND INVERTER_ID=:B1

5s34t44u10q4g SELECT a.name task_name, nvl(e.status, a.status) status#, a.last_exec_name as last_execution, e.exec_type_id as execution_type# FROM wri$_adv_tasks a, wri$_adv_executions e WHERE a.id = e.task_id(+) and a.advisor_id = e.advisor_id(+) and a.last_exec_name = e.name(+) and a.id = :1

5ur69atw3vfhj ��D�֣�ɢ��ΘH��H�᣿��룿��ܣ��;ã��䣿��ئ��룿��ɢ��ΘH��Ï��ã��ئ׿��ɥ��ˮ��ئ��X�K�YĲ��C⬣��X�K�YĲ��۵\��ã��鹔��Š��\�}��

69k5bhm12sz98 SELECT dbin.instance_number, dbin.db_name, dbin.instance_name, dbin.host_name, dbin.version, CASE WHEN s1.startup_time = s2.startup_time THEN 0 ELSE 1 END as bounce, CAST(s1.end_interval_time AS DATE) as begin_time, CAST(s2.end_interval_time AS DATE) as end_time, ROUND((cast( (case when s2.end_interval_time > s1.end_interval_time then s2.end_interval_time else s1.end_interval_time end) as date) - cast(s1.end_interval_time as date)) * 86400) as int_secs, CASE WHEN (s1.status <> 0 OR s2.status <> 0) THEN 1 ELSE 0 END as err_detect, round( greatest( (extract(day from s2.flush_elapsed) * 86400) + (extract(hour from s2.flush_elapsed) * 3600) + (extract(minute from s2.flush_elapsed) * 60) + extract(second from s2.flush_elapsed), (extract(day from s1.flush_elapsed) * 86400) + (extract(hour from s1.flush_elapsed) * 3600) + (extract(minute from s1.flush_elapsed) * 60) + extract(second from s1.flush_elapsed), 0 )) as max_flush_secs FROM WRM$_SNAPSHOT s1 , WRM$_DATABASE_INSTANCE dbin , WRM$_SNAPSHOT s2 WHERE s1.dbid = :dbid AND s2.dbid = :dbid AND s1.instance_number = s2.instance_number AND dbin.instance_number = s1.instance_number AND s1.snap_id = :bid AND s2.snap_id = :eid AND dbin.dbid = s1.dbid AND dbin.startup_time = s1.startup_time and dbin.instance_number = :inst

6gvch1xu9ca3g ��Q�磿�U��ǣ��ꣿ��ͮ�b�}��У��b��R��ס��ǣ��F��Џ��y��b�}��ɪ��ʣ��磿��ئ��磿�룿��

6thhhy0du9r98 update T_USER set LOGIN_NAME=:1 , LOGIN_PWD=:2 , FIRST_NAME=:3 , MIDDLE_NAME=:4 , LAST_NAME=:5 , PRIMARY_LANGUAGE_ID=:6 , USER_LOCALE=:7 , USER_GENDER=:8 , USER_EMAIL=:9 , EMAIL_CONFIRMED=:10 , QQ_LOGIN_NAME=:11 , QQ_BINDING=:12 , MSN_LOGIN_NAME=:13 , MSN_CONNECT=:14 , LAST_LOGIN_IP=:15 , LAST_LOGIN_TIME=:16 , CREATE_BY_ID=:17 , CREATE_TIME=:18 , UPDATE_BY_ID=:19 , UPDATE_TIME=:20 , USER_STATUS=:21 , USER_LANGUAGE=:22 , USER_CITY=:23 , USER_TIMEZONE=:24 , COUNTRY_CODE=:25 , TIME_ZONE_ID=:26 , TIMEZONE_ID=:27 , EMAIL_CODE=:28 , POPULATION_STAMP=:29 , LOGIN_IP=:30 , LOGIN_TIME=:31 where USER_ID=:32

6wm3n4d7bnddg ��̣��񪗣��ɢ�e��଒��M�}��ɢ�e��e��ɢ⬣��Ñb�J��y��ئ��ࣿ�e�̣��a��H��ͮ�b�}�a��b��H��e��ɢ⬣��ɢ��H��ĵ��ࣿ�a��ĵ��H��a��y��磿��أ��H��͛³b��K��B��a��d�򝛲��λ��ǧ��d�W٢��У��磿��΂��c��B��ţ��B��ţ��W��䬲F��\�}��ǣ��磿��أ��΂��W��Ñb�J��ɥ��ئ��W��f��ͮ�b�}��ͼ�B��ʜ��ðV��ţ��a��b��e�S�I�}��λ��f��U��Ͱ��r��ؓ��B��B��B�]�̏��O��_��W��B��³��K�P��r��H��³��K�X�³��K��B��H��͡䣿�a��a��K��e��a��I��գ��ғ��ĵ��ࣿ�a��ĵ��K��B��e�K��B��λ��ǧ��d�W٢��У��ǧ��dر �y��{��c��B��ţ��B��ţ��B꽝��ţ��ЁU�ˣ��d�W٢��y��W��Ñb�J��ɥ��ئ��ֵ��K��У��ͼ�B��d��ʜ��ðV��ţ��a��b��e��I�}��λ��f��U��͔��r��ؓ��B��B��B�]�̏��O��_��W��B��ֵ��K��У��ͼ�B��ʜ��ðV��ţ��a��b��e�S�I�}��λ��f��U��Ͱ��r��ؓ��B��B��B�]�̏��O��_��W��B��H��͡룿�a��ǣ��G��b�}��ţ��H��e��ɢ⬣��e��Ñb�J�y��룿�e�K��B��λ��ئ��a��³b��[��I��e��a��ţ��y��ǰ��ף��c��W��ã��B��ت�ο��B��_��ͣ��ئ��e�̣��S�I��a��I��գ��䣿�a��ĵ��a��y��ͼ�B��ʜ��ðV��ţ��a��b��e�S�I�}��λ��f��U��Ͱ��r��ؓ��B��B��B�]�̏��O��_��W��B��S��r��I��գ��q��̣�ǧ��ɢ�e��ǧ��K��B��ǧ

7gzxf61vj6wq4 SELECT ID FROM SYS.WRI$_ADV_TASKS A WHERE A.NAME = :B3 AND BITAND(A.PROPERTY, :B2 ) = :B2 AND A.OWNER# = :B1

7wwd9zjbvggmh INSERT INTO SYS.WRI$_ADV_TASKS (ID, OWNER#, OWNER_NAME, NAME, DESCRIPTION, ADVISOR_ID, ADVISOR_NAME, CTIME, MTIME, PARENT_ID, PARENT_REC_ID, PROPERTY, VERSION, EXEC_START, EXEC_END, STATUS, STATUS_MSG_ID, PCT_COMPLETION_TIME, PROGRESS_METRIC, METRIC_UNITS, ACTIVITY_COUNTER, REC_COUNT, ERROR_MSG#, SOURCE, HOW_CREATED ) VALUES (:B11 , :B10 , :B9 , :B8 , :B7 , :B6 , :B5 , SYSDATE, SYSDATE, :B4 , 0, :B3 , PRVT_ADVISOR.GET_DB_VERSION, NULL, NULL, :B2 , 0, 0, 0, '', 0, 0, 0, '', :B1 )

8fr0psqvxzjsj SELECT SUM(B.FEED_IN_POWER) FEED_IN_POWER, SUM(B.TODAY_ENERGY) TODAY_ENERGY, TO_CHAR(A.DISPLAY_TIME, 'YYYY-MM-DD HH24:MI:SS') DISPLAY_TIME FROM (SELECT DISPLAY_TIME FROM (SELECT :B2 +1-ROWNUM/288 DISPLAY_TIME FROM DUAL CONNECT BY LEVEL<=288) WHERE DISPLAY_TIME<:B1 ) A LEFT JOIN (SELECT A.DISPLAY_TIME, A.AREA_TIME, A.FEED_IN_POWER, A.TODAY_ENERGY FROM T_DISPLAY_POWER_DATA A WHERE A.USER_ID=:B4 AND A.SITE_ID=:B3 AND A.AREA_TIME>=:B2 AND A.AREA_TIME<:B1 ) B ON B.AREA_TIME=A.DISPLAY_TIME GROUP BY A.DISPLAY_TIME ORDER BY A.DISPLAY_TIME

8gdh70znps4y2 ئ��ǣ��λ��c��܅Џ��

8vskf8pmvgty4 UPDATE T_DISPLAY_POWER_DATA SET ID=:B17 , AREA_TIME=:B1 , PV_VOLTAGE=:B16 , PV_CURRENT=:B15 , FEED_IN_POWER=CASE WHEN :B14 =0 THEN FEED_IN_POWER ELSE (FEED_IN_POWER*INVERTER_NUM+NVL(:B14 , 0))/(INVERTER_NUM+1) END, INVERTER_NUM=CASE WHEN :B14 =0 THEN INVERTER_NUM ELSE INVERTER_NUM+1 END, INCREASE_ENERGY=CASE WHEN :B12 =1 THEN INCREASE_ENERGY+:B11 WHEN :B12 =2 OR :B12 =3 THEN INCREASE_ENERGY ELSE INCREASE_ENERGY+:B11 -:B13 END, TODAY_ENERGY=CASE WHEN :B12 =2 OR :B12 =3 THEN TODAY_ENERGY ELSE :B11 +:B10 END, CHASSIS_TEMPERATURE=:B9 , GRID_VOLTAGE=:B8 , FEED_IN_CURRENT=:B7 , GRID_FREQUENCY=:B6 , POPULATION_STAMP=SYSDATE WHERE USER_ID=:B5 AND SITE_ID=:B4 AND ETU_ID=:B3 AND INVERTER_ID=:B2 AND AREA_TIME=:B1

8xpzjbbvuqx2z ئ��c��߼��H�֏��ٵ��߼��f�٣��ࣿ��飿�֏��ٵ��߼��f�٣��ࣿ��ر�ʣ��߼��ئ��١�[��f�٣��ࣿ��߼��١�[��f�٣��ࣿ��߼��ࣿ��f�٣��ࣿ��W��y��

8yz9twtn06qtg BEGIN SP_ORIGINAL_DATA_INVERTER(:1 , :2 , :3 , :4 , :5 , :6 ); END;

91f6v8c3dg57k SELECT SF_TIME_ZONE_TO_NUMBER(TIME_ZONE) FROM T_SITE WHERE SITE_ID=:B1

9ms5u855uytjm SELECT X.ETU_ID, B.LOGIN_NAME, X.CREATE_TIME, NVL(SUM(CASE WHEN ((NVL(A.INVERTER_LID, 0)>0 AND A.POPULATION_STAMP>=SYSDATE-10/24/60) OR (NVL(A.LAST_INVERTER_LID, 0)>0 AND NVL(A.LAST_NET_TIME, TO_DATE('1990-01-01', 'YYYY-MM-DD'))>=SYSDATE-10/24/60)) THEN CASE WHEN D.POPULATION_STAMP>=SYSDATE-10/24/60 THEN CASE WHEN D.CURRENT_POWER>0 THEN D.CURRENT_POWER ELSE CASE WHEN NVL(D.LAST_TIME, TO_DATE('1990-01-01', 'YYYY-MM-DD'))>=SYSDATE-10/24/60 AND NVL(D.LAST_POWER, 0)>0 THEN D.LAST_POWER ELSE 0 END END ELSE 0 END ELSE 0 END), 0) CURRENT_POWER, NVL(SUM(CASE WHEN (NVL(A.INVERTER_LID, 0)>0 AND A.POPULATION_STAMP>=SYSDATE-10/24/60 OR (NVL(A.LAST_INVERTER_LID, 0)>0 AND NVL(A.LAST_NET_TIME, TO_DATE('1990-01-01', 'YYYY-MM-DD'))>=SYSDATE-10/24/60)) THEN 1 ELSE 0 END), 0) REG_NUM, NVL(SUM(CASE WHEN (NVL(A.INVERTER_LID, 0)>0 AND A.POPULATION_STAMP>=SYSDATE-10/24/60 OR (NVL(A.LAST_INVERTER_LID, 0)>0 AND NVL(A.LAST_NET_TIME, TO_DATE('1990-01-01', 'YYYY-MM-DD'))>=SYSDATE-10/24/60)) THEN 1 ELSE 0 END), 0) ONLINE_NUM, X.TOTAL_REG_INVERTER FROM T_ETU X JOIN (SELECT USER_ID, LOGIN_NAME FROM T_USER WHERE USER_ID=:B1 ) B ON B.USER_ID=X.USER_ID LEFT JOIN T_INVERTER A ON A.USER_ID=X.USER_ID AND A.SITE_ID=X.SITE_ID AND A.ETU_ID=X.ETU_ID LEFT JOIN T_POWER_DATA_NEWEST D ON D.USER_ID=A.USER_ID AND D.SITE_ID=A.SITE_ID AND D.ETU_ID=A.ETU_ID AND D.INVERTER_ID=A.INVERTER_ID WHERE X.USER_ID=:B1 AND X.SITE_ID=:B2 GROUP BY X.ETU_ID, B.LOGIN_NAME, X.CREATE_TIME , X.TOTAL_REG_INVERTER ORDER BY 4 DESC, 1

9rugrgks907mp SELECT COUNT(1) FROM T_INVERTER WHERE ETU_ID=:B2 AND INVERTER_LID=:B1

ab3swhv5g138y ��D�֣��ң��Э��|�ǣ��v��J��ǧ��|��٢��ǧ��D�֣��ѣ��ͣ��ёa��Э��ɢ��ã��ɪǣ�ғ��۫B����I��ң��瞽�J�ײַ��ɢ��ܬ��⬣��룿��ғ��ʜ��ࣿ��J��ғ��Δ��ɢ��ã��Δ��窕�œ��D��I�N��ǧ��ݔ��_�h��ɢ��ǣ��B�]�̣��[��ʜ��ғ��N�]��畍��⬣��룿��|��٢��ɢ��ܬ��⬣��룿��ǧ��̶��Δ��ã��Q��壿��Δ��ã��ĵ��ݑb��a�}��B�]�̣��Ô}�瞽��ĵ��ӣ��N�]��Q�J�B�b��]��ã��룿��]��ã��ƣ��룿��ܬ��⬣��H��N�]��畍��⬣��룿��]��ɪǣ�ғ��ã��H��]��B�]�̲��M��᣿��ёa��M��᣿��۫A��B��e��_��H��]��ёa��D�֣��ѣ��̶��Δ��ã��ёa�e�磿��Š��N�Q�M��벣��]��b��a��D��b��a��D��瓩��L��}�M��]��L��}��v��e��٢��N�]��畍��⬣��룿 ��H��D�֣��ѣ��۫A��B��ɢ��ã��ɪǣ�ғ��۫B����I��ғ��N�]��⬣����N�\��ܞ��J�ײַ��ғ��N�]��Q�J�B�b��룿��ɢ��ǣ��B�]�̣��飿��ғ��N�]��⬣����Δ��ɢ��Δ��Δ��ܪ��œ��D��I�N��ɢ��ã��룿�{�Q�JD��ݔ��d��ɢ��ǣ��B�]�̣��[��ʜ��ɢ��ã��룿�飿��ɢ��ܬ��⬣��룿��G�ת��œ��D��D��D��ꣿ��G�ת��œ��D��꽑\��ɢ�_ⳣ��ѣ��ӣ��ғ��N�]��ⳣ��ã��룿ⳣ��꽑\��B��꽑\��B��ĵ��᣿��ɢ��⬣����ܞ��J�ײַ��J�ײַ��ғ��N�]��ⳣ��ã��룿�[��ݔ��d��ݔ��ɢ��⬣����ܪ��œ��D��I�N��œ��D��I�N��̶��Δ��ã��訔��ɪ�Q��ⳣ��œ��D��ꣿ��Š��ĵ��ӣ��ѣ��B�]�̣��Ô}��ѣ��ӣ��]��꽑\��B��ѣ��]��ʜ��}��N�]��Q�J�B�b��]��ã�� ƣ��룿��ܬ��⬣��H��N�]��⬣��룿��]��ɪǣ�ғ��ã��H��]��B�]�̲��M��᣿��ёa��M��᣿��۫A��B��e��_��H��]��ёa��D�֣��ѣ��̶��Δ��ã��ёa�e�ߣ��Š��N�Q�M��벣��]��؛K远��a��ã��J��[�᣿��ɢ�_��ӣ��ɪ�B�`ɪ��䣿��ĵ��룿��룿��̶��Δ��ã��F��✯��}��Š��N�]��⬣��룿��]��ã���룿��]��ã��ɪ�B�`ɪ��]��؛K远��a��H��D�֣��ѣ��룿��ܬ��ͮ�b�}��ĵ��ԡ��ðV��딄��룿��G�ת��œ��D��B�]�̣��Ô}��ã��飿��N�]��⬡䣿��N�]��⬣��룿��]��ܬ��ͮ�b�}��e��٢��J��[�᣿��ɢ�_�f��ӣ��Ĳ��ˣ��ɢ��ã��룿ˮ�壿��Ĳ��룿��룿��̶��Δ��ã��z��[�꬜��T��G��ԣ��G��ԣ��B�]�̣��Ô}߭��ӣ��ѣ��\�}��r�Ǐ��Ҳ�d�W٢��[�ԣ��\�}��Ĳ��ˣ��e��_��H��]��߭�b��ʜ��M��󣿮��᣿��e��٢��J��[�᣿��ɢ�_��ӣ��Ĳ��ˣ��Ĳ�� ɢ��ã��룿��F��[��딄��룿��G�ת��œ��D��K�L��b��A��}�裿��ѣ��ף��ѣ��ڣ��✯��}鮣��Ô}��ӣ��ѣ��\�}��r�Ǐ��Ҳ�d�W٢��[�ԣ��\�}��Ĳ��ˣ��e��_��H��]��b��ʜ��M��󣿮��᣿��K远��a��ң��J��ң��v��h��

agdnmg75n2p76 INSERT INTO T_PROTOCOL_DATA_OTHER (ID, PROTOCOL_ID, ETU_ID, INVERTER_ID, INVERTER_LID, DATA_CONTENT, SEND_TIME, RECEIVE_TIME, CREATE_TIME) VALUES (SEQ_T_PROTOCOL_DATA.NEXTVAL, 3, :B6 , :B5 , :B4 , :B3 , :B2 , :B1 , SYSDATE)

akh9zqqkx3wj7 ��D�֣��³b�B��̶���U�T��֪͒e��Š��a�e�B��எ�J��[�᪗�D�֡䣿�³b�B��̶���U�T��қʔ��e��Š��a�e�B��எ�J��[�᪗�D�֡壿�³b�B��̶���U�T�T��e��Š��a�e�B��எ�J��[�᪗�D�֣��³b�B��̶���U�T��ã��Ô}��H��ɢ�_��d��G�ײM��ꓻ��b�J��D��Ô}��

az33m61ym46y4 ئ��D��b��I�ã����ś��o��͒֏��\�}��D��\��o��͒֏��}��D��[�� ⥣��λ��H��ɢ��r��I�ã��ǧ��o��͒֏��\�}��壿��W��ɢɪ��H��裿��q������ś��D��\�i

b0z3an9610nfs UPDATE T_INVERTER SET INVERTER_LID=:B2 , POPULATION_STAMP=SYSDATE WHERE INVERTER_ID=:B1

b2gnxm5z6r51n �K�У��D��N��Y��}��˯�N

bn4b3vjw2mj3u ئ��ң��ң��P��룿�|�ǣ��f��룿��ɢ��f��飿��Â��ǧ��h��f��|��٢��ǧ��f��y��ɢ�_��ӣ��ң��۫A��B��ң��ɪǣ�ғ��ң��۫B����I�}��ң��畍�۪e��P��ܬ��e�f��ࣿ��J��N�Q��ɢ��窕�œ��D��I�N��[��ɢ��ã��¾��œ��D��I�N��[��Δ��Ƭd��ݔ��_�h��ғ��ʜ��룿��ǣ��B�]�̣��f��ғ��N�]��畍��⬣��룿��|��٢��ғ��N�]��Q�J�B�b��룿�飿�Z��B��ۣ҅��̶��Δ��ã��Q��壿��Δ��ã��ĵ��ꯣ��ݑb��a�}񤣿��✯��}��Š��꽑\��B��ѣ��]��b��a��D��b��a��D��瓩��L��}�M��]��L��}��v��e��٢��N�]��畍��⬣��룿��J��[�᣿��ɢ�_��ӣ��ёa��᣿��ɪǣ�ғ��۫B����I��ã��Q�J�B�b��ɢ��ã��룿��J�ײַ��N�Y��ғ��N�]��⬣����Δ��ɢ��Δ��Δ��Δ��Ƭd�� ɢ��ã��룿��Q�JD��ݔ��d��ғ��ʜ��룿��ǣ��B�]�̣��ɢ��ã��룿�飿��أ��ɢ��ܬ��⬣��룿��ǧ��B�]�̲��f��G�ת��œ��D��D��D��ꣿ��G�ת��œ��D��꽑\��ɢ�_ⳣ��ѣ��ӣ��ғ��N�]��ⳣ��ã��룿ⳣ��꽑\��B��꽑\��B��ĵ��᣿��ɢ��⬣����ܞ��J�ײַ��J�ײַ��ғ��N�]��ⳣ��ã��룿�[��ݔ��d��ݔ��ɢ��⬣����ܪ��œ��D��I�N��œ��D��I�N��̶��Δ��ã��訔��ɪ�Q��ⳣ��œ��D��ꣿ��Ô}ⳣ��꽑\��B��ѣ��B�]�̣��Ô}��ѣ��ӣ��]��꽑\��B��ѣ��]��؛K远��a��ã��룿��ǣ��B�]�̣��r��f��́W��룿��́W��ƣ��룿�֣��́W��Ż�P��H��W��P��룿��ң��ɾ��́W��H��]��Э��e��_��H��f��M��]��Э��ɢ�_߭��ӣ��G�ת��œ��D��۫A�� Ô}��ã��룿��ã��N�Y��ã��ۣ҅��e��_��H��ۣ҅��֣�ɾ��壿ˮ��ǧ��

bwfb6assstav1 UPDATE SYS_TABLE SET T_ID=:B1 , TIME_STAMP=SYSDATE WHERE TABLE_NAME='T_GENERATED_POWER_DATA' AND TABLE_INFO='T_GENERATED_POWER_DATA'

c8khjbn635s3c ��D�֣��\�}��͒֏��\��ɢɪ��[��G��Σ��H��ɢ��Š��I�ã��ɣ��I�ã��D��I�ã��ɢɪ��ţ��D��\�i�]��o��͒֏��}��n��Â��裿��ɥ��ˣ��

cm5vu20fhtnq1 ��D�֣����P��]�D��D�Y�ᕐ̶��㼬��ɢ�_��ĵ��J��P�H��]�D��B�`�_�F��ĵ��]�D��

cw9mjyypvma13 SELECT CASE WHEN NVL(A.INVERTER_LID, 0)>0 THEN A.INVERTER_LID ELSE 99 END , A.INVERTER_ID, CASE WHEN ((NVL(A.INVERTER_LID, 0)>0 AND A.POPULATION_STAMP>=SYSDATE-10/24/60) OR (NVL(A.LAST_INVERTER_LID, 0)>0 AND NVL(A.LAST_NET_TIME, TO_DATE('1990-01-01', 'YYYY-MM-DD'))>=SYSDATE-10/24/60)) THEN CASE WHEN C.POPULATION_STAMP>=SYSDATE-10/24/60 THEN CASE WHEN C.CURRENT_POWER>0 THEN C.CURRENT_POWER ELSE CASE WHEN NVL(C.LAST_TIME, TO_DATE('1990-01-01', 'YYYY-MM-DD'))>=SYSDATE-10/24/60 AND NVL(C.LAST_POWER, 0)>0 THEN C.LAST_POWER ELSE 0 END END ELSE 0 END ELSE 0 END CURRENT_POWER, CASE WHEN C.AREA_TIME >=TO_DATE(:B3 , 'YYYY-MM-DD') THEN C.TODAY_ENERGY ELSE 0 END TODAY_ENERGY, C.AREA_TIME, A.INVERTER_LID, B.INVERTER_TYPE_NAME, D.PANL_CONTENT, A.ALIAS_NAME, A.ETU_ID, CASE WHEN (NVL(A.INVERTER_LID, 0)=0 AND NVL(A.LAST_INVERTER_LID, 0)=0) OR (NVL(A.INVERTER_LID, 0)>0 AND A.POPULATION_STAMP<SYSDATE-10/24/60) THEN -1 ELSE CASE WHEN C.POPULATION_STAMP>=SYSDATE-10/24/60 THEN CASE WHEN C.CURRENT_POWER>0 THEN 1 ELSE CASE WHEN NVL(C.LAST_TIME, TO_DATE('1990-01-01', 'YYYY-MM-DD'))>=SYSDATE-10/24/60 AND NVL(C.LAST_POWER, 0)>0 THEN 1 ELSE 0 END END ELSE 0 END END FLAG FROM T_INVERTER A JOIN T_SITE X ON X.SITE_ID=A.SITE_ID AND X.USER_ID=A.USER_ID LEFT JOIN T_INVERTER_TYPE B ON B.INVERTER_TYPE_ID=A.INVERTER_TYPE_ID LEFT JOIN T_POWER_DATA_NEWEST C ON C.USER_ID=A.USER_ID AND C.SITE_ID=A.SITE_ID AND C.ETU_ID=A.ETU_ID AND C.INVERTER_ID=A.INVERTER_ID LEFT JOIN T_INVERTER_PANL D ON D.USER_ID=A.USER_ID AND D.SITE_ID=A.SITE_ID AND D.ETU_ID='empty' WHERE A.USER_ID=:B2 AND A.SITE_ID=:B1 ORDER BY 1, 2

d335gcvnz7q9a SELECT output FROM TABLE (dbms_workload_repository.awr_report_html (:DID, :INST_NUMBER, :BgnSnap, :EndSnap ) )

d4hud7mhyjfbn BEGIN SP_T_GENERATED_POWER_DATA_2(:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 ); END;

f0f3ch6j2msvm SELECT A.DISPLAY_TIME DISPLAY_TIME, B.FEED_IN_POWER FEED_IN_POWER FROM (SELECT TRUNC(:B1 )+1-ROWNUM/288 DISPLAY_TIME FROM DUAL CONNECT BY LEVEL<=288*7) A LEFT JOIN (SELECT AREA_TIME, SUM(FEED_IN_POWER) FEED_IN_POWER FROM T_DISPLAY_POWER_DATA WHERE USER_ID=:B3 AND SITE_ID=:B2 AND AREA_TIME>=TRUNC(:B1 )-1 GROUP BY AREA_TIME UNION ALL SELECT AREA_TIME, SUM(FEED_IN_POWER) FEED_IN_POWER FROM T_DISPLAY_POWER_DATA_WEEK WHERE USER_ID=:B3 AND SITE_ID=:B2 AND AREA_TIME>=TRUNC(:B1 )-6 GROUP BY AREA_TIME ) B ON B.AREA_TIME=A.DISPLAY_TIME ORDER BY 1

fcb5u7n0r523m ئ��᣿�l��f��ҵͣ��H��ԣ��L��H��H��λ��ۅh�f��棿��ǰ��У��棿��ǰ��r��ټ��U��͏��ң��h�`��ף��󣿁W��H��

fsrpg0kmrtfzu SELECT TO_CHAR(A.DISPLAY_TIME, 'YYYY-MM-DD HH24:MI:SS') DISPLAY_TIME, SUM(NVL(B.FEED_IN_POWER, C.FEED_IN_POWER)) FEED_IN_POWER FROM (SELECT DISPLAY_TIME FROM (SELECT :B4 +1-ROWNUM/96 DISPLAY_TIME FROM DUAL CONNECT BY LEVEL<=96) WHERE DISPLAY_TIME<=:B3 ) A LEFT JOIN (SELECT USER_ID, SITE_ID, ETU_ID, INVERTER_ID, SF_GET_TIME_FIFTEEN(AREA_TIME) AREA_TIME, SUM(FEED_IN_POWER)/NULLIF(SUM(CASE WHEN FEED_IN_POWER>0 THEN 1 ELSE 0 END), 0) FEED_IN_POWER FROM T_DISPLAY_POWER_DATA WHERE USER_ID=:B2 AND SITE_ID=:B1 AND AREA_TIME>=:B4 GROUP BY USER_ID, SITE_ID, ETU_ID, INVERTER_ID, SF_GET_TIME_FIFTEEN(AREA_TIME) ) B ON B.AREA_TIME=A.DISPLAY_TIME LEFT JOIN (SELECT A.USER_ID, A.SITE_ID, A.ETU_ID, A.INVERTER_ID, :B3 AREA_TIME, CASE WHEN ((NVL(B.INVERTER_LID, 0)>0 AND B.POPULATION_STAMP>=SYSDATE-10/24/60) OR (NVL(B.LAST_INVERTER_LID, 0)>0 AND NVL(B.LAST_NET_TIME, TO_DATE('1990-01-01', 'YYYY-MM-DD'))>=SYSDATE-10/24/60)) THEN CASE WHEN A.POPULATION_STAMP>=SYSDATE-10/24/60 THEN CASE WHEN A.CURRENT_POWER>0 THEN A.CURRENT_POWER ELSE CASE WHEN NVL(A.LAST_TIME, TO_DATE('1990-01-01', 'YYYY-MM-DD'))>=SYSDATE-10/24/60 AND NVL(A.LAST_POWER, 0)>0 THEN A.LAST_POWER ELSE 0 END END ELSE 0 END ELSE 0 END FEED_IN_POWER FROM T_POWER_DATA_NEWEST A JOIN T_INVERTER B ON B.USER_ID=A.USER_ID AND B.SITE_ID=A.SITE_ID AND B.ETU_ID=A.ETU_ID AND B.INVERTER_ID=A.INVERTER_ID WHERE A.USER_ID=:B2 AND A.SITE_ID=:B1 ) C ON C.USER_ID=B.USER_ID AND C.SITE_ID=B.SITE_ID AND C.ETU_ID=B .ETU_ID AND C.INVERTER_ID=B.INVERTER_ID AND C.AREA_TIME=A.DISPLAY_TIME GROUP BY A.DISPLAY_TIME ORDER BY A.DISPLAY_TIME

g00cj285jmgsw ��흙�g��ì��ì��⬣��b��b��᣿��壿��ã��ғ��N�]��⬣��ۣ��ۣ��⬣��ã��ۣ��ܔ��Ŝ��e��ܔ��Ŝ��e��ūB�\�u��I�}��Ô}��ӣ��P

gjm43un5cy843 ئ��ئ��օͣ��y��ͣ��֣��r��ѣ��ЅN��ئ��օͣ��λ��ئ��e��U��ЅN��y��ͣ��֣��r��ڣ��ѣ��˷�߽��λ��L��ͣ��L��ͣ��L��J��c��ͣ�٢�Äd��ئ�r�ԣ�ǧ��W��ͣ��ͣ��W��ϻ��߽��́W��y��މ��飿�룿�W��ͣ��ã��H��ܣ��r��e��e��r��ͣ��գ��΂��ͣ��͏��r��e��U��e��U��y��򣿅ͣ��

grwydz59pu6mc select text from view$ where rowid=:1

gtkz6vhsmthkr select * from t_generated_power_data where etu_id='12030097' and inverter_id='0003001213000069' order by id desc

SQL Id	SQL Text
04r0dd9ht24av	SELECT TRUNC(:B1 )+(TRUNC((TO_NUMBER(TO_CHAR(:B1 , 'HH24'))60+TO_NUMBER(TO_CHAR(:B1 , 'MI')))/15))15/(24*60) FROM DUAL
07dbvfqrb5fzn	INSERT INTO T_PROTOCOL_DATA (ID, PROTOCOL_ID, ETU_ID, INVERTER_ID, INVERTER_LID, DATA_CONTENT, SEND_TIME, RECEIVE_TIME, ELAPSE_TIME, CREATE_TIME) VALUES (SEQ_T_PROTOCOL_DATA.NEXTVAL, 4, :B8 , :B7 , :B6 , :B5 , :B4 , :B3 , :B2 -:B1 , SYSDATE)
089dbukv1aanh	ئ��L��磿¼��L�ң��f��ٻ��y��
08bqjmf8490s2	ئ��裿��y��棿��c��磿�Є��U��
0k76nxtsksvy2	UPDATE T_POWER_DATA_NEWEST SET ID=:B21 , SEND_TIME=:B20 , CURRENT_TIME=:B19 , RECEIVE_TIME=:B18 , AREA_TIME=:B17 , PV_VOLTAGE=:B16 , PV_CURRENT=:B15 , CURRENT_POWER=CASE WHEN :B14 =0 THEN CURRENT_POWER ELSE (CURRENT_POWER*INVERTER_NUM+NVL(:B14 , 0))/(INVERTER_NUM+1) END, INVERTER_NUM=CASE WHEN :B14 =0 THEN INVERTER_NUM ELSE INVERTER_NUM+1 END, BASIC_ENERGY=:B12 , CURRENT_ENERGY=CASE WHEN :B11 =3 THEN CURRENT_ENERGY ELSE :B10 END, TODAY_ENERGY=CASE WHEN :B13 =0 THEN CASE WHEN :B11 =2 OR :B11 =3 THEN TODAY_ENERGY ELSE :B10 +:B12 END ELSE :B10 END, TOTAL_ENERGY_LIFE=CASE WHEN :B11 =1 THEN TOTAL_ENERGY_LIFE+:B10 WHEN :B11 =2 OR :B11 =3 THEN TOTAL_ENERGY_LIFE ELSE TOTAL_ENERGY_LIFE+:B10 -:B9 END, CHASSIS_TEMPERATURE=:B8 , GRID_VOLTAGE=:B7 , FEED_IN_CURRENT=:B6 , GRID_FREQUENCY=:B5 , POPULATION_STAMP=SYSDATE WHERE USER_ID=:B4 AND SITE_ID=:B3 AND ETU_ID=:B2 AND INVERTER_ID=:B1
0k8522rmdzg4k	��D�֣��]�D��̶��㼬��Ô}��ĵ��꽑]��]��P�H��
0kbtn4wjprtnz	SELECT TRUNC(:B1 )+(TRUNC((TO_NUMBER(TO_CHAR(:B1 , 'HH24'))60+TO_NUMBER(TO_CHAR(:B1 , 'MI')))/5))5/(24*60) FROM DUAL
0ws7ahf1d78qa	��D�֣��L��ͅ��ף��j��f��h߲��ǣ��֣�ئ�r�ԣ��¼���U��h߲��ǣ��֣�ئ�r�ԣ��f��L��ͅ��ף��n��҅��ˣ��[��f��Ż��ң��h߲��ǣ��֣�ئ�r�ԣ��λ��ɥ��̶��✯��}��Ô}��f��h߲��ǣ��֣�ئ�r�ԣ��f��
18naypzfmabd6	��ئ�ޣ��Ǵ��L�У��s�֣��ˣ��͏��ܣ��Ά��ܣ�߲�օͣ��Ǐ��ۆ��L��У��߼����߼��f�٣��ͣ��f�٣��ͣ��f�٣��壿��ͣ��f�٣��ࣿ��
1bu5pxmd05bsu	SELECT SUM(B.FEED_IN_POWER) FEED_IN_POWER, SUM(B.TODAY_ENERGY) TODAY_ENERGY, TO_CHAR(A.DISPLAY_TIME, 'YYYY-MM-DD HH24:MI:SS') DISPLAY_TIME FROM (SELECT DISPLAY_TIME FROM (SELECT :B2 +1-ROWNUM/288 DISPLAY_TIME FROM DUAL CONNECT BY LEVEL<=288) WHERE DISPLAY_TIME<:B1 ) A LEFT JOIN (SELECT A.DISPLAY_TIME, A.AREA_TIME, A.FEED_IN_POWER, A.TODAY_ENERGY FROM T_DISPLAY_POWER_DATA A WHERE A.USER_ID=:B5 AND A.SITE_ID=:B4 AND A.ETU_ID=:B3 AND A.AREA_TIME>=:B2 AND A.AREA_TIME<:B1 ) B ON B.AREA_TIME=A.DISPLAY_TIME GROUP BY A.DISPLAY_TIME ORDER BY A.DISPLAY_TIME
1g24uwkv0nmc5	INSERT INTO T_GENERATED_POWER_DATA (ID, SEND_TIME, AREA_TIME, RECEIVE_TIME, SOCKET_TIME, INVERTER_ID, USER_ID, SITE_ID, ETU_ID, PV_VOLTAGE, PV_CURRENT, FEED_IN_POWER, TODAY_ENERGY, CHASSIS_TEMPERATURE, GRID_VOLTAGE, FEED_IN_CURRENT, GRID_FREQUENCY, ENERGY_DATA_TYPE, POPULATION_STAMP) VALUES (:B18 , :B17 , :B16 , :B15 , :B14 , :B13 , :B12 , :B11 , :B10 , :B9 , :B8 , :B7 , :B6 , :B5 , :B4 , :B3 , :B2 , :B1 , SYSDATE)
2y05nb0r4m01g	SELECT SUM(B.FEED_IN_POWER) FEED_IN_POWER, SUM(B.TODAY_ENERGY) TODAY_ENERGY, TO_CHAR(A.DISPLAY_TIME, 'YYYY-MM-DD HH24:MI:SS') DISPLAY_TIME FROM (SELECT DISPLAY_TIME FROM (SELECT :B2 +1-ROWNUM/288 DISPLAY_TIME FROM DUAL CONNECT BY LEVEL<=288) WHERE DISPLAY_TIME<=:B1 ) A LEFT JOIN (SELECT A.DISPLAY_TIME, A.AREA_TIME, A.FEED_IN_POWER, A.TODAY_ENERGY FROM T_DISPLAY_POWER_DATA A WHERE A.USER_ID=:B4 AND A.SITE_ID=:B3 AND A.AREA_TIME>=:B2 AND A.AREA_TIME<:B1 UNION ALL SELECT :B1 , :B1 , CASE WHEN ((NVL(B.INVERTER_LID, 0)>0 AND B.POPULATION_STAMP>=SYSDATE-10/24/60) OR (NVL(B.LAST_INVERTER_LID, 0)>0 AND NVL(B.LAST_NET_TIME, TO_DATE('1990-01-01', 'YYYY-MM-DD'))>=SYSDATE-10/24/60)) THEN CASE WHEN A.POPULATION_STAMP>=SYSDATE-10/24/60 THEN CASE WHEN A.CURRENT_POWER>0 THEN A.CURRENT_POWER ELSE CASE WHEN NVL(A.LAST_TIME, TO_DATE('1990-01-01', 'YYYY-MM-DD'))>=SYSDATE-10/24/60 AND NVL(A.LAST_POWER, 0)>0 THEN A.LAST_POWER ELSE 0 END END ELSE 0 END ELSE 0 END CURRENT_POWER, A.TODAY_ENERGY FROM T_POWER_DATA_NEWEST A JOIN T_INVERTER B ON B.USER_ID=A.USER_ID AND B.SITE_ID=A.SITE_ID AND B.ETU_ID=A.ETU_ID AND B.INVERTER_ID=A.INVERTER_ID WHERE A.USER_ID=:B4 AND A.SITE_ID=:B3 ) B ON B.AREA_TIME=A.DISPLAY_TIME GROUP BY A.DISPLAY_TIME ORDER BY A.DISPLAY_TIME
350f5yrnnmshs	�K�У��D��흙�g��Ѯ��P�}䴓��X
3c1kubcdjnppq	��_��鬟�à��鬟�à��ғ��N�]��۱��飿��G��Ҟ��e��G��Ҟ��e��ɢ��ۣ��飿��G��Ҟ��e��G��Ҟ��e��ғ��N�]��۱��]��à��]��à��ɢ��ۣ��飿��鲽�à��鲽�à��ғ��N�]��۱��飿��H�à��H�à��ғ��N�]��۱��飿��I��ˣ��ţ��Š��ѣ��]��
43zjc5653gyk5	SELECT CEIL(COUNT(1)/NULLIF(:B4 , 0)) FROM T_PROTOCOL_DATA WHERE CREATE_TIME BETWEEN :B3 AND :B2 AND INVERTER_ID=:B1
459f3z9u4fb3u	��D�֣��[�ԣ��̶��Ô}��ţ��ͣ��U��
49s332uhbnsma	��ё`�i��V��㠑��H��O�Ԩ��e��Ť��`�]��л۰��ê��珲��珲��ʣ��e��ӳ�e��M��󣿮��ᬒ��珲��O��C�⬚��̣��B��e�y���s��B��e�y����C�⬚����n��
4m7m0t6fjcs5x	��_��Ԕ��b��ˮ�Ɯ��[�ԣ��³��[�ԣ��ْє��Δ��D��b�ã��Ħ�b��۪u��Ô}��ӣ�
4vs91dcv7u1p6	��Į�G��㼓~��A�J��ᔯ��B�b��I��ˣ��ᮒ�×H�B��úƜ��T��ғ��ԒԔ��Ԝ��ţ��➽�P�H��꽑]��󣿲I�ã��󣿑\��g�T��⬪��g��K��ޣ��U��K��ޣ��M�N��K��ޢݔ��қʔ��b��`��锯��᪗�A�J��飿��B��ƘB��B�]�̣��f��B��ݣ��N�B��Ѣ�Ħ��V�N��h߲��߼��ۆ��h�f��ͣ��ˮ��ˮ��磿��أ��ƣ�ף��ˮ��
4xtk7vpt7phmk	UPDATE T_EVENT_NEWEST SET END_TIME=:B5 WHERE USER_ID=:B4 AND SITE_ID=:B3 AND ETU_ID=:B2 AND INVERTER_ID=:B1
5s34t44u10q4g	SELECT a.name task_name, nvl(e.status, a.status) status#, a.last_exec_name as last_execution, e.exec_type_id as execution_type# FROM wri$_adv_tasks a, wri$_adv_executions e WHERE a.id = e.task_id(+) and a.advisor_id = e.advisor_id(+) and a.last_exec_name = e.name(+) and a.id = :1
5ur69atw3vfhj	��D�֣�ɢ��ΘH��H�᣿��룿��ܣ��;ã��䣿��ئ��룿��ɢ��ΘH��Ï��ã��ئ׿��ɥ��ˮ��ئ��X�K�YĲ��C⬣��X�K�YĲ��۵\��ã��鹔��Š��\�}��
69k5bhm12sz98	SELECT dbin.instance_number, dbin.db_name, dbin.instance_name, dbin.host_name, dbin.version, CASE WHEN s1.startup_time = s2.startup_time THEN 0 ELSE 1 END as bounce, CAST(s1.end_interval_time AS DATE) as begin_time, CAST(s2.end_interval_time AS DATE) as end_time, ROUND((cast( (case when s2.end_interval_time > s1.end_interval_time then s2.end_interval_time else s1.end_interval_time end) as date) - cast(s1.end_interval_time as date)) * 86400) as int_secs, CASE WHEN (s1.status <> 0 OR s2.status <> 0) THEN 1 ELSE 0 END as err_detect, round( greatest( (extract(day from s2.flush_elapsed) * 86400) + (extract(hour from s2.flush_elapsed) * 3600) + (extract(minute from s2.flush_elapsed) * 60) + extract(second from s2.flush_elapsed), (extract(day from s1.flush_elapsed) * 86400) + (extract(hour from s1.flush_elapsed) * 3600) + (extract(minute from s1.flush_elapsed) * 60) + extract(second from s1.flush_elapsed), 0 )) as max_flush_secs FROM WRM$_SNAPSHOT s1 , WRM$_DATABASE_INSTANCE dbin , WRM$_SNAPSHOT s2 WHERE s1.dbid = :dbid AND s2.dbid = :dbid AND s1.instance_number = s2.instance_number AND dbin.instance_number = s1.instance_number AND s1.snap_id = :bid AND s2.snap_id = :eid AND dbin.dbid = s1.dbid AND dbin.startup_time = s1.startup_time and dbin.instance_number = :inst
6gvch1xu9ca3g	��Q�磿�U��ǣ��ꣿ��ͮ�b�}��У��b��R��ס��ǣ��F��Џ��y��b�}��ɪ��ʣ��磿��ئ��磿�룿��
6thhhy0du9r98	update T_USER set LOGIN_NAME=:1 , LOGIN_PWD=:2 , FIRST_NAME=:3 , MIDDLE_NAME=:4 , LAST_NAME=:5 , PRIMARY_LANGUAGE_ID=:6 , USER_LOCALE=:7 , USER_GENDER=:8 , USER_EMAIL=:9 , EMAIL_CONFIRMED=:10 , QQ_LOGIN_NAME=:11 , QQ_BINDING=:12 , MSN_LOGIN_NAME=:13 , MSN_CONNECT=:14 , LAST_LOGIN_IP=:15 , LAST_LOGIN_TIME=:16 , CREATE_BY_ID=:17 , CREATE_TIME=:18 , UPDATE_BY_ID=:19 , UPDATE_TIME=:20 , USER_STATUS=:21 , USER_LANGUAGE=:22 , USER_CITY=:23 , USER_TIMEZONE=:24 , COUNTRY_CODE=:25 , TIME_ZONE_ID=:26 , TIMEZONE_ID=:27 , EMAIL_CODE=:28 , POPULATION_STAMP=:29 , LOGIN_IP=:30 , LOGIN_TIME=:31 where USER_ID=:32
6wm3n4d7bnddg	��̣��񪗣��ɢ�e��଒��M�}��ɢ�e��e��ɢ⬣��Ñb�J��y��ئ��ࣿ�e�̣��a��H��ͮ�b�}�a��b��H��e��ɢ⬣��ɢ��H��ĵ��ࣿ�a��ĵ��H��a��y��磿��أ��H��͛³b��K��B��a��d�򝛲��λ��ǧ��d�W٢��У��磿��΂��c��B��ţ��B��ţ��W��䬲F��\�}��ǣ��磿��أ��΂��W��Ñb�J��ɥ��ئ��W��f��ͮ�b�}��ͼ�B��ʜ��ðV��ţ��a��b��e�S�I�}��λ��f��U��Ͱ��r��ؓ��B��B��B�]�̏��O��_��W��B��³��K�P��r��H��³��K�X�³��K��B��H��͡䣿�a��a��K��e��a��I��գ��ғ��ĵ��ࣿ�a��ĵ��K��B��e�K��B��λ��ǧ��d�W٢��У��ǧ��dر �y��{��c��B��ţ��B��ţ��B꽝��ţ��ЁU�ˣ��d�W٢��y��W��Ñb�J��ɥ��ئ��ֵ��K��У��ͼ�B��d��ʜ��ðV��ţ��a��b��e��I�}��λ��f��U��͔��r��ؓ��B��B��B�]�̏��O��_��W��B��ֵ��K��У��ͼ�B��ʜ��ðV��ţ��a��b��e�S�I�}��λ��f��U��Ͱ��r��ؓ��B��B��B�]�̏��O��_��W��B��H��͡룿�a��ǣ��G��b�}��ţ��H��e��ɢ⬣��e��Ñb�J�y��룿�e�K��B��λ��ئ��a��³b��[��I��e��a��ţ��y��ǰ��ף��c��W��ã��B��ت�ο��B��_��ͣ��ئ��e�̣��S�I��a��I��գ��䣿�a��ĵ��a��y��ͼ�B��ʜ��ðV��ţ��a��b��e�S�I�}��λ��f��U��Ͱ��r��ؓ��B��B��B�]�̏��O��_��W��B��S��r��I��գ��q��̣�ǧ��ɢ�e��ǧ��K��B��ǧ
7gzxf61vj6wq4	SELECT ID FROM SYS.WRI$_ADV_TASKS A WHERE A.NAME = :B3 AND BITAND(A.PROPERTY, :B2 ) = :B2 AND A.OWNER# = :B1
7wwd9zjbvggmh	INSERT INTO SYS.WRI$_ADV_TASKS (ID, OWNER#, OWNER_NAME, NAME, DESCRIPTION, ADVISOR_ID, ADVISOR_NAME, CTIME, MTIME, PARENT_ID, PARENT_REC_ID, PROPERTY, VERSION, EXEC_START, EXEC_END, STATUS, STATUS_MSG_ID, PCT_COMPLETION_TIME, PROGRESS_METRIC, METRIC_UNITS, ACTIVITY_COUNTER, REC_COUNT, ERROR_MSG#, SOURCE, HOW_CREATED ) VALUES (:B11 , :B10 , :B9 , :B8 , :B7 , :B6 , :B5 , SYSDATE, SYSDATE, :B4 , 0, :B3 , PRVT_ADVISOR.GET_DB_VERSION, NULL, NULL, :B2 , 0, 0, 0, '', 0, 0, 0, '', :B1 )
8fr0psqvxzjsj	SELECT SUM(B.FEED_IN_POWER) FEED_IN_POWER, SUM(B.TODAY_ENERGY) TODAY_ENERGY, TO_CHAR(A.DISPLAY_TIME, 'YYYY-MM-DD HH24:MI:SS') DISPLAY_TIME FROM (SELECT DISPLAY_TIME FROM (SELECT :B2 +1-ROWNUM/288 DISPLAY_TIME FROM DUAL CONNECT BY LEVEL<=288) WHERE DISPLAY_TIME<:B1 ) A LEFT JOIN (SELECT A.DISPLAY_TIME, A.AREA_TIME, A.FEED_IN_POWER, A.TODAY_ENERGY FROM T_DISPLAY_POWER_DATA A WHERE A.USER_ID=:B4 AND A.SITE_ID=:B3 AND A.AREA_TIME>=:B2 AND A.AREA_TIME<:B1 ) B ON B.AREA_TIME=A.DISPLAY_TIME GROUP BY A.DISPLAY_TIME ORDER BY A.DISPLAY_TIME
8gdh70znps4y2	ئ��ǣ��λ��c��܅Џ��
8vskf8pmvgty4	UPDATE T_DISPLAY_POWER_DATA SET ID=:B17 , AREA_TIME=:B1 , PV_VOLTAGE=:B16 , PV_CURRENT=:B15 , FEED_IN_POWER=CASE WHEN :B14 =0 THEN FEED_IN_POWER ELSE (FEED_IN_POWER*INVERTER_NUM+NVL(:B14 , 0))/(INVERTER_NUM+1) END, INVERTER_NUM=CASE WHEN :B14 =0 THEN INVERTER_NUM ELSE INVERTER_NUM+1 END, INCREASE_ENERGY=CASE WHEN :B12 =1 THEN INCREASE_ENERGY+:B11 WHEN :B12 =2 OR :B12 =3 THEN INCREASE_ENERGY ELSE INCREASE_ENERGY+:B11 -:B13 END, TODAY_ENERGY=CASE WHEN :B12 =2 OR :B12 =3 THEN TODAY_ENERGY ELSE :B11 +:B10 END, CHASSIS_TEMPERATURE=:B9 , GRID_VOLTAGE=:B8 , FEED_IN_CURRENT=:B7 , GRID_FREQUENCY=:B6 , POPULATION_STAMP=SYSDATE WHERE USER_ID=:B5 AND SITE_ID=:B4 AND ETU_ID=:B3 AND INVERTER_ID=:B2 AND AREA_TIME=:B1
8xpzjbbvuqx2z	ئ��c��߼��H�֏��ٵ��߼��f�٣��ࣿ��飿�֏��ٵ��߼��f�٣��ࣿ��ر�ʣ��߼��ئ��١�[��f�٣��ࣿ��߼��١�[��f�٣��ࣿ��߼��ࣿ��f�٣��ࣿ��W��y��
8yz9twtn06qtg	BEGIN SP_ORIGINAL_DATA_INVERTER(:1 , :2 , :3 , :4 , :5 , :6 ); END;
91f6v8c3dg57k	SELECT SF_TIME_ZONE_TO_NUMBER(TIME_ZONE) FROM T_SITE WHERE SITE_ID=:B1
9ms5u855uytjm	SELECT X.ETU_ID, B.LOGIN_NAME, X.CREATE_TIME, NVL(SUM(CASE WHEN ((NVL(A.INVERTER_LID, 0)>0 AND A.POPULATION_STAMP>=SYSDATE-10/24/60) OR (NVL(A.LAST_INVERTER_LID, 0)>0 AND NVL(A.LAST_NET_TIME, TO_DATE('1990-01-01', 'YYYY-MM-DD'))>=SYSDATE-10/24/60)) THEN CASE WHEN D.POPULATION_STAMP>=SYSDATE-10/24/60 THEN CASE WHEN D.CURRENT_POWER>0 THEN D.CURRENT_POWER ELSE CASE WHEN NVL(D.LAST_TIME, TO_DATE('1990-01-01', 'YYYY-MM-DD'))>=SYSDATE-10/24/60 AND NVL(D.LAST_POWER, 0)>0 THEN D.LAST_POWER ELSE 0 END END ELSE 0 END ELSE 0 END), 0) CURRENT_POWER, NVL(SUM(CASE WHEN (NVL(A.INVERTER_LID, 0)>0 AND A.POPULATION_STAMP>=SYSDATE-10/24/60 OR (NVL(A.LAST_INVERTER_LID, 0)>0 AND NVL(A.LAST_NET_TIME, TO_DATE('1990-01-01', 'YYYY-MM-DD'))>=SYSDATE-10/24/60)) THEN 1 ELSE 0 END), 0) REG_NUM, NVL(SUM(CASE WHEN (NVL(A.INVERTER_LID, 0)>0 AND A.POPULATION_STAMP>=SYSDATE-10/24/60 OR (NVL(A.LAST_INVERTER_LID, 0)>0 AND NVL(A.LAST_NET_TIME, TO_DATE('1990-01-01', 'YYYY-MM-DD'))>=SYSDATE-10/24/60)) THEN 1 ELSE 0 END), 0) ONLINE_NUM, X.TOTAL_REG_INVERTER FROM T_ETU X JOIN (SELECT USER_ID, LOGIN_NAME FROM T_USER WHERE USER_ID=:B1 ) B ON B.USER_ID=X.USER_ID LEFT JOIN T_INVERTER A ON A.USER_ID=X.USER_ID AND A.SITE_ID=X.SITE_ID AND A.ETU_ID=X.ETU_ID LEFT JOIN T_POWER_DATA_NEWEST D ON D.USER_ID=A.USER_ID AND D.SITE_ID=A.SITE_ID AND D.ETU_ID=A.ETU_ID AND D.INVERTER_ID=A.INVERTER_ID WHERE X.USER_ID=:B1 AND X.SITE_ID=:B2 GROUP BY X.ETU_ID, B.LOGIN_NAME, X.CREATE_TIME , X.TOTAL_REG_INVERTER ORDER BY 4 DESC, 1
9rugrgks907mp	SELECT COUNT(1) FROM T_INVERTER WHERE ETU_ID=:B2 AND INVERTER_LID=:B1
ab3swhv5g138y	��D�֣��ң��Э��\|�ǣ��v��J��ǧ��\|��٢��ǧ��D�֣��ѣ��ͣ��ёa��Э��ɢ��ã��ɪǣ�ғ��۫B����I��ң��瞽�J�ײַ��ɢ��ܬ��⬣��룿��ғ��ʜ��ࣿ��J��ғ��Δ��ɢ��ã��Δ��窕�œ��D��I�N��ǧ��ݔ��_�h��ɢ��ǣ��B�]�̣��[��ʜ��ғ��N�]��畍��⬣��룿��\|��٢��ɢ��ܬ��⬣��룿��ǧ��̶��Δ��ã��Q��壿��Δ��ã��ĵ��ݑb��a�}��B�]�̣��Ô}�瞽��ĵ��ӣ��N�]��Q�J�B�b��]��ã��룿��]��ã��ƣ��룿��ܬ��⬣��H��N�]��畍��⬣��룿��]��ɪǣ�ғ��ã��H��]��B�]�̲��M��᣿��ёa��M��᣿��۫A��B��e��_��H��]��ёa��D�֣��ѣ��̶��Δ��ã��ёa�e�磿��Š��N�Q�M��벣��]��b��a��D��b��a��D��瓩��L��}�M��]��L��}��v��e��٢��N�]��畍��⬣��룿 ��H��D�֣��ѣ��۫A��B��ɢ��ã��ɪǣ�ғ��۫B����I��ғ��N�]��⬣����N�\��ܞ��J�ײַ��ғ��N�]��Q�J�B�b��룿��ɢ��ǣ��B�]�̣��飿��ғ��N�]��⬣����Δ��ɢ��Δ��Δ��ܪ��œ��D��I�N��ɢ��ã��룿�{�Q�JD��ݔ��d��ɢ��ǣ��B�]�̣��[��ʜ��ɢ��ã��룿�飿��ɢ��ܬ��⬣��룿��G�ת��œ��D��D��D��ꣿ��G�ת��œ��D��꽑\��ɢ�_ⳣ��ѣ��ӣ��ғ��N�]��ⳣ��ã��룿ⳣ��꽑\��B��꽑\��B��ĵ��᣿��ɢ��⬣����ܞ��J�ײַ��J�ײַ��ғ��N�]��ⳣ��ã��룿�[��ݔ��d��ݔ��ɢ��⬣����ܪ��œ��D��I�N��œ��D��I�N��̶��Δ��ã��訔��ɪ�Q��ⳣ��œ��D��ꣿ��Š��ĵ��ӣ��ѣ��B�]�̣��Ô}��ѣ��ӣ��]��꽑\��B��ѣ��]��ʜ��}��N�]��Q�J�B�b��]��ã�� ƣ��룿��ܬ��⬣��H��N�]��⬣��룿��]��ɪǣ�ғ��ã��H��]��B�]�̲��M��᣿��ёa��M��᣿��۫A��B��e��_��H��]��ёa��D�֣��ѣ��̶��Δ��ã��ёa�e�ߣ��Š��N�Q�M��벣��]��؛K远��a��ã��J��[�᣿��ɢ�_��ӣ��ɪ�B�`ɪ��䣿��ĵ��룿��룿��̶��Δ��ã��F��✯��}��Š��N�]��⬣��룿��]��ã���룿��]��ã��ɪ�B�`ɪ��]��؛K远��a��H��D�֣��ѣ��룿��ܬ��ͮ�b�}��ĵ��ԡ��ðV��딄��룿��G�ת��œ��D��B�]�̣��Ô}��ã��飿��N�]��⬡䣿��N�]��⬣��룿��]��ܬ��ͮ�b�}��e��٢��J��[�᣿��ɢ�_�f��ӣ��Ĳ��ˣ��ɢ��ã��룿ˮ�壿��Ĳ��룿��룿��̶��Δ��ã��z��[�꬜��T��G��ԣ��G��ԣ��B�]�̣��Ô}߭��ӣ��ѣ��\�}��r�Ǐ��Ҳ�d�W٢��[�ԣ��\�}��Ĳ��ˣ��e��_��H��]��߭�b��ʜ��M��󣿮��᣿��e��٢��J��[�᣿��ɢ�_��ӣ��Ĳ��ˣ��Ĳ�� ɢ��ã��룿��F��[��딄��룿��G�ת��œ��D��K�L��b��A��}�裿��ѣ��ף��ѣ��ڣ��✯��}鮣��Ô}��ӣ��ѣ��\�}��r�Ǐ��Ҳ�d�W٢��[�ԣ��\�}��Ĳ��ˣ��e��_��H��]��b��ʜ��M��󣿮��᣿��K远��a��ң��J��ң��v��h��
agdnmg75n2p76	INSERT INTO T_PROTOCOL_DATA_OTHER (ID, PROTOCOL_ID, ETU_ID, INVERTER_ID, INVERTER_LID, DATA_CONTENT, SEND_TIME, RECEIVE_TIME, CREATE_TIME) VALUES (SEQ_T_PROTOCOL_DATA.NEXTVAL, 3, :B6 , :B5 , :B4 , :B3 , :B2 , :B1 , SYSDATE)
akh9zqqkx3wj7	��D�֣��³b�B��̶���U�T��֪͒e��Š��a�e�B��எ�J��[�᪗�D�֡䣿�³b�B��̶���U�T��қʔ��e��Š��a�e�B��எ�J��[�᪗�D�֡壿�³b�B��̶���U�T�T��e��Š��a�e�B��எ�J��[�᪗�D�֣��³b�B��̶���U�T��ã��Ô}��H��ɢ�_��d��G�ײM��ꓻ��b�J��D��Ô}��
az33m61ym46y4	ئ��D��b��I�ã����ś��o��͒֏��\�}��D��\��o��͒֏��}��D��[�� ⥣��λ��H��ɢ��r��I�ã��ǧ��o��͒֏��\�}��壿��W��ɢɪ��H��裿��q������ś��D��\�i
b0z3an9610nfs	UPDATE T_INVERTER SET INVERTER_LID=:B2 , POPULATION_STAMP=SYSDATE WHERE INVERTER_ID=:B1
b2gnxm5z6r51n	�K�У��D��N��Y��}��˯�N
bn4b3vjw2mj3u	ئ��ң��ң��P��룿�\|�ǣ��f��룿��ɢ��f��飿��Â��ǧ��h��f��\|��٢��ǧ��f��y��ɢ�_��ӣ��ң��۫A��B��ң��ɪǣ�ғ��ң��۫B����I�}��ң��畍�۪e��P��ܬ��e�f��ࣿ��J��N�Q��ɢ��窕�œ��D��I�N��[��ɢ��ã��¾��œ��D��I�N��[��Δ��Ƭd��ݔ��_�h��ғ��ʜ��룿��ǣ��B�]�̣��f��ғ��N�]��畍��⬣��룿��\|��٢��ғ��N�]��Q�J�B�b��룿�飿�Z��B��ۣ҅��̶��Δ��ã��Q��壿��Δ��ã��ĵ��ꯣ��ݑb��a�}񤣿��✯��}��Š��꽑\��B��ѣ��]��b��a��D��b��a��D��瓩��L��}�M��]��L��}��v��e��٢��N�]��畍��⬣��룿��J��[�᣿��ɢ�_��ӣ��ёa��᣿��ɪǣ�ғ��۫B����I��ã��Q�J�B�b��ɢ��ã��룿��J�ײַ��N�Y��ғ��N�]��⬣����Δ��ɢ��Δ��Δ��Δ��Ƭd�� ɢ��ã��룿��Q�JD��ݔ��d��ғ��ʜ��룿��ǣ��B�]�̣��ɢ��ã��룿�飿��أ��ɢ��ܬ��⬣��룿��ǧ��B�]�̲��f��G�ת��œ��D��D��D��ꣿ��G�ת��œ��D��꽑\��ɢ�_ⳣ��ѣ��ӣ��ғ��N�]��ⳣ��ã��룿ⳣ��꽑\��B��꽑\��B��ĵ��᣿��ɢ��⬣����ܞ��J�ײַ��J�ײַ��ғ��N�]��ⳣ��ã��룿�[��ݔ��d��ݔ��ɢ��⬣����ܪ��œ��D��I�N��œ��D��I�N��̶��Δ��ã��訔��ɪ�Q��ⳣ��œ��D��ꣿ��Ô}ⳣ��꽑\��B��ѣ��B�]�̣��Ô}��ѣ��ӣ��]��꽑\��B��ѣ��]��؛K远��a��ã��룿��ǣ��B�]�̣��r��f��́W��룿��́W��ƣ��룿�֣��́W��Ż�P��H��W��P��룿��ң��ɾ��́W��H��]��Э��e��_��H��f��M��]��Э��ɢ�_߭��ӣ��G�ת��œ��D��۫A�� Ô}��ã��룿��ã��N�Y��ã��ۣ҅��e��_��H��ۣ҅��֣�ɾ��壿ˮ��ǧ��
bwfb6assstav1	UPDATE SYS_TABLE SET T_ID=:B1 , TIME_STAMP=SYSDATE WHERE TABLE_NAME='T_GENERATED_POWER_DATA' AND TABLE_INFO='T_GENERATED_POWER_DATA'
c8khjbn635s3c	��D�֣��\�}��͒֏��\��ɢɪ��[��G��Σ��H��ɢ��Š��I�ã��ɣ��I�ã��D��I�ã��ɢɪ��ţ��D��\�i�]��o��͒֏��}��n��Â��裿��ɥ��ˣ��
cm5vu20fhtnq1	��D�֣����P��]�D��D�Y�ᕐ̶��㼬��ɢ�_��ĵ��J��P�H��]�D��B�`�_�F��ĵ��]�D��
cw9mjyypvma13	SELECT CASE WHEN NVL(A.INVERTER_LID, 0)>0 THEN A.INVERTER_LID ELSE 99 END , A.INVERTER_ID, CASE WHEN ((NVL(A.INVERTER_LID, 0)>0 AND A.POPULATION_STAMP>=SYSDATE-10/24/60) OR (NVL(A.LAST_INVERTER_LID, 0)>0 AND NVL(A.LAST_NET_TIME, TO_DATE('1990-01-01', 'YYYY-MM-DD'))>=SYSDATE-10/24/60)) THEN CASE WHEN C.POPULATION_STAMP>=SYSDATE-10/24/60 THEN CASE WHEN C.CURRENT_POWER>0 THEN C.CURRENT_POWER ELSE CASE WHEN NVL(C.LAST_TIME, TO_DATE('1990-01-01', 'YYYY-MM-DD'))>=SYSDATE-10/24/60 AND NVL(C.LAST_POWER, 0)>0 THEN C.LAST_POWER ELSE 0 END END ELSE 0 END ELSE 0 END CURRENT_POWER, CASE WHEN C.AREA_TIME >=TO_DATE(:B3 , 'YYYY-MM-DD') THEN C.TODAY_ENERGY ELSE 0 END TODAY_ENERGY, C.AREA_TIME, A.INVERTER_LID, B.INVERTER_TYPE_NAME, D.PANL_CONTENT, A.ALIAS_NAME, A.ETU_ID, CASE WHEN (NVL(A.INVERTER_LID, 0)=0 AND NVL(A.LAST_INVERTER_LID, 0)=0) OR (NVL(A.INVERTER_LID, 0)>0 AND A.POPULATION_STAMP<SYSDATE-10/24/60) THEN -1 ELSE CASE WHEN C.POPULATION_STAMP>=SYSDATE-10/24/60 THEN CASE WHEN C.CURRENT_POWER>0 THEN 1 ELSE CASE WHEN NVL(C.LAST_TIME, TO_DATE('1990-01-01', 'YYYY-MM-DD'))>=SYSDATE-10/24/60 AND NVL(C.LAST_POWER, 0)>0 THEN 1 ELSE 0 END END ELSE 0 END END FLAG FROM T_INVERTER A JOIN T_SITE X ON X.SITE_ID=A.SITE_ID AND X.USER_ID=A.USER_ID LEFT JOIN T_INVERTER_TYPE B ON B.INVERTER_TYPE_ID=A.INVERTER_TYPE_ID LEFT JOIN T_POWER_DATA_NEWEST C ON C.USER_ID=A.USER_ID AND C.SITE_ID=A.SITE_ID AND C.ETU_ID=A.ETU_ID AND C.INVERTER_ID=A.INVERTER_ID LEFT JOIN T_INVERTER_PANL D ON D.USER_ID=A.USER_ID AND D.SITE_ID=A.SITE_ID AND D.ETU_ID='empty' WHERE A.USER_ID=:B2 AND A.SITE_ID=:B1 ORDER BY 1, 2
d335gcvnz7q9a	SELECT output FROM TABLE (dbms_workload_repository.awr_report_html (:DID, :INST_NUMBER, :BgnSnap, :EndSnap ) )
d4hud7mhyjfbn	BEGIN SP_T_GENERATED_POWER_DATA_2(:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 ); END;
f0f3ch6j2msvm	SELECT A.DISPLAY_TIME DISPLAY_TIME, B.FEED_IN_POWER FEED_IN_POWER FROM (SELECT TRUNC(:B1 )+1-ROWNUM/288 DISPLAY_TIME FROM DUAL CONNECT BY LEVEL<=288*7) A LEFT JOIN (SELECT AREA_TIME, SUM(FEED_IN_POWER) FEED_IN_POWER FROM T_DISPLAY_POWER_DATA WHERE USER_ID=:B3 AND SITE_ID=:B2 AND AREA_TIME>=TRUNC(:B1 )-1 GROUP BY AREA_TIME UNION ALL SELECT AREA_TIME, SUM(FEED_IN_POWER) FEED_IN_POWER FROM T_DISPLAY_POWER_DATA_WEEK WHERE USER_ID=:B3 AND SITE_ID=:B2 AND AREA_TIME>=TRUNC(:B1 )-6 GROUP BY AREA_TIME ) B ON B.AREA_TIME=A.DISPLAY_TIME ORDER BY 1
fcb5u7n0r523m	ئ��᣿�l��f��ҵͣ��H��ԣ��L��H��H��λ��ۅh�f��棿��ǰ��У��棿��ǰ��r��ټ��U��͏��ң��h�`��ף��󣿁W��H��
fsrpg0kmrtfzu	SELECT TO_CHAR(A.DISPLAY_TIME, 'YYYY-MM-DD HH24:MI:SS') DISPLAY_TIME, SUM(NVL(B.FEED_IN_POWER, C.FEED_IN_POWER)) FEED_IN_POWER FROM (SELECT DISPLAY_TIME FROM (SELECT :B4 +1-ROWNUM/96 DISPLAY_TIME FROM DUAL CONNECT BY LEVEL<=96) WHERE DISPLAY_TIME<=:B3 ) A LEFT JOIN (SELECT USER_ID, SITE_ID, ETU_ID, INVERTER_ID, SF_GET_TIME_FIFTEEN(AREA_TIME) AREA_TIME, SUM(FEED_IN_POWER)/NULLIF(SUM(CASE WHEN FEED_IN_POWER>0 THEN 1 ELSE 0 END), 0) FEED_IN_POWER FROM T_DISPLAY_POWER_DATA WHERE USER_ID=:B2 AND SITE_ID=:B1 AND AREA_TIME>=:B4 GROUP BY USER_ID, SITE_ID, ETU_ID, INVERTER_ID, SF_GET_TIME_FIFTEEN(AREA_TIME) ) B ON B.AREA_TIME=A.DISPLAY_TIME LEFT JOIN (SELECT A.USER_ID, A.SITE_ID, A.ETU_ID, A.INVERTER_ID, :B3 AREA_TIME, CASE WHEN ((NVL(B.INVERTER_LID, 0)>0 AND B.POPULATION_STAMP>=SYSDATE-10/24/60) OR (NVL(B.LAST_INVERTER_LID, 0)>0 AND NVL(B.LAST_NET_TIME, TO_DATE('1990-01-01', 'YYYY-MM-DD'))>=SYSDATE-10/24/60)) THEN CASE WHEN A.POPULATION_STAMP>=SYSDATE-10/24/60 THEN CASE WHEN A.CURRENT_POWER>0 THEN A.CURRENT_POWER ELSE CASE WHEN NVL(A.LAST_TIME, TO_DATE('1990-01-01', 'YYYY-MM-DD'))>=SYSDATE-10/24/60 AND NVL(A.LAST_POWER, 0)>0 THEN A.LAST_POWER ELSE 0 END END ELSE 0 END ELSE 0 END FEED_IN_POWER FROM T_POWER_DATA_NEWEST A JOIN T_INVERTER B ON B.USER_ID=A.USER_ID AND B.SITE_ID=A.SITE_ID AND B.ETU_ID=A.ETU_ID AND B.INVERTER_ID=A.INVERTER_ID WHERE A.USER_ID=:B2 AND A.SITE_ID=:B1 ) C ON C.USER_ID=B.USER_ID AND C.SITE_ID=B.SITE_ID AND C.ETU_ID=B .ETU_ID AND C.INVERTER_ID=B.INVERTER_ID AND C.AREA_TIME=A.DISPLAY_TIME GROUP BY A.DISPLAY_TIME ORDER BY A.DISPLAY_TIME
g00cj285jmgsw	��흙�g��ì��ì��⬣��b��b��᣿��壿��ã��ғ��N�]��⬣��ۣ��ۣ��⬣��ã��ۣ��ܔ��Ŝ��e��ܔ��Ŝ��e��ūB�\�u��I�}��Ô}��ӣ��P
gjm43un5cy843	ئ��ئ��օͣ��y��ͣ��֣��r��ѣ��ЅN��ئ��օͣ��λ��ئ��e��U��ЅN��y��ͣ��֣��r��ڣ��ѣ��˷�߽��λ��L��ͣ��L��ͣ��L��J��c��ͣ�٢�Äd��ئ�r�ԣ�ǧ��W��ͣ��ͣ��W��ϻ��߽��́W��y��މ��飿�룿�W��ͣ��ã��H��ܣ��r��e��e��r��ͣ��գ��΂��ͣ��͏��r��e��U��e��U��y��򣿅ͣ��
grwydz59pu6mc	select text from view$ where rowid=:1
gtkz6vhsmthkr	select * from t_generated_power_data where etu_id='12030097' and inverter_id='0003001213000069' order by id desc

Back to SQL Statistics
Back to Top

Instance Activity Statistics

Instance Activity Stats
Instance Activity Stats - Absolute Values
Instance Activity Stats - Thread Activity

Instance Activity Stats

Ordered by statistic name

Statistic	Total	per Second	per Trans
Batched IO (bound) vector count	5	0.00	0.00
Batched IO (full) vector count	0	0.00	0.00
Batched IO block miss count	15	0.00	0.00
Batched IO buffer defrag count	0	0.00	0.00
Batched IO double miss count	0	0.00	0.00
Batched IO same unit count	10	0.00	0.00
Batched IO single block count	5	0.00	0.00
Batched IO vector block count	0	0.00	0.00
Batched IO vector read count	0	0.00	0.00
Block Cleanout Optim referenced	10	0.00	0.00
CCursor + sql area evicted	11	0.00	0.00
CPU used by this session	47,571	13.19	1.07
CPU used when call started	47,113	13.06	1.06
CR blocks created	144	0.04	0.00
Cached Commit SCN referenced	0	0.00	0.00
Commit SCN cached	25	0.01	0.00
DB time	439,511	121.82	9.88
DBWR checkpoint buffers written	19,594	5.43	0.44
DBWR checkpoints	9	0.00	0.00
DBWR object drop buffers written	9	0.00	0.00
DBWR revisited being-written buffer	0	0.00	0.00
DBWR tablespace checkpoint buffers written	0	0.00	0.00
DBWR thread checkpoint buffers written	0	0.00	0.00
DBWR transaction table writes	119	0.03	0.00
DBWR undo block writes	4,268	1.18	0.10
HSC Heap Segment Block Changes	130,268	36.11	2.93
Heap Segment Array Inserts	3,265	0.90	0.07
Heap Segment Array Updates	12,734	3.53	0.29
IMU CR rollbacks	124	0.03	0.00
IMU Flushes	3,356	0.93	0.08
IMU Redo allocation size	8,404,596	2,329.50	188.96
IMU commits	39,280	10.89	0.88
IMU contention	5	0.00	0.00
IMU ktichg flush	0	0.00	0.00
IMU pool not allocated	0	0.00	0.00
IMU recursive-transaction flush	0	0.00	0.00
IMU undo allocation size	110,996,440	30,764.90	2,495.54
IMU- failed to get a private strand	0	0.00	0.00
LOB table id lookup cache misses	0	0.00	0.00
Misses for writing mapping	0	0.00	0.00
Number of read IOs issued	537	0.15	0.01
PX local messages recv'd	0	0.00	0.00
PX local messages sent	0	0.00	0.00
RowCR - row contention	0	0.00	0.00
RowCR attempts	266	0.07	0.01
RowCR hits	62	0.02	0.00
SMON posted for undo segment shrink	4	0.00	0.00
SQL*Net roundtrips to/from client	86,960	24.10	1.96
TBS Extension: bytes extended	0	0.00	0.00
TBS Extension: files extended	0	0.00	0.00
TBS Extension: tasks created	0	0.00	0.00
TBS Extension: tasks executed	0	0.00	0.00
active txn count during cleanout	322	0.09	0.01
application wait time	1	0.00	0.00
background checkpoints completed	3	0.00	0.00
background checkpoints started	3	0.00	0.00
background timeouts	15,248	4.23	0.34
branch node splits	5	0.00	0.00
buffer is not pinned count	2,656,168	736.21	59.72
buffer is pinned count	8,261,666	2,289.89	185.75
bytes received via SQL*Net from client	147,249,826	40,813.26	3,310.62
bytes sent via SQL*Net to client	293,698,847	81,404.56	6,603.24
calls to get snapshot scn: kcmgss	697,983	193.46	15.69
calls to kcmgas	63,227	17.52	1.42
calls to kcmgcs	111,007	30.77	2.50
cell physical IO interconnect bytes	727,088,640	201,527.27	16,347.15
change write time	161	0.04	0.00
cleanout - number of ktugct calls	1,140	0.32	0.03
cleanouts and rollbacks - consistent read gets	0	0.00	0.00
cleanouts only - consistent read gets	22	0.01	0.00
cluster key scan block gets	2,475	0.69	0.06
cluster key scans	2,226	0.62	0.05
commit batch/immediate performed	1	0.00	0.00
commit batch/immediate requested	1	0.00	0.00
commit cleanout failures: block lost	0	0.00	0.00
commit cleanout failures: buffer being written	0	0.00	0.00
commit cleanout failures: callback failure	6	0.00	0.00
commit cleanout failures: cannot pin	402	0.11	0.01
commit cleanouts	163,274	45.25	3.67
commit cleanouts successfully completed	162,866	45.14	3.66
commit immediate performed	1	0.00	0.00
commit immediate requested	1	0.00	0.00
commit txn count during cleanout	902	0.25	0.02
concurrency wait time	373	0.10	0.01
consistent changes	192,321	53.31	4.32
consistent gets	35,134,563	9,738.25	789.93
consistent gets - examination	1,304,100	361.46	29.32
consistent gets direct	537	0.15	0.01
consistent gets from cache	35,134,029	9,738.10	789.92
consistent gets from cache (fastpath)	33,741,069	9,352.02	758.60
cursor authentications	61	0.02	0.00
data blocks consistent reads - undo records applied	247	0.07	0.01
db block changes	662,535	183.63	14.90
db block gets	1,080,773	299.56	24.30
db block gets direct	0	0.00	0.00
db block gets from cache	1,080,773	299.56	24.30
db block gets from cache (fastpath)	133,318	36.95	3.00
deferred (CURRENT) block cleanout applications	129,601	35.92	2.91
dirty buffers inspected	1,206	0.33	0.03
enqueue conversions	1,031	0.29	0.02
enqueue releases	241,359	66.90	5.43
enqueue requests	241,383	66.90	5.43
enqueue timeouts	0	0.00	0.00
enqueue waits	6	0.00	0.00
exchange deadlocks	0	0.00	0.00
execute count	410,560	113.79	9.23
failed probes on index block reclamation	0	0.00	0.00
file io service time	0	0.00	0.00
file io wait time	16,681,733	4,623.68	375.06
free buffer inspected	11,564	3.21	0.26
free buffer requested	70,811	19.63	1.59
heap block compress	4,284	1.19	0.10
hot buffers moved to head of LRU	2,449	0.68	0.06
immediate (CR) block cleanout applications	22	0.01	0.00
immediate (CURRENT) block cleanout applications	2,194	0.61	0.05
index crx upgrade (positioned)	0	0.00	0.00
index crx upgrade (prefetch)	2	0.00	0.00
index fast full scans (full)	188	0.05	0.00
index fetch by key	418,984	116.13	9.42
index scans kdiixs1	1,132,698	313.95	25.47
leaf node 90-10 splits	21	0.01	0.00
leaf node splits	498	0.14	0.01
lob reads	63,333	17.55	1.42
lob writes	53,263	14.76	1.20
lob writes unaligned	53,263	14.76	1.20
logons cumulative	1,606	0.45	0.04
max cf enq hold time	0	0.00	0.00
messages received	51,500	14.27	1.16
messages sent	51,500	14.27	1.16
min active SCN optimization applied on CR	316	0.09	0.01
no buffer to keep pinned count	524	0.15	0.01
no work - consistent read gets	33,582,355	9,308.03	755.03
non-idle wait count	330,634	91.64	7.43
non-idle wait time	3,564	0.99	0.08
opened cursors cumulative	447,300	123.98	10.06
parse count (describe)	0	0.00	0.00
parse count (failures)	2	0.00	0.00
parse count (hard)	281	0.08	0.01
parse count (total)	64,938	18.00	1.46
parse time cpu	371	0.10	0.01
parse time elapsed	453	0.13	0.01
physical read IO requests	8,552	2.37	0.19
physical read bytes	71,557,120	19,833.50	1,608.82
physical read total IO requests	14,935	4.14	0.34
physical read total bytes	269,213,184	74,617.86	6,052.73
physical read total multi block requests	95	0.03	0.00
physical reads	8,735	2.42	0.20
physical reads cache	8,198	2.27	0.18
physical reads cache prefetch	775	0.21	0.02
physical reads direct	537	0.15	0.01
physical reads direct (lob)	537	0.15	0.01
physical reads direct temporary tablespace	0	0.00	0.00
physical reads prefetch warmup	0	0.00	0.00
physical write IO requests	6,003	1.66	0.13
physical write bytes	198,254,592	54,950.26	4,457.36
physical write total IO requests	55,397	15.35	1.25
physical write total bytes	457,875,456	126,909.41	10,294.43
physical write total multi block requests	900	0.25	0.02
physical writes	24,201	6.71	0.54
physical writes direct	0	0.00	0.00
physical writes direct (lob)	0	0.00	0.00
physical writes direct temporary tablespace	0	0.00	0.00
physical writes from cache	24,201	6.71	0.54
physical writes non checkpoint	3,141	0.87	0.07
pinned buffers inspected	0	0.00	0.00
pinned cursors current	3	0.00	0.00
prefetch clients - default	1	0.00	0.00
prefetch warmup blocks aged out before use	0	0.00	0.00
prefetched blocks aged out before use	0	0.00	0.00
process last non-idle time	3,599	1.00	0.08
recovery blocks read	0	0.00	0.00
recursive calls	808,608	224.12	18.18
recursive cpu usage	5,911	1.64	0.13
redo blocks checksummed by FG (exclusive)	104,739	29.03	2.35
redo blocks read for recovery	0	0.00	0.00
redo blocks written	204,818	56.77	4.60
redo buffer allocation retries	0	0.00	0.00
redo entries	80,760	22.38	1.82
redo k-bytes read for recovery	0	0.00	0.00
redo k-bytes read total	92,570	25.66	2.08
redo log space requests	0	0.00	0.00
redo log space wait time	0	0.00	0.00
redo ordering marks	1,637	0.45	0.04
redo size	90,954,708	25,209.93	2,044.94
redo size for direct writes	0	0.00	0.00
redo subscn max counts	4,171	1.16	0.09
redo synch time	337	0.09	0.01
redo synch writes	7,780	2.16	0.17
redo wastage	10,676,796	2,959.29	240.05
redo write time	751	0.21	0.02
redo writes	45,592	12.64	1.03
rollback changes - undo records applied	2	0.00	0.00
rollbacks only - consistent read gets	144	0.04	0.00
root node splits	0	0.00	0.00
rows fetched via callback	285,819	79.22	6.43
session connect time	0	0.00	0.00
session cursor cache hits	99,457	27.57	2.24
session logical reads	36,215,241	10,037.78	814.23
shared hash latch upgrades - no wait	66,835	18.52	1.50
shared hash latch upgrades - wait	784	0.22	0.02
sorts (memory)	41,156	11.41	0.93
sorts (rows)	495,002	137.20	11.13
sql area evicted	23	0.01	0.00
sql area purged	5	0.00	0.00
summed dirty queue length	1,289	0.36	0.03
switch current to new buffer	13,120	3.64	0.29
table fetch by rowid	4,934,493	1,367.69	110.94
table fetch continued row	5,525	1.53	0.12
table scan blocks gotten	240,702	66.72	5.41
table scan rows gotten	7,896,923	2,188.79	177.55
table scans (direct read)	0	0.00	0.00
table scans (long tables)	0	0.00	0.00
table scans (short tables)	31,435	8.71	0.71
temp space allocated (bytes)	0	0.00	0.00
total cf enq hold time	270	0.07	0.01
total number of cf enq holders	317	0.09	0.01
total number of times SMON posted	4	0.00	0.00
transaction rollbacks	1	0.00	0.00
transaction tables consistent read rollbacks	0	0.00	0.00
transaction tables consistent reads - undo records applied	0	0.00	0.00
undo change vector size	30,830,344	8,545.25	693.16
user I/O wait time	1,768	0.49	0.04
user calls	98,300	27.25	2.21
user commits	42,578	11.80	0.96
user rollbacks	1,900	0.53	0.04
workarea executions - onepass	0	0.00	0.00
workarea executions - optimal	24,919	6.91	0.56
write clones created in background	9	0.00	0.00
write clones created in foreground	0	0.00	0.00

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

Statistics with absolute values (should not be diffed)

Statistic	Begin Value	End Value
opened cursors current	226	359
workarea memory allocated	0	1,718
logons current	81	105
session uga memory max	303,934,055,160	305,128,975,640
session pga memory	33,418,207,512	33,588,879,208
session pga memory max	36,935,476,152	37,145,338,376
session cursor cache count	4,146,156	4,164,882
session uga memory	65,617,620,279,312	65,918,360,603,504

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

Statistics identified by '(derived)' come from sources other than SYSSTAT

Statistic	Total	per Hour
log switches (derived)	3	2.99

Back to Instance Activity Statistics
Back to Top

IOStat by Function summary

'Data' columns suffixed with M,G,T,P are in multiples of 1024 other columns suffixed with K,M,G,T,P are in multiples of 1000
ordered by (Data Read + Write) desc

Function Name	Reads: Data	Reqs per sec	Data per sec	Writes: Data	Reqs per sec	Data per sec	Waits: Count	Avg Tm(ms)
Others	188M	1.76	.052107	146M	1.03	.040466	10K	0.08
DBWR	0M	0.00	0M	190M	1.66	.052662	5621	0.20
LGWR	0M	0.01	0M	101M	12.66	.027994	45.7K	0.03
Buffer Cache Reads	65M	2.22	.018016	0M	0.00	0M	7435	2.12
Direct Reads	4M	0.15	.001108	0M	0.00	0M	537	0.02
TOTAL:	257M	4.14	.071232	437M	15.36	.121123	69.3K	0.28

Back to IO Stats
Back to Top

IOStat by Filetype summary

'Data' columns suffixed with M,G,T,P are in multiples of 1024 other columns suffixed with K,M,G,T,P are in multiples of 1000
Small Read and Large Read are average service times, in milliseconds
Ordered by (Data Read + Write) desc

Filetype Name	Reads: Data	Reqs per sec	Data per sec	Writes: Data	Reqs per sec	Data per sec	Small Read	Large Read
Data File	69M	2.39	.019124	187M	1.68	.051830	1.76	10.00
Log File	90M	0.03	.024945	100M	12.64	.027717	0.00	0.00
Control File	99M	1.72	.027439	57M	1.01	.015798	0.00	0.00
Archive Log	0M	0.00	0M	90M	0.03	.024945
TOTAL:	258M	4.14	.071509	434M	15.36	.120291	1.02	0.11

Back to IO Stats
Back to Top

IOStat by Function/Filetype summary

'Data' columns suffixed with M,G,T,P are in multiples of 1024 other columns suffixed with K,M,G,T,P are in multiples of 1000
Ordered by (Data Read + Write) desc for each function

Function/File Name	Reads: Data	Reqs per sec	Data per sec	Writes: Data	Reqs per sec	Data per sec	Waits: Count	Avg Tm(ms)
Others	189M	1.76	.052385	146M	1.03	.040466	6317	0.00
Others (Control File)	98M	1.71	.027162	56M	0.99	.015521	6158	0.00
Others (Archive Log)	0M	0.00	0M	90M	0.03	.024945	0
Others (Log File)	90M	0.03	.024945	0M	0.00	0M	12	0.00
Others (Data File)	1M	0.02	.000277	0M	0.02	0M	147	0.01
DBWR	0M	0.00	0M	190M	1.66	.052662	0
DBWR (Data File)	0M	0.00	0M	190M	1.66	.052662	0
LGWR	0M	0.01	0M	101M	12.66	.027994	57	0.00
LGWR (Log File)	0M	0.00	0M	100M	12.64	.027717	12	0.00
LGWR (Control File)	0M	0.01	0M	1M	0.02	.000277	45	0.00
Buffer Cache Reads	65M	2.22	.018016	0M	0.00	0M	7413	1.60
Buffer Cache Reads (Data File)	65M	2.22	.018016	0M	0.00	0M	7413	1.60
Direct Reads	4M	0.15	.001108	0M	0.00	0M	0
Direct Reads (Data File)	4M	0.15	.001108	0M	0.00	0M	0
TOTAL:	258M	4.14	.071509	437M	15.36	.121123	13.8K	0.86

Back to IO Stats
Back to Top

Tablespace IO Stats

ordered by IOs (Reads + Writes) desc

Tablespace	Reads	Av Reads/s	Av Rd(ms)	Av Blks/Rd	Writes	Av Writes/s	Buffer Waits	Av Buf Wt(ms)
SEDAS	3,672	1	1.95	1.00	1,379	0	3	0.00
SEDAS_04	3,738	1	1.43	1.00	0	0	0	0.00
SEDAS_05	2	0	0.00	1.00	2,918	1	0	0.00
SYSTEM	894	0	1.55	1.16	116	0	495	0.48
SYSAUX	205	0	2.00	1.13	506	0	0	0.00
SEDAS_03	2	0	0.00	1.00	390	0	0	0.00
UNDOTBS1	0	0	0.00	0.00	387	0	33	0.00
SEDAS_01	19	0	3.68	1.37	297	0	0	0.00
SEDAS_02	2	0	0.00	1.00	3	0	0	0.00
SEDAS_00	2	0	0.00	1.00	0	0	0	0.00
SEDAS_06	2	0	5.00	1.00	0	0	0	0.00
SEDAS_07	2	0	5.00	1.00	0	0	0	0.00
SEDAS_08	2	0	0.00	1.00	0	0	0	0.00
SEDAS_09	2	0	0.00	1.00	0	0	0	0.00
SEDAS_T	0	0	0.00	0.00	2	0	0	0.00

Back to IO Stats
Back to Top

File IO Stats

ordered by Tablespace, File

Tablespace	Filename	Reads	Av Reads/s	Av Rd(ms)	Av Blks/Rd	Writes	Av Writes/s	Buffer Waits	Av Buf Wt(ms)
SEDAS	/u01/database/SEDAS.DBF	3,672	1	1.95	1.00	1,379	0	3	0.00
SEDAS_00	/u01/database/SEDAS_00.DBF	2	0	0.00	1.00	0	0	0	0.00
SEDAS_01	/u01/database/SEDAS_01.DBF	19	0	3.68	1.37	297	0	0	0.00
SEDAS_02	/u01/database/SEDAS_02.DBF	2	0	0.00	1.00	3	0	0	0.00
SEDAS_03	/u01/database/SEDAS_03.DBF	2	0	0.00	1.00	390	0	0	0.00
SEDAS_04	/u01/database/SEDAS_04.DBF	3,738	1	1.43	1.00	0	0	0	0.00
SEDAS_05	/u01/database/SEDAS_05.DBF	2	0	0.00	1.00	2,918	1	0	0.00
SEDAS_06	/u01/database/SEDAS_06.DBF	2	0	5.00	1.00	0	0	0	0.00
SEDAS_07	/u01/database/SEDAS_07.DBF	2	0	5.00	1.00	0	0	0	0.00
SEDAS_08	/u01/database/SEDAS_08.DBF	2	0	0.00	1.00	0	0	0	0.00
SEDAS_09	/u01/database/SEDAS_09.DBF	2	0	0.00	1.00	0	0	0	0.00
SEDAS_T	/u01/database/SEDAS_T.DBF	0	0			2	0	0	0.00
SYSAUX	/u01/app/oracle/oradata/orc11g/sysaux01.dbf	205	0	2.00	1.13	506	0	0	0.00
SYSTEM	/u01/app/oracle/oradata/orc11g/system01.dbf	894	0	1.55	1.16	116	0	495	0.48
UNDOTBS1	/u01/app/oracle/oradata/orc11g/undotbs01.dbf	0	0			387	0	33	0.00

Back to IO Stats
Back to Top

Buffer Pool Statistics

Buffer Pool Statistics
Checkpoint Activity

Buffer Pool Statistics

Standard block size Pools D: default, K: keep, R: recycle
Default Pools for other block sizes: 2k, 4k, 8k, 16k, 32k

P	Number of Buffers	Pool Hit%	Buffer Gets	Physical Reads	Physical Writes	Free Buff Wait	Writ Comp Wait	Buffer Busy Waits
D	131,990	100	36,206,497	8,192	24,201	0	0	531

Back to Buffer Pool Statistics
Back to Top

Checkpoint Activity

Total Physical Writes: 24,201

MTTR Writes	Log Size Writes	Log Ckpt Writes	Other Settings Writes	Autotune Ckpt Writes	Thread Ckpt Writes
0	0	0	0	19,594	0

Back to Buffer Pool Statistics
Back to Top

Advisory Statistics

Instance Recovery Stats
MTTR Advisory
Buffer Pool Advisory
PGA Aggr Summary
PGA Aggr Target Stats
PGA Aggr Target Histogram
PGA Memory Advisory
Shared Pool Advisory
SGA Target Advisory
Streams Pool Advisory
Java Pool Advisory

Instance Recovery Stats

B: Begin Snapshot, E: End Snapshot

	Targt MTTR (s)	Estd MTTR (s)	Recovery Estd IOs	Actual RedoBlks	Target RedoBlks	Log Sz RedoBlks	Log Ckpt Timeout RedoBlks	Log Ckpt Interval RedoBlks	Opt Log Sz(M)	Estd RAC Avail Time
B	0	11	1795	20374	116097	165888	116097
E	0	11	1582	18282	92370	165888	92370

Back to Advisory Statistics
Back to Top

MTTR Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Buffer Pool Advisory

Only rows with estimated physical reads >0 are displayed
ordered by Block Size, Buffers For Estimate

P	Size for Est (M)	Size Factor	Buffers (thousands)	Est Phys Read Factor	Estimated Phys Reads (thousands)	Est Phys Read Time	Est %DBtime for Rds
D	96	0.09	12	1.96	17,352	1	18406.00
D	192	0.18	24	1.42	12,559	1	9422.00
D	288	0.27	35	1.27	11,250	1	6967.00
D	384	0.36	47	1.20	10,595	1	5740.00
D	480	0.45	59	1.16	10,222	1	5041.00
D	576	0.54	71	1.12	9,942	1	4516.00
D	672	0.63	83	1.10	9,684	1	4032.00
D	768	0.72	95	1.07	9,445	1	3584.00
D	864	0.81	106	1.05	9,240	1	3200.00
D	960	0.90	118	1.02	9,035	1	2815.00
D	1,056	0.99	130	1.00	8,870	1	2506.00
D	1,072	1.00	132	1.00	8,840	1	2449.00
D	1,152	1.07	142	0.98	8,696	1	2180.00
D	1,248	1.16	154	0.96	8,507	1	1825.00
D	1,344	1.25	165	0.95	8,380	1	1588.00
D	1,440	1.34	177	0.93	8,256	1	1356.00
D	1,536	1.43	189	0.92	8,155	1	1167.00
D	1,632	1.52	201	0.91	8,021	1	916.00
D	1,728	1.61	213	0.89	7,892	1	857.00
D	1,824	1.70	225	0.88	7,742	1	856.00
D	1,920	1.79	236	0.85	7,484	1	854.00

Back to Advisory Statistics
Back to Top

PGA Aggr Summary

PGA cache hit % - percentage of W/A (WorkArea) data processed only in-memory

PGA Cache Hit %	W/A MB Processed	Extra W/A MB Read/Written
100.00	2,733	0

Back to Advisory Statistics
Back to Top

PGA Aggr Target Stats

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

PGA Aggr Target Histogram

Optimal Executions are purely in-memory operations

Low Optimal	High Optimal	Total Execs	Optimal Execs
2K	4K	21,547	21,547
64K	128K	92	92
512K	1024K	2,890	2,890
1M	2M	378	378
2M	4M	10	10
4M	8M	2	2

Back to Advisory Statistics
Back to Top

PGA Memory Advisory

When using Auto Memory Mgmt, minimally choose a pga_aggregate_target value where Estd PGA Overalloc Count is 0

PGA Target Est (MB)	Size Factr	W/A MB Processed	Estd Extra W/A MB Read/ Written to Disk	Estd PGA Cache Hit %	Estd PGA Overalloc Count	Estd Time
140	0.13	795,913.56	91,600.95	90.00	15,651	51,128,337
280	0.25	795,913.56	62.81	100.00	3	45,854,966
560	0.50	795,913.56	0.00	100.00	0	45,851,347
840	0.75	795,913.56	0.00	100.00	0	45,851,347
1,120	1.00	795,913.56	0.00	100.00	0	45,851,347
1,344	1.20	795,913.56	0.00	100.00	0	45,851,347
1,568	1.40	795,913.56	0.00	100.00	0	45,851,347
1,792	1.60	795,913.56	0.00	100.00	0	45,851,347
2,016	1.80	795,913.56	0.00	100.00	0	45,851,347
2,240	2.00	795,913.56	0.00	100.00	0	45,851,347
3,360	3.00	795,913.56	0.00	100.00	0	45,851,347
4,480	4.00	795,913.56	0.00	100.00	0	45,851,347
6,720	6.00	795,913.56	0.00	100.00	0	45,851,347
8,960	8.00	795,913.56	0.00	100.00	0	45,851,347

Back to Advisory Statistics
Back to Top

Shared Pool Advisory

SP: Shared Pool Est LC: Estimated Library Cache Factr: Factor
Note there is often a 1:Many correlation between a single logical object in the Library Cache, and the physical number of memory objects associated with it. Therefore comparing the number of Lib Cache objects (e.g. in v$librarycache), with the number of Lib Cache Memory Objects is invalid.

Shared Pool Size(M)	SP Size Factr	Est LC Size (M)	Est LC Mem Obj	Est LC Time Saved (s)	Est LC Time Saved Factr	Est LC Load Time (s)	Est LC Load Time Factr	Est LC Mem Obj Hits (K)
464	0.49	27	1,701	2,769,666	1.00	6,924	1.29	95,606
560	0.59	124	7,083	2,769,856	1.00	6,734	1.25	340,980
656	0.69	220	10,713	2,770,481	1.00	6,109	1.14	341,009
752	0.80	315	14,148	2,770,903	1.00	5,687	1.06	341,029
848	0.90	411	17,072	2,771,123	1.00	5,467	1.02	341,042
944	1.00	507	20,042	2,771,212	1.00	5,378	1.00	341,047
1,040	1.10	603	23,383	2,771,233	1.00	5,357	1.00	341,049
1,136	1.20	699	26,597	2,771,245	1.00	5,345	0.99	341,050
1,232	1.31	795	29,473	2,771,254	1.00	5,336	0.99	341,050
1,328	1.41	891	32,343	2,771,257	1.00	5,333	0.99	341,050
1,424	1.51	977	34,870	2,771,258	1.00	5,332	0.99	341,051
1,520	1.61	1,019	36,612	2,771,260	1.00	5,330	0.99	341,051
1,616	1.71	1,019	36,612	2,771,260	1.00	5,330	0.99	341,051
1,712	1.81	1,019	36,612	2,771,260	1.00	5,330	0.99	341,051
1,808	1.92	1,019	36,612	2,771,260	1.00	5,330	0.99	341,051
1,904	2.02	1,019	36,612	2,771,260	1.00	5,330	0.99	341,051

Back to Advisory Statistics
Back to Top

SGA Target Advisory

SGA Target Size (M)	SGA Size Factor	Est DB Time (s)	Est Physical Reads
1,040	0.50	141,253	10,621,548
1,560	0.75	138,559	9,814,501
2,080	1.00	136,794	8,839,504
2,600	1.25	135,577	8,335,652
3,120	1.50	135,467	8,201,292
3,640	1.75	135,468	7,776,996
4,160	2.00	135,468	7,776,996

Back to Advisory Statistics
Back to Top

Streams Pool Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Java Pool Advisory

No data exists for this section of the report.

Back to Advisory Statistics
Back to Top

Wait Statistics

Buffer Wait Statistics
Enqueue Activity

Buffer Wait Statistics

ordered by wait time desc, waits desc

Class	Waits	Total Wait Time (s)	Avg Time (ms)
data block	494	0	0
undo header	33	0	0
segment header	4	0	0

Back to Wait Statistics
Back to Top

Enqueue Activity

only enqueues with waits are shown
Enqueue stats gathered prior to 10g should not be compared with 10g data
ordered by Wait Time desc, Waits desc

Enqueue Type (Request Reason)	Requests	Succ Gets	Failed Gets	Waits	Wt Time (s)	Av Wt Time(ms)
RO-Multiple Object Reuse (fast object reuse)	54	54	0	5	0	2.00
HW-Segment High Water Mark	179	179	0	1	0	0.00

Back to Wait Statistics
Back to Top

Undo Statistics

Undo Segment Summary
Undo Segment Stats

Undo Segment Summary

Min/Max TR (mins) - Min and Max Tuned Retention (minutes)
STO - Snapshot Too Old count, OOS - Out of Space count
Undo segment block stats:
uS - unexpired Stolen, uR - unexpired Released, uU - unexpired reUsed
eS - expired Stolen, eR - expired Released, eU - expired reUsed

Undo TS#	Num Undo Blocks (K)	Number of Transactions	Max Qry Len (s)	Max Tx Concurcy	Min/Max TR (mins)	STO/ OOS	uS/uR/uU/ eS/eR/eU
2	4.22	48,372	1,184	4	22.6/32.8	0/0	0/0/0/0/0/0

Back to Undo Statistics
Back to Top

Undo Segment Stats

Most recent 35 Undostat rows, ordered by Time desc

End Time	Num Undo Blocks	Number of Transactions	Max Qry Len (s)	Max Tx Concy	Tun Ret (mins)	STO/ OOS	uS/uR/uU/ eS/eR/eU
25-7�� 08:59	628	7,677	1,178	3	33	0/0	0/0/0/0/0/0
25-7�� 08:49	571	6,917	577	3	23	0/0	0/0/0/0/0/0
25-7�� 08:39	629	7,712	1,182	3	33	0/0	0/0/0/0/0/0
25-7�� 08:29	665	8,136	581	4	23	0/0	0/0/0/0/0/0
25-7�� 08:19	757	8,713	1,184	3	33	0/0	0/0/0/0/0/0
25-7�� 08:09	965	9,217	583	3	23	0/0	0/0/0/0/0/0

Back to Undo Statistics
Back to Top

Latch Statistics

Latch Activity
Latch Sleep Breakdown
Latch Miss Sources
Mutex Sleep Summary
Parent Latch Statistics
Child Latch Statistics

Latch Activity

"Get Requests", "Pct Get Miss" and "Avg Slps/Miss" are statistics for willing-to-wait latch get requests
"NoWait Requests", "Pct NoWait Miss" are for no-wait latch get requests
"Pct Misses" for both should be very close to 0.0

Latch Name	Get Requests	Pct Get Miss	Avg Slps /Miss	NoWait Requests	Pct NoWait Miss
AQ deq hash table latch	1	0.00		0
ASM db client latch	2,585	0.00		0
ASM map operation hash table	1	0.00		0
ASM network state latch	61	0.00		0
AWR Alerted Metric Element list	28,275	0.00		0
Change Notification Hash table latch	1,202	0.00		0
Consistent RBA	45,596	0.00		0
DML lock allocation	309,794	0.00	0.00	0
Event Group Locks	1,537	0.00		0
FAL Queue	102	0.00		0
FIB s.o chain latch	18	0.00		0
FOB s.o list latch	3,716	0.57	0.00	0
File State Object Pool Parent Latch	1	0.00		0
IPC stats buffer allocation latch	1	0.00		0
In memory undo latch	299,964	0.00	0.50	43,493	0.00
JS Sh mem access	7	0.00		0
JS broadcast autostart latch	66	0.00		0
JS mem alloc latch	6	0.00		0
JS queue access latch	7	0.00		0
JS queue state obj latch	26,170	0.00		0
JS slv state obj latch	243	0.00		0
KFC FX Hash Latch	1	0.00		0
KFC Hash Latch	1	0.00		0
KFCL LE Freelist	1	0.00		0
KGNFS-NFS:SHM structure	1	0.00		0
KGNFS-NFS:SVR LIST	1	0.00		0
KJC message pool free list	1	0.00		0
KJCT flow control latch	1	0.00		0
KMG MMAN ready and startup request latch	1,203	0.00		0
KTF sga latch	19	0.00		1,114	0.00
KWQS pqueue ctx latch	61	0.00		0
Locator state objects pool parent latch	1	0.00		0
Lsod array latch	1	0.00		0
MQL Tracking Latch	0			72	0.00
Memory Management Latch	1	0.00		1,203	0.00
Memory Queue	1	0.00		0
Memory Queue Message Subscriber #1	1	0.00		0
Memory Queue Message Subscriber #2	1	0.00		0
Memory Queue Message Subscriber #3	1	0.00		0
Memory Queue Message Subscriber #4	1	0.00		0
Memory Queue Subscriber	1	0.00		0
MinActiveScn Latch	20	0.00		0
Mutex	1	0.00		0
Mutex Stats	1	0.00		0
OS process	5,371	0.00		0
OS process allocation	4,806	0.37	0.00	0
OS process: request allocation	3,048	0.79	0.00	0
PL/SQL warning settings	2,655	0.00		0
PX hash array latch	1	0.00		0
QMT	1	0.00		0
Real-time plan statistics latch	8,567	0.00		0
SGA IO buffer pool latch	66	0.00		66	0.00
SGA blob parent	1	0.00		0
SGA bucket locks	1	0.00		0
SGA heap locks	1	0.00		0
SGA pool locks	1	0.00		0
SQL memory manager latch	121	0.00		1,201	0.00
SQL memory manager workarea list latch	200,929	0.00		0
Shared B-Tree	313	0.00		0
Streams Generic	1	0.00		0
Testing	1	0.00		0
Token Manager	1	0.00		0
WCR: sync	1	0.00		0
Write State Object Pool Parent Latch	1	0.00		0
X$KSFQP	1,974	0.00		0
XDB NFS Security Latch	1	0.00		0
XDB unused session pool	1	0.00		0
XDB used session pool	1	0.00		0
active checkpoint queue latch	6,902	0.00		0
active service list	15,013	0.59	0.47	2,566	0.00
alert log latch	6	0.00		0
archive control	69	0.00		0
archive process latch	309	0.00		0
buffer pool	1	0.00		0
business card	1	0.00		0
cache buffer handles	3,942	0.00		0
cache buffers chains	73,154,225	0.06	0.01	51,736	0.00
cache buffers lru chain	50,940	0.00		154,170	0.00
cache table scan latch	28	0.00		28	0.00
call allocation	5,490	5.63	0.59	0
cas latch	1	0.00		0
change notification client cache latch	1	0.00		0
channel handle pool latch	3,078	0.39	0.00	0
channel operations parent latch	23,262	0.12	0.00	0
checkpoint queue latch	365,317	0.00		19,175	0.00
client/application info	11,420	0.00		0
compile environment latch	1,606	0.00		0
corrupted undo seg latch	7	0.00		0
cp cmon/server latch	1	0.00		0
cp pool latch	1	0.00		0
cp server hash latch	1	0.00		0
cp sga latch	61	0.00		0
cvmap freelist lock	1	0.00		0
deferred cleanup latch	61	0.00		0
dml lock allocation	61	0.00		0
done queue latch	1	0.00		0
dummy allocation	3,189	0.13	0.00	0
enqueue hash chains	483,771	0.01	0.02	0
enqueues	69,065	0.02	0.00	0
fifth spare latch	1	0.00		0
file cache latch	545	0.00		0
flashback copy	1	0.00		0
gc element	1	0.00		0
gcs commit scn state	1	0.00		0
gcs partitioned table hash	1	0.00		0
gcs pcm hashed value bucket hash	1	0.00		0
gcs resource freelist	1	0.00		0
gcs resource hash	1	0.00		0
gcs resource scan list	1	0.00		0
gcs shadows freelist	1	0.00		0
ges domain table	1	0.00		0
ges enqueue table freelist	1	0.00		0
ges group table	1	0.00		0
ges process hash list	1	0.00		0
ges process parent latch	1	0.00		0
ges resource hash list	1	0.00		0
ges resource scan list	1	0.00		0
ges resource table freelist	1	0.00		0
ges value block free list	1	0.00		0
global KZLD latch for mem in SGA	1,396	0.07	0.00	0
global tx hash mapping	1	0.00		0
granule operation	1	0.00		0
hash table column usage latch	47	0.00		115,237	0.00
hash table modification latch	89	0.00		0
heartbeat check	1	0.00		0
internal temp table object number allocation latch	2	0.00		0
intra txn parallel recovery	1	0.00		0
io pool granule metadata list	1	0.00		0
job workq parent latch	71	0.00		73	1.37
job_queue_processes free list latch	144	0.00		0
job_queue_processes parameter latch	855	0.00		0
k2q lock allocation	1	0.00		0
kcbtsemkid latch	3	0.00		0
kdlx hb parent latch	1	0.00		0
kgb parent	1	0.00		0
kks stats	602	0.00		0
kokc descriptor allocation latch	454	0.00		0
ksfv messages	1	0.00		0
kss move lock	37	0.00		0
ksuosstats global area	243	0.00		0
ksv allocation latch	133	0.00		0
ksv class latch	73	0.00		0
ksv msg queue latch	1	0.00		0
ksz_so allocation latch	3,048	0.62	0.00	0
ktm global data	26	0.00		0
kwqbsn:qsga	129	0.00		0
lgwr LWN SCN	45,637	0.00		0
list of block allocation	3,008	0.03	0.00	0
loader state object freelist	546	0.00		0
lob segment dispenser latch	1	0.00		0
lob segment hash table latch	13	0.00		0
lob segment query latch	1	0.00		0
lock DBA buffer during media recovery	1	0.00		0
logical standby cache	1	0.00		0
logminer context allocation	1	0.00		0
logminer work area	1	0.00		0
longop free list parent	1	0.00		0
managed standby latch	99	0.00		0
mapped buffers lru chain	1	0.00		0
message pool operations parent latch	403	0.00		0
messages	181,857	0.00	0.00	0
mostly latch-free SCN	45,645	0.01	0.33	0
msg queue latch	1	0.00		0
multiblock read objects	552	0.00		0
name-service namespace bucket	1	0.00		0
ncodef allocation latch	61	0.00		0
object queue header heap	55,096	0.00		55	0.00
object queue header operation	253,838	0.00		0
object stats modification	37	0.00		0
parallel query alloc buffer	445	0.00		0
parallel query stats	1	0.00		0
parameter list	235	0.00		0
parameter table management	3,190	0.03	0.00	0
peshm	1	0.00		0
pesom_free_list	1	0.00		0
pesom_hash_node	1	0.00		0
post/wait queue	6,949	0.06	0.00	4,946	0.04
process allocation	3,187	1.57	0.66	1,521	0.99
process group creation	3,048	1.05	0.00	0
process queue	1	0.00		0
process queue reference	1	0.00		0
qmn task queue latch	525	0.00		0
query server freelists	1	0.00		0
queued dump request	12	0.00		0
queuing load statistics	1	0.00		0
recovery domain hash list	1	0.00		0
redo allocation	224,519	0.02	0.03	80,718	0.02
redo copy	1	0.00		80,725	0.18
redo writing	146,175	0.00	1.00	0
resmgr group change latch	1,788	0.00		0
resmgr:active threads	3,189	0.00		0
resmgr:actses change group	1,486	0.00		0
resmgr:actses change state	1	0.00		0
resmgr:free threads list	3,188	0.78	0.00	0
resmgr:plan CPU method	1	0.00		0
resmgr:resource group CPU method	1	0.00		0
resmgr:schema config	81	0.00		0
resmgr:session queuing	1	0.00		0
rm cas latch	1	0.00		0
row cache objects	803,468	0.25	0.00	0
second spare latch	1	0.00		0
sequence cache	134,533	0.01	0.00	0
session allocation	166,999	0.00	0.00	55,682	0.01
session idle bit	250,676	0.00	0.00	0
session queue latch	1	0.00		0
session state list latch	3,270	0.24	0.00	0
session switching	7,622	0.20	0.00	0
session timer	1,290	0.00		0
shared pool	92,419	1.66	0.01	0
shared pool sim alloc	2	0.00		0
shared pool simulator	1,705	0.00		0
sim partition latch	1	0.00		0
simulator hash latch	2,455,324	0.00		0
simulator lru latch	6,618	0.00		2,447,540	0.10
sort extent pool	107	0.00		0
space background state object latch	6	0.00		0
space background task latch	2,671	0.00		2,406	0.00
state object free list	2	0.00		0
statistics aggregation	560	0.00		0
tablespace key chain	1	0.00		0
temp lob duration state obj allocation	4	0.00		0
test excl. parent l0	1	0.00		0
test excl. parent2 l0	1	0.00		0
third spare latch	1	0.00		0
threshold alerts latch	322	0.00		0
transaction allocation	3,637	0.03	0.00	0
undo global data	235,791	0.00	0.00	0
virtual circuit buffers	1	0.00		0
virtual circuit holder	1	0.00		0
virtual circuit queues	1	0.00		0

Back to Latch Statistics
Back to Top

Latch Sleep Breakdown

ordered by misses desc

Latch Name	Get Requests	Misses	Sleeps	Spin Gets
cache buffers chains	73,154,225	42,575	247	42,346
row cache objects	803,468	2,048	1	2,047
shared pool	92,419	1,536	9	1,527
call allocation	5,490	309	181	145
active service list	15,013	89	42	49
enqueue hash chains	483,771	56	1	55
process allocation	3,187	50	33	18
redo allocation	224,519	36	1	35
mostly latch-free SCN	45,645	3	1	2
In memory undo latch	299,964	2	1	1
redo writing	146,175	1	1	0

Back to Latch Statistics
Back to Top

Latch Miss Sources

only latches with sleeps are shown
ordered by name, sleeps desc

Latch Name	Where	Sleeps	Waiter Sleeps
In memory undo latch	kticmt: child	1	0
active service list	kswslogon: session logout	60	60
cache buffers chains	kcbgtcr: fast path	158	3
cache buffers chains	kcbgtcr: fast path (cr pin)	147	11
cache buffers chains	kcbgcur_2	117	44
cache buffers chains	kcbgtcr_2	24	56
cache buffers chains	kcbrls_1	6	171
cache buffers chains	kcbrls_2	3	49
cache buffers chains	kcbchg1: kslbegin: call CR func	1	62
call allocation	ksuxds	173	156
call allocation	ksudlp: top call	8	25
enqueue hash chains	ksqgtl3	1	0
lgwr LWN SCN	kcs023	1	0
process allocation	ksucrp:1	33	0
redo allocation	kcrfw_redo_gen: redo allocation 1	1	0
redo writing	kcrfwcr	1	0
row cache objects	kqreqd: reget	1	0
shared pool	kghalo	4	3
shared pool	kghfre	4	4
shared pool	kghupr1	1	2

Back to Latch Statistics
Back to Top

Mutex Sleep Summary

ordered by number of sleeps desc

Mutex Type	Location	Sleeps	Wait Time (ms)
Library Cache	kglhdgn2 106	332	-0
Library Cache	kgllkdl1 85	96	0
Library Cache	kgllkc1 57	61	0
Library Cache	kglpin1 4	46	0
Library Cache	kglpndl1 95	43	-0
Library Cache	kglpnal1 90	37	0
Library Cache	kglhdgn1 62	28	-0
Cursor Pin	kksfbc [KKSCHLFSP2]	4	0
Cursor Pin	kksLockDelete [KKSCHLPIN6]	1	0
Cursor Pin	kksfbc [KKSCHLPIN1]	1	0
Cursor Pin	kkslce [KKSCHLPIN2]	1	0

Back to Latch Statistics
Back to Top

Parent Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

Child Latch Statistics

No data exists for this section of the report.

Back to Latch Statistics
Back to Top

Segment Statistics

Segments by Logical Reads
Segments by Physical Reads
Segments by Physical Read Requests
Segments by UnOptimized Reads
Segments by Optimized Reads
Segments by Direct Physical Reads
Segments by Physical Writes
Segments by Physical Write Requests
Segments by Direct Physical Writes
Segments by Table Scans
Segments by DB Blocks Changes
Segments by Row Lock Waits
Segments by ITL Waits
Segments by Buffer Busy Waits

Segments by Logical Reads

Total Logical Reads: 36,215,241
Captured Segments account for 99.3% of Total

Owner	Tablespace Name	Object Name	Obj. Type	Logical Reads	%Total
SEDAS_2	SEDAS	IX_T_DISPLAY_POWER_DATA	INDEX	30,939,536	85.43
SEDAS_2	SEDAS	T_DISPLAY_POWER_DATA	TABLE	1,445,632	3.99
SYS	SYSTEM	I_OBJ2	INDEX	981,056	2.71
SYS	TEMP	SYS_TEMP_0FD9D6627_9CCD3DAA	TABLE	640,192	1.77
SEDAS_2	SEDAS_01	T_INVERTER	TABLE	289,232	0.80

Back to Segment Statistics
Back to Top

Segments by Physical Reads

Total Physical Reads: 8,735
Captured Segments account for 58.3% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Physical Reads	%Total
SEDAS_2	SEDAS_04	T_PROTOCOL_DATA	P_20120724	TABLE PARTITION	2,342	26.81
SEDAS_2	SEDAS	T_DISPLAY_POWER_DATA_WEEK		TABLE	2,246	25.71
SEDAS_2	SEDAS	IX_T_DISPLAY_POWER_DATA		INDEX	208	2.38
SEDAS_2	SEDAS_04	IX_T_PROTOCOL_DATA	P_20120724	INDEX PARTITION	113	1.29
SYS	SYSTEM	I_OBJAUTH1		INDEX	76	0.87

Back to Segment Statistics
Back to Top

Segments by Physical Read Requests

Total Physical Read Requests: 8,552
Captured Segments account for 59.4% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Phys Read Requests	%Total
SEDAS_2	SEDAS_04	T_PROTOCOL_DATA	P_20120724	TABLE PARTITION	2,342	27.39
SEDAS_2	SEDAS	T_DISPLAY_POWER_DATA_WEEK		TABLE	2,246	26.26
SEDAS_2	SEDAS	IX_T_DISPLAY_POWER_DATA		INDEX	208	2.43
SEDAS_2	SEDAS_04	IX_T_PROTOCOL_DATA	P_20120724	INDEX PARTITION	113	1.32
SYS	SYSTEM	I_OBJAUTH1		INDEX	76	0.89

Back to Segment Statistics
Back to Top

Segments by UnOptimized Reads

Total UnOptimized Read Requests: 8,552
Captured Segments account for 59.4% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	UnOptimized Reads	%Total
SEDAS_2	SEDAS_04	T_PROTOCOL_DATA	P_20120724	TABLE PARTITION	2,342	27.39
SEDAS_2	SEDAS	T_DISPLAY_POWER_DATA_WEEK		TABLE	2,246	26.26
SEDAS_2	SEDAS	IX_T_DISPLAY_POWER_DATA		INDEX	208	2.43
SEDAS_2	SEDAS_04	IX_T_PROTOCOL_DATA	P_20120724	INDEX PARTITION	113	1.32
SYS	SYSTEM	I_OBJAUTH1		INDEX	76	0.89

Back to Segment Statistics
Back to Top

Segments by Optimized Reads

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Direct Physical Reads

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Physical Writes

Total Physical Writes: 24,201
Captured Segments account for 59.6% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Physical Writes	%Total
SEDAS_2	SEDAS_05	IX_T_PROTOCOL_DATA_OTHER	P_20120725	INDEX PARTITION	3,724	15.39
SEDAS_2	SEDAS_05	IX_T_GENERATED_POWER_DATA	P_20120725	INDEX PARTITION	3,432	14.18
SEDAS_2	SEDAS_05	IX_T_PROTOCOL_DATA	P_20120725	INDEX PARTITION	3,114	12.87
SEDAS_2	SEDAS	IX_T_DISPLAY_POWER_DATA		INDEX	1,690	6.98
SEDAS_2	SEDAS_05	T_PROTOCOL_DATA_OTHER	P_20120725	TABLE PARTITION	499	2.06

Back to Segment Statistics
Back to Top

Segments by Physical Write Requests

Total Physical Write Requestss: 6,003
Captured Segments account for 77.3% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Phys Write Requests	%Total
SEDAS_2	SEDAS_05	IX_T_PROTOCOL_DATA_OTHER	P_20120725	INDEX PARTITION	1,080	17.99
SEDAS_2	SEDAS	IX_T_DISPLAY_POWER_DATA		INDEX	908	15.13
SEDAS_2	SEDAS_05	IX_T_GENERATED_POWER_DATA	P_20120725	INDEX PARTITION	759	12.64
SEDAS_2	SEDAS_05	IX_T_PROTOCOL_DATA	P_20120725	INDEX PARTITION	668	11.13
SEDAS_2	SEDAS_01	T_INVERTER		TABLE	270	4.50

Back to Segment Statistics
Back to Top

Segments by Direct Physical Writes

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Table Scans

Total Table Scans: 188
Captured Segments account for 6.4% of Total

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	Table Scans	%Total
SYS	SYSTEM	I_OBJ2		INDEX	11	5.85
SEDAS_2	SEDAS_01	IDX_ETU_ID		INDEX	1	0.53

Back to Segment Statistics
Back to Top

Segments by DB Blocks Changes

% of Capture shows % of DB Block Changes for each top segment compared
with total DB Block Changes for all segments captured by the Snapshot

Owner	Tablespace Name	Object Name	Subobject Name	Obj. Type	DB Block Changes	% of Capture
SYS	TEMP	SYS_TEMP_0FD9D6627_9CCD3DAA		TABLE	192,048	91.54
SEDAS_2	SEDAS_05	IX_T_GENERATED_POWER_DATA	P_20120725	INDEX PARTITION	3,744	1.78
SEDAS_2	SEDAS_05	IX_T_PROTOCOL_DATA_OTHER	P_20120725	INDEX PARTITION	2,944	1.40
SEDAS_2	SEDAS_05	T_PROTOCOL_DATA_OTHER	P_20120725	TABLE PARTITION	2,096	1.00
SEDAS_2	SEDAS_05	T_GENERATED_POWER_DATA	P_20120725	TABLE PARTITION	2,064	0.98

Back to Segment Statistics
Back to Top

Segments by Row Lock Waits

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by ITL Waits

No data exists for this section of the report.

Back to Segment Statistics
Back to Top

Segments by Buffer Busy Waits

% of Capture shows % of Buffer Busy Waits for each top segment compared
with total Buffer Busy Waits for all segments captured by the Snapshot

Owner	Tablespace Name	Object Name	Obj. Type	Buffer Busy Waits	% of Capture
SYS	SYSTEM	AUD$	TABLE	494	99.20
SEDAS_2	SEDAS	IX_T_DISPLAY_POWER_DATA	INDEX	3	0.60
SYS	SYSTEM	JOB$	TABLE	1	0.20

Back to Segment Statistics
Back to Top

Dictionary Cache Stats

"Pct Misses" should be very low (< 2% in most cases)
"Final Usage" is the number of cache entries being used

Cache	Get Requests	Pct Miss	Mod Reqs	Final Usage
dc_awr_control	65	0.00	2	1
dc_files	21	0.00	0	21
dc_global_oids	486	0.00	0	74
dc_histogram_data	15,542	0.18	0	11,056
dc_histogram_defs	10,365	0.82	0	7,540
dc_objects	8,646	0.05	9	4,964
dc_profiles	1,468	0.00	0	1
dc_rollback_segments	836	0.00	0	22
dc_segments	4,414	0.00	27	1,650
dc_sequences	2,102	0.00	2,102	17
dc_tablespaces	79,088	0.00	0	23
dc_users	173,041	0.00	0	244
global database name	3,954	0.00	0	1
outstanding_alerts	120	0.00	0	20
sch_lj_oids	5	0.00	0	61

Library Cache Activity

"Pct Misses" should be very low

Namespace	Get Requests	Pct Miss	Pin Requests	Pct Miss	Reloads	Invali- dations
BODY	1,479	0.00	13,661	0.01	2	0
CLUSTER	83	0.00	10	0.00	0	0
DBLINK	2,795	0.00	0		0	0
EDITION	1,482	0.00	2,948	0.00	0	0
INDEX	219	0.00	154	0.00	0	0
QUEUE	60	0.00	212	0.00	0	0
SCHEMA	2,866	0.00	0		0	0
SQL AREA	15,485	0.11	430,115	0.18	199	17
SUBSCRIPTION	12	0.00	12	0.00	0	0
TABLE/PROCEDURE	5,200	0.00	87,763	0.05	46	0
TRIGGER	50	0.00	106	0.94	1	0

Memory Statistics

Memory Dynamic Components
Memory Resize Operations Summary
Memory Resize Ops
Process Memory Summary
SGA Memory Summary
SGA breakdown difference

Memory Dynamic Components

Min/Max sizes since instance startup
Oper Types/Modes: INItializing,GROw,SHRink,STAtic/IMMediate,DEFerred
ordered by Component

Component	Begin Snap Size (Mb)	Current Size (Mb)	Min Size (Mb)	Max Size (Mb)	Last Op Typ/Mod
ASM Buffer Cache	0.00	0.00	0.00	0.00	STA/
DEFAULT 16K buffer cache	0.00	0.00	0.00	0.00	STA/
DEFAULT 2K buffer cache	0.00	0.00	0.00	0.00	STA/
DEFAULT 32K buffer cache	0.00	0.00	0.00	0.00	STA/
DEFAULT 4K buffer cache	0.00	0.00	0.00	0.00	STA/
DEFAULT 8K buffer cache	0.00	0.00	0.00	0.00	STA/
DEFAULT buffer cache	1,072.00	1,072.00	880.00	1,072.00	GRO/DEF
KEEP buffer cache	0.00	0.00	0.00	0.00	STA/
PGA Target	1,120.00	1,120.00	1,120.00	1,120.00	STA/
RECYCLE buffer cache	0.00	0.00	0.00	0.00	STA/
SGA Target	2,080.00	2,080.00	2,080.00	2,080.00	STA/
Shared IO Pool	0.00	0.00	0.00	0.00	STA/
java pool	16.00	16.00	16.00	16.00	STA/
large pool	16.00	16.00	16.00	16.00	STA/
shared pool	944.00	944.00	944.00	1,136.00	SHR/DEF
streams pool	0.00	0.00	0.00	0.00	STA/

Back to Memory Statistics
Back to Top

Memory Resize Operations Summary

No data exists for this section of the report.

Back to Memory Statistics
Back to Top

Memory Resize Ops

No data exists for this section of the report.

Back to Memory Statistics
Back to Top

Process Memory Summary

B: Begin Snap E: End Snap
All rows below contain absolute values (i.e. not diffed over the interval)
Max Alloc is Maximum PGA Allocation size at snapshot time
Hist Max Alloc is the Historical Max Allocation for still-connected processes
ordered by Begin/End snapshot, Alloc (MB) desc

	Category	Alloc (MB)	Used (MB)	Avg Alloc (MB)	Std Dev Alloc (MB)	Max Alloc (MB)	Hist Max Alloc (MB)	Num Proc	Num Alloc
B	Other	205.46		2.48	5.91	37	37	83	83
	Freeable	53.88	0.00	2.84	7.72	34		19	19
	SQL	1.32	0.84	0.02	0.02	0	2	67	62
	PL/SQL	1.29	1.00	0.02	0.05	0	0	81	81
E	Other	227.58		2.13	5.23	37	37	107	107
	Freeable	61.94	0.00	2.48	6.71	34		25	25
	SQL	3.78	2.97	0.04	0.15	1	5	91	86
	PL/SQL	1.85	1.47	0.02	0.05	0	0	105	105

Back to Memory Statistics
Back to Top

SGA Memory Summary

SGA regions	Begin Size (Bytes)	End Size (Bytes) (if different)
Database Buffers	1,124,073,472
Fixed Size	2,217,952
Redo Buffers	16,343,040
Variable Size	2,197,817,376

Back to Memory Statistics
Back to Top

SGA breakdown difference

ordered by Pool, Name
N/A value for Begin MB or End MB indicates the size of that Pool/Name was insignificant, or zero in that snapshot

Pool	Name	Begin MB	End MB	% Diff
java	free memory	16.00	16.00	0.00
large	PX msg pool	7.81	7.81	0.00
large	free memory	8.19	8.19	0.00
shared	ASH buffers	15.50	15.50	0.00
shared	CCUR	85.22	84.25	-1.14
shared	FileOpenBlock	15.20	15.20	0.00
shared	KGLH0	11.81	11.78	-0.26
shared	KGLHD	20.94	20.93	-0.01
shared	KGLS	11.50	11.26	-2.03
shared	PCUR	45.73	45.79	0.12
shared	PLMCD	10.84	13.01	20.01
shared	SQLA	413.61	403.52	-2.44
shared	event statistics per sess	9.50	9.50	0.00
shared	free memory	139.55	149.46	7.10
shared	private strands	11.04	11.04	0.00
	buffer_cache	1,072.00	1,072.00	0.00
	fixed_sga	2.12	2.12	0.00
	log_buffer	15.59	15.59	0.00

Back to Memory Statistics
Back to Top

Streams Statistics

Streams CPU/IO Usage
Streams Capture
Streams Capture Rate
Streams Apply
Streams Apply Rate
Buffered Queues
Buffered Queue Subscribers
Rule Set
Persistent Queues
Persistent Queues Rate
Persistent Queue Subscribers

Streams CPU/IO Usage

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Capture

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Capture Rate

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Apply

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Streams Apply Rate

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Buffered Queues

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Buffered Queue Subscribers

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Rule Set

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Persistent Queues

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Persistent Queues Rate

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Persistent Queue Subscribers

No data exists for this section of the report.

Back to Streams Statistics
Back to Top

Resource Limit Stats

No data exists for this section of the report.

Shared Server Statistics

Shared Servers Activity
Shared Servers Rates
Shared Servers Utilization
Shared Servers Common Queue
Shared Servers Dispatchers

Shared Servers Activity

Values represent averages for all samples

Avg Total Connections	Avg Active Connections	Avg Total Shared Srvrs	Avg Active Shared Srvrs	Avg Total Dispatchers	Avg Active Dispatchers
0	0	1	0	1	0

Back to Shared Server Statistics
Back to Top

Shared Servers Rates

Common Queue Per Sec	Disp Queue Per Sec	Server Msgs/Sec	Server KB/Sec	Common Queue Total	Disp Queue Total	Server Total Msgs	Server Total(KB)
0	0	0	0.00	0	0	0	0

Back to Shared Server Statistics
Back to Top

Shared Servers Utilization

Statistics are combined for all servers
Incoming and Outgoing Net % are included in %Busy

Total Server Time (s)	%Busy	%Idle	Incoming Net %	Outgoing Net %
3,607	0.00	100.00	0.00	0.00

Back to Shared Server Statistics
Back to Top

Shared Servers Common Queue

No data exists for this section of the report.

Back to Shared Server Statistics
Back to Top

Shared Servers Dispatchers

Ordered by %Busy, descending
Total Queued, Total Queue Wait and Avg Queue Wait are for dispatcher queue
Name suffixes: "(N)" - dispatcher started between begin and end snapshots "(R)" - dispatcher re-started between begin and end snapshots

Name	Avg Conns	Total Disp Time (s)	%Busy	%Idle	Total Queued	Total Queue Wait (s)	Avg Queue Wait (ms)
D000	0.00	3,607	0.00	100.00	0	0

Back to Shared Server Statistics
Back to Top

init.ora Parameters

if IP/Public/Source at End snap is different a '*' is displayed

Parameter Name	Begin value	End value (if different)
audit_file_dest	/u01/app/oracle/admin/orc11g/adump
audit_trail	DB
compatible	11.2.0.0.0
control_files	/u01/app/oracle/oradata/orc11g/control01.ctl, /u01/app/oracle/flash_recovery_area/orc11g/control02.ctl
db_block_size	8192
db_domain
db_name	orc11g
db_recovery_file_dest	/u01/app/oracle/flash_recovery_area
db_recovery_file_dest_size	4070572032
diagnostic_dest	/u01/app/oracle
dispatchers	(PROTOCOL=TCP) (SERVICE=orc11gXDB)
log_archive_dest_1	LOCATION=/u01/arch
memory_target	3355443200
open_cursors	1000
processes	500
remote_login_passwordfile	EXCLUSIVE
undo_tablespace	UNDOTBS1

Dynamic Remastering Stats

No data exists for this section of the report.

End of Report

Buffer Nowait %:	100.00	Redo NoWait %:	100.00
Buffer Hit %:	99.98	In-memory Sort %:	100.00
Library Hit %:	99.85	Soft Parse %:	99.57
Execute to Parse %:	84.18	Latch Hit %:	99.94
Parse CPU to Parse Elapsd %:	81.90	% Non-Parse CPU:	99.29