ASH Report For BAP/BAP_STB (PHYSICAL STANDBY)

DB Name DB Id Instance Inst num Release RAC Host

BAP 662651641 BAP_STB 1 11.2.0.3.0 NO T9DB03

DB Name	DB Id	Instance	Inst num	Release	RAC	Host
BAP	662651641	BAP_STB	1	11.2.0.3.0	NO	T9DB03

CPUs SGA Size Buffer Cache Shared Pool ASH Buffer Size

80 326,217M (100%) 296,960M (91.0%) 28,160M (8.6%) 160.0M (0.0%)

CPUs	SGA Size	Buffer Cache	Shared Pool	ASH Buffer Size
80	326,217M (100%)	296,960M (91.0%)	28,160M (8.6%)	160.0M (0.0%)

Sample Time Data Source

Analysis Begin Time: 22-1月 -15 01:40:00 V$ACTIVE_SESSION_HISTORY

Analysis End Time: 22-1月 -15 01:55:00 V$ACTIVE_SESSION_HISTORY

Elapsed Time: 15.0 (mins)

Sample Count: 996

Average Active Sessions: 1.11

Avg. Active Session per CPU: 0.01

Report Target: None specified

	Sample Time	Data Source
Analysis Begin Time:	22-1月 -15 01:40:00	V$ACTIVE_SESSION_HISTORY
Analysis End Time:	22-1月 -15 01:55:00	V$ACTIVE_SESSION_HISTORY
Elapsed Time:	15.0 (mins)
Sample Count:	996
Average Active Sessions:	1.11
Avg. Active Session per CPU:	0.01
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	92.97	1.03

Top Background Events

Event	Event Class	% Activity	Avg Active Sessions
CPU + Wait for CPU	CPU	3.51	0.04
ASM file metadata operation	Other	1.51	0.02
control file sequential read	System I/O	1.20	0.01

Top Event P1/P2/P3 Values

Event	% Event	P1 Value, P2 Value, P3 Value	% Activity	Parameter 1	Parameter 2	Parameter 3
ASM file metadata operation	1.61	"17","0","0"	1.10	msgop	locn	NOT DEFINED
control file sequential read	1.20	"0","1","1"	0.40	file#	block#	blocks

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	92.97	UNNAMED	92.97
SYS$BACKGROUND	UNNAMED	6.63	UNNAMED	6.63

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	9	93.17	1.03

Back to Load Profile
Back to Top

Top Phases of Execution

Phase of Execution	% Activity	Avg Active Sessions
SQL Execution	93.07	1.03

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
267u084sjc4rc	581374162	15	87.95	CPU + Wait for CPU	87.95	INDEX - RANGE SCAN	25.00	select d.TRAN_SNO DTRAN_SNO, t...
g74ktwbsq92nb	971144020	14	2.01	CPU + Wait for CPU	2.01	TABLE ACCESS - BY INDEX ROWID	1.41	select NVL(sum(LAST_BL), 0) fr...
2ft8y8wd23u6w	212606098	11	1.10	CPU + Wait for CPU	1.10	TABLE ACCESS - FULL	1.10	select * from(select a.*, rown...

Top SQL with Top Row Sources

SQL ID	PlanHash	Sampled # of Executions	% Activity	Row Source	% RwSrc	Top Event	% Event	SQL Text
267u084sjc4rc	581374162	15	87.95	INDEX - RANGE SCAN	25.00	CPU + Wait for CPU	25.00	select d.TRAN_SNO DTRAN_SNO, t...
267u084sjc4rc	581374162	15	87.95180722891566265060240963855421686747	TABLE ACCESS - BY GLOBAL INDEX ROWID	24.60	CPU + Wait for CPU	24.60
267u084sjc4rc	581374162	15	87.95180722891566265060240963855421686747	TABLE ACCESS - BY GLOBAL INDEX ROWID	23.59	CPU + Wait for CPU	23.59
g74ktwbsq92nb	971144020	14	2.01	TABLE ACCESS - BY INDEX ROWID	1.41	CPU + Wait for CPU	1.41	select NVL(sum(LAST_BL), 0) fr...
2ft8y8wd23u6w	212606098	11	1.10	TABLE ACCESS - FULL	1.10	CPU + Wait for CPU	1.10	select * from(select a.*, rown...

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

267u084sjc4rc select d.TRAN_SNO DTRAN_SNO, t.ORN_ORD_NO TRAN_SNO, t.AMT TRAN_AMT, d.VCH_CD, d.DC_FLG, t.BL_DRT FUNDSDRT, d.CR_AMT, d.DR_AMT, d.SYS_DT, d.SBJ_NO, d.ATOM_TRAN_TYP, d.AC_NO DAC_NO, t.EVT_DT, t.AC_NO, d.AMS_SNO, t.SNO, t.SUB_TCD from (select /*+ index(T_AMS_AC_PMT_DTL T_AMS_AC_PMT_DTL_IDX4) */ dl.* from (select * from ams.T_AMS_AC_PMT_DTL where ADT=:1 and adt_bno=:2 ) dl inner join ams.T_AMS _AC_IF f on f.AC_NO=dl.AC_NO where f.SBJ_NO=:3 ) t full outer join (select /*+ index(T_AIS_GL_DTL_D T_AIS_GL_DTL_D_IDX6) */ * from ais.T_AIS_GL_DTL_D where ADT=:4 and abno=:5 and sbj_no=:6 ) d on d.AMS_SNO=t.SNO

2ft8y8wd23u6w select * from(select a.*, rownum rn from( select mi.USR_ID as "usrId", mi.IN_MNO as "inMno", mi.mno as "mno", mi.MEC_TYPE_FLAG as "mecTypeFlag", mi.MEC_CONNENT_TYPE as "mecConnentType", mi.MEC_SOURCE as "mecSource", mi.IS_XW as "isXw", mi.PARENT_IN_MNO as "parentInMno", mi.mec_typ as "mecTyp" ;, mi.mec_sts as "mecSts", mi.MEC_FEE_TYP as "mecFeeTyp", mi.bus_overview as "busOverview", mi.mec_prov_cd as "mecProvCd", mi.mec_city_cd as "mecCityCd", mi.mec_dist_cd as "mecDistCd", (select ar.area_nm from BAP.t_bap_cde_area ar where ar.area_id = mi.mec_prov_cd) as "mecProvNm", (select ar.area_nm from BAP.t_bap_cde_area ar where ar.area_id = mi.mec_city_cd) as "mecCityNm", (select ar.area_nm from BAP.t_ba p_cde_area ar where ar.area_id = mi.mec_dist_cd) as "mecDistNm", mi.cpr_typ as "cprTyp", mi.cs_tel_no as "csTelNo", mi.cup_code as "cupCode", mi.cpr_reg_nm_cn as "cprRegNmCn", mi.cpr_oper_nm_cn as "cprOperNmCn", mi.CPR_REG_NM_EN as "cprRegNmEn", mi.CPR_OPER_NM_EN as "cprOperNmEn", mi.ATV_FLG as "atvFlg", mi.sys_id as "sysId", mi.UTE_STFF_NO as "uteStffNo", mi.CTE_STFF_NO as &q uot;cteStffNo", mi.DT_CTE as "dtCte", mi.DT_UTE as "dtUte", mi.TM_UTE as "tmUte", mi.TM_CTE as "tmCte", d.bus_addr as "busAddr", d.cont_nm_cn as "contNmCn", d.cont_tel_no as "contTelNo", (select count(1) from PTS.T_PTS_TIF_IF ti where ti.in_mno = mi.in_mno) as "posNum" from BAP.t_bap_mec_if mi left join BAP.t_bap_mec_if_detail d on d.in_mno = mi.in_mno where mi.parent_in_mno = :1 ) a where rownum <= : 2 ) where rn >:3

g74ktwbsq92nb select NVL(sum(LAST_BL), 0) from ams.T_AMS_AC_IF where ADT=:1 and ADT_BNO=:2 and SBJ_NO = :3

SQL Id	SQL Text
267u084sjc4rc	select d.TRAN_SNO DTRAN_SNO, t.ORN_ORD_NO TRAN_SNO, t.AMT TRAN_AMT, d.VCH_CD, d.DC_FLG, t.BL_DRT FUNDSDRT, d.CR_AMT, d.DR_AMT, d.SYS_DT, d.SBJ_NO, d.ATOM_TRAN_TYP, d.AC_NO DAC_NO, t.EVT_DT, t.AC_NO, d.AMS_SNO, t.SNO, t.SUB_TCD from (select /+ index(T_AMS_AC_PMT_DTL T_AMS_AC_PMT_DTL_IDX4) / dl.* from (select * from ams.T_AMS_AC_PMT_DTL where ADT=:1 and adt_bno=:2 ) dl inner join ams.T_AMS _AC_IF f on f.AC_NO=dl.AC_NO where f.SBJ_NO=:3 ) t full outer join (select /+ index(T_AIS_GL_DTL_D T_AIS_GL_DTL_D_IDX6) / * from ais.T_AIS_GL_DTL_D where ADT=:4 and abno=:5 and sbj_no=:6 ) d on d.AMS_SNO=t.SNO
2ft8y8wd23u6w	select * from(select a.*, rownum rn from( select mi.USR_ID as "usrId", mi.IN_MNO as "inMno", mi.mno as "mno", mi.MEC_TYPE_FLAG as "mecTypeFlag", mi.MEC_CONNENT_TYPE as "mecConnentType", mi.MEC_SOURCE as "mecSource", mi.IS_XW as "isXw", mi.PARENT_IN_MNO as "parentInMno", mi.mec_typ as "mecTyp" ;, mi.mec_sts as "mecSts", mi.MEC_FEE_TYP as "mecFeeTyp", mi.bus_overview as "busOverview", mi.mec_prov_cd as "mecProvCd", mi.mec_city_cd as "mecCityCd", mi.mec_dist_cd as "mecDistCd", (select ar.area_nm from BAP.t_bap_cde_area ar where ar.area_id = mi.mec_prov_cd) as "mecProvNm", (select ar.area_nm from BAP.t_bap_cde_area ar where ar.area_id = mi.mec_city_cd) as "mecCityNm", (select ar.area_nm from BAP.t_ba p_cde_area ar where ar.area_id = mi.mec_dist_cd) as "mecDistNm", mi.cpr_typ as "cprTyp", mi.cs_tel_no as "csTelNo", mi.cup_code as "cupCode", mi.cpr_reg_nm_cn as "cprRegNmCn", mi.cpr_oper_nm_cn as "cprOperNmCn", mi.CPR_REG_NM_EN as "cprRegNmEn", mi.CPR_OPER_NM_EN as "cprOperNmEn", mi.ATV_FLG as "atvFlg", mi.sys_id as "sysId", mi.UTE_STFF_NO as "uteStffNo", mi.CTE_STFF_NO as &q uot;cteStffNo", mi.DT_CTE as "dtCte", mi.DT_UTE as "dtUte", mi.TM_UTE as "tmUte", mi.TM_CTE as "tmCte", d.bus_addr as "busAddr", d.cont_nm_cn as "contNmCn", d.cont_tel_no as "contTelNo", (select count(1) from PTS.T_PTS_TIF_IF ti where ti.in_mno = mi.in_mno) as "posNum" from BAP.t_bap_mec_if mi left join BAP.t_bap_mec_if_detail d on d.in_mno = mi.in_mno where mi.parent_in_mno = :1 ) a where rownum <= : 2 ) where rn >:3
g74ktwbsq92nb	select NVL(sum(LAST_BL), 0) from ams.T_AMS_AC_IF where ADT=:1 and ADT_BNO=:2 and SBJ_NO = :3

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	928	93.17	1.03
LOGOFF	45	4.52	0.05

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
2245, 339	89.96	CPU + Wait for CPU	89.96	QUERY	JDBC Thin Client	896/900 [100%]
1749, 149	4.52	CPU + Wait for CPU	1.51	SYS	oracle@T9DB03 (PR00)	15/900 [ 2%]
1749, 149	4.5180722891566265060240963855421686747	ASM file metadata operation	1.41	SYS	oracle@T9DB03 (PR00)	14/900 [ 2%]
1749, 149	4.5180722891566265060240963855421686747	control file sequential read	1.20	SYS	oracle@T9DB03 (PR00)	12/900 [ 1%]
305, 1	1.00	CPU + Wait for CPU	1.00	SYS	oracle@T9DB03 (DIA0)	10/900 [ 1%]
2131, 437	1.00	CPU + Wait for CPU	1.00	QUERY	JDBC Thin Client	10/900 [ 1%]

Top Blocking Sessions

No data exists for this section of the report.

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	E vent	Event Count	% Event
01:40:00 (0 secs)	1	CPU + Wait for CPU	1	0.10
01:40:00 (2.0 min)	133	CPU + Wait for CPU	128	12.85
01:40:00 (2.0 min)	133	control file sequential read	2	0.20
01:40:00 (2.0 min)	133	ASM file metadata operation	1	0.10
01:42:00 (2.0 min)	129	CPU + Wait for CPU	124	12.45
01:42:00 (2.0 min)	129	ASM file metadata operation	3	0.30
01:42:00 (2.0 min)	129	control file sequential read	1	0.10
01:44:00 (2.0 min)	139	CPU + Wait for CPU	131	13.15
01:44:00 (2.0 min)	139	control file sequential read	4	0.40
01:44:00 (2.0 min)	139	ASM file metadata operation	3	0.30
01:46:00 (2.0 min)	132	CPU + Wait for CPU	128	12.85
01:46:00 (2.0 min)	132	ASM file metadata operation	3	0.30
01:46:00 (2.0 min)	132	control file sequential read	1	0.10
01:48:00 (2.0 min)	132	CPU + Wait for CPU	129	12.95
01:48:00 (2.0 min)	132	control file sequential read	2	0.20
01:48:00 (2.0 min)	132	ASM file metadata operation	1	0.10
01:50:00 (2.0 min)	133	CPU + Wait for CPU	131	13.15
01:50:00 (2.0 min)	133	ASM file metadata operation	2	0.20
01:52:00 (2.0 min)	127	CPU + Wait for CPU	124	12.45
01:52:00 (2.0 min)	127	log file sequential read	2	0.20
01:52:00 (2.0 min)	127	ASM file metadata operation	1	0.10
01:54:00 (60 secs)	70	CPU + Wait for CPU	65	6.53
01:54:00 (60 secs)	70	ASM file metadata operation	2	0.20
01:54:00 (60 secs)	70	control file sequential read	2	0.20

End of Report