ASH Report For AWDDB/awddb

ASH Report For AWDDB/awddb

DB Name	DB Id	Instance	Inst num	Release	RAC	Host
AWDDB	1223021198	awddb	1	10.2.0.1.0	NO	JGCKSSDB

 

CPUs	SGA Size	Buffer Cache	Shared Pool	ASH Buffer Size
16	9,808M (100%)	8,384M (85.5%)	1,133M (11.6%)	29.0M (0.3%)

 

	Sample Time	Data Source
Analysis Begin Time:	27-10月-10 09:01:12	V$ACTIVE_SESSION_HISTORY
Analysis End Time:	27-10月-10 09:06:12	V$ACTIVE_SESSION_HISTORY
Elapsed Time:	5.0 (mins)
Sample Count:	91
Average Active Sessions:	0.30
Avg. Active Session per CPU:	0.02
Report Target:	None specified

ASH Report

• Top Events
• Load Profile
• Top SQL
• Top Sessions
• Top Objects/Files/Latches
• Activity Over Time

Back to Top

---

Top Events

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

Back to Top

Top User Events

Event	Event Class	% Activity	Avg Active Sessions
CPU + Wait for CPU	CPU	52.75	0.16
log file sync	Commit	1.10	0.00

Back to Top Events 
Back to Top

Top Background Events

Event	Event Class	% Activity	Avg Active Sessions
CPU + Wait for CPU	CPU	45.05	0.14
db file parallel write	System I/O	1.10	0.00

Back to Top Events 
Back to Top

Top Event P1/P2/P3 Values

Event	% Event	P1 Value, P2 Value, P3 Value	% Activity	Parameter 1	Parameter 2	Parameter 3
db file parallel write	1.10	"1","0","2147483647"	1.10	requests	interrupt	timeout
log file sync	1.10	"2199","0","0"	1.10	buffer#	NOT DEFINED	NOT DEFINED

Back to Top Events 
Back to Top

 

Load Profile

• Top Service/Module
• Top Client IDs
• Top SQL Command Types

Back to Top

Top Service/Module

Service	Module	% Activity	Action	% Action
SYS$USERS	JDBC Thin Client	50.55	UNNAMED	50.55
SYS$BACKGROUND	UNNAMED	46.15	UNNAMED	46.15
SYS$USERS	Admin Connection	2.20	UNNAMED	2.20
awddb	OEM.DefaultPool	1.10	/database/instance/sitemap	1.10

Back to Load Profile 
Back to Top

Top Client IDs

Client ID	% Activity	Avg Active Sessions	User	Program	Service
SECU@jgckssdb@Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.2	2.20	0.01	SECU	OMS	SYS$USERS
SECU@jgckssdb@Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.2	1.10	0.00	SYSMAN	OMS	awddb

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	16	49.45	0.15

Back to Load Profile 
Back to Top

 

Top SQL

• Top SQL Statements
• Top SQL using literals
• Complete List of SQL Text

Back to Top

Top SQL Statements

SQL ID	Planhash	% Activity	Event	% Event	SQL Text
cxv4s81pts1q9	1986007704	18.68	CPU + Wait for CPU	18.68	SELECT CONTENT FROM XXDM X WHE...
47174j02xb70d	3516538420	12.09	CPU + Wait for CPU	12.09	select * from ( select jbxx0_....
f2yzzhdjsgzfp	3393585987	3.30	CPU + Wait for CPU	3.30	select * from ( select jbxx0_....
5573mfyrgg583	670136327	2.20	CPU + Wait for CPU	2.20	select * from ( select jbxx0_....
1yr8ghjndt7cd	670136327	1.10	CPU + Wait for CPU	1.10	select * from ( select jbxx0_....

Back to Top SQL 
Back to Top

 

Top SQL using literals

No data exists for this section of the report.

Back to Top SQL 
Back to Top

 

Complete List of SQL Text

SQL Id	SQL Text
1yr8ghjndt7cd	select * from ( select jbxx0_.ID as col_0_0_, (to_xxdmzh('XB', jbxx0_.XB) ) as col_1_0_, (to_xxdmzh('ZJLX', jbxx0_.ZJLX) ) as col_2_0_, (to_xxdmzh('MZ', jbxx0_.MZ) ) as col_3_0_, (to_xxdmzh('HYZK', jbxx0_.HYZK) ) as col_4_0_, (to_xxdmzh('XZQH', jbxx0_.HJD) ) as col_5_0_, (to_xxdmzh('XZQH', jbxx0_.XZD) ) as col_6_0_, (to_xxdmzh('WHCD', jbxx0_.WHCD) ) as col_7_0_, (to_xxdmzh('SF', jbxx0_.SF) ) as col_8_0_, (to_xxdmzh('ZC', jbxx0_.ZC) ) as col_9_0_, (to_xxdmzh('GJ', jbxx0_.GJ) ) as col_10_0_, (to_xxdmzh('XZQH', jbxx0_.JG) ) as col_11_0_, (to_xxdmzh('ZZMM', jbxx0_.ZZMM) ) as col_12_0_, (to_xxdmzh('TSSF', trim(jbxx0_.TSSF)) ) as col_13_0_, (to_xxdmzh('ZY', jbxx0_.ZY) ) as col_14_0_, (to_xxdmzh('JKZK', jbxx0_.JKZK) ) as col_15_0_, (to_xxdmmultizh('AJLB', jbxx0_.AY) ) as col_16_0_, (to_xxdmzh('CYLX', jbxx0_.CYLX) ) as col_17_0_, (to_xxdmzh('BAJD', jbxx0_.BAHJ) ) as col_18_0_, (to_xxdmzh('RSXZ', jbxx0_.RSXZ) ) as col_19_0_, (to_xxdmzh('AJLB', jbxx0_.CAAJ) ) as col_20_0_, (to_xxdmzh('SYPZ', jbxx0_.SYPZ) ) as col_21_0_, (to_xxdmzh('DWLX', jbxx0_.DWLX) ) as col_22_0_, (select zdglobal1_.KVALUE from ZD_GLOBAL zdglobal1_ where zdglobal1_.KTYPE='AQDJ' and zdglobal1_.NUMKEY=jbxx0_.AQDJ) as col_23_0_, (to_xxdmzh('CSYY', jbxx0_.CSYY) ) as col_24_0_, (to_xxdmzh('CLJG', jbxx0_.CLJG) ) as col_25_0_, (to_xxdmzh('FJX', jbxx0_.FJX) ) as col_26_0_, jbxx0_.ID as ID28_, jbxx0_.AQDJ as AQDJ28_, jbxx0_.AY as AY28_, jbxx0_.AZB as AZB28_, jbxx0_.BADW as BADW28_, jbxx0_.BAHJ as BAHJ28_, jbxx0_.BAR as BAR28_, jbxx0_.BARJH as BARJH28_, jbxx0_.BHLX as BHLX28_, jbxx0_.BM as BM28_, jbxx0_.BMTY as BMTY28_, jbxx0_.BZ as BZ28_, jbxx0_.CAAJ as CAAJ28_, jbxx0_.CLJG as CLJG28_, jbxx0_.CREATETIME as CREATETIME28_, jbxx0_.CSQX as CSQX28_, jbxx0_.CSRQ as CSRQ28_, jbxx0_.CSSJ as CSSJ28_, jbxx0_.CSYY as CSYY28_, jbxx0_.CYLX as CYLX28_, jbxx0_.DAH as DAH28_, jbxx0_.DBRQ as DBRQ28_, jbxx0_.DH as DH28_, jbxx0_.DWLX as DWLX28_, jbxx0_.EMLX as EMLX28_, jbxx0_.FJX as FJX28_, jbxx0_.FZJL as FZJL28_, jbxx0_.GCBH as GCBH28_, jbxx0_.GJ as GJ28_, jbxx0_.GRJL as GRJL28_, jbxx0_.GYQX as GYQX28_, jbxx0_.GZDW as GZDW28_, jbxx0_.HJD as HJD28_, jbxx0_.HJDXZ as HJDXZ28_, jbxx0_.HX as HX28_, jbxx0_.HXQX as HXQX28_, jbxx0_.HYZK as HYZK28_, jbxx0_.JB as JB28_, jbxx0_.JG as JG28_, jbxx0_.JJ as JJ28_, jbxx0_.JKZK as JKZK28_, jbxx0_.JLRQ as JLRQ28_, jbxx0_.JSBH as JSBH28_, jbxx0_.JSH as JSH28_, jbxx0_.JSHJ as JSHJ28_, jbxx0_.JSLX as JSLX28_, jbxx0_.JSLY as JSLY28_, jbxx0_.JYAQ as JYAQ28_, jbxx0_.JYRQ as JYRQ28_, jbxx0_.LDF as LDF28_, jbxx0_.LSCSYY as LSCSYY28_, jbxx0_.LSFH as LSFH28_, jbxx0_.MZ as MZ28_, jbxx0_.OPERATOR as OPERATOR28_, jbxx0_.PWH as PWH28_, jbxx0_.RSRQ as RSRQ28_, jbxx0_.RSXZ as RSXZ28_, jbxx0_.RYBH as RYBH28_, jbxx0_.RYGLLB as RYGLLB28_, jbxx0_.SAVETIME as SAVETIME28_, jbxx0_.SCBZ as SCBZ28_, jbxx0_.SF as SF28_, jbxx0_.SG as SG28_, jbxx0_.SNBH as SNBH28_, jbxx0_.STATE as STATE28_, jbxx0_.SY as SY28_, jbxx0_ .SYDW as SYDW28_, jbxx0_.SYPZ as SYPZ28_, jbxx0_.SYPZWSH as SYPZWSH28_, jbxx0_.SYR as SYR28_, jbxx0_.TSBJ as TSBJ28_, jbxx0_.TSSF as TSSF28_, jbxx0_.WBRYBH as WBRYBH28_, jbxx0_.WHCD as WHCD28_, jbxx0_.WXDJ as WXDJ28_, jbxx0_.XB as XB28_, jbxx0_.XM as XM28_, jbxx0_.XMPY as XMPY28_, jbxx0_.XQ as XQ28_, jbxx0_.XZD as XZD28_, jbxx0_.XZDXZ as XZDXZ28_, jbxx0_.YGRY as YGRY28_, jbxx0_.ZC as ZC28_, jbxx0_.ZDZY as ZDZY28_, jbxx0_.ZJH as ZJH28_, jbxx0_.ZJLX as ZJLX28_, jbxx0_.ZRDW as ZRDW28_, jbxx0_.ZSZT as ZSZT28_, jbxx0_.ZUC as ZUC28_, jbxx0_.ZWBH as ZWBH28_, jbxx0_.ZY as ZY28_, jbxx0_.ZYAF as ZYAF28_, jbxx0_.ZYRYXGQK as ZYRYXGQK28_, jbxx0_.ZZMM as ZZMM28_, jbxx0_.ZZQSRQ as ZZQSRQ28_ from JBXX jbxx0_ where 1=1 and (jbxx0_.JSH='9999' or jbxx0_.JSH='0351' or jbxx0_.JSH='0352' or jbxx0_.JSH='0353' or jbxx0_.JSH='0354' or jbxx0_.JSH='0355' or jbxx0_.JSH='0356' or jbxx0_.JSH='0357' or jbxx0_.JSH='0358' or jbxx0_.JSH='0359' or jbxx0_.JSH='0360' or jbxx0_.JSH='0361' or jbxx0_.JSH='0362' or jbxx0_.JSH='0363' or jbxx0_.JSH='0364' or jbxx0_.JSH='0365' or jbxx0_.JSH='0366' or jbxx0_.JSH='0367' or jbxx0_.JSH='0368' or jbxx0_.JSH='0401' or jbxx0_.JSH='0402' or jbxx0_.JSH='0403' or jbxx0_.JSH='0404' or jbxx0_.JSH='0405' or jbxx0_.JSH='0406' or jbxx0_.JSH='0407' or jbxx0_.JSH='0408' or jbxx0_.JSH='0409' or jbxx0_.JSH='0410' or jbxx0_.JSH='0411' or jbxx0_.JSH='0412' or jbxx0_.JSH='0413' or jbxx0_.JSH='0414' or jbxx0_.JSH='0415' or jbxx0_.JSH='0501' or jbxx0_.JSH='0502' or jbxx0_.JSH='0503' or jbxx0_.JSH='0504' or jbxx0_.JSH='0505' or jbxx0_.JSH='0506' or jbxx0_.JSH='0507' or jbxx0_.JSH='0508' or jbxx0_.JSH='0509' or jbxx0_.JSH='0510' or jbxx0_.JSH='0511' or jbxx0_.JSH='0512' or jbxx0_.JSH='0513' or jbxx0_.JSH='0514' or jbxx0_.JSH='0515' or jbxx0_.JSH='0516' or jbxx0_.JSH='0517' or jbxx0_.JSH='0518' or jbxx0_.JSH='0519' or jbxx0_.JSH='0601' or jbxx0_.JSH='0602' or jbxx0_.JSH='0603' or jbxx0_.JSH='0604' or jbxx0_.JSH='0605' or jbxx0_.JSH='0606' or jbxx0_.JSH='0607' or jbxx0_.JSH='0608' or jbxx0_.JSH='0609' or jbxx0_.JSH='0610' or jbxx0_.JSH='0611' or jbxx0_.JSH='0612' or jbxx0_.JSH='0613' or jbxx0_.JSH='0614' or jbxx0_.JSH='0615' or jbxx0_.JSH='0616' or jbxx0_.JSH='0617' or jbxx0_.JSH='0618' or jbxx0_.JSH='0619' or jbxx0_.JSH='0620' or jbxx0_.JSH='0621' or jbxx0_.JSH='0622' or jbxx0_.JSH='0623' or jbxx0_.JSH='0624' or jbxx0_.JSH='0625' or jbxx0_.JSH='0626' or jbxx0_.JSH='0627' or jbxx0_.JSH='0628' or jbxx0_.JSH='0629' or jbxx0_.JSH='0630' or jbxx0_.JSH='0103' or jbxx0_.JSH='0104' or jbxx0_.JSH='0105' or jbxx0_.JSH='0106' or jbxx0_.JSH='0107' or jbxx0_.JSH='0108' or jbxx0_.JSH='0109' or jbxx0_.JSH='0110' or jbxx0_.JSH='0111' or jbxx0_.JSH='0112' or jbxx0_.JSH='0113' or jbxx0_.JSH='0114' or jbxx0_.JSH='0115' or jbxx0_.JSH='0116' or jbxx0_.JSH='0117' or jbxx0_.JSH='0118' or jbxx0_.JSH='0119' or jbxx0_.JSH='0120' or jbxx0_.JSH='0121' or jbxx0_.JSH='0122' or jbxx0_.JSH='0123' or jbxx0_.JSH='0124' or jbxx0_.JSH='0125' or jbxx0_.JSH='0126' or jbxx0_.J SH='0127' or jbxx0_.JSH='0128' or jbxx0_.JSH='0129' or jbxx0_.JSH='0130' or jbxx0_.JSH='0131' or jbxx0_.JSH='0132' or jbxx0_.JSH='0133' or jbxx0_.JSH='0134' or jbxx0_.JSH='0135' or jbxx0_.JSH='0136' or jbxx0_.JSH='0137' or jbxx0_.JSH='0138' or jbxx0_.JSH='0139' or jbxx0_.JSH='0201' or jbxx0_.JSH='0202' or jbxx0_.JSH='0203' or jbxx0_.JSH='0204' or jbxx0_.JSH='0205' or jbxx0_.JSH='0206' or jbxx0_.JSH='0207' or jbxx0_.JSH='0208' or jbxx0_.JSH='0209' or jbxx0_.JSH='0210' or jbxx0_.JSH='0211' or jbxx0_.JSH='0212' or jbxx0_.JSH='0213' or jbxx0_.JSH='0214' or jbxx0_.JSH='0215' or jbxx0_.JSH='0216' or jbxx0_.JSH='0217' or jbxx0_.JSH='0218' or jbxx0_.JSH='0219' or jbxx0_.JSH='0101' or jbxx0_.JSH='0102' or jbxx0_.JSH='0220' or jbxx0_.JSH='0221' or jbxx0_.JSH='0222' or jbxx0_.JSH='0223' or jbxx0_.JSH='0224' or jbxx0_.JSH='0225' or jbxx0_.JSH='0226' or jbxx0_.JSH='0227' or jbxx0_.JSH='0228' or jbxx0_.JSH='0229' or jbxx0_.JSH='0230' or jbxx0_.JSH='0231' or jbxx0_.JSH='0232' or jbxx0_.JSH='0233' or jbxx0_.JSH='0234' or jbxx0_.JSH='0235' or jbxx0_.JSH='0236' or jbxx0_.JSH='0237' or jbxx0_.JSH='0238' or jbxx0_.JSH='0239' or jbxx0_.JSH='0240' or jbxx0_.JSH='0241' or jbxx0_.JSH='0242' or jbxx0_.JSH='0243' or jbxx0_.JSH='0244' or jbxx0_.JSH='0245' or jbxx0_.JSH='0246' or jbxx0_.JSH='0247' or jbxx0_.JSH='0248' or jbxx0_.JSH='0301' or jbxx0_.JSH='0302' or jbxx0_.JSH='0303' or jbxx0_.JSH='0304' or jbxx0_.JSH='0305' or jbxx0_.JSH='0306' or jbxx0_.JSH='0307' or jbxx0_.JSH='0308' or jbxx0_.JSH='0309' or jbxx0_.JSH='0310' or jbxx0_.JSH='0311' or jbxx0_.JSH='0312' or jbxx0_.JSH='0313' or jbxx0_.JSH='0314' or jbxx0_.JSH='0315' or jbxx0_.JSH='0316' or jbxx0_.JSH='0317' or jbxx0_.JSH='0318' or jbxx0_.JSH='0319' or jbxx0_.JSH='0320' or jbxx0_.JSH='0321' or jbxx0_.JSH='0322' or jbxx0_.JSH='0323' or jbxx0_.JSH='0324' or jbxx0_.JSH='0325' or jbxx0_.JSH='0326' or jbxx0_.JSH='0327' or jbxx0_.JSH='0328' or jbxx0_.JSH='0329' or jbxx0_.JSH='0330' or jbxx0_.JSH='0331' or jbxx0_.JSH='0332' or jbxx0_.JSH='0333' or jbxx0_.JSH='0334' or jbxx0_.JSH='0335' or jbxx0_.JSH='0336' or jbxx0_.JSH='0337' or jbxx0_.JSH='0338' or jbxx0_.JSH='0339' or jbxx0_.JSH='0340' or jbxx0_.JSH='0341' or jbxx0_.JSH='0342' or jbxx0_.JSH='0343' or jbxx0_.JSH='0344' or jbxx0_.JSH='0345' or jbxx0_.JSH='0346' or jbxx0_.JSH='0347' or jbxx0_.JSH='0348' or jbxx0_.JSH='0349' or jbxx0_.JSH='0350') and jbxx0_.STATE='R8' and (jbxx0_.JSH like '0206%') and jbxx0_.JSBH='310115111' order by jbxx0_.RSRQ desc ) where rownum <= :1
47174j02xb70d	select * from ( select jbxx0_.ID as col_0_0_, (to_xxdmzh('XB', jbxx0_.XB) ) as col_1_0_, (to_xxdmzh('ZJLX', jbxx0_.ZJLX) ) as col_2_0_, (to_xxdmzh('MZ', jbxx0_.MZ) ) as col_3_0_, (to_xxdmzh('HYZK', jbxx0_.HYZK) ) as col_4_0_, (to_xxdmzh('XZQH', jbxx0_.HJD) ) as col_5_0_, (to_xxdmzh('XZQH', jbxx0_.XZD) ) as col_6_0_, (to_xxdmzh('WHCD', jbxx0_.WHCD) ) as col_7_0_, (to_xxdmzh('SF', jbxx0_.SF) ) as col_8_0_, (to_xxdmzh('ZC', jbxx0_.ZC) ) as col_9_0_, (to_xxdmzh('GJ', jbxx0_.GJ) ) as col_10_0_, (to_xxdmzh('XZQH', jbxx0_.JG) ) as col_11_0_, (to_xxdmzh('ZZMM', jbxx0_.ZZMM) ) as col_12_0_, (to_xxdmzh('TSSF', trim(jbxx0_.TSSF)) ) as col_13_0_, (to_xxdmzh('ZY', jbxx0_.ZY) ) as col_14_0_, (to_xxdmzh('JKZK', jbxx0_.JKZK) ) as col_15_0_, (to_xxdmmultizh('AJLB', jbxx0_.AY) ) as col_16_0_, (to_xxdmzh('CYLX', jbxx0_.CYLX) ) as col_17_0_, (to_xxdmzh('BAJD', jbxx0_.BAHJ) ) as col_18_0_, (to_xxdmzh('RSXZ', jbxx0_.RSXZ) ) as col_19_0_, (to_xxdmzh('AJLB', jbxx0_.CAAJ) ) as col_20_0_, (to_xxdmzh('SYPZ', jbxx0_.SYPZ) ) as col_21_0_, (to_xxdmzh('DWLX', jbxx0_.DWLX) ) as col_22_0_, (to_zdzh('AQDJ', jbxx0_.AQDJ) ) as col_23_0_, (to_xxdmzh('CSYY', jbxx0_.CSYY) ) as col_24_0_, (to_xxdmzh('CLJG', jbxx0_.CLJG) ) as col_25_0_, (to_xxdmzh('FJX', jbxx0_.FJX) ) as col_26_0_, jbxx0_.ID as ID28_, jbxx0_.AQDJ as AQDJ28_, jbxx0_.AY as AY28_, jbxx0_.AZB as AZB28_, jbxx0_.BADW as BADW28_, jbxx0_.BAHJ as BAHJ28_, jbxx0_.BAR as BAR28_, jbxx0_.BARJH as BARJH28_, jbxx0_.BHLX as BHLX28 _, jbxx0_.BM as BM28_, jbxx0_.BMTY as BMTY28_, jbxx0_.BZ as BZ28_, jbxx0_.CAAJ as CAAJ28_, jbxx0_.CLJG as CLJG28_, jbxx0_.CREATETIME as CREATETIME28_, jbxx0_.CSQX as CSQX28_, jbxx0_.CSRQ as CSRQ28_, jbxx0_.CSSJ as CSSJ28_, jbxx0_.CSYY as CSYY28_, jbxx0_.CYLX as CYLX28_, jbxx0_.DAH as DAH28_, jbxx0_.DBRQ as DBRQ28_, jbxx0_.DH as DH28_, jbxx0_.DWLX as DWLX28_, jbxx0_.EMLX as EMLX28_, jbxx0_.FJX as FJX28_, jbxx0_.FZJL as FZJL28_, jbxx0_.GCBH as GCBH28_, jbxx0_.GJ as GJ28_, jbxx0_.GRJL as GRJL28_, jbxx0_.GYQX as GYQX28_, jbxx0_.GZDW as GZDW28_, jbxx0_.HJD as HJD28_, jbxx0_.HJDXZ as HJDXZ28_, jbxx0_.HX as HX28_, jbxx0_.HXQX as HXQX28_, jbxx0_.HYZK as HYZK28_, jbxx0_.JB as JB28_, jbxx0_.JG as JG28_, jbxx0_.JJ as JJ28_, jbxx0_.JKZK as JKZK28_, jbxx0_.JLRQ as JLRQ28_, jbxx0_.JSBH as JSBH28_, jbxx0_.JSH as JSH28_, jbxx0_.JSHJ as JSHJ28_, jbxx0_.JSLX as JSLX28_, jbxx0_.JSLY as JSLY28_, jbxx0_.JYAQ as JYAQ28_, jbxx0_.JYRQ as JYRQ28_, jbxx0_.LDF as LDF28_, jbxx0_.LSCSYY as LSCSYY28_, jbxx0_.LSFH as LSFH28_, jbxx0_.MZ as MZ28_, jbxx0_.OPERATOR as OPERATOR28_, jbxx0_.PWH as PWH28_, jbxx0_.RSRQ as RSRQ28_, jbxx0_.RSXZ as RSXZ28_, jbxx0_.RYBH as RYBH28_, jbxx0_.RYGLLB as RYGLLB28_, jbxx0_.SAVETIME as SAVETIME28_, jbxx0_.SCBZ as SCBZ28_, jbxx0_.SF as SF28_, jbxx0_.SG as SG28_, jbxx0_.SNBH as SNBH28_, jbxx0_.STATE as STATE28_, jbxx0_.SY as SY28_, jbxx0_.SYDW as SYDW28_, jbxx0_.SYPZ as SYPZ28_, jbxx0_.SYPZWSH as SYPZWSH28_, jbxx0_.SYR as SYR28_, jbxx0_.TSBJ as TSBJ28_, jbxx0_.TSSF as TSSF28_, jbxx0_.WBRYBH as WBRYBH28_, jbxx0_.WHCD as WHCD28_, jbxx0_.WXDJ as WXDJ28_, jbxx0_.XB as XB28_, jbxx0_.XM as XM28_, jbxx0_.XMPY as XMPY28_, jbxx0_.XQ as XQ28_, jbxx0_.XZD as XZD28_, jbxx0_.XZDXZ as XZDXZ28_, jbxx0_.YGRY as YGRY28_, jbxx0_.ZC as ZC28_, jbxx0_.ZDZY as ZDZY28_, jbxx0_.ZJH as ZJH28_, jbxx0_.ZJLX as ZJLX28_, jbxx0_.ZRDW as ZRDW28_, jbxx0_.ZSZT as ZSZT28_, jbxx0_.ZUC as ZUC28_, jbxx0_.ZWBH as ZWBH28_, jbxx0_.ZY as ZY28_, jbxx0_.ZYAF as ZYAF28_, jbxx0_.ZYRYXGQK as ZYRYXGQK28_, jbxx0_.ZZMM as ZZMM28_, jbxx0_.ZZQSRQ as ZZQSRQ28_ from JBXX jbxx0_ where 1=1 and (jbxx0_.JSH='9999' or jbxx0_.JSH='0101' or jbxx0_.JSH='0102' or jbxx0_.JSH='0103' or jbxx0_.JSH='0104' or jbxx0_.JSH='0105' or jbxx0_.JSH='0106' or jbxx0_.JSH='0107' or jbxx0_.JSH='0108' or jbxx0_.JSH='0109' or jbxx0_.JSH='0110' or jbxx0_.JSH='0111' or jbxx0_.JSH='0112' or jbxx0_.JSH='0113' or jbxx0_.JSH='0114' or jbxx0_.JSH='0115' or jbxx0_.JSH='0116' or jbxx0_.JSH='0201' or jbxx0_.JSH='0202' or jbxx0_.JSH='0203' or jbxx0_.JSH='0204' or jbxx0_.JSH='0205' or jbxx0_.JSH='0206' or jbxx0_.JSH='0207' or jbxx0_.JSH='0208' or jbxx0_.JSH='0209' or jbxx0_.JSH='0210' or jbxx0_.JSH='0211' or jbxx0_.JSH='0212' or jbxx0_.JSH='0213' or jbxx0_.JSH='0214' or jbxx0_.JSH='0215' or jbxx0_.JSH='0216' or jbxx0_.JSH='0217' or jbxx0_.JSH='0218' or jbxx0_.JSH='0219' or jbxx0_.JSH='0301' or jbxx0_.JSH='0302' or jbxx0_.JSH='0303' or jbxx0_.JSH='0304' or jbxx0_.JSH='0305' or jbxx0_.JSH='0306' or jbxx0_.JSH='0307' or jbxx0_.JSH='0308' or jbxx0_.JSH='0309' or jbxx0_.JSH='0310' or jbxx0_.JSH='0311' or jbxx0_.JSH='0312' or jbxx0_.JSH='0313' or jbxx0_.JSH='0314' or jbxx0_.JSH='0315' or jbxx0_.JSH='0316' or jbxx0_.JSH='0317' or jbxx0_.JSH='0318' or jbxx0_.JSH='0319' or jbxx0_.JSH='0401' or jbxx0_.JSH='0402' or jbxx0_.JSH='0403' or jbxx0_.JSH='0404' or jbxx0_.JSH='0405' or jbxx0_.JSH='0406' or jbxx0_.JSH='0407' or jbxx0_.JSH='0408' or jbxx0_.JSH='0409' or jbxx0_.JSH='0410' or jbxx0_.JSH='0411' or jbxx0_.JSH='0412' or jbxx0_.JSH='0413' or jbxx0_.JSH='0414' or jbxx0_.JSH='0415' or jbxx0_.JSH='0416' or jbxx0_.JSH='0501' or jbxx0_.JSH='0502' or jbxx0_.JSH='0503' or jbxx0_.JSH='0504' or jbxx0_.JSH='0505' or jbxx0_.JSH='0506' or jbxx0_.JSH='0507' or jbxx0_.JSH='0508' or jbxx0_.JSH='0509' or jbxx0_.JSH='0510') and jbxx0_.STATE='R7' and jbxx0_.JSBH='310101111' order by jbxx0_.RSRQ desc ) where rownum <= :1
5573mfyrgg583	select * from ( select jbxx0_.ID as col_0_0_, (to_xxdmzh('XB', jbxx0_.XB) ) as col_1_0_, (to_xxdmzh('ZJLX', jbxx0_.ZJLX) ) as col_2_0_, (to_xxdmzh('MZ', jbxx0_.MZ) ) as col_3_0_, (to_xxdmzh('HYZK', jbxx0_.HYZK) ) as col_4_0_, (to_xxdmzh('XZQH', jbxx0_.HJD) ) as col_5_0_, (to_xxdmzh('XZQH', jbxx0_.XZD) ) as col_6_0_, (to_xxdmzh('WHCD', jbxx0_.WHCD) ) as col_7_0_, (to_xxdmzh('SF', jbxx0_.SF) ) as col_8_0_, (to_xxdmzh('ZC', jbxx0_.ZC) ) as col_9_0_, (to_xxdmzh('GJ', jbxx0_.GJ) ) as col_10_0_, (to_xxdmzh('XZQH', jbxx0_.JG) ) as col_11_0_, (to_xxdmzh('ZZMM', jbxx0_.ZZMM) ) as col_12_0_, (to_xxdmzh('TSSF', trim(jbxx0_.TSSF)) ) as col_13_0_, (to_xxdmzh('ZY', jbxx0_.ZY) ) as col_14_0_, (to_xxdmzh('JKZK', jbxx0_.JKZK) ) as col_15_0_, (to_xxdmmultizh('AJLB', jbxx0_.AY) ) as col_16_0_, (to_xxdmzh('CYLX', jbxx0_.CYLX) ) as col_17_0_, (to_xxdmzh('BAJD', jbxx0_.BAHJ) ) as col_18_0_, (to_xxdmzh('RSXZ', jbxx0_.RSXZ) ) as col_19_0_, (to_xxdmzh('AJLB', jbxx0_.CAAJ) ) as col_20_0_, (to_xxdmzh('SYPZ', jbxx0_.SYPZ) ) as col_21_0_, (to_xxdmzh('DWLX', jbxx0_.DWLX) ) as col_22_0_, (to_zdzh('AQDJ', jbxx0_.AQDJ) ) as col_23_0_, (to_xxdmzh('CSYY', jbxx0_.CSYY) ) as col_24_0_, (to_xxdmzh('CLJG', jbxx0_.CLJG) ) as col_25_0_, (to_xxdmzh('FJX', jbxx0_.FJX) ) as col_26_0_, jbxx0_.ID as ID28_, jbxx0_.AQDJ as AQDJ28_, jbxx0_.AY as AY28_, jbxx0_.AZB as AZB28_, jbxx0_.BADW as BADW28_, jbxx0_.BAHJ as BAHJ28_, jbxx0_.BAR as BAR28_, jbxx0_.BARJH as BARJH28_, jbxx0_.BHLX as BHLX28 _, jbxx0_.BM as BM28_, jbxx0_.BMTY as BMTY28_, jbxx0_.BZ as BZ28_, jbxx0_.CAAJ as CAAJ28_, jbxx0_.CLJG as CLJG28_, jbxx0_.CREATETIME as CREATETIME28_, jbxx0_.CSQX as CSQX28_, jbxx0_.CSRQ as CSRQ28_, jbxx0_.CSSJ as CSSJ28_, jbxx0_.CSYY as CSYY28_, jbxx0_.CYLX as CYLX28_, jbxx0_.DAH as DAH28_, jbxx0_.DBRQ as DBRQ28_, jbxx0_.DH as DH28_, jbxx0_.DWLX as DWLX28_, jbxx0_.EMLX as EMLX28_, jbxx0_.FJX as FJX28_, jbxx0_.FZJL as FZJL28_, jbxx0_.GCBH as GCBH28_, jbxx0_.GJ as GJ28_, jbxx0_.GRJL as GRJL28_, jbxx0_.GYQX as GYQX28_, jbxx0_.GZDW as GZDW28_, jbxx0_.HJD as HJD28_, jbxx0_.HJDXZ as HJDXZ28_, jbxx0_.HX as HX28_, jbxx0_.HXQX as HXQX28_, jbxx0_.HYZK as HYZK28_, jbxx0_.JB as JB28_, jbxx0_.JG as JG28_, jbxx0_.JJ as JJ28_, jbxx0_.JKZK as JKZK28_, jbxx0_.JLRQ as JLRQ28_, jbxx0_.JSBH as JSBH28_, jbxx0_.JSH as JSH28_, jbxx0_.JSHJ as JSHJ28_, jbxx0_.JSLX as JSLX28_, jbxx0_.JSLY as JSLY28_, jbxx0_.JYAQ as JYAQ28_, jbxx0_.JYRQ as JYRQ28_, jbxx0_.LDF as LDF28_, jbxx0_.LSCSYY as LSCSYY28_, jbxx0_.LSFH as LSFH28_, jbxx0_.MZ as MZ28_, jbxx0_.OPERATOR as OPERATOR28_, jbxx0_.PWH as PWH28_, jbxx0_.RSRQ as RSRQ28_, jbxx0_.RSXZ as RSXZ28_, jbxx0_.RYBH as RYBH28_, jbxx0_.RYGLLB as RYGLLB28_, jbxx0_.SAVETIME as SAVETIME28_, jbxx0_.SCBZ as SCBZ28_, jbxx0_.SF as SF28_, jbxx0_.SG as SG28_, jbxx0_.SNBH as SNBH28_, jbxx0_.STATE as STATE28_, jbxx0_.SY as SY28_, jbxx0_.SYDW as SYDW28_, jbxx0_.SYPZ as SYPZ28_, jbxx0_.SYPZWSH as SYPZWSH28_, jbxx0_.SYR as SYR28_, jbxx0_.TSBJ as TSBJ28_, jbxx0_.TSSF as TSSF28_, jbxx0_.WBRYBH as WBRYBH28_, jbxx0_.WHCD as WHCD28_, jbxx0_.WXDJ as WXDJ28_, jbxx0_.XB as XB28_, jbxx0_.XM as XM28_, jbxx0_.XMPY as XMPY28_, jbxx0_.XQ as XQ28_, jbxx0_.XZD as XZD28_, jbxx0_.XZDXZ as XZDXZ28_, jbxx0_.YGRY as YGRY28_, jbxx0_.ZC as ZC28_, jbxx0_.ZDZY as ZDZY28_, jbxx0_.ZJH as ZJH28_, jbxx0_.ZJLX as ZJLX28_, jbxx0_.ZRDW as ZRDW28_, jbxx0_.ZSZT as ZSZT28_, jbxx0_.ZUC as ZUC28_, jbxx0_.ZWBH as ZWBH28_, jbxx0_.ZY as ZY28_, jbxx0_.ZYAF as ZYAF28_, jbxx0_.ZYRYXGQK as ZYRYXGQK28_, jbxx0_.ZZMM as ZZMM28_, jbxx0_.ZZQSRQ as ZZQSRQ28_ from JBXX jbxx0_ where 1=1 and (jbxx0_.JSH='9999' or jbxx0_.JSH='0351' or jbxx0_.JSH='0352' or jbxx0_.JSH='0353' or jbxx0_.JSH='0354' or jbxx0_.JSH='0355' or jbxx0_.JSH='0356' or jbxx0_.JSH='0357' or jbxx0_.JSH='0358' or jbxx0_.JSH='0359' or jbxx0_.JSH='0360' or jbxx0_.JSH='0361' or jbxx0_.JSH='0362' or jbxx0_.JSH='0363' or jbxx0_.JSH='0364' or jbxx0_.JSH='0365' or jbxx0_.JSH='0366' or jbxx0_.JSH='0367' or jbxx0_.JSH='0368' or jbxx0_.JSH='0401' or jbxx0_.JSH='0402' or jbxx0_.JSH='0403' or jbxx0_.JSH='0404' or jbxx0_.JSH='0405' or jbxx0_.JSH='0406' or jbxx0_.JSH='0407' or jbxx0_.JSH='0408' or jbxx0_.JSH='0409' or jbxx0_.JSH='0410' or jbxx0_.JSH='0411' or jbxx0_.JSH='0412' or jbxx0_.JSH='0413' or jbxx0_.JSH='0414' or jbxx0_.JSH='0415' or jbxx0_.JSH='0501' or jbxx0_.JSH='0502' or jbxx0_.JSH='0503' or jbxx0_.JSH='0504' or jbxx0_.JSH='0505' or jbxx0_.JSH='0506' or jbxx0_.JSH='0507' or jbxx0_.JSH='0508' or jbxx0_.JSH='0509' or jbxx0_.JSH='0510' or jbxx0_.JSH='0511' or jbxx0_.JSH='0512' or jbxx0_.JSH='0513' or jbxx0_.JSH='0514' or jbxx0_.JSH='0515' or jbxx0_.JSH='0516' or jbxx0_.JSH='0517' or jbxx0_.JSH='0518' or jbxx0_.JSH='0519' or jbxx0_.JSH='0601' or jbxx0_.JSH='0602' or jbxx0_.JSH='0603' or jbxx0_.JSH='0604' or jbxx0_.JSH='0605' or jbxx0_.JSH='0606' or jbxx0_.JSH='0607' or jbxx0_.JSH='0608' or jbxx0_.JSH='0609' or jbxx0_.JSH='0610' or jbxx0_.JSH='0611' or jbxx0_.JSH='0612' or jbxx0_.JSH='0613' or jbxx0_.JSH='0614' or jbxx0_.JSH='0615' or jbxx0_.JSH='0616' or jbxx0_.JSH='0617' or jbxx0_.JSH='0618' or jbxx0_.JSH='0619' or jbxx0_.JSH='0620' or jbxx0_.JSH='0621' or jbxx0_.JSH='0622' or jbxx0_.JSH='0623' or jbxx0_.JSH='0624' or jbxx0_.JSH='0625' or jbxx0_.JSH='0626' or jbxx0_.JSH='0627' or jbxx0_.JSH='0628' or jbxx0_.JSH='0629' or jbxx0_.JSH='0630' or jbxx0_.JSH='0103' or jbxx0_.JSH='0104' or jbxx0_.JSH='0105' or jbxx0_.JSH='0106' or jbxx0_.JSH='0107' or jbxx0_.JSH='0108' or jbxx0_.JSH='0109' or jbxx0_.JSH='0110' or jbxx0_.JSH='0111' or jbxx0_.JSH='0112' or jbxx0_.JSH='0113' or jbxx0_.JSH='0114' or jbxx0_.JSH='0115' or jbxx0_.JSH='0116' or jbxx0_.JSH='0117' or jbxx0_.JSH='0118' or jbxx0_.JSH='0119' or jbxx0_.JSH='0120' or jbxx0_.JSH='0121' or jbxx0_.JSH='0122' or jbxx0_.JSH='0123' or jbxx0_.JSH='0124' or jbxx0_.JSH='0125' or jbxx0_.JSH='0126' or jbxx0_.JSH='0127' or jbxx0_.JSH='0128' or jbxx0_.JSH='0129' or jbxx0_.JSH='0130' or jbxx0_.JS H='0131' or jbxx0_.JSH='0132' or jbxx0_.JSH='0133' or jbxx0_.JSH='0134' or jbxx0_.JSH='0135' or jbxx0_.JSH='0136' or jbxx0_.JSH='0137' or jbxx0_.JSH='0138' or jbxx0_.JSH='0139' or jbxx0_.JSH='0201' or jbxx0_.JSH='0202' or jbxx0_.JSH='0203' or jbxx0_.JSH='0204' or jbxx0_.JSH='0205' or jbxx0_.JSH='0206' or jbxx0_.JSH='0207' or jbxx0_.JSH='0208' or jbxx0_.JSH='0209' or jbxx0_.JSH='0210' or jbxx0_.JSH='0211' or jbxx0_.JSH='0212' or jbxx0_.JSH='0213' or jbxx0_.JSH='0214' or jbxx0_.JSH='0215' or jbxx0_.JSH='0216' or jbxx0_.JSH='0217' or jbxx0_.JSH='0218' or jbxx0_.JSH='0219' or jbxx0_.JSH='0101' or jbxx0_.JSH='0102' or jbxx0_.JSH='0220' or jbxx0_.JSH='0221' or jbxx0_.JSH='0222' or jbxx0_.JSH='0223' or jbxx0_.JSH='0224' or jbxx0_.JSH='0225' or jbxx0_.JSH='0226' or jbxx0_.JSH='0227' or jbxx0_.JSH='0228' or jbxx0_.JSH='0229' or jbxx0_.JSH='0230' or jbxx0_.JSH='0231' or jbxx0_.JSH='0232' or jbxx0_.JSH='0233' or jbxx0_.JSH='0234' or jbxx0_.JSH='0235' or jbxx0_.JSH='0236' or jbxx0_.JSH='0237' or jbxx0_.JSH='0238' or jbxx0_.JSH='0239' or jbxx0_.JSH='0240' or jbxx0_.JSH='0241' or jbxx0_.JSH='0242' or jbxx0_.JSH='0243' or jbxx0_.JSH='0244' or jbxx0_.JSH='0245' or jbxx0_.JSH='0246' or jbxx0_.JSH='0247' or jbxx0_.JSH='0248' or jbxx0_.JSH='0301' or jbxx0_.JSH='0302' or jbxx0_.JSH='0303' or jbxx0_.JSH='0304' or jbxx0_.JSH='0305' or jbxx0_.JSH='0306' or jbxx0_.JSH='0307' or jbxx0_.JSH='0308' or jbxx0_.JSH='0309' or jbxx0_.JSH='0310' or jbxx0_.JSH='0311' or jbxx0_.JSH='0312' or jbxx0_.JSH='0313' or jbxx0_.JSH='0314' or jbxx0_.JSH='0315' or jbxx0_.JSH='0316' or jbxx0_.JSH='0317' or jbxx0_.JSH='0318' or jbxx0_.JSH='0319' or jbxx0_.JSH='0320' or jbxx0_.JSH='0321' or jbxx0_.JSH='0322' or jbxx0_.JSH='0323' or jbxx0_.JSH='0324' or jbxx0_.JSH='0325' or jbxx0_.JSH='0326' or jbxx0_.JSH='0327' or jbxx0_.JSH='0328' or jbxx0_.JSH='0329' or jbxx0_.JSH='0330' or jbxx0_.JSH='0331' or jbxx0_.JSH='0332' or jbxx0_.JSH='0333' or jbxx0_.JSH='0334' or jbxx0_.JSH='0335' or jbxx0_.JSH='0336' or jbxx0_.JSH='0337' or jbxx0_.JSH='0338' or jbxx0_.JSH='0339' or jbxx0_.JSH='0340' or jbxx0_.JSH='0341' or jbxx0_.JSH='0342' or jbxx0_.JSH='0343' or jbxx0_.JSH='0344' or jbxx0_.JSH='0345' or jbxx0_.JSH='0346' or jbxx0_.JSH='0347' or jbxx0_.JSH='0348' or jbxx0_.JSH='0349' or jbxx0_.JSH='0350') and jbxx0_.STATE='R8' and jbxx0_.JSBH='310115111' order by jbxx0_.RSRQ desc ) where rownum <= :1
cxv4s81pts1q9	SELECT CONTENT FROM XXDM X WHERE X.FIELDNAME=:B2 AND X.CODE=TRIM(:B1 ) AND ROWNUM=1
f2yzzhdjsgzfp	select * from ( select jbxx0_.ID as col_0_0_, (to_xxdmzh('XB', jbxx0_.XB) ) as col_1_0_, (to_xxdmzh('ZJLX', jbxx0_.ZJLX) ) as col_2_0_, (to_xxdmzh('MZ', jbxx0_.MZ) ) as col_3_0_, (to_xxdmzh('HYZK', jbxx0_.HYZK) ) as col_4_0_, (to_xxdmzh('XZQH', jbxx0_.HJD) ) as col_5_0_, (to_xxdmzh('XZQH', jbxx0_.XZD) ) as col_6_0_, (to_xxdmzh('WHCD', jbxx0_.WHCD) ) as col_7_0_, (to_xxdmzh('SF', jbxx0_.SF) ) as col_8_0_, (to_xxdmzh('ZC', jbxx0_.ZC) ) as col_9_0_, (to_xxdmzh('GJ', jbxx0_.GJ) ) as col_10_0_, (to_xxdmzh('XZQH', jbxx0_.JG) ) as col_11_0_, (to_xxdmzh('ZZMM', jbxx0_.ZZMM) ) as col_12_0_, (to_xxdmzh('TSSF', trim(jbxx0_.TSSF)) ) as col_13_0_, (to_xxdmzh('ZY', jbxx0_.ZY) ) as col_14_0_, (to_xxdmzh('JKZK', jbxx0_.JKZK) ) as col_15_0_, (to_xxdmmultizh('AJLB', jbxx0_.AY) ) as col_16_0_, (to_xxdmzh('CYLX', jbxx0_.CYLX) ) as col_17_0_, (to_xxdmzh('BAJD', jbxx0_.BAHJ) ) as col_18_0_, (to_xxdmzh('RSXZ', jbxx0_.RSXZ) ) as col_19_0_, (to_xxdmzh('AJLB', jbxx0_.CAAJ) ) as col_20_0_, (to_xxdmzh('SYPZ', jbxx0_.SYPZ) ) as col_21_0_, (to_xxdmzh('DWLX', jbxx0_.DWLX) ) as col_22_0_, (to_zdzh('AQDJ', jbxx0_.AQDJ) ) as col_23_0_, (to_xxdmzh('CSYY', jbxx0_.CSYY) ) as col_24_0_, (to_xxdmzh('CLJG', jbxx0_.CLJG) ) as col_25_0_, (to_xxdmzh('FJX', jbxx0_.FJX) ) as col_26_0_, jbxx0_.ID as ID28_, jbxx0_.AQDJ as AQDJ28_, jbxx0_.AY as AY28_, jbxx0_.AZB as AZB28_, jbxx0_.BADW as BADW28_, jbxx0_.BAHJ as BAHJ28_, jbxx0_.BAR as BAR28_, jbxx0_.BARJH as BARJH28_, jbxx0_.BHLX as BHLX28 _, jbxx0_.BM as BM28_, jbxx0_.BMTY as BMTY28_, jbxx0_.BZ as BZ28_, jbxx0_.CAAJ as CAAJ28_, jbxx0_.CLJG as CLJG28_, jbxx0_.CREATETIME as CREATETIME28_, jbxx0_.CSQX as CSQX28_, jbxx0_.CSRQ as CSRQ28_, jbxx0_.CSSJ as CSSJ28_, jbxx0_.CSYY as CSYY28_, jbxx0_.CYLX as CYLX28_, jbxx0_.DAH as DAH28_, jbxx0_.DBRQ as DBRQ28_, jbxx0_.DH as DH28_, jbxx0_.DWLX as DWLX28_, jbxx0_.EMLX as EMLX28_, jbxx0_.FJX as FJX28_, jbxx0_.FZJL as FZJL28_, jbxx0_.GCBH as GCBH28_, jbxx0_.GJ as GJ28_, jbxx0_.GRJL as GRJL28_, jbxx0_.GYQX as GYQX28_, jbxx0_.GZDW as GZDW28_, jbxx0_.HJD as HJD28_, jbxx0_.HJDXZ as HJDXZ28_, jbxx0_.HX as HX28_, jbxx0_.HXQX as HXQX28_, jbxx0_.HYZK as HYZK28_, jbxx0_.JB as JB28_, jbxx0_.JG as JG28_, jbxx0_.JJ as JJ28_, jbxx0_.JKZK as JKZK28_, jbxx0_.JLRQ as JLRQ28_, jbxx0_.JSBH as JSBH28_, jbxx0_.JSH as JSH28_, jbxx0_.JSHJ as JSHJ28_, jbxx0_.JSLX as JSLX28_, jbxx0_.JSLY as JSLY28_, jbxx0_.JYAQ as JYAQ28_, jbxx0_.JYRQ as JYRQ28_, jbxx0_.LDF as LDF28_, jbxx0_.LSCSYY as LSCSYY28_, jbxx0_.LSFH as LSFH28_, jbxx0_.MZ as MZ28_, jbxx0_.OPERATOR as OPERATOR28_, jbxx0_.PWH as PWH28_, jbxx0_.RSRQ as RSRQ28_, jbxx0_.RSXZ as RSXZ28_, jbxx0_.RYBH as RYBH28_, jbxx0_.RYGLLB as RYGLLB28_, jbxx0_.SAVETIME as SAVETIME28_, jbxx0_.SCBZ as SCBZ28_, jbxx0_.SF as SF28_, jbxx0_.SG as SG28_, jbxx0_.SNBH as SNBH28_, jbxx0_.STATE as STATE28_, jbxx0_.SY as SY28_, jbxx0_.SYDW as SYDW28_, jbxx0_.SYPZ as SYPZ28_, jbxx0_.SYPZWSH as SYPZWSH28_, jbxx0_.SYR as SYR28_, jbxx0_.TSBJ as TSBJ28_, jbxx0_.TSSF as TSSF28_, jbxx0_.WBRYBH as WBRYBH28_, jbxx0_.WHCD as WHCD28_, jbxx0_.WXDJ as WXDJ28_, jbxx0_.XB as XB28_, jbxx0_.XM as XM28_, jbxx0_.XMPY as XMPY28_, jbxx0_.XQ as XQ28_, jbxx0_.XZD as XZD28_, jbxx0_.XZDXZ as XZDXZ28_, jbxx0_.YGRY as YGRY28_, jbxx0_.ZC as ZC28_, jbxx0_.ZDZY as ZDZY28_, jbxx0_.ZJH as ZJH28_, jbxx0_.ZJLX as ZJLX28_, jbxx0_.ZRDW as ZRDW28_, jbxx0_.ZSZT as ZSZT28_, jbxx0_.ZUC as ZUC28_, jbxx0_.ZWBH as ZWBH28_, jbxx0_.ZY as ZY28_, jbxx0_.ZYAF as ZYAF28_, jbxx0_.ZYRYXGQK as ZYRYXGQK28_, jbxx0_.ZZMM as ZZMM28_, jbxx0_.ZZQSRQ as ZZQSRQ28_ from JBXX jbxx0_ where 1=1 and (jbxx0_.JSH='9999' or jbxx0_.JSH='0103' or jbxx0_.JSH='0104' or jbxx0_.JSH='0105' or jbxx0_.JSH='0106' or jbxx0_.JSH='0107' or jbxx0_.JSH='0108' or jbxx0_.JSH='0109' or jbxx0_.JSH='0110' or jbxx0_.JSH='0111' or jbxx0_.JSH='0112' or jbxx0_.JSH='0113' or jbxx0_.JSH='0114' or jbxx0_.JSH='0115' or jbxx0_.JSH='0116' or jbxx0_.JSH='0117' or jbxx0_.JSH='0118' or jbxx0_.JSH='0119' or jbxx0_.JSH='0120' or jbxx0_.JSH='0121' or jbxx0_.JSH='0122' or jbxx0_.JSH='0123' or jbxx0_.JSH='0124' or jbxx0_.JSH='0125' or jbxx0_.JSH='0126' or jbxx0_.JSH='0127' or jbxx0_.JSH='0128' or jbxx0_.JSH='0129' or jbxx0_.JSH='0201' or jbxx0_.JSH='0202' or jbxx0_.JSH='0203' or jbxx0_.JSH='0204' or jbxx0_.JSH='0205' or jbxx0_.JSH='0206' or jbxx0_.JSH='0207' or jbxx0_.JSH='0208' or jbxx0_.JSH='0209' or jbxx0_.JSH='0210' or jbxx0_.JSH='0211' or jbxx0_.JSH='0212' or jbxx0_.JSH='0213' or jbxx0_.JSH='0214' or jbxx0_.JSH='0215' or jbxx0_.JSH='0216' or jbxx0_.JSH='0217' or jbxx0_.JSH='0218' or jbxx0_.JSH='0219' or jbxx0_.JSH='0220' or jbxx0_.JSH='0221' or jbxx0_.JSH='0222' or jbxx0_.JSH='0223' or jbxx0_.JSH='0224' or jbxx0_.JSH='0225' or jbxx0_.JSH='0226' or jbxx0_.JSH='0227' or jbxx0_.JSH='0228' or jbxx0_.JSH='0229' or jbxx0_.JSH='0101' or jbxx0_.JSH='0102') and jbxx0_.STATE='R8' and jbxx0_.JSBH='310000113' order by jbxx0_.RSRQ desc ) where rownum <= :1

Back to Top SQL 
Back to Top

 

Top Sessions

• Top Sessions
• Top Blocking Sessions
• Top Sessions running PQs

Back to Top

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	XIDs
82, 1	46.15	CPU + Wait for CPU	45.05	SYS	ORACLE.EXE (DBW0)	41/300 [ 14%]	0
		db file parallel write	1.10			1/300 [ 0%]	0
54, 447	28.57	CPU + Wait for CPU	28.57	SECU	JDBC Thin Client	26/300 [ 9%]	0
21, 95	6.59	CPU + Wait for CPU	6.59	SECU	JDBC Thin Client	6/300 [ 2%]	0
1, 2121	5.49	CPU + Wait for CPU	4.40	SECU	JDBC Thin Client	4/300 [ 1%]	0
		log file sync	1.10			1/300 [ 0%]	0
148, 189	4.40	CPU + Wait for CPU	4.40	SECU	JDBC Thin Client	4/300 [ 1%]	0

Back to Top Sessions 
Back to Top

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	% Activity	Event Caused	% Event	User	Program	# Samples Active	XIDs
80, 1	1.10	log file sync	1.10	** NOT FOUND **	BLOCKING SESSION NOT FOUND	0/300 [ 0%]

Back to Top Sessions 
Back to Top

 

Top Sessions running PQs

No data exists for this section of the report.

Back to Top Sessions 
Back to Top

 

Top Objects/Files/Latches

• Top DB Objects
• Top DB Files
• Top Latches

Back to Top

 

Top DB Objects

No data exists for this section of the report.

Back to Top Objects/Files/Latches 
Back to Top

 

Top DB Files

No data exists for this section of the report.

Back to Top Objects/Files/Latches 
Back to Top

 

Top Latches

No data exists for this section of the report.

Back to Top Objects/Files/Latches 
Back to Top

 

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
09:01:12 (48 secs)	7	CPU + Wait for CPU	7	7.69
09:02:00 (1.0 min)	4	CPU + Wait for CPU	4	4.40
09:03:00 (1.0 min)	32	CPU + Wait for CPU	31	34.07
		db file parallel write	1	1.10
09:04:00 (1.0 min)	26	CPU + Wait for CPU	26	28.57
09:05:00 (1.0 min)	18	CPU + Wait for CPU	17	18.68
		log file sync	1	1.10
09:06:00 (12 secs)	4	CPU + Wait for CPU	4	4.40

Back to Top

 

End of Report