WORKLOAD REPOSITORY report for

DB Name	DB Id	Instance	Inst num	Release	RAC	Host
UDAS2PDB	4051413816	udas2p2	2	10.2.0.4.0	YES	fipd429

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	20787	07-Apr-11 11:00:40	74	4.4
End Snap:	20789	07-Apr-11 13:00:04	101	4.8
Elapsed:		119.41 (mins)
DB Time:		912.95 (mins)

Report Summary

Cache Sizes

	Begin	End
Buffer Cache:	2,320M	2,256M	Std Block Size:	8K
Shared Pool Size:	1,792M	1,856M	Log Buffer:	14,340K

Load Profile

	Per Second	Per Transaction
Redo size:	1,330,572.73	626,876.59
Logical reads:	37,109.39	17,483.45
Block changes:	7,210.49	3,397.10
Physical reads:	1,058.50	498.69
Physical writes:	288.34	135.85
User calls:	146.47	69.01
Parses:	33.20	15.64
Hard parses:	2.37	1.12
Sorts:	8.60	4.05
Logons:	1.37	0.65
Executes:	70.32	33.13
Transactions:	2.12

% Blocks changed per Read:	19.43	Recursive Call %:	62.83
Rollback per transaction %:	48.37	Rows per Sort:	500.93

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %:	99.98	Redo NoWait %:	99.94
Buffer Hit %:	97.48	In-memory Sort %:	99.52
Library Hit %:	96.67	Soft Parse %:	92.85
Execute to Parse %:	52.79	Latch Hit %:	99.36
Parse CPU to Parse Elapsd %:	40.26	% Non-Parse CPU:	99.69

Shared Pool Statistics

	Begin	End
Memory Usage %:	73.21	77.35
% SQL with executions>1:	76.81	78.91
% Memory for SQL w/exec>1:	95.85	77.03

Top 5 Timed Events

Event	Waits	Time(s)	Avg Wait(ms)	% Total Call Time	Wait Class
gc buffer busy	66,704	17,666	265	32.3	Cluster
gc current block busy	43,295	14,565	336	26.6	Cluster
CPU time		8,003		14.6
log file sync	28,833	7,594	263	13.9	Commit
gcs log flush sync	2,716,333	5,634	2	10.3	Other

RAC Statistics

	Begin	End
Number of Instances:	3	3

Global Cache Load Profile

	Per Second	Per Transaction
Global Cache blocks received:	317.92	149.78
Global Cache blocks served:	710.38	334.68
GCS/GES messages received:	2,528.25	1,191.14
GCS/GES messages sent:	2,080.51	980.20
DBWR Fusion writes:	51.23	24.14
Estd Interconnect traffic (KB)	9,126.56

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

Buffer access - local cache %:	96.62
Buffer access - remote cache %:	0.86
Buffer access - disk %:	2.52

Global Cache and Enqueue Services - Workload Characteristics

Avg global enqueue get time (ms):	3.7
Avg global cache cr block receive time (ms):	41.0
Avg global cache current block receive time (ms):	7.8
Avg global cache cr block build time (ms):	0.1
Avg global cache cr block send time (ms):	0.0
Global cache log flushes for cr blocks served %:	8.0
Avg global cache cr block flush time (ms):	270.0
Avg global cache current block pin time (ms):	0.1
Avg global cache current block send time (ms):	0.0
Global cache log flushes for current blocks served %:	0.7
Avg global cache current block flush time (ms):	278.9

Global Cache and Enqueue Services - Messaging Statistics

Avg message sent queue time (ms):	0.1
Avg message sent queue time on ksxp (ms):	0.4
Avg message received queue time (ms):	0.0
Avg GCS message process time (ms):	0.0
Avg GES message process time (ms):	0.0
% of direct sent messages:	27.75
% of indirect sent messages:	69.93
% of flow controlled messages:	2.32

Main Report

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

More RAC Statistics

• RAC Report Summary
• Global Enqueue Statistics
• Global CR Served Stats
• Global CURRENT Served Stats
• Global Cache Transfer Stats

Wait Events Statistics

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

Time Model Statistics

• Total time in database user-calls (DB Time): 54776.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

Back to Wait Events Statistics
Back to Top

Wait Class

• s - second
• cs - centisecond - 100th of a second
• ms - millisecond - 1000th of a second
• us - microsecond - 1000000th of a second
• ordered by wait time desc, waits desc

Back to Wait Events Statistics
Back to Top

Wait Events

• s - second
• cs - centisecond - 100th of a second
• ms - millisecond - 1000th of a second
• us - microsecond - 1000000th of a second
• ordered by wait time desc, waits desc (idle events last)

Back to Wait Events Statistics
Back to Top

Background Wait Events

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

Back to Wait Events Statistics
Back to Top

Operating System Statistics

Back to Wait Events Statistics
Back to Top

Service Statistics

• ordered by DB Time

Back to Wait Events Statistics
Back to Top

Service Wait Class Stats

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

Back to Wait Events Statistics
Back to Top

SQL Statistics

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

SQL ordered by Elapsed Time

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

Back to SQL Statistics
Back to Top

SQL ordered by CPU Time

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

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: 265,870,865
• Captured SQL account for 43.8% of Total

Back to SQL Statistics
Back to Top

SQL ordered by Reads

• Total Disk Reads: 7,583,637
• Captured SQL account for 78.0% of Total

Back to SQL Statistics
Back to Top

SQL ordered by Executions

• Total Executions: 503,809
• Captured SQL account for 61.7% of Total

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

• Total Parse Calls: 237,841
• Captured SQL account for 69.4% of Total

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

No data exists for this section of the report.

Back to SQL Statistics
Back to Top

SQL ordered by Version Count

• Only Statements with Version Count greater than 20 are displayed

Back to SQL Statistics
Back to Top

SQL ordered by Cluster Wait Time

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL Id	SQL Text
01mfzbszdmf0u	SELECT MAP_NAME, MAP_AREA_NAME, DMA_NAME, VHO_CODE, CHANNEL_NAME, ELCTRNC_PRGRM_GUIDE_GUID, TUNER_POSITION, CALL_LETTERS, CONTENT_TYPE, RESOLUTION, HD_FEE_RQRD, SERVICE_NAME, SERVICE_TYPE FROM UDAS_CHMAP_SER_DETAILS_V a WHERE ZIP_CODE=:1 AND UPPER(MAP_TYPE)=:2 AND SERVICE_NAME IS NOT NULL AND PACKAGE_BILLING_CODE IN ('U200') and not exists (select 1 from UDAS_CHMAP_SER_DETAILS_V b left outer join (select * from ref_filter_package where upper(package_type)=upper(:3)) rbasic on b.package_billing_code=rbasic.package_billing_code , ref_filter_channel rchnl where a.zip_code=b.zip_code and a.map_type=b.map_type and a.package_billing_code=b.package_billing_code and a.vho_code=b.vho_code and a.channel_name=b.channel_name and b.channel_name=rchnl.channel_name and rbasic.package_billing_code is null) AND VHO_CODE=:4 GROUP BY MAP_NAME, MAP_AREA_NAME, DMA_NAME, VHO_CODE, CHANNEL_NAME, ELCTRNC_PRGRM_GUIDE_GUID, TUNER_POSITION, CALL_LETTERS, CONTENT_TYPE, RESOLUTION, HD_FEE_RQRD, SERVICE_NAME, SERVICE_TYPE
04xtrk7uyhknh	select obj#, type#, ctime, mtime, stime, status, dataobj#, flags, oid$, spare1, spare2 from obj$ where owner#=:1 and name=:2 and namespace=:3 and remoteowner is null and linkname is null and subname is null
0548jzyd9hy1y	SELECT TUNER_POSITION, ELCTRNC_PRGRM_GUIDE_GUID, COUNT(TUNER_POSITION) AS TUNERPOSITION FROM UDAS_CHMAP_SER_DETAILS_V a WHERE ZIP_CODE=:1 AND UPPER(MAP_TYPE)=:2 AND SERVICE_NAME IS NOT NULL AND PACKAGE_BILLING_CODE IN ('U100') and not exists (select package_billing_code from ref_filter_package rbasic, ref_filter_channel rchnl WHERE a.package_billing_code=rbasic.package_billing_code(+) and upper(package_type)=upper(:3) AND a.channel_name =rchnl.channel_name AND rbasic.package_billing_code IS NULL AND a.channel_name =rchnl.channel_name) AND VHO_CODE=:4 GROUP BY TUNER_POSITION, ELCTRNC_PRGRM_GUIDE_GUID
0a54p6s6jk94y	INSERT INTO STG_ID_MAPPER(GLF_PROGRAM_ID, INTERNAL_PROGRAM_ID, VHO_CLLI_CODE) VALUES ( :1, :2, :3)
0h6b2sajwb74n	select privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0
0k8522rmdzg4k	select privilege# from sysauth$ where (grantee#=:1 or grantee#=1) and privilege#>0
0pf2bjujgf2na	UPDATE BF_MART_PRCH_HSTRY SET VERSION_NUM = :1, LAST_UPDATE_TS = :2, WORKFLOW_RUN_ID = :3, UAR_SRC_STATUS = :4 WHERE PRINCIPAL_EXTERNAL_ID = :5 AND ASSET_BILLING_EVENT_ID = :6 AND ASSET_DEPLOYMENT_ID = :7
0sa5cmb8p9qsx	select B.VHO_CLLI_CODE||', '||B.ASSET_BILLING_EVENT_ID||', '||A.BE_STATE_ID||', '||A.RESOURCE_TYPE||', '||A.REJECT_REASON||', '||A.RESOURCE_NAME||', '||A.PURCHASE_AMOUNT||', '||A.CURRENCY||', '||B.RESOURCE_TYPE||', '||B.BE_STATE_ID||', '||to_char(PE_LAST_UPDATE_TS, 'yyyy-mm-dd hh24:mi:ssxff')||', '||to_char(PE_INSERT_TS, 'yyyy-mm-dd hh24:mi:ssxff')||', '||VERSION_NUM||', '||DISCOUNT_AMOUNT from BF_ALRT_PRCH_HSTRY A, BF_AUDIT_TRAIL B where B.purchase_dt > :z and B.PE_INSERT_TS <= :y and B.PE_INSERT_TS >= :x and A.ASSET_BILLING_EVENT_ID(+) = B.ASSET_BILLING_EVENT_ID and A.VHO_CLLI_CODE(+)= B.VHO_CLLI_CODE
0ws7ahf1d78qa	select SYS_CONTEXT('USERENV', 'SERVER_HOST'), SYS_CONTEXT('USERENV', 'DB_UNIQUE_NAME'), SYS_CONTEXT('USERENV', 'INSTANCE_NAME'), SYS_CONTEXT('USERENV', 'SERVICE_NAME'), INSTANCE_NUMBER, STARTUP_TIME, SYS_CONTEXT('USERENV', 'DB_DOMAIN') from v$instance where INSTANCE_NAME=SYS_CONTEXT('USERENV', 'INSTANCE_NAME')
0zxgq19d59v83	begin App_Team.table_trunc('STG_ID_MAPPER'); App_Team.table_trunc('STG_PROGRAMID_MAPPER'); App_Team.table_trunc('STG_IPTV_GUID_PGMID_ASSOC'); end;
12ff1v1491pmv	INSERT INTO BF_AUDIT_TRAIL ( BF_AUDIT_ID , ASSET_DEPLOYMENT_ID , ASSET_BILLING_EVENT_ID , PRINCIPAL_EXTERNAL_ID , VHO_CLLI_CODE , PURCHASE_DT , PURCHASE_AMOUNT , PPV_ASSET_START_DT , PPV_ASSET_END_DT , RECONCILIATION_FILE_ID , RELIABLE_DELIVERY_ID , VERSION_NUM , BE_STATE_ID , PE_INSERT_TS , PE_LAST_UPDATE_TS , LAST_UPDATE_PROCESS_ID , SRC_VAL_STATUS , SRC_VAL_FAILURE_REASON , MDT_DB_FAILURE_COUNT, MDT_API_FAILURE_COUNT, IPTV_UPD_STATUS, IPTV_UPD_FAILURE_COUNT, INSERT_TS ) VALUES( BF_AUDIT_TRAIL_SEQ.NEXTVAL, :B1 , :B2 , :B3 , :B4 , :B5 , :B6 , :B7 , :B8 , :B9 , :B10 , 0 , :B11 , :B12 , :B13 , :B14 , :B15 , :B16 , :B17 , :B18 , :B19 , :B20 , SYSDATE )
15qu74m0pdxwp	UPDATE BF_MART_PRCH_HSTRY SET BE_STATE_ID=9, VERSION_NUM=VERSION_NUM+1, LAST_UPDATE_TS=SYSDATE, WORKFLOW_RUN_ID='737448' WHERE BILLING_FILE_ID=(SELECT SK_ID FROM BF_FWD_FILE_CTRL WHERE trim(BE_FILE_NAME)='UDAS_2_FWD_IPTV_SEQ059274_20110407123812.txt')
15zytu14qzw6p	insert into sys.aud$( sessionid, entryid, statement, ntimestamp#, userid, userhost, terminal, action#, returncode, obj$creator, obj$name, auth$privileges, auth$grantee, new$owner, new$name, ses$actions, ses$tid, logoff$pread, logoff$lwrite, logoff$dead, comment$text, spare1, spare2, priv$used, clientid, sessioncpu, proxy$sid, user$guid, instance#, process#, xid, scn, auditid, sqlbind, sqltext) values(:1, :2, :3, SYS_EXTRACT_UTC(SYSTIMESTAMP), :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21, :22, :23, :24, :25, :26, :27, :28, :29, :30, :31, :32, :33, :34)
192s5u561rar6	INSERT INTO STG_PGA_BOUNDARY_POINTS(SK_PGA_BNDRY_POINT_ID, BK_BNDRY_POINT_DIGITS, BK_PGROUP_NM, INSERT_DT) VALUES ( :1, :2, :3, :4)
1dw3dxw59xsgh	select * from BF_MART_PRCH_HSTRY where asset_deployment_id ='86EB1879-2BE0-4EB5-955F-B43B0F0993D8'
1m837brk5tgx1	SELECT MAX(PCT_VSDA_USD_LOAD.SVCH_LAST_UPDATE_TS) SVCH_LAST_UPDATE_TS FROM PCT_VSDA_USD_LOAD WHERE PCT_VSDA_USD_LOAD.LOAD_STATUS='Successfull' and PCT_VSDA_USD_LOAD.MODULE_NM ='INC'
1rd8um1taq1fn	update sys.aud$ set action#=:2, returncode=:3, logoff$time=cast(systimestamp as date), logoff$pread=:4, logoff$lread=:5, logoff$lwrite=:6, logoff$dead=:7, sessioncpu=:8 where sessionid=:1 and entryid=1 and action#=100
2hyykjpq47h3x	SELECT DISTINCT BK_BNDRY_POINT_DIGITS, BK_PGROUP_NM FROM ( SELECT LC_PGA_BOUNDARY_POINTS.BK_BNDRY_POINT_DIGITS, LC_PGA_BOUNDARY_POINTS.BK_PGROUP_NM FROM LC_PGA_BOUNDARY_POINTS MINUS SELECT STG_PGA_BOUNDARY_POINTS.BK_BNDRY_POINT_DIGITS, STG_PGA_BOUNDARY_POINTS.BK_PGROUP_NM FROM STG_PGA_BOUNDARY_POINTS)
2ym6hhaq30r73	select type#, blocks, extents, minexts, maxexts, extsize, extpct, user#, iniexts, NVL(lists, 65535), NVL(groups, 65535), cachehint, hwmincr, NVL(spare1, 0), NVL(scanhint, 0) from seg$ where ts#=:1 and file#=:2 and block#=:3
33upt6jutd7x0	INSERT INTO BF_MART_PRCH_HSTRY(PRINCIPAL_EXTERNAL_ID, ASSET_BILLING_EVENT_ID, ASSET_DEPLOYMENT_ID, VHO_CLLI_CODE, PURCHASE_DT, PPV_ASSET_START_DT, PPV_ASSET_END_DT, RESOURCE_NAME, PROVIDER_ASSET_ID, RATING, PURCHASE_AMOUNT, CURRENCY, SERVICE_PROVIDER_ID, GENRE, CONTENT_PROVIDER_ID, RESOURCE_TYPE, EVENT_TYPE, ADULT_CONTENT_IND, BILLED_ASSET_TITLE, DISCOUNT_AMOUNT, BILLED_AMOUNT, BE_STATE_ID, VERSION_NUM, LAST_UPDATE_TS, WORKFLOW_RUN_ID, OVERLAY_ASSET_TITLE) VALUES ( :1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21, :22, :23, :24, :25, :26)
35ku6489jtxpa	SELECT BF_MART_PRCH_HSTRY.PRINCIPAL_EXTERNAL_ID, BF_MART_PRCH_HSTRY.ASSET_BILLING_EVENT_ID, BF_MART_PRCH_HSTRY.ASSET_DEPLOYMENT_ID, BF_MART_PRCH_HSTRY.PURCHASE_DT, BF_MART_PRCH_HSTRY.PPV_ASSET_START_DT, BF_MART_PRCH_HSTRY.PPV_ASSET_END_DT, BF_MART_PRCH_HSTRY.RESOURCE_NAME, BF_MART_PRCH_HSTRY.PROVIDER_ASSET_ID, BF_MART_PRCH_HSTRY.PURCHASE_AMOUNT, BF_MART_PRCH_HSTRY.GENRE, BF_MART_PRCH_HSTRY.RESOURCE_TYPE, BF_MART_PRCH_HSTRY.ADULT_CONTENT_IND, BF_MART_PRCH_HSTRY.DISCOUNT_AMOUNT, BF_MART_PRCH_HSTRY.BILLED_AMOUNT, BF_MART_PRCH_HSTRY.VERSION_NUM, BF_MART_PRCH_HSTRY.OVERLAY_ASSET_TITLE FROM BF_MART_PRCH_HSTRY WHERE BF_MART_PRCH_HSTRY.BE_STATE_ID=9 AND BF_MART_PRCH_HSTRY.RESOURCE_TYPE='PPV' AND BF_MART_PRCH_HSTRY.UAR_SRC_STATUS='N' AND BF_MART_PRCH_HSTRY.CSF_SRC_STATUS=( CASE WHEN BF_MART_PRCH_HSTRY.BILLED_AMOUNT=0 THEN 0 ELSE 1 END)
3j7ukmasa5yb7	SELECT SK_SERVICE_AREA_CHANNEL_MAP, SK_SERVICE_AREA, SK_CHANNEL_MAP, SK_CHANNELS, PG_IC_START_DATE, START_DATE, TUNER_POSITION FROM SERVICE_AREA_MAP_CHANNELS ORDER BY SK_SERVICE_AREA, SK_CHANNEL_MAP, SK_CHANNELS, PG_IC_START_DATE, START_DATE, TUNER_POSITION
431ukanuxc5uj	SELECT DISTINCT TUNER_POSITION, CHANNEL_NAME, ELCTRNC_PRGRM_GUIDE_GUID, CALL_LETTERS, MAP_NAME, MAP_AREA_NAME, VHO_CODE, DMA_NAME, CONTENT_TYPE, RESOLUTION, HD_FEE_RQRD FROM UDAS_CHMAP_SER_DETAILS_V a WHERE ZIP_CODE=:1 AND UPPER(MAP_TYPE)=:2 AND PACKAGE_BILLING_CODE IN ('U100') and not exists (select 1 from UDAS_CHMAP_SER_DETAILS_V b left outer join (select * from ref_filter_package where upper(package_type)=upper(:3)) rbasic on b.package_billing_code=rbasic.package_billing_code , ref_filter_channel rchnl where a.zip_code=b.zip_code and a.map_type=b.map_type and a.package_billing_code=b.package_billing_code and a.vho_code=b.vho_code and a.channel_name=b.channel_name and b.channel_name=rchnl.channel_name and rbasic.package_billing_code is null) AND VHO_CODE=:4 GROUP BY MAP_NAME, MAP_AREA_NAME, DMA_NAME, VHO_CODE, CHANNEL_NAME, ELCTRNC_PRGRM_GUIDE_GUID, TUNER_POSITION, CALL_LETTERS, CONTENT_TYPE, RESOLUTION, HD_FEE_RQRD, SERVICE_NAME, SERVICE_TYPE
4488b4fqp2vh5	select dummy from dual where USER like 'SYS'
459f3z9u4fb3u	select value$ from props$ where name = 'GLOBAL_DB_NAME'
4d9uaw6jcyug9	SELECT VOD_ASSET_DATA_SEQ.NEXTVAL FROM DUAL
4dxyvxm331xb3	SELECT a.inst_id, SUM (DECODE (NAME, 'db block changes', VALUE, 0)), SUM (DECODE (NAME, 'db block gets', VALUE, 0)), SUM (DECODE (NAME, 'consistent gets', VALUE, 0)), SUM (DECODE (NAME, 'physical reads', VALUE, 0)), SUM (DECODE (NAME, 'physical writes', VALUE, 0)), SUM (DECODE (NAME, 'redo writes', VALUE, 0)), SUM (DECODE (NAME, 'parse count (total)', VALUE, 0)), SUM (DECODE (NAME, 'execute count', VALUE, 0)), SUM (DECODE (NAME, 'user commits', VALUE, 0)), SUM (DECODE (NAME, 'user rollbacks', VALUE, 0)), host_name FROM gv$sysstat a, gv$instance b WHERE a.INST_ID = b.INST_ID and NAME IN ('db block changes', 'db block gets', 'consistent gets', 'physical reads', 'physical writes', 'redo writes', 'redo writes', 'parse count (total)', 'execute count', 'user commits', 'user rollbacks') GROUP BY a.inst_id, HOST_NAME order by inst_id
4m7m0t6fjcs5x	update seq$ set increment$=:2, minvalue=:3, maxvalue=:4, cycle#=:5, order$=:6, cache=:7, highwater=:8, audit$=:9, flags=:10 where obj#=:1
4n382ffgbu4nz	UPDATE BF_MART_PRCH_HSTRY SET BE_STATE_ID=9, VERSION_NUM=VERSION_NUM+1, LAST_UPDATE_TS=SYSDATE, WORKFLOW_RUN_ID='736767' WHERE BILLING_FILE_ID=(SELECT SK_ID FROM BF_FWD_FILE_CTRL WHERE trim(BE_FILE_NAME)='UDAS_2_FWD_IPTV_SEQ059255_20110407112749.txt')
53saa2zkr6wc3	select intcol#, nvl(pos#, 0), col#, nvl(spare1, 0) from ccol$ where con#=:1
5819tm9a0455y	SELECT DISTINCT PCT_VSDA_USD_LOAD.PROC_ID FROM PCT_VSDA_USD_LOAD WHERE PCT_VSDA_USD_LOAD.PROC_ID=17165001.000000000000000 AND PCT_VSDA_USD_LOAD.MODULE_NM='INC'
5ja8186ubypp9	UPDATE PCT_VSDA_USD_LOAD SET LOAD_STATUS=:1, LOAD_END_TS=:2 WHERE PROC_ID=:3 AND MODULE_NM='OMCM'
5jxwda6s8nvc7	select tablespace_id, rfno, allocated_space, file_size, file_maxsize, changescn_base, changescn_wrap, flag from GV$FILESPACE_USAGE where inst_id != :inst and (changescn_wrap >= :w or (changescn_wrap = :w and changescn_base >= :b))
5ngzsfstg8tmy	select o.owner#, o.name, o.namespace, o.remoteowner, o.linkname, o.subname, o.dataobj#, o.flags from obj$ o where o.obj#=:1
5pbrnvcgyf3ta	UPDATE BF_MART_PRCH_HSTRY SET BE_STATE_ID=9, VERSION_NUM=VERSION_NUM+1, LAST_UPDATE_TS=SYSDATE, WORKFLOW_RUN_ID='737306' WHERE BILLING_FILE_ID=(SELECT SK_ID FROM BF_FWD_FILE_CTRL WHERE trim(BE_FILE_NAME)='UDAS_2_FWD_IPTV_SEQ059270_20110407122510.txt')
5pdgmjpnacak4	INSERT INTO CODIE_TRANSACTION_LOG (CODIE_CLIENT_APP, CODIE_TRANS_STATUS, CODIE_CLIENT_REQUEST_TIME, CODIE_TRANS_DESCRIPTION, CODIE_METHOD_ID, CODIE_START_TIME, CODIE_END_TIME, SRC_IP_ADDR, SRC_MESSAGE_ID, METHOD_VERSION, FAILURE_SYSTEM, RESPONSE_CODE, REQUEST_PARAMETER, RESPONSE_DURATION, CODIE_TRANS_ID, HOST_NAME) VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16)
5qsu4hxv1rs6u	update om_pkg_pga_prvdr_assoc set status = 'Inactive' where (VOD_OFFR_NOTES is null or VOD_OFFR_NOTES =:1) and VOD_OFFR_ACCESS_TYPE =:2 and (PRODUCT_VALUE is null or PRODUCT_VALUE =:3) and status = :4
5un910zs5681s	DECLARE lcommand varchar(200); BEGIN EXECUTE IMMEDIATE 'alter session set workarea_size_policy=MANUAL'; EXECUTE IMMEDIATE 'alter session set sort_area_size=31457280'; END set_trace;
5ur69atw3vfhj	select decode(failover_method, NULL, 0 , 'BASIC', 1, 'PRECONNECT', 2 , 'PREPARSE', 4 , 0), decode(failover_type, NULL, 1 , 'NONE', 1 , 'SESSION', 2, 'SELECT', 4, 1), failover_retries, failover_delay, flags from service$ where name = :1
6atcfr6wc0g4y	select 'DATAPOINT', nvl(min(nvl(b.bytes, 0)/1048576), 11) minfreespace, nvl(min(nvl(b.bytes, 0)/c.bytes*100), 111) minfreespacepct from (select distinct e.ts#, f.name from sys.seg$ e, sys.ts$ f where e.ts# = f.ts# and e.ts# > 0 and e.TYPE# = 1 and f.online$ = 1 ) a, (select tablespace_name, sum(bytes) bytes from dba_free_space group by tablespace_name ) b, (select tablespace_name, sum(bytes) bytes from dba_data_files group by tablespace_name ) c, (select ts# from p$obj_exclusion where file# is null and block# is null and user# is null ) d, (select tablespace_name from dba_data_files a, sys.filext$ b where a.file_id = b.file# ) g, (select tablespace_name from dba_rollback_segs where status = 'ONLINE' ) h where a.name = b.tablespace_name(+) and a.name = c.tablespace_name and a.ts# = d.ts#(+) and d.ts# is null and a.name = g.tablespace_name(+) and g.tablespace_name is null and a.name = h.tablespace_name
6dv0dpznx0dg9	select VALUE from NLS_SESSION_PARAMETERS where PARAMETER='NLS_LENGTH_SEMANTICS'
6yduvbd2j842m	SELECT MAP_NAME, MAP_AREA_NAME, DMA_NAME, VHO_CODE, CHANNEL_NAME, ELCTRNC_PRGRM_GUIDE_GUID, TUNER_POSITION, CALL_LETTERS, CONTENT_TYPE, RESOLUTION, HD_FEE_RQRD FROM UDAS_CHANNELMAP_DETAILS_V a WHERE ZIP_CODE=:1 AND UPPER(MAP_TYPE)=:2 AND PACKAGE_BILLING_CODE IN ('ENCORE', 'FLIX', 'HBO', 'HBOCIN', 'MAX', 'MOVIE', 'SHO', 'SHUNLD', 'SPORTS', 'STARZ', 'TMC', 'U450', 'UTVFMO') and not exists (select 1 from UDAS_CHANNELMAP_DETAILS_V b left outer join (select * from ref_filter_package where upper(package_type)=upper(:3)) rbasic on b.package_billing_code=rbasic.package_billing_code , ref_filter_channel rchnl where a.zip_code=b.zip_code and a.map_type=b.map_type and a.package_billing_code=b.package_billing_code and a.vho_code=b.vho_code and a.channel_name=b.channel_name and b.channel_name=rchnl.channel_name and rbasic.package_billing_code is null) AND VHO_CODE=:4 GROUP BY MAP_NAME, MAP_AREA_NAME, DMA_NAME, VHO_CODE, CHANNEL_NAME, ELCTRNC_PRGRM_GUIDE_GUID, TUNER_POSITION, CALL_LETTERS, CONTENT_TYPE, RESOLUTION, HD_FEE_RQRD
709jpjcuzmj3n	SELECT LC_PGA_BOUNDARY_POINTS.SK_PGA_BNDRY_POINT_ID AS SK_PGA_BNDRY_POINT_ID, LC_PGA_BOUNDARY_POINTS.BK_BNDRY_POINT_DIGITS AS BK_BNDRY_POINT_DIGITS, LC_PGA_BOUNDARY_POINTS.BK_PGROUP_NM AS BK_PGROUP_NM FROM LC_PGA_BOUNDARY_POINTS ORDER BY BK_BNDRY_POINT_DIGITS, BK_PGROUP_NM, SK_PGA_BNDRY_POINT_ID
7ng34ruy5awxq	select i.obj#, i.ts#, i.file#, i.block#, i.intcols, i.type#, i.flags, i.property, i.pctfree$, i.initrans, i.maxtrans, i.blevel, i.leafcnt, i.distkey, i.lblkkey, i.dblkkey, i.clufac, i.cols, i.analyzetime, i.samplesize, i.dataobj#, nvl(i.degree, 1), nvl(i.instances, 1), i.rowcnt, mod(i.pctthres$, 256), i.indmethod#, i.trunccnt, nvl(c.unicols, 0), nvl(c.deferrable#+c.valid#, 0), nvl(i.spare1, i.intcols), i.spare4, i.spare2, i.spare6, decode(i.pctthres$, null, null, mod(trunc(i.pctthres$/256), 256)), ist.cachedblk, ist.cachehit, ist.logicalread from ind$ i, ind_stats$ ist, (select enabled, min(cols) unicols, min(to_number(bitand(defer, 1))) deferrable#, min(to_number(bitand(defer, 4))) valid# from cdef$ where obj#=:1 and enabled > 1 group by enabled) c where i.obj#=c.enabled(+) and i.obj# = ist.obj#(+) and i.bo#=:1 order by i.obj#
7rg1tkpnr9jyw	INSERT INTO VOD_ASSET_DATA(PACKAGE_ID, VOD_TITLE_ID, VOD_CONTENT_TYPE, LICENSING_WINDOW_START, LICENSING_WINDOW_END, STUDIO_NAME) VALUES ( :1, :2, :3, :4, :5, :6)
82un7fp0r86dw	delete from stg_package where UPPER(PACKAGE_TYPE) not in ('LIVE', 'RDP')
8sbx79qhw31aj	UPDATE BF_MART_PRCH_HSTRY SET BE_STATE_ID=9, VERSION_NUM=VERSION_NUM+1, LAST_UPDATE_TS=SYSDATE, WORKFLOW_RUN_ID='737009' WHERE BILLING_FILE_ID=(SELECT SK_ID FROM BF_FWD_FILE_CTRL WHERE trim(BE_FILE_NAME)='UDAS_2_FWD_IPTV_SEQ059265_20110407120251.txt')
8vaak0p1tfc57	SELECT MAP_NAME, MAP_AREA_NAME, DMA_NAME, VHO_CODE, CHANNEL_NAME, ELCTRNC_PRGRM_GUIDE_GUID, TUNER_POSITION, CALL_LETTERS, CONTENT_TYPE, RESOLUTION, HD_FEE_RQRD, SERVICE_NAME, SERVICE_TYPE FROM UDAS_CHMAP_SER_DETAILS_V a WHERE ZIP_CODE=:1 AND UPPER(MAP_TYPE)=:2 AND SERVICE_NAME IS NOT NULL AND PACKAGE_BILLING_CODE IN ('U100') and not exists (select 1 from UDAS_CHMAP_SER_DETAILS_V b left outer join (select * from ref_filter_package where upper(package_type)=upper(:3)) rbasic on b.package_billing_code=rbasic.package_billing_code , ref_filter_channel rchnl where a.zip_code=b.zip_code and a.map_type=b.map_type and a.package_billing_code=b.package_billing_code and a.vho_code=b.vho_code and a.channel_name=b.channel_name and b.channel_name=rchnl.channel_name and rbasic.package_billing_code is null) AND VHO_CODE=:4 GROUP BY MAP_NAME, MAP_AREA_NAME, DMA_NAME, VHO_CODE, CHANNEL_NAME, ELCTRNC_PRGRM_GUIDE_GUID, TUNER_POSITION, CALL_LETTERS, CONTENT_TYPE, RESOLUTION, HD_FEE_RQRD, SERVICE_NAME, SERVICE_TYPE
91zqwudt6jqx1	SELECT SK_SERVICE_AREA_CHANNEL_MAP, END_DATE, LAST_MODIFY, PG_IC_END_DATE, SK_SERVICE_AREA, SK_CHANNEL_MAP, SK_CHANNELS, START_DATE, PG_IC_START_DATE, TUNER_POSITION FROM SERVICE_AREA_MAP_CHANNELS ORDER BY SK_SERVICE_AREA, SK_CHANNEL_MAP, SK_CHANNELS, START_DATE, PG_IC_START_DATE, TUNER_POSITION
92cnrsm3kn8m9	SELECT PACKAGE_BILLING_CODE, PACKAGE_NAME, MAP_AREA_TYPE, MAP_AREA_NAME, CALL_LETTERS, CHANNEL_NAME, CHANNEL_CATEGORY, RESOLUTION, TUNER_POSITION, PACKAGE_CATEGORY, CHANNEL_ID, PACKAGE_TYPE, PACKAGE_CATALOG_ID FROM UDAS_PACKAGEDETAILS_BY_AREA_V where ZIP_CODE=:1 AND MAP_AREA_TYPE=:2 AND UPPER(PACKAGE_BILLING_CODE) NOT IN (SELECT UPPER(PACKAGE_BILLING_CODE) FROM REF_FILTER_PACKAGE WHERE UPPER(PACKAGE_TYPE) IN(UPPER(:3), UPPER(:4), UPPER(:5)))
94csdxbq8c3nc	UPDATE BF_MART_PRCH_HSTRY SET BE_STATE_ID=9, VERSION_NUM=VERSION_NUM+1, LAST_UPDATE_TS=SYSDATE, WORKFLOW_RUN_ID='736844' WHERE BILLING_FILE_ID=(SELECT SK_ID FROM BF_FWD_FILE_CTRL WHERE trim(BE_FILE_NAME)='UDAS_2_FWD_IPTV_SEQ059257_20110407113432.txt')
978j5sbkzfzzd	select dummy from dual where USER like 'DEXTER_APPID'
9babjv8yq8ru3	BEGIN DBMS_OUTPUT.GET_LINES(:LINES, :NUMLINES); END;
9cc2u12mg7vsu	SELECT DISTINCT(a.BOUNDARY_ZIP_CODE_DIGITS), COUNT(DISTINCT b.MAP_AREA_NAME) from SERVICE_AREA_BOUNDARY a, CHANNEL_MAP_DETAILS b WHERE a.SK_CHANNEL_MAP=b.SK_CHANNEL_MAP AND a.BOUNDARY_ZIP_CODE_DIGITS like :1 GROUP BY a.BOUNDARY_ZIP_CODE_DIGITS
9jyj1vwwbu4xr	select regionboun0_.FK_REGION_ID as FK6_1_, regionboun0_.SK_SUB_GRP_REGION_ZIP_ASSOC_ID as SK1_1_, regionboun0_.SK_SUB_GRP_REGION_ZIP_ASSOC_ID as SK1_395_0_, regionboun0_.STATUS_IND as STATUS2_395_0_, regionboun0_.BK_REGION_BNDRY_VALUE as BK3_395_0_, regionboun0_.LAST_UPDATE_USER_ID as LAST4_395_0_, regionboun0_.LAST_UPDATE_TS as LAST5_395_0_, regionboun0_.FK_REGION_ID as FK6_395_0_ from om_region_boundary regionboun0_ where regionboun0_.FK_REGION_ID=:1
9p1um1wd886xb	select o.owner#, u.name, o.name, o.namespace, o.obj#, d.d_timestamp, nvl(d.property, 0), o.type#, o.subname, d.d_attrs from dependency$ d, obj$ o, user$ u where d.p_obj#=:1 and (d.p_timestamp=:2 or d.property=2) and d.d_obj#=o.obj# and o.owner#=u.user# order by o.obj#
9qgtwh66xg6nz	update seg$ set type#=:4, blocks=:5, extents=:6, minexts=:7, maxexts=:8, extsize=:9, extpct=:10, user#=:11, iniexts=:12, lists=decode(:13, 65535, NULL, :13), groups=decode(:14, 65535, NULL, :14), cachehint=:15, hwmincr=:16, spare1=DECODE(:17, 0, NULL, :17), scanhint=:18 where ts#=:1 and file#=:2 and block#=:3
9r8qf5amrwcag	SELECT DISTINCT TUNER_POSITION, CHANNEL_NAME, ELCTRNC_PRGRM_GUIDE_GUID, CALL_LETTERS, MAP_NAME, MAP_AREA_NAME, VHO_CODE, DMA_NAME, CONTENT_TYPE, RESOLUTION, HD_FEE_RQRD FROM UDAS_CHMAP_SER_DETAILS_V a WHERE ZIP_CODE=:1 AND UPPER(MAP_TYPE)=:2 AND PACKAGE_BILLING_CODE IN ('UFAM') and not exists (select 1 from UDAS_CHMAP_SER_DETAILS_V b left outer join (select * from ref_filter_package where upper(package_type)=upper(:3)) rbasic on b.package_billing_code=rbasic.package_billing_code , ref_filter_channel rchnl where a.zip_code=b.zip_code and a.map_type=b.map_type and a.package_billing_code=b.package_billing_code and a.vho_code=b.vho_code and a.channel_name=b.channel_name and b.channel_name=rchnl.channel_name and rbasic.package_billing_code is null) AND VHO_CODE=:4 GROUP BY MAP_NAME, MAP_AREA_NAME, DMA_NAME, VHO_CODE, CHANNEL_NAME, ELCTRNC_PRGRM_GUIDE_GUID, TUNER_POSITION, CALL_LETTERS, CONTENT_TYPE, RESOLUTION, HD_FEE_RQRD, SERVICE_NAME, SERVICE_TYPE
a12b5292h48vq	select /*NORULE */ 'DATAPOINT free_space ' bpb, decode(min((a.BYTES_FREE / b.BYTES) * 100), '', 'NULL', min((a.BYTES_FREE / b.BYTES) * 100)) from (select /*NORULE */ tfs_b.name tablespace_name, tfs_b.ts# ts#, sum(nvl(tfs_a.bytes, 0)) bytes_free from dba_free_space tfs_a, sys.ts$ tfs_b where tfs_b.name = tfs_a.tablespace_name (+) and tfs_b.online$ != 3 group by tfs_b.name, tfs_b.ts#) a, (select /*NORULE */ e.tablespace_name, sum(e.bytes) bytes from dba_data_files e, (select /*NORULE */ tablespace_name from dba_data_files where autoextensible = 'YES') f where e.tablespace_name = f.tablespace_name(+) and f.tablespace_name is null and e.autoextensible = 'NO' group by e.tablespace_name) b, DBA_TABLESPACES c, (SELECT /*NORULE */ TS# FROM P$OBJ_EXCLUSION WHERE OBJECT_TYPE = 'TABLE' AND FILE# IS NULL AND BLOCK# IS NULL) d where a.TABLESPACE_NAME = b.TABLESPACE_NAME and b.TABLESPACE_NAME = c.TABLESPACE_NAME and c.CONTENTS != 'TEMPORARY' and c.status = 'ONLINE' and a.TS# = d.TS#(+) and d.TS# is NULL and c.TABLESPACE_NAME != 'SYSTEM'
a3t2dv56rvvuj	SELECT DISTINCT TUNER_POSITION, CHANNEL_NAME, ELCTRNC_PRGRM_GUIDE_GUID, CALL_LETTERS, MAP_NAME, MAP_AREA_NAME, VHO_CODE, DMA_NAME, CONTENT_TYPE, RESOLUTION, HD_FEE_RQRD FROM UDAS_CHMAP_SER_DETAILS_V a WHERE ZIP_CODE=:1 AND UPPER(MAP_TYPE)=:2 AND PACKAGE_BILLING_CODE IN ('U200') and not exists (select 1 from UDAS_CHMAP_SER_DETAILS_V b left outer join (select * from ref_filter_package where upper(package_type)=upper(:3)) rbasic on b.package_billing_code=rbasic.package_billing_code , ref_filter_channel rchnl where a.zip_code=b.zip_code and a.map_type=b.map_type and a.package_billing_code=b.package_billing_code and a.vho_code=b.vho_code and a.channel_name=b.channel_name and b.channel_name=rchnl.channel_name and rbasic.package_billing_code is null) AND VHO_CODE=:4 GROUP BY MAP_NAME, MAP_AREA_NAME, DMA_NAME, VHO_CODE, CHANNEL_NAME, ELCTRNC_PRGRM_GUIDE_GUID, TUNER_POSITION, CALL_LETTERS, CONTENT_TYPE, RESOLUTION, HD_FEE_RQRD, SERVICE_NAME, SERVICE_TYPE
a5vsgkgfc3q8w	UPDATE BF_MART_PRCH_HSTRY SET BE_STATE_ID=9, VERSION_NUM=VERSION_NUM+1, LAST_UPDATE_TS=SYSDATE, WORKFLOW_RUN_ID='737448' WHERE BILLING_FILE_ID=(SELECT SK_ID FROM BF_FWD_FILE_CTRL WHERE trim(BE_FILE_NAME)='UDAS_2_FWD_IPTV_SEQ059275_20110407124221.txt')
axmdf8vq7k1rh	select increment$, minvalue, maxvalue, cycle#, order$, cache, highwater, audit$, flags from seq$ where obj#=:1
b0bjzw3rya9j7	UPDATE BF_MART_PRCH_HSTRY SET BE_STATE_ID=9, VERSION_NUM=VERSION_NUM+1, LAST_UPDATE_TS=SYSDATE, WORKFLOW_RUN_ID='737163' WHERE BILLING_FILE_ID=(SELECT SK_ID FROM BF_FWD_FILE_CTRL WHERE trim(BE_FILE_NAME)='UDAS_2_FWD_IPTV_SEQ059269_20110407121941.txt')
bbmwdff29yy47	UPDATE BF_MART_PRCH_HSTRY SET BE_STATE_ID=9, VERSION_NUM=VERSION_NUM+1, LAST_UPDATE_TS=SYSDATE, WORKFLOW_RUN_ID='736767' WHERE BILLING_FILE_ID=(SELECT SK_ID FROM BF_FWD_FILE_CTRL WHERE trim(BE_FILE_NAME)='UDAS_2_FWD_IPTV_SEQ059254_20110407112200.txt')
brnztf3hyutu9	begin App_Team.table_trunc('BF_REG_COUPON_INV'); end;
c02896az8t7pk	INSERT INTO BF_AUDIT_TRAIL ( BF_AUDIT_ID , ASSET_DEPLOYMENT_ID , ASSET_BILLING_EVENT_ID , PRINCIPAL_EXTERNAL_ID , VHO_CLLI_CODE , RESOURCE_NAME , RESOURCE_TYPE , EVENT_TYPE , PROVIDER_ASSET_ID , SERVICE_PROVIDER_ID , CONTENT_PROVIDER_ID , GENRE , RATING , ADULT_CONTENT_IND , PURCHASE_DT , PPV_ASSET_START_DT , PPV_ASSET_END_DT , CURRENCY , PURCHASE_AMOUNT , DISCOUNT_AMOUNT , BILLED_AMOUNT , BILLED_ASSET_TITLE , OVERLAY_ASSET_TITLE , BILLING_FILE_ID , RECONCILIATION_FILE_ID , RELIABLE_DELIVERY_ID , SEQNBR , VERSION_NUM , BE_STATE_ID , PE_INSERT_TS , PE_LAST_UPDATE_TS , LAST_UPDATE_PROCESS_ID , CSF_SRC_STATUS , INSERT_TS, UAR_SRC_STATUS ) VALUES( BF_AUDIT_TRAIL_SEQ.NEXTVAL, :B1 , :B2 , :B3 , :B4 , :B5 , :B6 , :B7 , :B8 , :B9 , :B10 , :B11 , :B12 , :B13 , :B14 , :B15 , :B16 , :B17 , :B18 , :B19 , :B20 , :B21 , :B22 , :B23 , :B24 , :B25 , :B26 , :B27 , :B28 , :B29 , :B30 , :B31 , :B32 , SYSDATE, :B33 )
cdk073dvj8vua	SELECT 1 FROM DUAL WHERE EXISTS (SELECT * FROM SC_SVC_CHANGE WHERE SVCH_MOD_REC_SK_VAL = :B3 AND SVCH_MOD_REC_COL_SK_NM = :B2 AND SVCH_STATUS = 'Pending' AND SVCH_MOD_TABLE_NM = :B1 )
cpq6xj7pkk52y	delete from stg_service where PACKAGE_ID in (select PACKAGE_ID from stg_package where UPPER(PACKAGE_TYPE) not in ('LIVE', 'RDP'))
csgadz21m2mk0	UPDATE STG_SERVICE SET SERVICE_NAME = :1, INTENT = :2, HINT = :3 WHERE SERVICE_ID = :4
djdmff08yg5yt	SELECT BOUNDARY_ZIP_CODE_DIGITS, PRINCIPAL_GROUP_CODE, VHO_CLLI_CODE, DMA_NAME, PACKAGE_BILLING_CODE, TO_TIMESTAMP(PACKAGE_START_DATE, 'DD-MM-YYYY HH24:MI:SS.FF4') PACKAGE_START_DATE, PACKAGE_INCLUDES_HD_CONTENT, MAP_NAME, TO_TIMESTAMP(START_DATE, 'DD-MM-YYYY HH24:MI:SS.FF4') START_DATE FROM ( SELECT MIR_SA_BNDRY.BOUNDARY_ZIP_CODE_DIGITS, MIR_SA_PGROUP.PRINCIPAL_GROUP_CODE, MIR_SA_PGROUP.VHO_CLLI_CODE, MIR_SA_PGROUP.DMA_NAME, MIR_SA_PGROUP.PACKAGE_BILLING_CODE, DECODE(MIR_SA_PGROUP.PACKAGE_START_DATE, NULL, '01-JAN-1900', TO_CHAR(MIR_SA_PGROUP.PACKAGE_START_DATE, 'DD-MM-YYYY HH24:MI:SS.FF4')) PACKAGE_START_DATE, MIR_SA_PGROUP.PACKAGE_INCLUDES_HD_CONTENT, MIR_CHMAP.MAP_NAME, DECODE(MIR_CHMAP.START_DATE, NULL, '01-JAN-1900', TO_CHAR(MIR_CHMAP.START_DATE, 'DD-MM-YYYY HH24:MI:SS.FF4')) START_DATE FROM MIR_SA_BOUNDARY MIR_SA_BNDRY, MIR_SA_PRINCIPAL_GROUP MIR_SA_PGROUP, MIR_CHMAP_DETAILS MIR_CHMAP WHERE MIR_SA_BNDRY.SK_SERVICE_AREA =MIR_SA_PGROUP.SK_SERVICE_AREA AND MIR_SA_BNDRY.SK_CHANNEL_MAP = MIR_CHMAP.SK_CHANNEL_MAP MINUS SELECT SA_BNDRY.BOUNDARY_ZIP_CODE_DIGITS, SA_PGROUP.PRINCIPAL_GROUP_CODE, SA_PGROUP.VHO_CLLI_CODE, SA_PGROUP.DMA_NAME, SA_PGROUP.PACKAGE_BILLING_CODE, DECODE(SA_PGROUP.PACKAGE_START_DATE, NULL, '01-JAN-1900', TO_CHAR(SA_PGROUP.PACKAGE_START_DATE, 'DD-MM-YYYY HH24:MI:SS.FF4')) PACKAGE _START_DATE, SA_PGROUP.PACKAGE_INCLUDES_HD_CONTENT, CHMAP.MAP_NAME, DECODE(CHMAP.START_DATE, NULL, '01-JAN-1900', TO_CHAR(CHMAP.START_DATE, 'DD-MM-YYYY HH24:MI:SS.FF4')) START_DATE FROM SERVICE_AREA_BOUNDARY SA_BNDRY, SERVICE_AREA_PRINCIPAL_GROUP SA_PGROUP, CHANNEL_MAP_DETAILS CHMAP WHERE SA_BNDRY.SK_SERVICE_AREA = SA_PGROUP.SK_SERVICE_AREA AND SA_BNDRY.SK_CHANNEL_MAP = CHMAP.SK_CHANNEL_MAP AND SA_PGROUP.PACKAGE_END_DATE IS NULL AND CHMAP.END_DATE IS NULL)
f5ma6sr1cyd7m	INSERT INTO STG_PROGRAMID_MAPPER(INTERNAL_PROGRAM_ID, CONTENT_ID, VHO_CLLI_CODE) VALUES ( :1, :2, :3)
f7cj89gbthspp	DELETE FROM BF_STG_PRCH_HSTRY WHERE PRINCIPAL_EXTERNAL_ID = :1 AND ASSET_BILLING_EVENT_ID = :2 AND ASSET_DEPLOYMENT_ID = :3 AND VHO_CLLI_CODE = :4
f7h7zgxtbg0jk	SELECT BK_BNDRY_POINT_DIGITS, BK_PGROUP_NM FROM ( SELECT DISTINCT STG_PGA_BOUNDARY_POINTS.BK_BNDRY_POINT_DIGITS, STG_PGA_BOUNDARY_POINTS.BK_PGROUP_NM FROM STG_PGA_BOUNDARY_POINTS MINUS SELECT DISTINCT LC_PGA_BOUNDARY_POINTS.BK_BNDRY_POINT_DIGITS, LC_PGA_BOUNDARY_POINTS.BK_PGROUP_NM FROM LC_PGA_BOUNDARY_POINTS)
f8jra2wc6r5x7	SELECT TUNER_POSITION, ELCTRNC_PRGRM_GUIDE_GUID, COUNT(TUNER_POSITION) AS TUNERPOSITION FROM UDAS_CHMAP_SER_DETAILS_V a WHERE ZIP_CODE=:1 AND UPPER(MAP_TYPE)=:2 AND SERVICE_NAME IS NOT NULL AND PACKAGE_BILLING_CODE IN ('U200') and not exists (select package_billing_code from ref_filter_package rbasic, ref_filter_channel rchnl WHERE a.package_billing_code=rbasic.package_billing_code(+) and upper(package_type)=upper(:3) AND a.channel_name =rchnl.channel_name AND rbasic.package_billing_code IS NULL AND a.channel_name =rchnl.channel_name) AND VHO_CODE=:4 GROUP BY TUNER_POSITION, ELCTRNC_PRGRM_GUIDE_GUID
fvk5x826hw6gg	INSERT INTO BF_STG_PRCH_HSTRY(PRINCIPAL_EXTERNAL_ID, ASSET_BILLING_EVENT_ID, ASSET_DEPLOYMENT_ID, VHO_CLLI_CODE, PURCHASE_DT, PPV_ASSET_START_DT, PPV_ASSET_END_DT, SRC_VAL_STATUS, SRC_VAL_FAILURE_COUNT, IPTV_UPD_STATUS, IPTV_UPD_FAILURE_COUNT, BE_STATE_ID, LAST_UPDATE_TS, WORKFLOW_RUN_ID, PRICE) VALUES ( :1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15)
fzzrcp1wczcbw	UPDATE BF_MART_PRCH_HSTRY SET BE_STATE_ID=9, VERSION_NUM=VERSION_NUM+1, LAST_UPDATE_TS=SYSDATE, WORKFLOW_RUN_ID='736704' WHERE BILLING_FILE_ID=(SELECT SK_ID FROM BF_FWD_FILE_CTRL WHERE trim(BE_FILE_NAME)='UDAS_2_FWD_IPTV_SEQ059250_20110407111134.txt')
g00cj285jmgsw	update sys.mon_mods$ set inserts = inserts + :ins, updates = updates + :upd, deletes = deletes + :del, flags = (decode(bitand(flags, :flag), :flag, flags, flags + :flag)), drop_segments = drop_segments + :dropseg, timestamp = :time where obj# = :objn
g527v48drgf0j	SELECT BF_MART_PRCH_HSTRY.PRINCIPAL_EXTERNAL_ID, BF_MART_PRCH_HSTRY.ASSET_BILLING_EVENT_ID, BF_MART_PRCH_HSTRY.ASSET_DEPLOYMENT_ID, BF_MART_PRCH_HSTRY.PURCHASE_DT, BF_MART_PRCH_HSTRY.PPV_ASSET_START_DT, BF_MART_PRCH_HSTRY.PPV_ASSET_END_DT, BF_MART_PRCH_HSTRY.RESOURCE_NAME, BF_MART_PRCH_HSTRY.PROVIDER_ASSET_ID, BF_MART_PRCH_HSTRY.PURCHASE_AMOUNT, BF_MART_PRCH_HSTRY.GENRE, BF_MART_PRCH_HSTRY.RESOURCE_TYPE, BF_MART_PRCH_HSTRY.ADULT_CONTENT_IND, BF_MART_PRCH_HSTRY.DISCOUNT_AMOUNT, BF_MART_PRCH_HSTRY.BILLED_AMOUNT, BF_MART_PRCH_HSTRY.VERSION_NUM, BF_MART_PRCH_HSTRY.OVERLAY_ASSET_TITLE, DISCOUNT_COUPON.COUPON_CD, DISCOUNT_COUPON.COUPON_DESC, DISCOUNT_COUPON.COUPON_EXTERNAL_ID, DISCOUNT_COUPON.COUPON_NM, DISCOUNT_COUPON.COUPON_TYPE, DISCOUNT_COUPON.COUPON_VALUE, ASSET_COUPON_ASSOC.COUPON_APPLIED_DT FROM BF_MART_PRCH_HSTRY LEFT OUTER JOIN ASSET_COUPON_ASSOC ON BF_MART_PRCH_HSTRY.PRINCIPAL_EXTERNAL_ID=ASSET_COUPON_ASSOC.PRINCIPAL_EXTERNAL_ID AND BF_MART_PRCH_HSTRY.ASSET_BILLING_EVENT_ID=ASSET_COUPON_ASSOC.ASSET_BILLING_EVENT_ID AND BF_MART_PRCH_HSTRY.ASSET_DEPLOYMENT_ID=ASSET_COUPON_ASSOC.ASSET_DEPLOYMENT_ID LEFT OUTER JOIN DISCOUNT_COUPON ON ASSET_COUPON_ASSOC.SK_COUPON_ID=DISCOUNT_COUPON.SK_COUPON_ID WHERE BF_MART_PRCH_HSTRY.BE_STATE_ID=9 AND BF_MART_PRCH_HSTRY.RESOURCE_TYPE=' VOD' AND BF_MART_PRCH_HSTRY.UAR_SRC_STATUS='N'AND BF_MART_PRCH_HSTRY.CSF_SRC_STATUS=( CASE WHEN BF_MART_PRCH_HSTRY.BILLED_AMOUNT=0 THEN 0 ELSE 1 END)
gquasqp1c85d0	insert into OM_VHO_SVC_COL_ASSOC (version_num, sk_vho_id, SK_SVC_COL_ID, SK_SVC_ID, SVC_COL_SVC_SEQ, SVC_ORDER, last_update_ts, update_method, last_update_user_id, status, start_dt, end_dt, SK_VHO_SVC_COL_ID) values (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13)
grwydz59pu6mc	select text from view$ where rowid=:1
gztkq8a876n4s	UPDATE BF_MART_PRCH_HSTRY SET BE_STATE_ID=9, VERSION_NUM=VERSION_NUM+1, LAST_UPDATE_TS=SYSDATE, WORKFLOW_RUN_ID='737306' WHERE BILLING_FILE_ID=(SELECT SK_ID FROM BF_FWD_FILE_CTRL WHERE trim(BE_FILE_NAME)='UDAS_2_FWD_IPTV_SEQ059271_20110407122510.txt')

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

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Absolute Values

• Statistics with absolute values (should not be diffed)

Back to Instance Activity Statistics
Back to Top

Instance Activity Stats - Thread Activity

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

Back to Instance Activity Statistics
Back to Top

IO Stats

• Tablespace IO Stats
• File IO Stats

Tablespace IO Stats

• ordered by IOs (Reads + Writes) desc

Back to IO Stats
Back to Top

File IO Stats

• ordered by Tablespace, File

Back to IO Stats
Back to Top

Buffer Pool Statistics

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

Back to Top

Advisory Statistics

• Instance Recovery Stats
• 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