ASH Report For AM2A/AM2A

DB Name DB Id Instance Inst num Release RAC Host

AM2A 2280179506 AM2A 1 11.2.0.1.0 NO gstqa010b

DB Name	DB Id	Instance	Inst num	Release	RAC	Host
AM2A	2280179506	AM2A	1	11.2.0.1.0	NO	gstqa010b

CPUs SGA Size Buffer Cache Shared Pool ASH Buffer Size

2 3,058M (100%) 2,448M (80.0%) 466M (15.2%) M (%)

CPUs	SGA Size	Buffer Cache	Shared Pool	ASH Buffer Size
2	3,058M (100%)	2,448M (80.0%)	466M (15.2%)	M (%)

Sample Time Data Source

Analysis Begin Time: 29-Oct-13 10:30:00 DBA_HIST_ACTIVE_SESS_HISTORY
in AWR snapshot 16600

Analysis End Time: 29-Oct-13 11:20:00 DBA_HIST_ACTIVE_SESS_HISTORY
in AWR snapshot 16601

Elapsed Time: 50.0 (mins)

Sample Count: 17

Average Active Sessions: 0.06

Avg. Active Session per CPU: 0.03

Report Target: None specified

	Sample Time	Data Source
Analysis Begin Time:	29-Oct-13 10:30:00	DBA_HIST_ACTIVE_SESS_HISTORY in AWR snapshot 16600
Analysis End Time:	29-Oct-13 11:20:00	DBA_HIST_ACTIVE_SESS_HISTORY in AWR snapshot 16601
Elapsed Time:	50.0 (mins)
Sample Count:	17
Average Active Sessions:	0.06
Avg. Active Session per CPU:	0.03
Report Target:	None specified

Top Events

Top User Events
Top Background Events
Top Event P1/P2/P3 Values

Top User Events

Event	Event Class	% Event	Avg Active Sessions
CPU + Wait for CPU	CPU	64.71	0.04
log file sync	Commit	5.88	0.00

Top Background Events

Event	Event Class	% Activity	Avg Active Sessions
control file parallel write	System I/O	11.76	0.01
CPU + Wait for CPU	CPU	5.88	0.00
db file async I/O submit	System I/O	5.88	0.00
log file parallel write	System I/O	5.88	0.00

Top Event P1/P2/P3 Values

Event	% Event	P1 Value, P2 Value, P3 Value	% Activity	Parameter 1	Parameter 2	Parameter 3
control file parallel write	11.76	"2","3","2"	11.76	files	block#	requests
db file async I/O submit	5.88	"3","0","0"	5.88	requests	interrupt	timeout
log file parallel write	5.88	"1","4","2"	5.88	files	blocks	requests
log file sync	5.88	"2260","104677982","0"	5.88	buffer#	sync scn	NOT DEFINED

Load Profile

Top Service/Module
Top Client IDs
Top SQL Command Types
Top Phases of Execution

Top Service/Module

Service	Module	% Activity	Action	% Action
SYS$USERS	JDBC Thin Client	70.59	UNNAMED	70.59
SYS$BACKGROUND	UNNAMED	29.41	UNNAMED	29.41

Back to Load Profile
Back to Top

Top Client IDs

No data exists for this section of the report.

Back to Load Profile
Back to Top

Top SQL Command Types

'Distinct SQLIDs' is the count of the distinct number of SQLIDs with the given SQL Command Type found over all the ASH samples in the analysis period

SQL Command Type	Distinct SQLIDs	% Activity	Avg Active Sessions
SELECT	4	64.71	0.04

Back to Load Profile
Back to Top

Top Phases of Execution

Phase of Execution	% Activity	Avg Active Sessions
SQL Execution	64.71	0.04

Back to Load Profile
Back to Top

Top SQL

Top SQL with Top Events
Top SQL with Top Row Sources
Top SQL using literals
Top Parsing Module/Action
Complete List of SQL Text

Top SQL with Top Events

SQL ID	Planhash	Sampled # of Executions	% Activity	Event	% Event	Top Row Source	% RwSrc	SQL Text
20frb3fpdavaf	3775135828	7	41.18	CPU + Wait for CPU	41.18	HASH JOIN	35.29	SELECT V_ROWNUM, CONT_CONTRACT...
1wm6vm3xr9yv0	1296550816	2	11.76	CPU + Wait for CPU	11.76	HASH JOIN	11.76	SELECT V_ROWNUM, CONT_CONTRACT...
9ukzrv19xdvw6	275220473	0	5.88	CPU + Wait for CPU	5.88	SELECT STATEMENT	5.88	SELECT INVENTORY_MOVEMENT_EAV_...
ffs7zjud4c27w	2759333226	1	5.88	CPU + Wait for CPU	5.88	HASH JOIN	5.88	SELECT t0.V_ROWNUM, t0.APPLIED...

Top SQL with Top Row Sources

SQL ID	PlanHash	Sampled # of Executions	% Activity	Row Source	% RwSrc	Top Event	% Event	SQL Text
20frb3fpdavaf	3775135828	7	41.18	HASH JOIN	35.29	CPU + Wait for CPU	35.29	SELECT V_ROWNUM, CONT_CONTRACT...
				NESTED LOOPS - OUTER	5.88	CPU + Wait for CPU	5.88
1wm6vm3xr9yv0	1296550816	2	11.76	HASH JOIN	11.76	CPU + Wait for CPU	11.76	SELECT V_ROWNUM, CONT_CONTRACT...
9ukzrv19xdvw6	275220473	0	5.88	SELECT STATEMENT	5.88	CPU + Wait for CPU	5.88	SELECT INVENTORY_MOVEMENT_EAV_...
ffs7zjud4c27w	2759333226	1	5.88	HASH JOIN	5.88	CPU + Wait for CPU	5.88	SELECT t0.V_ROWNUM, t0.APPLIED...

Top SQL using literals

No data exists for this section of the report.

Top Parsing Module/Action

No data exists for this section of the report.

Complete List of SQL Text

SQL Id SQL Text

1wm6vm3xr9yv0 SELECT V_ROWNUM, CONT_CONTRACT_CODE, CONT_CONTRACT_TEMPLATE_ID, CONT_CUSTOMER_ID, CONT_DESCRIPTION, CONT_NAME, CONT_PERIOD_END, CONT_PERIOD_START, CONT_REFERENCE_NUMBER, CONT_STATUS, CONT_TRANSACTION_ID, CONTRACT_ID, DAIT_CODE, DAIT_DATA_TYPE_ID, DAIT_DESC_TRANSLATION_ID, DAIT_DESCRIPTION, DAIT_DISPLAY_SEQUENCE, DAIT_FORMAT_MASK, DAIT_MULTIPLICITY, DAIT_NAME, DAIT_NAME_TRANSLATION_ID, DAIT_PERIOD_END, DAIT_PERIOD_START, DAIT_UOM_CODE, DATA_ITEM_TYPE_ID, ENTE_CODE, ENTE_ CREATED_ON, ENTE_DATA_ITEM_TYPE_ID, ENTE_DESC_TRANSLATION_ID, ENTE_DESCRIPTION, ENTE_INSTANCE_TYPE_CODE, ENTE_NAME, ENTE_NAME_TRANSLATION_ID, ENTE_PERIOD_END, ENTE_PERIOD_START, ENTE_PERIOD_TEMPLATE_ID, ENTE_PROC_TEMP_TYPE_CODE, ENTE_SOURCE, ENTE_TIMELINE_PERIOD_TPL_ID, ENTE_TYPE, ENTE_VERSION, ENTITY_TEMPLATE_ID, NOMINATION_SCHED_PERIOD_ID, NOMINATION_SCHED_QUANTITY_ID, NOMINATION_SCHEDULE_ID, NOSC_CONTRACT_ID, NOSC_CREATED_FOR_TIMESTAMP, NOSC_ENTITY_TEMPLATE_ID, NOSC_NAME , NOSC_NOMINATION_SCHED_GROUP_ID, NOSC_RECORDED_TIMESTAMP, NOSC_SCHED_FOR_PERIOD_END, NOSC_SCHED_FOR_PERIOD_START, NOSC_SOURCE, NOSC_STATUS, NOSC_TRANSACTION_ID, NOSP_CUSTOMER_NOMINATION_ID, NOSP_NOMINATION_SCHEDULE_ID, NOSP_PERIOD_TEMPLATE_ID, NOSP_SCHEDULE_PERIOD_END, NOSP_SCHEDULE_PERIOD_QTY_TOTAL, NOSP_SCHEDULE_PERIOD_START, NOSP_STATUS, NOSP_TRANSACTION_ID, NOSQ_COMMENTS, NOSQ_COUNTER_PARTY, NOSQ_MODIFIED, NOSQ_QUANTITY, NOSQ_QUANTITY_TEMPLATE_ID, NOSQ_SERVICE_ID, NOSQ _SOURCE, NOSQ_STATUS, NOSQ_TRANSACTION_ID, QUANTITY_TEMPLATE_ID, QUTE_CODE, QUTE_DATA_ITEM_TYPE_ID, QUTE_DESC_TRANSLATION_ID, QUTE_DESCRIPTION, QUTE_DISPLAY_SEQUENCE, QUTE_ENTERABLE, QUTE_FORMAT_MASK, QUTE_INSTANCE_TYPE_CODE, QUTE_NAME, QUTE_NAME_TRANSLATION_ID, QUTE_PERIOD_END, QUTE_PERIOD_START, QUTE_PRTT_CODE, QUTE_SERVICE_ID, QUTE_SOURCE, QUTE_TYPE, QUTE_VERSION, QUTE_VIEWABLE, SERV_CODE, SERV_DESC_TRANSLATION_ID, SERV_DESCRIPTION, SERV_NAME, SERV_NAME_TRANSLATION_I D, SERV_PERIOD_END, SERV_PERIOD_START, SERV_TRADABLE, SERV_TRANSFERABLE, SERV_TYPE, SERV_UOM_CODE, SERV_VERSION, SERVICE_ID FROM V_NOMINATION_SCHED_QUANTITY WHERE (NOMINATION_SCHEDULE_ID = :1)

20frb3fpdavaf SELECT V_ROWNUM, CONT_CONTRACT_CODE, CONT_CONTRACT_TEMPLATE_ID, CONT_CUSTOMER_ID, CONT_DESCRIPTION, CONT_NAME, CONT_PERIOD_END, CONT_PERIOD_START, CONT_REFERENCE_NUMBER, CONT_STATUS, CONT_TRANSACTION_ID, CONTRACT_ID, DAIT_CODE, DAIT_DATA_TYPE_ID, DAIT_DESC_TRANSLATION_ID, DAIT_DESCRIPTION, DAIT_DISPLAY_SEQUENCE, DAIT_FORMAT_MASK, DAIT_MULTIPLICITY, DAIT_NAME, DAIT_NAME_TRANSLATION_ID, DAIT_PERIOD_END, DAIT_PERIOD_START, DAIT_UOM_CODE, DATA_ITEM_TYPE_ID, ENTE_CODE, ENTE_ CREATED_ON, ENTE_DATA_ITEM_TYPE_ID, ENTE_DESC_TRANSLATION_ID, ENTE_DESCRIPTION, ENTE_INSTANCE_TYPE_CODE, ENTE_NAME, ENTE_NAME_TRANSLATION_ID, ENTE_PERIOD_END, ENTE_PERIOD_START, ENTE_PERIOD_TEMPLATE_ID, ENTE_PROC_TEMP_TYPE_CODE, ENTE_SOURCE, ENTE_TIMELINE_PERIOD_TPL_ID, ENTE_TYPE, ENTE_VERSION, ENTITY_TEMPLATE_ID, NOMINATION_SCHED_PERIOD_ID, NOMINATION_SCHED_QUANTITY_ID, NOMINATION_SCHEDULE_ID, NOSC_CONTRACT_ID, NOSC_CREATED_FOR_TIMESTAMP, NOSC_ENTITY_TEMPLATE_ID, NOSC_NAME , NOSC_NOMINATION_SCHED_GROUP_ID, NOSC_RECORDED_TIMESTAMP, NOSC_SCHED_FOR_PERIOD_END, NOSC_SCHED_FOR_PERIOD_START, NOSC_SOURCE, NOSC_STATUS, NOSC_TRANSACTION_ID, NOSP_CUSTOMER_NOMINATION_ID, NOSP_NOMINATION_SCHEDULE_ID, NOSP_PERIOD_TEMPLATE_ID, NOSP_SCHEDULE_PERIOD_END, NOSP_SCHEDULE_PERIOD_QTY_TOTAL, NOSP_SCHEDULE_PERIOD_START, NOSP_STATUS, NOSP_TRANSACTION_ID, NOSQ_COMMENTS, NOSQ_COUNTER_PARTY, NOSQ_MODIFIED, NOSQ_QUANTITY, NOSQ_QUANTITY_TEMPLATE_ID, NOSQ_SERVICE_ID, NOSQ _SOURCE, NOSQ_STATUS, NOSQ_TRANSACTION_ID, QUANTITY_TEMPLATE_ID, QUTE_CODE, QUTE_DATA_ITEM_TYPE_ID, QUTE_DESC_TRANSLATION_ID, QUTE_DESCRIPTION, QUTE_DISPLAY_SEQUENCE, QUTE_ENTERABLE, QUTE_FORMAT_MASK, QUTE_INSTANCE_TYPE_CODE, QUTE_NAME, QUTE_NAME_TRANSLATION_ID, QUTE_PERIOD_END, QUTE_PERIOD_START, QUTE_PRTT_CODE, QUTE_SERVICE_ID, QUTE_SOURCE, QUTE_TYPE, QUTE_VERSION, QUTE_VIEWABLE, SERV_CODE, SERV_DESC_TRANSLATION_ID, SERV_DESCRIPTION, SERV_NAME, SERV_NAME_TRANSLATION_I D, SERV_PERIOD_END, SERV_PERIOD_START, SERV_TRADABLE, SERV_TRANSFERABLE, SERV_TYPE, SERV_UOM_CODE, SERV_VERSION, SERVICE_ID FROM V_NOMINATION_SCHED_QUANTITY WHERE (((NOSC_STATUS = :1) AND (ENTE_CODE = :2)) AND (NOSC_SCHED_FOR_PERIOD_START = :3)) ORDER BY NOSP_SCHEDULE_PERIOD_START ASC

9ukzrv19xdvw6 SELECT INVENTORY_MOVEMENT_EAV_ID, CREATED_BY, CREATED_ON, ENTITY_ATTRIBUTE_TYPE_ID, LAST_UPDATED_BY, LAST_UPDATED_ON, VALUE, INVENTORY_MOVEMENT_ID FROM INVENTORY_MOVEMENT_EAV WHERE (INVENTORY_MOVEMENT_ID = :1)

ffs7zjud4c27w SELECT t0.V_ROWNUM, t0.APPLIED_TIMELINE_POINT_TPL_ID, t0.DAIT_CODE, t0.DAIT_DATA_TYPE_ID, t0.DAIT_DESC_TRANSLATION_ID, t0.DAIT_DESCRIPTION, t0.DAIT_DISPLAY_SEQUENCE, t0.DAIT_FORMAT_MASK, t0.DAIT_MULTIPLICITY, t0.DAIT_NAME, t0.DAIT_NAME_TRANSLATION_ID, t0.DAIT_PERIOD_END, t0.DAIT_PERIOD_START, t0.DAIT_UOM_CODE, t0.DATA_ITEM_TYPE_ID, t0.INME_ID, t0.INME_TRANSACTION_ID, t0.INMET_CODE, t0.INMET_DESC_TRANSLATION_ID, t0.INMET_DESCRIPTION, t0.INMET_INVENTORY_PERSPECTIVE, t0.INMET_N AME, t0.INMET_NAME_TRANSLATION_ID, t0.INMET_OPERATION, t0.INMET_PERIOD_END, t0.INMET_PERIOD_START, t0.INMET_VERSION, t0.INMO_APPLIED_TIMESTAMP, t0.INMO_COMMENTS, t0.INMO_MOVEMENT_PERIOD_END, t0.INMO_MOVEMENT_PERIOD_START, t0.INMO_QUANTITY, t0.INMO_SOURCE, t0.INMO_STATUS, t0.INMO_TRANSACTION_ID, t0.INMOT_CODE, t0.INMOT_DATA_ITEM_TYPE_ID, t0.INMOT_DESC_TRANSLATION_ID, t0.INMOT_DESCRIPTION, t0.INMOT_NAME, t0.INMOT_NAME_TRANSLATION_ID, t0.INMOT_PERIOD_END, t0.INMOT_PERIOD_START, t0.INMOT_VERSION, t0.INVENTORY_ID, t0.INVENTORY_MEMBERSHIP_TPL_ID, t0.INVENTORY_MOVEMENT_ID, t0.INVENTORY_MOVEMENT_TPL_ID, t0.INVENTORY_TPL_ID, t0.UNIT_OF_MEASURE_ID, t0.UNOM_CODE, t0.UNOM_DESC_TRANSLATION_ID, t0.UNOM_DESCRIPTION, t0.UNOM_NAME, t0.UNOM_NAME_TRANSLATION_ID, t0.UNOM_UNIT_OF_MEASURE_TYPE FROM V_INVENTORY_MOVEMENT t0 WHERE (((((t0.INMET_OPERATION = :1) AND (t0.INMO_STATUS <> :2)) AND (t0.INVENTORY_ID = :3)) AND (t0.INMET_INVENTORY_PERSPECTIVE IN (:4, :5, :6))) AN D (t0.INMO_APPLIED_TIMESTAMP = (SELECT MAX(t1.INMO_APPLIED_TIMESTAMP) FROM V_INVENTORY_MOVEMENT t1 WHERE (((((t1.INMET_OPERATION = :7) AND (t1.INMO_STATUS <> :8)) AND (t1.INVENTORY_ID = :9)) AND (t1.INMET_INVENTORY_PERSPECTIVE IN (:10, :11, :12))) AND (t1.INMO_APPLIED_TIMESTAMP < :13)))))

SQL Id	SQL Text
1wm6vm3xr9yv0	SELECT V_ROWNUM, CONT_CONTRACT_CODE, CONT_CONTRACT_TEMPLATE_ID, CONT_CUSTOMER_ID, CONT_DESCRIPTION, CONT_NAME, CONT_PERIOD_END, CONT_PERIOD_START, CONT_REFERENCE_NUMBER, CONT_STATUS, CONT_TRANSACTION_ID, CONTRACT_ID, DAIT_CODE, DAIT_DATA_TYPE_ID, DAIT_DESC_TRANSLATION_ID, DAIT_DESCRIPTION, DAIT_DISPLAY_SEQUENCE, DAIT_FORMAT_MASK, DAIT_MULTIPLICITY, DAIT_NAME, DAIT_NAME_TRANSLATION_ID, DAIT_PERIOD_END, DAIT_PERIOD_START, DAIT_UOM_CODE, DATA_ITEM_TYPE_ID, ENTE_CODE, ENTE_ CREATED_ON, ENTE_DATA_ITEM_TYPE_ID, ENTE_DESC_TRANSLATION_ID, ENTE_DESCRIPTION, ENTE_INSTANCE_TYPE_CODE, ENTE_NAME, ENTE_NAME_TRANSLATION_ID, ENTE_PERIOD_END, ENTE_PERIOD_START, ENTE_PERIOD_TEMPLATE_ID, ENTE_PROC_TEMP_TYPE_CODE, ENTE_SOURCE, ENTE_TIMELINE_PERIOD_TPL_ID, ENTE_TYPE, ENTE_VERSION, ENTITY_TEMPLATE_ID, NOMINATION_SCHED_PERIOD_ID, NOMINATION_SCHED_QUANTITY_ID, NOMINATION_SCHEDULE_ID, NOSC_CONTRACT_ID, NOSC_CREATED_FOR_TIMESTAMP, NOSC_ENTITY_TEMPLATE_ID, NOSC_NAME , NOSC_NOMINATION_SCHED_GROUP_ID, NOSC_RECORDED_TIMESTAMP, NOSC_SCHED_FOR_PERIOD_END, NOSC_SCHED_FOR_PERIOD_START, NOSC_SOURCE, NOSC_STATUS, NOSC_TRANSACTION_ID, NOSP_CUSTOMER_NOMINATION_ID, NOSP_NOMINATION_SCHEDULE_ID, NOSP_PERIOD_TEMPLATE_ID, NOSP_SCHEDULE_PERIOD_END, NOSP_SCHEDULE_PERIOD_QTY_TOTAL, NOSP_SCHEDULE_PERIOD_START, NOSP_STATUS, NOSP_TRANSACTION_ID, NOSQ_COMMENTS, NOSQ_COUNTER_PARTY, NOSQ_MODIFIED, NOSQ_QUANTITY, NOSQ_QUANTITY_TEMPLATE_ID, NOSQ_SERVICE_ID, NOSQ _SOURCE, NOSQ_STATUS, NOSQ_TRANSACTION_ID, QUANTITY_TEMPLATE_ID, QUTE_CODE, QUTE_DATA_ITEM_TYPE_ID, QUTE_DESC_TRANSLATION_ID, QUTE_DESCRIPTION, QUTE_DISPLAY_SEQUENCE, QUTE_ENTERABLE, QUTE_FORMAT_MASK, QUTE_INSTANCE_TYPE_CODE, QUTE_NAME, QUTE_NAME_TRANSLATION_ID, QUTE_PERIOD_END, QUTE_PERIOD_START, QUTE_PRTT_CODE, QUTE_SERVICE_ID, QUTE_SOURCE, QUTE_TYPE, QUTE_VERSION, QUTE_VIEWABLE, SERV_CODE, SERV_DESC_TRANSLATION_ID, SERV_DESCRIPTION, SERV_NAME, SERV_NAME_TRANSLATION_I D, SERV_PERIOD_END, SERV_PERIOD_START, SERV_TRADABLE, SERV_TRANSFERABLE, SERV_TYPE, SERV_UOM_CODE, SERV_VERSION, SERVICE_ID FROM V_NOMINATION_SCHED_QUANTITY WHERE (NOMINATION_SCHEDULE_ID = :1)
20frb3fpdavaf	SELECT V_ROWNUM, CONT_CONTRACT_CODE, CONT_CONTRACT_TEMPLATE_ID, CONT_CUSTOMER_ID, CONT_DESCRIPTION, CONT_NAME, CONT_PERIOD_END, CONT_PERIOD_START, CONT_REFERENCE_NUMBER, CONT_STATUS, CONT_TRANSACTION_ID, CONTRACT_ID, DAIT_CODE, DAIT_DATA_TYPE_ID, DAIT_DESC_TRANSLATION_ID, DAIT_DESCRIPTION, DAIT_DISPLAY_SEQUENCE, DAIT_FORMAT_MASK, DAIT_MULTIPLICITY, DAIT_NAME, DAIT_NAME_TRANSLATION_ID, DAIT_PERIOD_END, DAIT_PERIOD_START, DAIT_UOM_CODE, DATA_ITEM_TYPE_ID, ENTE_CODE, ENTE_ CREATED_ON, ENTE_DATA_ITEM_TYPE_ID, ENTE_DESC_TRANSLATION_ID, ENTE_DESCRIPTION, ENTE_INSTANCE_TYPE_CODE, ENTE_NAME, ENTE_NAME_TRANSLATION_ID, ENTE_PERIOD_END, ENTE_PERIOD_START, ENTE_PERIOD_TEMPLATE_ID, ENTE_PROC_TEMP_TYPE_CODE, ENTE_SOURCE, ENTE_TIMELINE_PERIOD_TPL_ID, ENTE_TYPE, ENTE_VERSION, ENTITY_TEMPLATE_ID, NOMINATION_SCHED_PERIOD_ID, NOMINATION_SCHED_QUANTITY_ID, NOMINATION_SCHEDULE_ID, NOSC_CONTRACT_ID, NOSC_CREATED_FOR_TIMESTAMP, NOSC_ENTITY_TEMPLATE_ID, NOSC_NAME , NOSC_NOMINATION_SCHED_GROUP_ID, NOSC_RECORDED_TIMESTAMP, NOSC_SCHED_FOR_PERIOD_END, NOSC_SCHED_FOR_PERIOD_START, NOSC_SOURCE, NOSC_STATUS, NOSC_TRANSACTION_ID, NOSP_CUSTOMER_NOMINATION_ID, NOSP_NOMINATION_SCHEDULE_ID, NOSP_PERIOD_TEMPLATE_ID, NOSP_SCHEDULE_PERIOD_END, NOSP_SCHEDULE_PERIOD_QTY_TOTAL, NOSP_SCHEDULE_PERIOD_START, NOSP_STATUS, NOSP_TRANSACTION_ID, NOSQ_COMMENTS, NOSQ_COUNTER_PARTY, NOSQ_MODIFIED, NOSQ_QUANTITY, NOSQ_QUANTITY_TEMPLATE_ID, NOSQ_SERVICE_ID, NOSQ _SOURCE, NOSQ_STATUS, NOSQ_TRANSACTION_ID, QUANTITY_TEMPLATE_ID, QUTE_CODE, QUTE_DATA_ITEM_TYPE_ID, QUTE_DESC_TRANSLATION_ID, QUTE_DESCRIPTION, QUTE_DISPLAY_SEQUENCE, QUTE_ENTERABLE, QUTE_FORMAT_MASK, QUTE_INSTANCE_TYPE_CODE, QUTE_NAME, QUTE_NAME_TRANSLATION_ID, QUTE_PERIOD_END, QUTE_PERIOD_START, QUTE_PRTT_CODE, QUTE_SERVICE_ID, QUTE_SOURCE, QUTE_TYPE, QUTE_VERSION, QUTE_VIEWABLE, SERV_CODE, SERV_DESC_TRANSLATION_ID, SERV_DESCRIPTION, SERV_NAME, SERV_NAME_TRANSLATION_I D, SERV_PERIOD_END, SERV_PERIOD_START, SERV_TRADABLE, SERV_TRANSFERABLE, SERV_TYPE, SERV_UOM_CODE, SERV_VERSION, SERVICE_ID FROM V_NOMINATION_SCHED_QUANTITY WHERE (((NOSC_STATUS = :1) AND (ENTE_CODE = :2)) AND (NOSC_SCHED_FOR_PERIOD_START = :3)) ORDER BY NOSP_SCHEDULE_PERIOD_START ASC
9ukzrv19xdvw6	SELECT INVENTORY_MOVEMENT_EAV_ID, CREATED_BY, CREATED_ON, ENTITY_ATTRIBUTE_TYPE_ID, LAST_UPDATED_BY, LAST_UPDATED_ON, VALUE, INVENTORY_MOVEMENT_ID FROM INVENTORY_MOVEMENT_EAV WHERE (INVENTORY_MOVEMENT_ID = :1)
ffs7zjud4c27w	SELECT t0.V_ROWNUM, t0.APPLIED_TIMELINE_POINT_TPL_ID, t0.DAIT_CODE, t0.DAIT_DATA_TYPE_ID, t0.DAIT_DESC_TRANSLATION_ID, t0.DAIT_DESCRIPTION, t0.DAIT_DISPLAY_SEQUENCE, t0.DAIT_FORMAT_MASK, t0.DAIT_MULTIPLICITY, t0.DAIT_NAME, t0.DAIT_NAME_TRANSLATION_ID, t0.DAIT_PERIOD_END, t0.DAIT_PERIOD_START, t0.DAIT_UOM_CODE, t0.DATA_ITEM_TYPE_ID, t0.INME_ID, t0.INME_TRANSACTION_ID, t0.INMET_CODE, t0.INMET_DESC_TRANSLATION_ID, t0.INMET_DESCRIPTION, t0.INMET_INVENTORY_PERSPECTIVE, t0.INMET_N AME, t0.INMET_NAME_TRANSLATION_ID, t0.INMET_OPERATION, t0.INMET_PERIOD_END, t0.INMET_PERIOD_START, t0.INMET_VERSION, t0.INMO_APPLIED_TIMESTAMP, t0.INMO_COMMENTS, t0.INMO_MOVEMENT_PERIOD_END, t0.INMO_MOVEMENT_PERIOD_START, t0.INMO_QUANTITY, t0.INMO_SOURCE, t0.INMO_STATUS, t0.INMO_TRANSACTION_ID, t0.INMOT_CODE, t0.INMOT_DATA_ITEM_TYPE_ID, t0.INMOT_DESC_TRANSLATION_ID, t0.INMOT_DESCRIPTION, t0.INMOT_NAME, t0.INMOT_NAME_TRANSLATION_ID, t0.INMOT_PERIOD_END, t0.INMOT_PERIOD_START, t0.INMOT_VERSION, t0.INVENTORY_ID, t0.INVENTORY_MEMBERSHIP_TPL_ID, t0.INVENTORY_MOVEMENT_ID, t0.INVENTORY_MOVEMENT_TPL_ID, t0.INVENTORY_TPL_ID, t0.UNIT_OF_MEASURE_ID, t0.UNOM_CODE, t0.UNOM_DESC_TRANSLATION_ID, t0.UNOM_DESCRIPTION, t0.UNOM_NAME, t0.UNOM_NAME_TRANSLATION_ID, t0.UNOM_UNIT_OF_MEASURE_TYPE FROM V_INVENTORY_MOVEMENT t0 WHERE (((((t0.INMET_OPERATION = :1) AND (t0.INMO_STATUS <> :2)) AND (t0.INVENTORY_ID = :3)) AND (t0.INMET_INVENTORY_PERSPECTIVE IN (:4, :5, :6))) AN D (t0.INMO_APPLIED_TIMESTAMP = (SELECT MAX(t1.INMO_APPLIED_TIMESTAMP) FROM V_INVENTORY_MOVEMENT t1 WHERE (((((t1.INMET_OPERATION = :7) AND (t1.INMO_STATUS <> :8)) AND (t1.INVENTORY_ID = :9)) AND (t1.INMET_INVENTORY_PERSPECTIVE IN (:10, :11, :12))) AND (t1.INMO_APPLIED_TIMESTAMP < :13)))))

Top PL/SQL Procedures

No data exists for this section of the report.

Top Java Workload

No data exists for this section of the report.

Top Call Types

Call Type	Count	% Activity	Avg Active Sessions
V8 Bundled Exec	11	64.71	0.04
COMMIT	1	5.88	0.00

Top Sessions

Top Sessions
Top Blocking Sessions
Top Sessions running PQs

Top Sessions

'# Samples Active' shows the number of ASH samples in which the session was found waiting for that particular event. The percentage shown in this column is calculated with respect to wall clock time and not total database activity.
'XIDs' shows the number of distinct transaction IDs sampled in ASH when the session was waiting for that particular event
For sessions running Parallel Queries, this section will NOT aggregate the PQ slave activity into the session issuing the PQ. Refer to the 'Top Sessions running PQs' section for such statistics.

Sid, Serial#	% Activity	Event	% Event	User	Program	# Samples Active
17, 1577	35.29	CPU + Wait for CPU	35.29	AM2_BASE	JDBC Thin Client	6/300 [ 2%]
6, 1	17.65	control file parallel write	11.76	SYS	oracle@gstqa010b (CKPT)	2/300 [ 1%]
		CPU + Wait for CPU	5.88			1/300 [ 0%]
22, 1255	17.65	CPU + Wait for CPU	17.65	AM2_BASE	JDBC Thin Client	3/300 [ 1%]
145, 569	11.76	CPU + Wait for CPU	5.88	AM2_BASE	JDBC Thin Client	1/300 [ 0%]
		log file sync	5.88			1/300 [ 0%]
5, 1	5.88	db file async I/O submit	5.88	SYS	oracle@gstqa010b (DBW0)	1/300 [ 0%]

Top Blocking Sessions

Blocking session activity percentages are calculated with respect to waits on enqueues, latches and "buffer busy" only
'% Activity' represents the load on the database caused by a particular blocking session
'# Samples Active' shows the number of ASH samples in which the blocking session was found active.
'XIDs' shows the number of distinct transaction IDs sampled in ASH when the blocking session was found active.

Blocking Sid (Inst)	% Activity	Event Caused	% Event	User	Program	# Samples Active	XIDs
130, 1( 1)	5.88	log file sync	5.88	SYS	oracle@gstqa010b (LGWR)	1/300 [ 0%]	0

Top Sessions running PQs

No data exists for this section of the report.

Top Objects/Files/Latches

Top DB Objects
Top DB Files
Top Latches

Top DB Objects

No data exists for this section of the report.

Top DB Files

No data exists for this section of the report.

Top Latches

No data exists for this section of the report.

Activity Over Time

Analysis period is divided into smaller time slots
Top 3 events are reported in each of those slots
'Slot Count' shows the number of ASH samples in that slot
'Event Count' shows the number of ASH samples waiting for that event in that slot
'% Event' is 'Event Count' over all ASH samples in the analysis period

Slot Time (Duration)	Slot Count	Event	Event Count	% Event
10:30:00 (5.0 min)	7	CPU + Wait for CPU	4	23.53
		db file async I/O submit	1	5.88
		log file parallel write	1	5.88
10:40:00 (5.0 min)	1	control file parallel write	1	5.88
10:45:00 (5.0 min)	1	CPU + Wait for CPU	1	5.88
11:00:00 (5.0 min)	3	CPU + Wait for CPU	3	17.65
11:05:00 (5.0 min)	2	CPU + Wait for CPU	1	5.88
		control file parallel write	1	5.88
11:10:00 (5.0 min)	2	CPU + Wait for CPU	2	11.76
11:15:00 (5.0 min)	1	CPU + Wait for CPU	1	5.88

End of Report