WORKLOAD REPOSITORY report for

DB Name	DB Id	Instance	Inst num	Startup Time	Release	RAC
CBW	4656724118	CBW	1	23-Apr-11 19:04	11.2.0.2.0	NO

Host Name	Platform	CPUs	Cores	Sockets	Memory (GB)
mnsdbp23	HP-UX IA (64-bit)	64	32	8	255.67

	Snap Id	Snap Time	Sessions	Cursors/Session
Begin Snap:	867	25-Apr-11 09:00:43	781	5.3
End Snap:	868	25-Apr-11 10:00:59	768	5.6
Elapsed:		60.26 (mins)
DB Time:		1,890.97 (mins)

Report Summary

Cache Sizes

	Begin	End
Buffer Cache:	91,648M	91,648M	Std Block Size:	32K
Shared Pool Size:	7,424M	7,424M	Log Buffer:	316,164K

Load Profile

	Per Second	Per Transaction	Per Exec	Per Call
DB Time(s):	31.4	15.6	0.25	0.11
DB CPU(s):	2.1	1.1	0.02	0.01
Redo size:	572,443.7	283,999.2
Logical reads:	17,050.7	8,459.2
Block changes:	1,656.9	822.0
Physical reads:	9,764.7	4,844.4
Physical writes:	33.8	16.8
User calls:	298.6	148.1
Parses:	108.7	53.9
Hard parses:	3.4	1.7
W/A MB processed:	28.7	14.2
Logons:	3.5	1.8
Executes:	127.5	63.3
Rollbacks:	0.0	0.0
Transactions:	2.0

Instance Efficiency Percentages (Target 100%)

Buffer Nowait %:	100.00	Redo NoWait %:	100.00
Buffer Hit %:	56.20	In-memory Sort %:	100.00
Library Hit %:	98.01	Soft Parse %:	96.86
Execute to Parse %:	14.77	Latch Hit %:	99.97
Parse CPU to Parse Elapsd %:	9.66	% Non-Parse CPU:	99.87

Shared Pool Statistics

	Begin	End
Memory Usage %:	38.31	36.82
% SQL with executions>1:	97.87	97.45
% Memory for SQL w/exec>1:	97.42	95.84

Top 5 Timed Foreground Events

Host CPU (CPUs: 64 Cores: 32 Sockets: 8)

Load Average Begin	Load Average End	%User	%System	%WIO	%Idle
0.11	0.05	4.9	2.0	0.0	93.1

Instance CPU

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

Memory Statistics

	Begin	End
Host Mem (MB):	261,802.8	261,802.8
SGA use (MB):	102,400.0	102,400.0
PGA use (MB):	2,325.4	2,268.7
% Host Mem used for SGA+PGA:	40.00	39.98

Main Report

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

Wait Events Statistics

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

Time Model Statistics

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

Operating System Statistics

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

Back to Wait Events Statistics
Back to Top

Operating System Statistics - Detail

Back to Wait Events Statistics
Back to Top

Foreground Wait Class

• s - second, ms - millisecond - 1000th of a second
• ordered by wait time desc, waits desc
• %Timeouts: value of 0 indicates value was < .5%. Value of null is truly 0
• Captured Time accounts for 99.7% of Total DB time 113,458.48 (s)
• Total FG Wait Time: 105,414.86 (s) DB CPU time: 7,720.93 (s)

Back to Wait Events Statistics
Back to Top

Foreground Wait Events

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

Back to Wait Events Statistics
Back to Top

Background Wait Events

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

Back to Wait Events Statistics
Back to Top

Wait Event Histogram

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

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (64 msec to 2 sec)

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

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (4 sec to 2 min)

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

Back to Wait Events Statistics
Back to Top

Wait Event Histogram Detail (4 min to 1 hr)

No data exists for this section of the report.

Back to Wait Events Statistics
Back to Top

Service Statistics

• ordered by DB Time

Back to Wait Events Statistics
Back to Top

Service Wait Class Stats

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

Back to Wait Events Statistics
Back to Top

SQL Statistics

• SQL ordered by Elapsed Time
• SQL ordered by CPU Time
• SQL ordered by User I/O Wait Time
• SQL ordered by Gets
• SQL ordered by Reads
• SQL ordered by Physical Reads (UnOptimized)
• SQL ordered by Executions
• SQL ordered by Parse Calls
• SQL ordered by Sharable Memory
• SQL ordered by Version Count
• Complete List of SQL Text

SQL ordered by Elapsed Time

• Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code.
• % Total DB Time is the Elapsed Time of the SQL statement divided into the Total Database Time multiplied by 100
• %Total - Elapsed Time as a percentage of Total DB time
• %CPU - CPU Time as a percentage of Elapsed Time
• %IO - User I/O Time as a percentage of Elapsed Time
• Captured SQL account for 98.9% of Total DB Time (s): 113,458
• Captured PL/SQL account for 0.0% of Total DB Time (s): 113,458

Back to SQL Statistics
Back to Top

SQL ordered by CPU Time

• Resources reported for PL/SQL code includes the resources used by all SQL statements called by the code.
• %Total - CPU Time as a percentage of Total DB CPU
• %CPU - CPU Time as a percentage of Elapsed Time
• %IO - User I/O Time as a percentage of Elapsed Time
• Captured SQL account for 88.9% of Total CPU Time (s): 7,721
• Captured PL/SQL account for 0.0% of Total CPU Time (s): 7,721

Back to SQL Statistics
Back to Top

SQL ordered by User I/O Wait Time

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

Back to SQL Statistics
Back to Top

SQL ordered by Gets

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

Back to SQL Statistics
Back to Top

SQL ordered by Reads

• %Total - Physical Reads as a percentage of Total Disk Reads
• %CPU - CPU Time as a percentage of Elapsed Time
• %IO - User I/O Time as a percentage of Elapsed Time
• Total Disk Reads: 35,306,191
• Captured SQL account for 99.6% of Total

Back to SQL Statistics
Back to Top

SQL ordered by Physical Reads (UnOptimized)

• UnOptimized Read Reqs = Physical Read Reqts - Optimized Read Reqs
• %Opt - Optimized Reads as percentage of SQL Read Requests
• %Total - UnOptimized Read Reqs as a percentage of Total UnOptimized Read Reqs
• Total Physical Read Requests: 20,669,505
• Captured SQL account for 0.7% of Total
• Total UnOptimized Read Requests: 20,669,505
• Captured SQL account for 0.7% of Total
• Total Optimized Read Requests: 1
• Captured SQL account for 0.0% of Total

Back to SQL Statistics
Back to Top

SQL ordered by Executions

• %CPU - CPU Time as a percentage of Elapsed Time
• %IO - User I/O Time as a percentage of Elapsed Time
• Total Executions: 460,942
• Captured SQL account for 80.5% of Total

Back to SQL Statistics
Back to Top

SQL ordered by Parse Calls

• Total Parse Calls: 392,850
• Captured SQL account for 83.9% of Total

Back to SQL Statistics
Back to Top

SQL ordered by Sharable Memory

• Only Statements with Sharable Memory greater than 1048576 are displayed

Back to SQL Statistics
Back to Top

SQL ordered by Version Count

No data exists for this section of the report.

Back to SQL Statistics
Back to Top

Complete List of SQL Text

SQL Id	SQL Text
04wrxwypk32yv	SELECT SUM(saturation_symb) FROM( SELECT /*+ PARALLEL(FRUT 16) */ MAX(saturation_symb) saturation_symb FROM EU_BILL.FU_REPORTING_sim_TABLE FRUT WHERE CUST_INFO_CONTRACT_ID = :B5 AND CUST_INFO_CUSTOMER_ID = :B4 AND ENTRY_DATE_TIMESTAMP >= :B3 AND ENTRY_DATE_TIMESTAMP <= NVL (:B2 , SYSDATE) AND ((TARIFF_INFO_SNCODE = 66) OR (MC_INFO_CODE IS NOT NULL) OR (good_glass_INFO_PART_CREATOR = 'X' AND EXISTS (SELECT mop_pain_ID FROM RPE_PACK@BSCSDB WHERE mop_pain_ID = good_glass_INFO_FU_PACK_ID AND LOWER(LONG_DESC) LIKE '%ith%'))) AND RATED_VOLUME_xiseem = :B1 AND panel_IND = 'H' AND TARIFF_INFO_TMCODE NOT IN (7, 636) AND RATED_FLAT_AMOUNT > 0 GROUP BY CUST_INFO_CUSTOMER_ID, CUST_INFO_CONTRACT_ID, CUST_INFO_BILL_CYCLE, ENTRY_DATE_TIMESTAMP, gls_STREAM_ID, gls_RECORD_ID, gls_BASE_PART_ID, gls_CHARGE_PART_ID)
0j6y3hqx18wmr	SELECT SUM(RESULT) FROM( SELECT /*+ PARALLEL(FRUT 16) */ (MAX(RATED_FLAT_AMOUNT) + MAX(NVL(panel_CHARGE_AMOUNT, 0)) + MAX(NVL(panel_CHARGE_TAX, 0)) - SUM(NVL(FREE_CHARGE_AMOUNT, 0)) - CASE MAX(TARIFF_INFO_SNCODE) WHEN 246 THEN MAX(NVL(panel_CHARGE_AMOUNT, 0)) ELSE 0 END) RESULT FROM EU_BILL.FU_REPORTING_sim_TABLE FRUT WHERE CUST_INFO_CONTRACT_ID = :B5 AND CUST_INFO_CUSTOMER_ID = :B4 AND ENTRY_DATE_TIMESTAMP >= :B3 AND ENTRY_DATE_TIMESTAMP <= NVL (:B2 , SYSDATE) AND NOT ((TARIFF_INFO_SNCODE = 66) OR (MC_INFO_CODE IS NOT NULL) OR (good_glass_INFO_PART_CREATOR = 'X' AND EXISTS (SELECT mop_pain_ID FROM RPE_PACK@BSCSDB WHERE mop_pain_ID = good_glass_INFO_FU_PACK_ID AND LOWER(LONG_DESC) LIKE '%ith%'))) AND RATED_VOLUME_xiseem = :B1 AND panel_IND = 'H' AND TARIFF_INFO_TMCODE NOT IN (7, 636) AND RATED_FLAT_AMOUNT > 0 GROUP BY CUST_INFO_CUSTOMER_ID, CUST_INFO_CONTRACT_ID, CUST_INFO_BILL_CYCLE, ENTRY_DATE_TIMESTAMP, gls_STREAM_ID, gls_RECORD_ID, gls_BASE_PART_ID, gls_CHARGE_PART_ID)
0k8522rmdzg4k	select privilege# from sysauth$ where (grantee#=:1 or grantee#=1) and privilege#>0
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')
11r0n880fu66h	SELECT NULL, gls_STREAM_ID, gls_RECORD_ID, gls_BASE_PART_ID, gls_CHARGE_PART_ID, gls_FREE_UNIT_PART_ID, gls_SPECIAL_PURPOSE_PART_ID, to_char(START_TIME_TIMESTAMP, 'YYYYMMDDHH24MISS'), START_TIME_OFFSET, TECHN_INFO_SCCODE, TECHN_INFO_PREPAY_IND, REMARK, RECORD_ID_CDR_ID, RECORD_ID_CDR_SUB_ID, RECORD_ID_bforef_SEQNO, CUST_INFO_CONTRACT_ID, CUST_INFO_CUSTOMER_ID, CUST_INFO_CONTRACT_PKEY, CUST_INFO_BUS_UNIT_ID, RATED_FLAT_AMOUNT, RATED_FLAT_AMOUNT_CURRENCY, RATED_FLAT_AMOUNT_GROSS_IND, TARIFF_INFO_TMCODE, TARIFF_INFO_TMVERSION, TARIFF_INFO_SPCODE, TARIFF_INFO_SNCODE, TARIFF_DETAIL_CBW_CHARGE_TYPE, TARIFF_DETAIL_LOGICAL_QUANTITY, ALT_TMCODE, ALT_value_AMOUNT, ALT_value_CURRENCY, ALT_value_GROSS_IND, to_char(ENTRY_DATE_TIMESTAMP, 'YYYYMMDDHH24MISS'), ENTRY_DATE_OFFSET, to_char(END_TIME_TIMESTAMP, 'YYYYMMDDHH24MISS'), END_TIME_OFFSET, TAX_INFO_SERV_CAT, TAX_INFO_SERV_TYPE, TAX_INFO_SERV_CODE, HOME_NETWORK_CODE, sim_CHARGEPART_ID, good_glass_INFO_PART_CREATOR, FREE_CLICKS_VOLUME, FREE_CLICKS_xiseem, FREE_ROUNDED_VOLUME_VOLUME, FREE_ROUNDED_VOLUME_xiseem, FREE_value_VOLUME_VOLUME, FREE_value_VOLUME_xiseem, FREE_CHARGE_AMOUNT, FREE_CHARGE_TAX, FREE_CHARGE_CURRENCY, FREE_CHARGE_GROSS_IND, ROUTING_INFO_IMP_EXP_MODE, to_char(INITIAL_START_TIME_TIMESTAMP, 'YYYYMMDDHH24MISS'), INITIAL_START_TIME_TIME_OFFSET, BAL_AUDIT_DAT_CONTRACT_ID, BAL_AUDIT_DAT_USER_PROFILE_ID, BAL_AUDIT_DAT_BALANCE_PROD_ID, BAL_AUDIT_DAT_BALANCE_ACCUM, BAL_AUDI T_DAT_BAL_BEFORE_CHG, BAL_AUDIT_DAT_BAL_AFTER_CHG, BAL_AUDIT_DAT_BUNDL_PROD_ID, BAL_AUDIT_DAT_PURCHASE_SEQ_NO, BAL_AUDIT_DAT_PREP_CREDIT_IND, six_INFO_six_PACKAGE_ID, six_INFO_six_PURPOSE, six_INFO_DETAIL_six_ALTERN_IND, six_INFO_DETAIL_SEQUENCE_SP, six_INFO_DETAIL_SEQUENCE_RP, six_INFO_DETAIL_CONTRACTED_IND, six_TARIFF_INFO_TMCODE, six_TARIFF_INFO_TMVERSION, six_TARIFF_INFO_SPCODE, six_TARIFF_INFO_SNCODE, CHARGE_INFO_CASH_FLOW_DIRECT, RECORD_TYPE_RECORD_CHRG_TYPE, SERVICE_INFO_USER_PROFILE_ID, SERVICE_INFO_NET_PROFILE_ID, SRV_CHARGE_INFO_CHARGEABLE_IND, SRV_CHARGE_INFO_OVERWRITE_IND, SRV_CHARGE_INFO_SRV_CHARGETYPE, SRV_CHARGE_INFO_CHARGE_SUBTYPE, SRV_CHARGE_INFO_NUM_ITEMS, SRV_CHARGE_INFO_NUM_DAYS, SRV_CHARGE_INFO_PRORATE_IND, SRV_CHARGE_INFO_VAS_IND, ITEM_PRICE_AMOUNT, ITEM_PRICE_CURRENCY, CHRG_SRV_INFO_STATUS, to_char(CHRGIV_STARTTIME_TIMESTAMP, 'YYYYMMDDHH24MISS'), CHRGIV_STARTTIME_TIME_OFFSET, to_char(CHRGIV_ENDTIME_TIMESTAMP, 'YYYYMMDDHH24MISS'), CHRGIV_ENDTIME_TIME_OFFSET, to_char(CHRGPRMVALIDFROM_TIMESTAMP, 'YYYYMMDDHH24MISS'), CHRGPRMVALIDFROM_TIME_OFFSET, CHRGSRVPARAMINFO_PARAM_VAL_ID FROM sim_NU_CHARGES WHERE CUST_INFO_CUSTOMER_ID = :MULT_ATTR_BIND0 AND CUST_INFO_CONTRACT_ID = :MULT_ATTR_BIND1 AND END_TIME_TIMESTAMP <= to_date( :MULT_ATTR_BIND2, 'YYYY-MM-DD-HH24.MI.SS' ) AND END_TIME_TIMESTAMP > to_date( :MULT_ATTR_BIND3, 'YYYY-MM-DD-HH24.MI.SS' ) AND ENTRY_DATE_TIMESTAMP < to_date( :MULT_ATTR_BIND4, 'YYYY-MM-DD-HH24. MI.SS' ) ORDER BY END_TIME_TIMESTAMP ASC , 2 ASC , 3 ASC , 4 ASC , 5 ASC , 6 ASC , 7 ASC
1gnbucx9h65sr	SELECT TABLE_NAME, gls_STREAM_ID, gls_RECORD_ID, gls_BASE_PART_ID, gls_CHARGE_PART_ID, gls_FREE_UNIT_PART_ID, gls_SPECIAL_PURPOSE_PART_ID, CALL_TYPE, panel_IND, FOLLOW_UP_CALL_TYPE, panel_CALL_TYPE, to_char(START_TIME_TIMESTAMP, 'YYYYMMDDHH24MISS'), START_TIME_OFFSET, SERVICE_LOGIC_CODE, SERVICE_ACTION_CODE, SERVICE_VAS_CODE, SERVICE_USED_SERVICE, saturation_symb, DURATION_xiseem, panel_CHARGE_AMOUNT, panel_CHARGE_TAX, panel_CHARGE_CURRENCY, panel_CHARGE_GROSS_IND, panel_DISCOUNT_AMOUNT, panel_DISCOUNT_CURRENCY, panel_TIME_BAND_CODE, panel_DAY_CATEGORY_CODE, S_P_NUMBER_ADDRESS, S_P_NUMBER_NUMBERING_PLAN, S_P_NUMBER_NETWORK_CODE, S_P_NUMBER_HOME_BID_ID, S_P_PORT_ADDRESS, S_P_PORT_NUMBERING_PLAN, S_P_EQUIPMENT_NUMBER, S_P_LOCATION_ADDRESS, S_P_LOCATION_NUMBERING_PLAN, S_P_LOC_SERVING_BID_ID, S_P_LOC_SERVING_LOCATION, S_P_HOME_LOC_ADDRESS, S_P_HOME_LOC_NUMBERING_PLAN, NET_ELEMENT_ADDRESS, NET_ELEMENT_NUMBERING_PLAN, NET_ELEMENT_TYPE_OF_NUMBER, NET_ELEMENT_NETWORK_CODE, O_P_NUMBER_ADDRESS, O_P_NUMBER_NUMBERING_PLAN, O_P_NUMBER_TYPE_OF_NUMBER, O_P_NUMBER_CLIR, O_P_NUMBER_CARRIER_CODE, ROUTING_ADDRESS, ROUTING_NUMBERING_PLAN, ROUTING_TYPE_OF_NUMBER, ROUTING_NETWORK_CODE, CAMEL_MSC_ADDRESS, CAMEL_MSC_ADDR_USER_PROF_ID, TECHN_INFO_PRE_value_IND, TECHN_INFO_TERMINATION_IND, TECHN_INFO_SCCODE, TECHN_INFO_HOME_TERMINATED_IND, TECHN_INFO_PREPAY_IND, OUTTRUNK, REMARK, CONTENT_REPORT, RECORD_ID_sim_FILE_ID, RECORD_ID_CALL_ID, RECORD_ID_ORIG_CDR_ID, RECORD_ID_CDR_ID, RECORD_ID_CDR_SUB_ID, RECORD_ID_TAP_SEQUENCE_NUM, RECORD_ID_bforef_SEQNO, DATA_VOLUME, DATA_VOLUME_xiseem, MESSAGES_VOLUME, MESSAGES_xiseem, CAMEL_REFERENCE_NUMBER, CUST_INFO_PORT_ID, CUST_INFO_CONTRACT_ID, CUST_INFO_CUSTOMER_ID, CUST_INFO_SUBS_CODE, CUST_INFO_SUBS_TAG, CUST_INFO_CUSTOMER_GROUP, CUST_INFO_BILLCYCLE_GROUP, CUST_INFO_USER_PROFILE_ID, CUST_INFO_MAIN_MSISDN, CUST_INFO_BILL_CYCLE, RATED_VOLUME, RATED_VOLUME_xiseem, ROUNDED_VOLUME, ROUNDED_VOLUME_xiseem, RATED_CLICKS_VOLUME, RATED_CLICKS_xiseem, RATED_FLAT_AMOUNT, RATED_FLAT_AMOUNT_TAX, RATED_FLAT_AMOUNT_CURRENCY, RATED_FLAT_AMOUNT_GROSS_IND, TARIFF_INFO_TMCODE, TARIFF_INFO_TMVERSION, TARIFF_INFO_RPVERSION, TARIFF_INFO_EGVERSION, TARIFF_INFO_SPCODE, TARIFF_INFO_SNCODE, TARIFF_INFO_TWCODE, TARIFF_INFO_GVCODE, TARIFF_INFO_ZNCODE, TARIFF_INFO_ZPCODE, TARIFF_INFO_TIME_BAND_CODE, TARIFF_INFO_ZPCODE_DAY_CATCODE, TARIFF_INFO_TM_USED_TYPE, TARIFF_INFO_USAGE_IND, TARIFF_INFO_EGCODE, TARIFF_INFO_RPCODE, TARIFF_DETAIL_TTCODE, TARIFF_DETAIL_CBW_CHARGE_TYPE, TARIFF_DETAIL_RATE_TYPE_ID, TARIFF_DETAIL_CHGBL_QUANTITY, TARIFF_DETAIL_EXT_CHRG_UDMCODE, MC_INFO_CODE, MC_INFO_IND, CALL_DEST, to_char(START_TIME_CHARGE_TIMESTAMP, 'YYYYMMDDHH24MISS'), START_TIME_CHARGE_OFFSET, LZLIST, to_char(ENTRY_DATE_TIMESTAMP, 'YYYYMMDDHH24MISS'), ENTRY_DATE_OFFSET, REJECT_REASON_CODE, NUMBER_OF_REJECTIONS, REJECTED_BASE_PART, TAX_INFO_SERV_CAT, TA X_INFO_SERV_TYPE, TAX_INFO_SERV_CODE, HOME_NETWORK_CODE, MC_SCALEFACTOR, ORIGIN_FIELD_ID, DESTINATION_FIELD_ID, sim_BASEPART_ID, sim_CHARGEPART_ID, CAMEL_DEST_ADDR_USER_PROF_ID, CAMEL_SRV_ADDR_USER_PROF_ID, S_PDP_ADDRESS, S_PDP_NUMBERING_PLAN, UPLINK_VOLUME_VOLUME, UPLINK_VOLUME_xiseem, DOWNLINK_VOLUME_VOLUME, DOWNLINK_VOLUME_xiseem, SGSN_ADDRESSES, BUSINESS_INFO_PRE_BS_ID, BUSINESS_INFO_PRE_BS_VERSION, BUSINESS_INFO_BS_ID, BUSINESS_INFO_BS_VERSION, BUSINESS_INFO_CHARGE_PARTY_ID, BUSINESS_INFO_CHARGE_ITEM_ID, BUSINESS_INFO_C_P_FIELD_REF, BUSINESS_INFO_O_P_FIELD_REF, SPEC_NUM_INFO_APPLY_good_glass, IMPACTED_PARTY2_TMCODE, O_P_NORMED_NUM_ADDRESS, O_P_NORMED_NUM_NUMBER_PLAN, O_P_NORMED_NUM_INT_ACC_CODE, NORMED_RTD_NUM_ADDRESS, NORMED_RTD_NUM_NUMBER_PLAN, NORMED_RTD_NUM_INT_ACC_CODE, EVENT_VOLUME, EVENT_xiseem, good_glass_INFO_FU_PACK_ID, good_glass_INFO_VERSION, good_glass_INFO_FUP_SEQ, good_glass_INFO_CHG_RED_QUOTA, good_glass_INFO_SEQNO, good_glass_INFO_ACCOUNT_KEY, good_glass_INFO_PREVIOUS_SEQNO, good_glass_INFO_ACC_HIST_ID, good_glass_INFO_ACCOUNT_ORIGIN, good_glass_INFO_PART_CREATOR, good_glass_INFO_DISCOUNT_RATE, good_glass_INFO_APPL_METHOD, FREE_CLICKS_VOLUME, FREE_CLICKS_xiseem, FREE_ROUNDED_VOLUME_VOLUME, FREE_ROUNDED_VOLUME_xiseem, FREE_value_VOLUME_VOLUME, FREE_value_VOLUME_xiseem, ZERO_ROUNDED_VOLUME_VOLUME, ZERO_ROUNDED_VOLUME_xiseem, ZERO_value_VOLUME_VOLUME, ZERO_value_VOLUME_xiseem, FREE_CHARGE_AMOUNT, FRE E_CHARGE_TAX, FREE_CHARGE_CURRENCY, FREE_CHARGE_GROSS_IND, OR_FLAG, AN_PACK_AN_PACKAGE_ID_LIST, AN_PACK_ORIG_AN_PACK_ID_LIST, O_P_NUMBER_BACKUP_ADDRESS, panel_BASE_CHARGE_AMOUNT, panel_BASE_CHARGE_TAX, panel_BASE_CHARGE_CURRENCY, panel_BASE_CHARGE_GROSS_IND, RECIPIENT_NET_ADDRESS, RECIPIENT_NET_NUMBERING_PLAN, to_char(INITIAL_START_TIME_TIMESTAMP, 'YYYYMMDDHH24MISS'), INITIAL_START_TIME_TIME_OFFSET, EVENT_INFO_EVENT_TYPE, S_P_HOME_ID_NETWORK, S_P_HOME_ID_HOME_BID_ID, RATED_FLAT_AMOUNT_ORIG_AMOUNT, RATED_FLAT_AMOUNT_ORIG_TAX, RATED_FLAT_AMNT_ORIG_CURRENCY, RATED_FLAT_AMNT_ORIG_GROSS_IND, UNBILLED_AMOUNT_AMOUNT, UNBILLED_AMOUNT_CURRENCY, CHARGE_INFO_CASH_FLOW_DIRECT, bforef_INFO_bforef_RECORD_TYPE, MICRO_roll_MC_CODE, MICRO_roll_SCALEFACTOR, MICRO_roll_MC_PKEY, MICRO_roll_MC_TYPE, MICRO_roll_IMCSCALEFACTORTYPE, to_char(ORIG_ENTRY_DATE_TIMESTAMP, 'YYYYMMDDHH24MISS'), ORIG_ENTRY_DATE_TIME_OFFSET, CALLED_PARTY_MNP_ADDRESS, CALLED_PARTY_MNP_NUMBER_PLAN, CALLED_PARTY_MNP_TYPE_OF_NUM, CALLED_PARTY_MNP_IAC, panel_bforef_AMOUNT, panel_bforef_TAX, panel_bforef_CURRENCY, panel_bforef_GROSS_IND, panel_ORIGINAL_AMOUNT, panel_ORIGINAL_TAX, panel_ORIGINAL_CURRENCY, panel_ORIGINAL_GROSS_IND, panel_SURCHARGE_AMOUNT, panel_SURCHARGE_TAX, panel_SURCHARGE_CURRENCY, panel_SURCHARGE_GROSS_IND, ISMSC_ISN_SERIAL_NUMBER FROM CBW_sim WHERE CUST_INFO_CUSTOMER_ID = :MULT_ATTR_BIND0 AND CUST_INFO_CONTRACT_ID = :MULT_ATTR_BIND1 AND ENTRY_DATE_TIMESTAMP < to_date( :MULT_ATTR_BIND2, 'YYYY-MM-DD-HH24.MI.SS' ) AND ENTRY_DATE_TIMESTAMP >= to_date( :MULT_ATTR_BIND3, 'YYYY-MM-DD-HH24.MI.SS' ) AND CUST_INFO_BILL_CYCLE IN ('18') ORDER BY INITIAL_START_TIME_TIMESTAMP ASC , 2 ASC , 3 ASC , 4 ASC , 5 ASC , 6 ASC , 7 ASC
1jx2xc38k6zn9	SELECT NULL, gls_STREAM_ID, BI_RECORD_ID, BI_BALANCE_PART_ID, BI_SESSION_PART_ID, BI_THRESHOLD_PART_ID, BI_ROUT_INFO_FAMILY_GROUP_ID, BI_ROUTING_INFO_REQ_APPL_ID, BI_PURPOSE_BI_PURPOSE, BI_PURPOSE_BI_TYPE, to_char(BI_EXT_REQUEST_TIMESTAMP, 'YYYYMMDDHH24MISS'), BI_EXT_REQUEST_CONTRACT_ID, BI_EXT_REQUEST_CUSTOMER_ID, BI_EXT_REQUEST_SNCODE, BI_EXT_REQUEST_USER_PROFILE_ID, BI_EXT_REQUEST_EXTERNAL_REQ_ID, BI_BALAN_IDENT_CONTRACT_ID, BI_BALAN_IDENT_CUSTOMER_ID, BI_BALAN_IDENT_SNCODE, BI_BALAN_IDENT_USER_PROFILE_ID, BI_debit_pbak_AMOUNT, BI_debit_pbak_CURRENCY, BI_CREDIT_VOLUME_VOLUME, BI_CREDIT_VOLUME_xiseem, to_char(BI_START_DATE_TIMESTAMP, 'YYYYMMDDHH24MISS'), BI_START_DATE_TIME_OFFSET, to_char(BI_END_DATE_TIMESTAMP, 'YYYYMMDDHH24MISS'), BI_END_DATE_TIME_OFFSET, to_char(BI_NEXT_RESET_TIMESTAMP, 'YYYYMMDDHH24MISS'), BI_NEXT_RESET_TIME_OFFSET, BI_REQ_AMOUNT_AMOUNT, BI_REQ_AMOUNT_CURRENCY, BI_REQ_AMOUNT_GROSS_IND, BI_REQ_VOLUME_VOLUME, BI_REQ_VOLUME_xiseem, to_char(BI_BALAN_SNAP_DATE_TIMESTAMP, 'YYYYMMDDHH24MISS'), BI_BALAN_SNAP_DATE_TIME_OFFSET, BI_REM_debit_pbak_AMOUNT, BI_REM_debit_pbak_CURRENCY, BI_REM_CREDIT_VOL_VOLUME, BI_REM_CREDIT_VOL_xiseem, BI_DET_ACTION_DETAILED_ACTION, BI_DET_ACT_AMOUNT_AMOUNT, BI_DET_ACT_CURRENCY, BI_DET_ACT_GROSS_IND, BI_DET_ACT_VOLUME_VOLUME, BI_DET_ACT_xiseem, to_char(BI_ENTRY_DATE_TIMESTAMP, 'YYYYMMDDHH24MISS'), BI_LC_INFO_TRIGGER_LC_FLAG, BI_VOUCHERINFO_VOUCHERTYPE, BI_VOUCHERINFO_VOUCHERID, BI _TOPUPACTINF_AMOUNT, BI_TOPUPACTINF_CURRENCY, BI_TOPUPACTINF_CONTRACTID, BI_TOPUPACTINF_TMCODE, BI_TOPUPACTINF_SNCODE, BI_TOPUPACTINF_USERPROFILEID, BI_TOPUPACTINF_PURCHASE_SEQNO, to_char(BI_TOPUPACTINF_VALIDFROM, 'YYYYMMDDHH24MISS'), to_char(BI_TOPUPACTINF_VALIDTO, 'YYYYMMDDHH24MISS'), BI_TOPUPACTINF_REQSUBID, BI_TOPUPACTINF_RULEPACKID, BI_TOPUPACTINF_RULEMODELID, BI_TOPUPACTINF_RULEELEMENTID, BI_TOPUPACTINF_RULEMECHID, BI_TOPUPACTINF_TOPUPACTLISTID, BI_TOPUPACTINF_TOPUPACTLISVERS, BI_TOPUPACTINF_TOPUPACTTYPE, BI_TOPUPACTINF_TOPUPACTITMSTAT, BI_TOPUPACTINF_PRICALTERNID, BI_TOPUPACTINF_ACCRELEVFLAG, BI_TOPUPACTINF_TOPUPACT_ITM_ID, BI_LCACTEXPPERIOD_PERIOD, BI_LCACTEXPPERIOD_PERIODTYPE, BI_LCPASSEXPPERIOD_PERIOD, BI_LCPASSEXPPERIOD_PERIODTYPE, BI_TOPUPACTEXPPERID_PERIOD, BI_TOPUPACTEXPPERID_PERIODTYPE, BI_TOPUPPASEXPPERID_PERIOD, BI_TOPUPPASEXPPERID_PERIODTYPE, BI_EXTACTEXPPERIOD_PERIOD, BI_EXTACTEXPPERIOD_PERIODTYPE, BI_EXTPASEXPPERIOD_PERIOD, BI_EXTPASEXPPERIOD_PERIODTYPE FROM TOPUP_REQUEST_ACTION WHERE BI_EXT_REQUEST_CUSTOMER_ID = :MULT_ATTR_BIND0 AND BI_EXT_REQUEST_CONTRACT_ID = :MULT_ATTR_BIND1 AND BI_ENTRY_DATE_TIMESTAMP <= to_date( :MULT_ATTR_BIND2, 'YYYY-MM-DD-HH24.MI.SS' ) AND BI_ENTRY_DATE_TIMESTAMP > to_date( :MULT_ATTR_BIND3, 'YYYY-MM-DD-HH24.MI.SS' ) ORDER BY BI_ENTRY_DATE_TIMESTAMP ASC , 2 ASC , 3 ASC , 4 ASC , 5 ASC , 6 ASC
1wfy9u3ddmd3d	SELECT /*+ PARALLEL(FRUT 16) */ SUM(DATA_VOLUME) FROM EU_BILL.FU_REPORTING_sim_TABLE FRUT WHERE CUST_INFO_CONTRACT_ID = :B7 AND CUST_INFO_CUSTOMER_ID = :B6 AND ((:B5 IS NOT NULL AND (INSTR(:B5 , ':' || TARIFF_INFO_ZNCODE || ', ' || TARIFF_INFO_SNCODE || ':') > 0 OR INSTR(:B5 , ':0, ' || TARIFF_INFO_SNCODE || ':') > 0 OR INSTR(:B5 , ':' || TARIFF_INFO_ZNCODE || ', 0:') > 0)) OR (:B4 IS NOT NULL AND NOT (INSTR(:B4 , ':' || TARIFF_INFO_ZNCODE || ', ' || TARIFF_INFO_SNCODE || ':') > 0 OR INSTR(:B4 , ':0, ' || TARIFF_INFO_SNCODE || ':') > 0 OR INSTR(:B4 , ':' || TARIFF_INFO_ZNCODE || ', 0:') > 0))) AND TARIFF_INFO_SNCODE = 63 AND ENTRY_DATE_TIMESTAMP >= :B3 AND ENTRY_DATE_TIMESTAMP <= NVL(:B2 , SYSDATE) AND RATED_VOLUME_xiseem = :B1 AND panel_IND = 'H' AND gls_CHARGE_PART_ID = 1 AND TARIFF_INFO_TMCODE NOT IN (7, 636) AND RATED_FLAT_AMOUNT > 0 AND ((gls_FREE_UNIT_PART_ID = 0) OR (gls_FREE_UNIT_PART_ID = 1))
2nbry1kgcbf6b	SELECT round(bitand(s.ownerid, 65535)) parent_session_sid, round(bitand(s.ownerid, 16711680)/65536) parent_session_instid, s.SADDR, s.SID, s.SERIAL#, s.AUDSID, s.PADDR, s.USER#, s.USERNAME, s.COMMAND, s.OWNERID, s.TADDR, s.LOCKWAIT, s.STATUS, s.SERVER, s.SCHEMA#, s.SCHEMANAME, s.OSUSER, s.PROCESS, s.MACHINE, s.PORT, s.TERMINAL, UPPER(s.PROGRAM) PROGRAM, s.TYPE, s.SQL_ADDRESS, s.SQL_HASH_VALUE, s.SQL_ID, s.SQL_CHILD_NUMBER, s.SQL_EXEC_START, s.SQL_EXEC_ID, s.PREV_SQL_ADDR, s.PREV_HASH_VALUE, s.PREV_SQL_ID, s.PREV_CHILD_NUMBER, s.PREV_EXEC_START, s.PREV_EXEC_ID, s.PLSQL_ENTRY_OBJECT_ID, s.PLSQL_ENTRY_SUBPROGRAM_ID, s.PLSQL_OBJECT_ID, s.PLSQL_SUBPROGRAM_ID, s.MODULE, s.MODULE_HASH, s.ACTION, s.ACTION_HASH, s.CLIENT_INFO, s.FIXED_TABLE_SEQUENCE, s.ROW_WAIT_OBJ#, s.ROW_WAIT_FILE#, s.ROW_WAIT_BLOCK#, s.ROW_WAIT_ROW#, s.TOP_LEVEL_CALL#, s.LOGON_TIME, s.LAST_CALL_ET, s.PDML_ENABLED, s.FAILOVER_TYPE, s.FAILOVER_METHOD, s.FAILED_OVER, s.RESOURCE_CONSUMER_GROUP, s.PDML_STATUS, s.PDDL_STATUS, s.PQ_STATUS, s.CURRENT_QUEUE_DURATION, s.CLIENT_IDENTIFIER, s.BLOCKING_SESSION_STATUS, s.BLOCKING_INSTANCE, s.BLOCKING_SESSION, s.FINAL_BLOCKING_SESSION_STATUS, s.FINAL_BLOCKING_INSTANCE, s.FINAL_BLOCKING_SESSION, s.SEQ#, s.EVENT#, s.EVENT, s.P1TEXT, s.P1, s.P1RAW, s.P2TEXT, s.P2, s.P2RAW, s.P3TEXT, s.P3, s.P3RAW, s.WAIT_CLASS_ID, s.WAIT_CLASS#, s.WAIT_CLASS, s.WAIT_TIME, s.SECONDS_IN_WAIT, s.STATE, s.WAIT_TIME_ MICRO, s.TIME_REMAINING_MICRO, s.TIME_SINCE_LAST_WAIT_MICRO, s.SERVICE_NAME, s.SQL_TRACE, s.SQL_TRACE_WAITS, s.SQL_TRACE_BINDS, s.SQL_TRACE_PLAN_STATS, s.SESSION_EDITION_ID, s.CREATOR_ADDR, s.CREATOR_SERIAL#, s.ECID FROM V$SESSION S WHERE ( s.STATUS = 'ACTIVE' ) AND ( (s.USERNAME is not null) and (NVL(s.osuser, 'x') <> 'SYSTEM') and (s.type <> 'BACKGROUND') ) order by "USERNAME", OWNERID
3c0tgk6phq37z	SELECT TABLE_NAME, gls_STREAM_ID, gls_RECORD_ID, gls_BASE_PART_ID, gls_CHARGE_PART_ID, gls_FREE_UNIT_PART_ID, gls_SPECIAL_PURPOSE_PART_ID, CALL_TYPE, panel_IND, FOLLOW_UP_CALL_TYPE, panel_CALL_TYPE, to_char(START_TIME_TIMESTAMP, 'YYYYMMDDHH24MISS'), START_TIME_OFFSET, SERVICE_LOGIC_CODE, SERVICE_ACTION_CODE, SERVICE_VAS_CODE, SERVICE_USED_SERVICE, saturation_symb, DURATION_xiseem, panel_CHARGE_AMOUNT, panel_CHARGE_TAX, panel_CHARGE_CURRENCY, panel_CHARGE_GROSS_IND, panel_DISCOUNT_AMOUNT, panel_DISCOUNT_CURRENCY, panel_TIME_BAND_CODE, panel_DAY_CATEGORY_CODE, S_P_NUMBER_ADDRESS, S_P_NUMBER_NUMBERING_PLAN, S_P_NUMBER_NETWORK_CODE, S_P_NUMBER_HOME_BID_ID, S_P_PORT_ADDRESS, S_P_PORT_NUMBERING_PLAN, S_P_EQUIPMENT_NUMBER, S_P_LOCATION_ADDRESS, S_P_LOCATION_NUMBERING_PLAN, S_P_LOC_SERVING_BID_ID, S_P_LOC_SERVING_LOCATION, S_P_HOME_LOC_ADDRESS, S_P_HOME_LOC_NUMBERING_PLAN, NET_ELEMENT_ADDRESS, NET_ELEMENT_NUMBERING_PLAN, NET_ELEMENT_TYPE_OF_NUMBER, NET_ELEMENT_NETWORK_CODE, O_P_NUMBER_ADDRESS, O_P_NUMBER_NUMBERING_PLAN, O_P_NUMBER_TYPE_OF_NUMBER, O_P_NUMBER_CLIR, O_P_NUMBER_CARRIER_CODE, ROUTING_ADDRESS, ROUTING_NUMBERING_PLAN, ROUTING_TYPE_OF_NUMBER, ROUTING_NETWORK_CODE, CAMEL_MSC_ADDRESS, CAMEL_MSC_ADDR_USER_PROF_ID, TECHN_INFO_PRE_value_IND, TECHN_INFO_TERMINATION_IND, TECHN_INFO_SCCODE, TECHN_INFO_HOME_TERMINATED_IND, TECHN_INFO_PREPAY_IND, OUTTRUNK, REMARK, CONTENT_REPORT, RECORD_ID_sim_FILE_ID, RECORD_ID_CALL_ID, RECORD_ID_ORIG_CDR_ID, RECORD_ID_CDR_ID, RECORD_ID_CDR_SUB_ID, RECORD_ID_TAP_SEQUENCE_NUM, RECORD_ID_bforef_SEQNO, DATA_VOLUME, DATA_VOLUME_xiseem, MESSAGES_VOLUME, MESSAGES_xiseem, CAMEL_REFERENCE_NUMBER, CUST_INFO_PORT_ID, CUST_INFO_CONTRACT_ID, CUST_INFO_CUSTOMER_ID, CUST_INFO_SUBS_CODE, CUST_INFO_SUBS_TAG, CUST_INFO_CUSTOMER_GROUP, CUST_INFO_BILLCYCLE_GROUP, CUST_INFO_USER_PROFILE_ID, CUST_INFO_MAIN_MSISDN, CUST_INFO_BILL_CYCLE, RATED_VOLUME, RATED_VOLUME_xiseem, ROUNDED_VOLUME, ROUNDED_VOLUME_xiseem, RATED_CLICKS_VOLUME, RATED_CLICKS_xiseem, RATED_FLAT_AMOUNT, RATED_FLAT_AMOUNT_TAX, RATED_FLAT_AMOUNT_CURRENCY, RATED_FLAT_AMOUNT_GROSS_IND, TARIFF_INFO_TMCODE, TARIFF_INFO_TMVERSION, TARIFF_INFO_RPVERSION, TARIFF_INFO_EGVERSION, TARIFF_INFO_SPCODE, TARIFF_INFO_SNCODE, TARIFF_INFO_TWCODE, TARIFF_INFO_GVCODE, TARIFF_INFO_ZNCODE, TARIFF_INFO_ZPCODE, TARIFF_INFO_TIME_BAND_CODE, TARIFF_INFO_ZPCODE_DAY_CATCODE, TARIFF_INFO_TM_USED_TYPE, TARIFF_INFO_USAGE_IND, TARIFF_INFO_EGCODE, TARIFF_INFO_RPCODE, TARIFF_DETAIL_TTCODE, TARIFF_DETAIL_CBW_CHARGE_TYPE, TARIFF_DETAIL_RATE_TYPE_ID, TARIFF_DETAIL_CHGBL_QUANTITY, TARIFF_DETAIL_EXT_CHRG_UDMCODE, MC_INFO_CODE, MC_INFO_IND, CALL_DEST, to_char(START_TIME_CHARGE_TIMESTAMP, 'YYYYMMDDHH24MISS'), START_TIME_CHARGE_OFFSET, LZLIST, to_char(ENTRY_DATE_TIMESTAMP, 'YYYYMMDDHH24MISS'), ENTRY_DATE_OFFSET, REJECT_REASON_CODE, NUMBER_OF_REJECTIONS, REJECTED_BASE_PART, TAX_INFO_SERV_CAT, TA X_INFO_SERV_TYPE, TAX_INFO_SERV_CODE, HOME_NETWORK_CODE, MC_SCALEFACTOR, ORIGIN_FIELD_ID, DESTINATION_FIELD_ID, sim_BASEPART_ID, sim_CHARGEPART_ID, CAMEL_DEST_ADDR_USER_PROF_ID, CAMEL_SRV_ADDR_USER_PROF_ID, S_PDP_ADDRESS, S_PDP_NUMBERING_PLAN, UPLINK_VOLUME_VOLUME, UPLINK_VOLUME_xiseem, DOWNLINK_VOLUME_VOLUME, DOWNLINK_VOLUME_xiseem, SGSN_ADDRESSES, BUSINESS_INFO_PRE_BS_ID, BUSINESS_INFO_PRE_BS_VERSION, BUSINESS_INFO_BS_ID, BUSINESS_INFO_BS_VERSION, BUSINESS_INFO_CHARGE_PARTY_ID, BUSINESS_INFO_CHARGE_ITEM_ID, BUSINESS_INFO_C_P_FIELD_REF, BUSINESS_INFO_O_P_FIELD_REF, SPEC_NUM_INFO_APPLY_good_glass, IMPACTED_PARTY2_TMCODE, O_P_NORMED_NUM_ADDRESS, O_P_NORMED_NUM_NUMBER_PLAN, O_P_NORMED_NUM_INT_ACC_CODE, NORMED_RTD_NUM_ADDRESS, NORMED_RTD_NUM_NUMBER_PLAN, NORMED_RTD_NUM_INT_ACC_CODE, EVENT_VOLUME, EVENT_xiseem, good_glass_INFO_FU_PACK_ID, good_glass_INFO_VERSION, good_glass_INFO_FUP_SEQ, good_glass_INFO_CHG_RED_QUOTA, good_glass_INFO_SEQNO, good_glass_INFO_ACCOUNT_KEY, good_glass_INFO_PREVIOUS_SEQNO, good_glass_INFO_ACC_HIST_ID, good_glass_INFO_ACCOUNT_ORIGIN, good_glass_INFO_PART_CREATOR, good_glass_INFO_DISCOUNT_RATE, good_glass_INFO_APPL_METHOD, FREE_CLICKS_VOLUME, FREE_CLICKS_xiseem, FREE_ROUNDED_VOLUME_VOLUME, FREE_ROUNDED_VOLUME_xiseem, FREE_value_VOLUME_VOLUME, FREE_value_VOLUME_xiseem, ZERO_ROUNDED_VOLUME_VOLUME, ZERO_ROUNDED_VOLUME_xiseem, ZERO_value_VOLUME_VOLUME, ZERO_value_VOLUME_xiseem, FREE_CHARGE_AMOUNT, FRE E_CHARGE_TAX, FREE_CHARGE_CURRENCY, FREE_CHARGE_GROSS_IND, OR_FLAG, AN_PACK_AN_PACKAGE_ID_LIST, AN_PACK_ORIG_AN_PACK_ID_LIST, O_P_NUMBER_BACKUP_ADDRESS, panel_BASE_CHARGE_AMOUNT, panel_BASE_CHARGE_TAX, panel_BASE_CHARGE_CURRENCY, panel_BASE_CHARGE_GROSS_IND, RECIPIENT_NET_ADDRESS, RECIPIENT_NET_NUMBERING_PLAN, to_char(INITIAL_START_TIME_TIMESTAMP, 'YYYYMMDDHH24MISS'), INITIAL_START_TIME_TIME_OFFSET, EVENT_INFO_EVENT_TYPE, S_P_HOME_ID_NETWORK, S_P_HOME_ID_HOME_BID_ID, RATED_FLAT_AMOUNT_ORIG_AMOUNT, RATED_FLAT_AMOUNT_ORIG_TAX, RATED_FLAT_AMNT_ORIG_CURRENCY, RATED_FLAT_AMNT_ORIG_GROSS_IND, UNBILLED_AMOUNT_AMOUNT, UNBILLED_AMOUNT_CURRENCY, CHARGE_INFO_CASH_FLOW_DIRECT, bforef_INFO_bforef_RECORD_TYPE, MICRO_roll_MC_CODE, MICRO_roll_SCALEFACTOR, MICRO_roll_MC_PKEY, MICRO_roll_MC_TYPE, MICRO_roll_IMCSCALEFACTORTYPE, to_char(ORIG_ENTRY_DATE_TIMESTAMP, 'YYYYMMDDHH24MISS'), ORIG_ENTRY_DATE_TIME_OFFSET, CALLED_PARTY_MNP_ADDRESS, CALLED_PARTY_MNP_NUMBER_PLAN, CALLED_PARTY_MNP_TYPE_OF_NUM, CALLED_PARTY_MNP_IAC, panel_bforef_AMOUNT, panel_bforef_TAX, panel_bforef_CURRENCY, panel_bforef_GROSS_IND, panel_ORIGINAL_AMOUNT, panel_ORIGINAL_TAX, panel_ORIGINAL_CURRENCY, panel_ORIGINAL_GROSS_IND, panel_SURCHARGE_AMOUNT, panel_SURCHARGE_TAX, panel_SURCHARGE_CURRENCY, panel_SURCHARGE_GROSS_IND, ISMSC_ISN_SERIAL_NUMBER FROM CBW_sim WHERE CUST_INFO_CUSTOMER_ID = :MULT_ATTR_BIND0 AND CUST_INFO_CONTRACT_ID = :MULT_ATTR_BIND1 AND ENTRY_DATE_TIMESTAMP < to_date( :MULT_ATTR_BIND2, 'YYYY-MM-DD-HH24.MI.SS' ) AND ENTRY_DATE_TIMESTAMP >= to_date( :MULT_ATTR_BIND3, 'YYYY-MM-DD-HH24.MI.SS' ) AND CUST_INFO_BILL_CYCLE IN ('13', '16') ORDER BY INITIAL_START_TIME_TIMESTAMP ASC , 2 ASC , 3 ASC , 4 ASC , 5 ASC , 6 ASC , 7 ASC
3qhpsxxsjby44	select A.BI_BALAN_IDENT_CONTRACT_ID , A.BI_BALAN_IDENT_SNCODE , A.BI_BALAN_IDENT_USER_PROFILE_ID , A.BI_BALAN_IDENT_AGGREGATE_MONEY , A.BI_AGGR_CHRG_AMOUNT , A.BI_AGGR_CHRG_CURRENCY , A.BI_debit_pbak_AMOUNT , A.BI_debit_pbak_CURRENCY , A.BI_REM_debit_pbak_AMOUNT , A.BI_REM_debit_pbak_CURRENCY , A.BI_AGGR_VOLUME_VOLUME , A.BI_AGGR_VOLUME_xiseem , A.BI_CREDIT_VOLUME_VOLUME , A.BI_REM_CREDIT_VOL_VOLUME , TO_CHAR(A.BI_END_DATE_TIMESTAMP, 'YYYY-MM-DD HH24:MI:SS') , A.BI_END_DATE_TIME_OFFSET , TO_CHAR(A.BI_NEXT_RESET_TIMESTAMP, 'YYYYMMDDHH24MISS') , A.BI_NEXT_RESET_TIME_OFFSET , TO_CHAR(A.BI_BALAN_SNAP_DATE_TIMESTAMP, 'YYYYMMDDHH24MISS') , A.BI_BALAN_SNAP_DATE_TIME_OFFSET , A.BI_BALAN_ATTR_MONEY_WALLET , NVL(A.BI_BALAN_IDENT_PURCHASE_SEQ_NO, 0) , NVL(A.BI_BALAN_IDENT_BUNDL_PROD_ID, 0) , TO_CHAR(A.BI_START_DATE_TIMESTAMP, 'YYYY-MM-DD HH24:MI:SS') , A.BI_START_DATE_TIME_OFFSET from BI_ACCOUNTS_VIEW A , hro_PROCESS_CONTR B where (((((((A.BI_BALAN_IDENT_CONTRACT_ID=B.CONTRACT_ID and B.CUSTOMER_SET_ID=:b1) and B.BILLSEQNO=:b2) and B.sim_PACKAGE_NUM=:b3) and A.BI_BALAN_IDENT_BILL_CYCLE=:b4) and A.BI_BALAN_ATTR_BALAN_SEQUENCE=(select max(C.BI_BALAN_ATTR_BALAN_SEQUENCE) from BI_ACCOUNTS_VIEW C where ((((((((((C.BI_BALAN_IDENT_CONTRACT_ID=B.CONTRACT_ID and B.CUSTOMER_SET_ID=:b1) and B.BILLSEQNO=:b2) and B.sim_PACKAGE_NUM=:b3) and C.BI_BALAN_IDENT_CONTRACT_ID=A.BI_BALAN_IDENT_CONTRACT_ID) and C.BI_BALAN_IDENT_BILL_CYCLE=:b4) and C.BI_BALAN_IDENT_SNCODE=A.BI_BALAN_IDENT_SNCODE) and C.BI _BALAN_IDENT_USER_PROFILE_ID=A.BI_BALAN_IDENT_USER_PROFILE_ID) and NVL(C.BI_BALAN_IDENT_PURCHASE_SEQ_NO, 0)=NVL(A.BI_BALAN_IDENT_PURCHASE_SEQ_NO, 0)) and NVL(C.BI_BALAN_IDENT_BUNDL_PROD_ID, 0)=NVL(A.BI_BALAN_IDENT_BUNDL_PROD_ID, 0)) and C.BI_BALAN_SNAP_DATE_TIMESTAMP<TO_DATE(:b9, 'YYYY-MM-DD HH24:MI:SS')))) and (A.BI_END_DATE_TIMESTAMP is null or A.BI_END_DATE_TIMESTAMP>B.LAST_BILL_RUN)) and (A.BI_START_DATE_TIMESTAMP is null or A.BI_START_DATE_TIMESTAMP<TO_DATE(:b9, 'YYYY-MM-DD HH24:MI:SS'))) order by A.BI_BALAN_IDENT_CONTRACT_ID, A.BI_BALAN_IDENT_USER_PROFILE_ID, A.BI_BALAN_IDENT_SNCODE, A.BI_BALAN_IDENT_BUNDL_PROD_ID, A.BI_BALAN_IDENT_PURCHASE_SEQ_NO
419s5y1ypjry0	select tanim, rlh_giris_tarihi, sum(cdr_count), sum(nvl("Dakika/Terabayt", 0)) "Dakika/Terabayt" from ( select case when tariff_info_sncode in(1, 5, 6, 7, 8, 11, 12, 13, 66, 67, 93, 208, 278, 629, 630) then 'Voice' when tariff_info_sncode in (76, 2, 209, 279) then 'SMS MO' when tariff_info_sncode = 63 then 'GPRS' else 'Diger' end tanim, trunc(START_TIME_TIMESTAMP + NVL((START_TIME_OFFSET * 1/86400), 0)) RLH_Giris_Tarihi, count(*) cdr_count, case when tariff_info_sncode in (1, 5, 6, 7, 8, 11, 12, 13, 66, 67, 93, 208, 278, 629, 630) then round(sum(saturation_symb)/60, 2) when tariff_info_sncode=63 and gls_charge_part_id=1 then round(sum(data_volume)/1024/1024/1024/1024, 2) else null end "Dakika/Terabayt" from ( select /*+ parallel ( r, 32) */ * from sysadm.sim_lt r) group by tariff_info_sncode, gls_charge_part_id, trunc(START_TIME_TIMESTAMP + NVL((START_TIME_OFFSET * 1/86400), 0)) order by 1, 2 ) group by tanim, rlh_giris_tarihi order by 1, 2
43db9py1pakfg	delete from hro_PROCESS_CONTR where ((CUSTOMER_SET_ID=:b1 and BILLSEQNO=:b2) and sim_PACKAGE_NUM=:b3)
459f3z9u4fb3u	select value$ from props$ where name = 'GLOBAL_DB_NAME'
5nzxhhkjthdnb	INSERT INTO sim_NU_CHARGES ( gls_STREAM_ID, gls_RECORD_ID, gls_BASE_PART_ID, gls_CHARGE_PART_ID, gls_FREE_UNIT_PART_ID, gls_SPECIAL_PURPOSE_PART_ID, START_TIME_TIMESTAMP, START_TIME_OFFSET, TECHN_INFO_SCCODE, TECHN_INFO_PREPAY_IND, REMARK, RECORD_ID_CDR_ID, RECORD_ID_CDR_SUB_ID, RECORD_ID_bforef_SEQNO, CUST_INFO_CONTRACT_ID, CUST_INFO_CUSTOMER_ID, CUST_INFO_CONTRACT_PKEY, CUST_INFO_BUS_UNIT_ID, RATED_FLAT_AMOUNT, RATED_FLAT_AMOUNT_CURRENCY, RATED_FLAT_AMOUNT_GROSS_IND, TARIFF_INFO_TMCODE, TARIFF_INFO_TMVERSION, TARIFF_INFO_SPCODE, TARIFF_INFO_SNCODE, TARIFF_DETAIL_CBW_CHARGE_TYPE, TARIFF_DETAIL_LOGICAL_QUANTITY, ALT_TMCODE, ALT_value_AMOUNT, ALT_value_CURRENCY, ALT_value_GROSS_IND, ENTRY_DATE_TIMESTAMP, ENTRY_DATE_OFFSET, END_TIME_TIMESTAMP, END_TIME_OFFSET, TAX_INFO_SERV_CAT, TAX_INFO_SERV_TYPE, TAX_INFO_SERV_CODE, HOME_NETWORK_CODE, sim_CHARGEPART_ID, good_glass_INFO_PART_CREATOR, FREE_CLICKS_VOLUME, FREE_CLICKS_xiseem, FREE_ROUNDED_VOLUME_VOLUME, FREE_ROUNDED_VOLUME_xiseem, FREE_value_VOLUME_VOLUME, FREE_value_VOLUME_xiseem, FREE_CHARGE_AMOUNT, FREE_CHARGE_TAX, FREE_CHARGE_CURRENCY, FREE_CHARGE_GROSS_IND, ROUTING_INFO_IMP_EXP_MODE, INITIAL_START_TIME_TIMESTAMP, INITIAL_START_TIME_TIME_OFFSET, BAL_AUDIT_DAT_CONTRACT_ID, BAL_AUDIT_DAT_USER_PROFILE_ID, BAL_AUDIT_DAT_BALANCE_PROD_ID, BAL_AUDIT_DAT_BALANCE_ACCUM, BAL_AUDIT_DAT_BAL_BEFORE_CHG, BAL_AUDIT_DAT_BAL_AFTER_CHG, BAL_AUDIT_DAT_BUNDL_PROD_ID, B AL_AUDIT_DAT_PURCHASE_SEQ_NO, BAL_AUDIT_DAT_PREP_CREDIT_IND, six_INFO_six_PACKAGE_ID, six_INFO_six_PURPOSE, six_INFO_DETAIL_six_ALTERN_IND, six_INFO_DETAIL_SEQUENCE_SP, six_INFO_DETAIL_SEQUENCE_RP, six_INFO_DETAIL_CONTRACTED_IND, six_TARIFF_INFO_TMCODE, six_TARIFF_INFO_TMVERSION, six_TARIFF_INFO_SPCODE, six_TARIFF_INFO_SNCODE, CHARGE_INFO_CASH_FLOW_DIRECT, RECORD_TYPE_RECORD_CHRG_TYPE, SERVICE_INFO_USER_PROFILE_ID, SERVICE_INFO_NET_PROFILE_ID, SRV_CHARGE_INFO_CHARGEABLE_IND, SRV_CHARGE_INFO_OVERWRITE_IND, SRV_CHARGE_INFO_SRV_CHARGETYPE, SRV_CHARGE_INFO_CHARGE_SUBTYPE, SRV_CHARGE_INFO_NUM_ITEMS, SRV_CHARGE_INFO_NUM_DAYS, SRV_CHARGE_INFO_PRORATE_IND, SRV_CHARGE_INFO_VAS_IND, ITEM_PRICE_AMOUNT, ITEM_PRICE_CURRENCY, CHRG_SRV_INFO_STATUS, CHRGIV_STARTTIME_TIMESTAMP, CHRGIV_STARTTIME_TIME_OFFSET, CHRGIV_ENDTIME_TIMESTAMP, CHRGIV_ENDTIME_TIME_OFFSET, CHRGPRMVALIDFROM_TIMESTAMP, CHRGPRMVALIDFROM_TIME_OFFSET, CHRGSRVPARAMINFO_PARAM_VAL_ID ) values ( :1, :2, :3, :4, :5, :6, to_date(:7, 'YYYYMMDDHH24MISS'), :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21, :22, :23, :24, :25, :26, :27, :28, :29, :30, :31, to_date(:32, 'YYYYMMDDHH24MISS'), :33, to_date(:34, 'YYYYMMDDHH24MISS'), :35, :36, :37, :38, :39, :40, :41, :42, :43, :44, :45, :46, :47, :48, :49, :50, :51, :52, to_date(:53, 'YYYYMMDDHH24MISS'), :54, :55, :56, :57, :58, :59, :60, :61, :62, :63, :64, :65, :66, :67, :68 , :69, :70, :71, :72, :73, :74, :75, :76, :77, :78, :79, :80, :81, :82, :83, :84, :85, :86, :87, :88, to_date(:89, 'YYYYMMDDHH24MISS'), :90, to_date(:91, 'YYYYMMDDHH24MISS'), :92, to_date(:93, 'YYYYMMDDHH24MISS'), :94, :95 )
5qgz1p0cut7mx	BEGIN DBMS_OUTPUT.DISABLE; END;
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
6jmquq9369kd2	SELECT NULL, gls_STREAM_ID, gls_RECORD_ID, gls_BASE_PART_ID, gls_CHARGE_PART_ID, gls_FREE_UNIT_PART_ID, gls_SPECIAL_PURPOSE_PART_ID, to_char(START_TIME_TIMESTAMP, 'YYYYMMDDHH24MISS'), START_TIME_OFFSET, TECHN_INFO_SCCODE, TECHN_INFO_PREPAY_IND, REMARK, RECORD_ID_CDR_ID, RECORD_ID_CDR_SUB_ID, RECORD_ID_bforef_SEQNO, CUST_INFO_CONTRACT_ID, CUST_INFO_CUSTOMER_ID, CUST_INFO_CONTRACT_PKEY, CUST_INFO_BUS_UNIT_ID, RATED_FLAT_AMOUNT, RATED_FLAT_AMOUNT_CURRENCY, RATED_FLAT_AMOUNT_GROSS_IND, TARIFF_INFO_TMCODE, TARIFF_INFO_TMVERSION, TARIFF_INFO_SPCODE, TARIFF_INFO_SNCODE, TARIFF_DETAIL_CBW_CHARGE_TYPE, TARIFF_DETAIL_LOGICAL_QUANTITY, ALT_TMCODE, ALT_value_AMOUNT, ALT_value_CURRENCY, ALT_value_GROSS_IND, to_char(ENTRY_DATE_TIMESTAMP, 'YYYYMMDDHH24MISS'), ENTRY_DATE_OFFSET, to_char(END_TIME_TIMESTAMP, 'YYYYMMDDHH24MISS'), END_TIME_OFFSET, TAX_INFO_SERV_CAT, TAX_INFO_SERV_TYPE, TAX_INFO_SERV_CODE, HOME_NETWORK_CODE, sim_CHARGEPART_ID, good_glass_INFO_PART_CREATOR, FREE_CLICKS_VOLUME, FREE_CLICKS_xiseem, FREE_ROUNDED_VOLUME_VOLUME, FREE_ROUNDED_VOLUME_xiseem, FREE_value_VOLUME_VOLUME, FREE_value_VOLUME_xiseem, FREE_CHARGE_AMOUNT, FREE_CHARGE_TAX, FREE_CHARGE_CURRENCY, FREE_CHARGE_GROSS_IND, ROUTING_INFO_IMP_EXP_MODE, to_char(INITIAL_START_TIME_TIMESTAMP, 'YYYYMMDDHH24MISS'), INITIAL_START_TIME_TIME_OFFSET, BAL_AUDIT_DAT_CONTRACT_ID, BAL_AUDIT_DAT_USER_PROFILE_ID, BAL_AUDIT_DAT_BALANCE_PROD_ID, BAL_AUDIT_DAT_BALANCE_ACCUM, BAL_AUDI T_DAT_BAL_BEFORE_CHG, BAL_AUDIT_DAT_BAL_AFTER_CHG, BAL_AUDIT_DAT_BUNDL_PROD_ID, BAL_AUDIT_DAT_PURCHASE_SEQ_NO, BAL_AUDIT_DAT_PREP_CREDIT_IND, six_INFO_six_PACKAGE_ID, six_INFO_six_PURPOSE, six_INFO_DETAIL_six_ALTERN_IND, six_INFO_DETAIL_SEQUENCE_SP, six_INFO_DETAIL_SEQUENCE_RP, six_INFO_DETAIL_CONTRACTED_IND, six_TARIFF_INFO_TMCODE, six_TARIFF_INFO_TMVERSION, six_TARIFF_INFO_SPCODE, six_TARIFF_INFO_SNCODE, CHARGE_INFO_CASH_FLOW_DIRECT, RECORD_TYPE_RECORD_CHRG_TYPE, SERVICE_INFO_USER_PROFILE_ID, SERVICE_INFO_NET_PROFILE_ID, SRV_CHARGE_INFO_CHARGEABLE_IND, SRV_CHARGE_INFO_OVERWRITE_IND, SRV_CHARGE_INFO_SRV_CHARGETYPE, SRV_CHARGE_INFO_CHARGE_SUBTYPE, SRV_CHARGE_INFO_NUM_ITEMS, SRV_CHARGE_INFO_NUM_DAYS, SRV_CHARGE_INFO_PRORATE_IND, SRV_CHARGE_INFO_VAS_IND, ITEM_PRICE_AMOUNT, ITEM_PRICE_CURRENCY, CHRG_SRV_INFO_STATUS, to_char(CHRGIV_STARTTIME_TIMESTAMP, 'YYYYMMDDHH24MISS'), CHRGIV_STARTTIME_TIME_OFFSET, to_char(CHRGIV_ENDTIME_TIMESTAMP, 'YYYYMMDDHH24MISS'), CHRGIV_ENDTIME_TIME_OFFSET, to_char(CHRGPRMVALIDFROM_TIMESTAMP, 'YYYYMMDDHH24MISS'), CHRGPRMVALIDFROM_TIME_OFFSET, CHRGSRVPARAMINFO_PARAM_VAL_ID FROM sim_NU_CHARGES WHERE CUST_INFO_CUSTOMER_ID = :MULT_ATTR_BIND0 AND CUST_INFO_CONTRACT_ID = :MULT_ATTR_BIND1 AND END_TIME_TIMESTAMP < to_date( :MULT_ATTR_BIND2, 'YYYY-MM-DD-HH24.MI.SS' ) AND ENTRY_DATE_TIMESTAMP >= to_date( :MULT_ATTR_BIND3, 'YYYY-MM-DD-HH24.MI.SS' ) ORDER BY END_TIME_TIMESTAMP ASC , 2 ASC , 3 ASC , 4 ASC , 5 ASC , 6 ASC , 7 ASC
79d80c88a7hkb	SELECT "A1"."START_TIME_TIMESTAMP", "A1"."START_TIME_OFFSET", MIN("A1"."ENTRY_DATE_TIMESTAMP"), MIN("A1"."ENTRY_DATE_OFFSET"), MIN("A1"."O_P_NUMBER_ADDRESS"), MIN("A1"."saturation_symb"), MIN("A1"."DATA_VOLUME"), MIN("A1"."TARIFF_INFO_SNCODE"), MIN("A1"."TARIFF_INFO_ZPCODE"), MAX("A1"."RATED_FLAT_AMOUNT"), SUM("A1"."FREE_CHARGE_AMOUNT"), MIN("A1"."TARIFF_INFO_TMCODE"), MIN("A1"."O_P_NORMED_NUM_ADDRESS"), "A1"."CUST_INFO_CUSTOMER_ID", "A1"."CUST_INFO_CONTRACT_ID", "A1"."gls_STREAM_ID", "A1"."gls_RECORD_ID", "A1"."gls_BASE_PART_ID", "A1"."gls_CHARGE_PART_ID" FROM "SYSADM"."sim_LT" "A1" WHERE "A1"."gls_CHARGE_PART_ID"=1 AND ("A1"."CUST_INFO_CUSTOMER_ID"=7794932 OR "A1"."CUST_INFO_CUSTOMER_ID"=0) AND ("A1"."CUST_INFO_CONTRACT_ID"=8927777 OR "A1"."CUST_INFO_CONTRACT_ID"=0) AND "A1"."START_TIME_TIMESTAMP"+NVL("A1"."START_TIME_OFFSET"/86400, 0)>=:1 AND "A1"."START_TIME_TIMESTAMP"+NVL("A1"."START_TIME_OFFSE T"/86400, 0)<=:2 GROUP BY "A1"."CUST_INFO_CUSTOMER_ID", "A1"."CUST_INFO_CONTRACT_ID", "A1"."START_TIME_TIMESTAMP", "A1"."START_TIME_OFFSET", "A1"."gls_STREAM_ID", "A1"."gls_RECORD_ID", "A1"."gls_BASE_PART_ID", "A1"."gls_CHARGE_PART_ID" HAVING MIN("A1"."TARIFF_INFO_SNCODE") IS NOT NULL AND (MIN("A1"."O_P_NORMED_NUM_ADDRESS") LIKE '%'||:3||'%' OR MIN("A1"."O_P_NUMBER_ADDRESS") LIKE '%'||:4||'%')
7hys3h7ysgf9m	SELECT ATTRIBUTE, SCOPE, NUMERIC_VALUE, CHAR_VALUE, DATE_VALUE FROM SYSTEM.PRODUCT_PRIVS WHERE (UPPER('SQL*Plus') LIKE UPPER(PRODUCT)) AND (USER LIKE USERID)
8djqzwpg6zs80	select A.BI_BALAN_IDENT_CONTRACT_ID , A.BI_BALAN_IDENT_SNCODE , A.BI_BALAN_IDENT_USER_PROFILE_ID , A.BI_BALAN_IDENT_AGGREGATE_MONEY , A.BI_PURPOSE_BI_PURPOSE , A.BI_REQ_AMOUNT_AMOUNT , A.BI_REQ_AMOUNT_CURRENCY , A.BI_AGGR_CHRG_AMOUNT , A.BI_AGGR_CHRG_CURRENCY , A.BI_debit_pbak_AMOUNT , A.BI_debit_pbak_CURRENCY , A.BI_REM_debit_pbak_AMOUNT , A.BI_REM_debit_pbak_CURRENCY , A.BI_REQ_VOLUME_VOLUME , A.BI_AGGR_VOLUME_VOLUME , A.BI_AGGR_VOLUME_xiseem , A.BI_CREDIT_VOLUME_VOLUME , A.BI_REM_CREDIT_VOL_VOLUME , TO_CHAR(A.BI_BALAN_SNAP_DATE_TIMESTAMP, 'YYYYMMDDHH24MISS') , A.BI_BALAN_SNAP_DATE_TIME_OFFSET , A.BI_REMARK_REASON_ID , A.BI_REMARK_REMARK , A.BI_BALAN_ATTR_MONEY_WALLET , A.BI_BALAN_IDENT_PURCHASE_SEQ_NO , A.BI_BALAN_IDENT_BUNDL_PROD_ID , A.BI_PREPAID_TRANSACT_TYPE_ID , TO_CHAR(A.BI_START_DATE_TIMESTAMP, 'YYYY-MM-DD HH24:MI:SS') , A.BI_START_DATE_TIME_OFFSET , A.BI_DET_ACTION_DETAILED_ACTION from BI_ACCOUNTS_VIEW A , hro_PROCESS_CONTR B where ((((((A.BI_BALAN_IDENT_CONTRACT_ID=B.CONTRACT_ID and B.CUSTOMER_SET_ID=:b1) and B.BILLSEQNO=:b2) and B.sim_PACKAGE_NUM=:b3) and A.BI_BALAN_SNAP_DATE_TIMESTAMP>=B.LAST_BILL_RUN) and A.BI_BALAN_SNAP_DATE_TIMESTAMP<TO_DATE(:b4, 'YYYY-MM-DD HH24:MI:SS')) and A.BI_PURPOSE_BI_PURPOSE in ('A', 'B', 'C', 'D', 'M', 'T')) order by A.BI_BALAN_IDENT_CONTRACT_ID, A.BI_BALAN_IDENT_USER_PROFILE_ID, A.BI_BALAN_IDENT_SNCODE, A.BI_BALAN_ATTR_BALAN_SEQUENCE
99svxhhsrd0qp	SELECT NULL, "A1"."gls_STREAM_ID", "A1"."DR_RECORD_PART_ID", "A1"."DR_REFERENCE_PART_ID", "A1"."DR_ADDRESSEE_CONTRACT_ID", "A1"."DR_ADDRESSEE_CUSTOMER_ID", "A1"."DR_ADDRESSEE_CUSTOMER_PKEY", "A1"."DR_ADDRESSEE_BA_ID", "A1"."DR_ADDRESSEE_CONTRACT_PKEY", "A1"."DR_ADDRESSEE_BA_PKEY", "A1"."DR_ASS_DOC_NUMBER_INTERNAL_ID", "A1"."DR_ASS_DOC_NUMBER_EXTERNAL_ID", "A1"."DR_REQUEST_ASS_DOC_REQUEST_ID", "A1"."DR_REQUEST_BUS_UNIT_ID", "A1"."DR_REQUEST_BUS_UNIT_PKEY", TO_CHAR("A1"."DR_ASS_DOC_CR_DATE_TIMESTAMP", 'YYYYMMDDHH24MISS'), "A1"."DR_ASS_DOC_CR_DATE_TIME_OFFSET", "A1"."DR_ASS_DOC_CR_TIMEZONE_ID", TO_CHAR("A1"."DR_ASS_DOC_MN_DATE_TIMESTAMP", 'YYYYMMDDHH24MISS'), "A1"."DR_ASS_DOC_MN_DATE_TIME_OFFSET", "A1"."DR_ASS_DOC_MN_TIMEZONE_ID", TO_CHAR("A1"."DR_ASS_DOC_RF_DATE_TIMESTAMP", 'YYYYMMDDHH24MISS'), "A1"."DR_ASS_DOC_RF_DATE_TIME_OFFSET", "A1"."DR_ASS_DOC_RF_DATE_TIMEZONE_ID", TO_CHAR("A1"."DR_ASS_REACT_DATE_TIMESTAMP", 'YYYYMMDDHH24MISS'), "A1"."DR_ASS_REACT_DATE_TIME_OFFSET", "A1". "DR_ASS_REACT_DATE_TIMEZONE_ID", TO_CHAR("A1"."DR_ASS_LAST_SEND_DATE_TIMEST", 'YYYYMMDDHH24MISS'), "A1"."DR_ASS_LAST_SEND_DATE_TIME_OFF", "A1"."DR_ASS_LAST_SEND_DATE_TIMEZ_ID", "A1"."DR_ASS_DOC_TYPE_ASS_DOC_TYPE", "A1"."DR_ASS_DOC_TYPE_GEN_PURPOSE", "A1"."DR_ASS_DOC_TYPE_BILL_PURPOSE", "A1"."DR_ASS_DOC_TYPE_BILL_CYCLE", "A1"."DR_ASS_DOC_TYPE_BILL_MED_ID", "A1"."DR_ASS_DOC_TYPE_BILL_MED_PKEY", "A1"."DR_ASS_DOC_TYPE_NUMBEROFCOPIES", "A1"."DR_ASS_DOC_TYPE_SUPPRESS_FLAG", "A1"."DR_ASS_DOC_TYPE_INV_REASON_ID", "A1"."DR_ASS_DOC_TYPE_THRESHOLD_VAL", "A1"."DR_ASS_DOC_TYPE_THRESHOLD_CURR", "A1"."DR_ASS_DOC_COPY_COPY_IND", "A1"."DR_DOCU_REFERENCE_LINK_TYPE", "A1"."DR_DOCU_NUMBER_INTERNAL_ID", "A1"."DR_DOCU_TYPE_DOC_TYPE", "A1"."DR_DOCU_TYPE_DOC_FORMAT", "A1"."DR_DOCU_LINK_LINK", TO_CHAR("A1"."DR_DOCU_CREAT_DATE_TIMESTAMP", 'YYYYMMDDHH24MISS'), "A1"."DR_DOCU_CREAT_DATE_TIME_OFFSET", "A1"."DR_DOCU_CREAT_DATE_TIMEZONE_ID", "A1"."DR_DOC_LANGUAGE_LNG_PKEY", "A1"."DR_ACKNOWL_INDICATOR" FROM "SYSADM"."DR_glasses" "A1" WHERE "A1"."DR_ADDRESSEE_CONTRACT_ID"=:MULT_ATTR_BIND0 AND "A1"."DR_ASS_DOC_TYPE_ASS_DOC_TYPE"<>:MULT_ATTR_BIND1 AND "A1"."DR_ASS_DOC_MN_DATE_TIMESTAMP">=TO_DATE(:MULT_ATTR_BIND2, 'DD.MM.YYYY HH24:MI:SS') AND "A1"."DR_ASS_DOC_MN_DATE_TIMESTAMP"<TO_DATE(:MULT_ATTR_BIND3, 'DD.MM.YYYY HH24:MI:SS') ORDER BY "A1"."gls_STREAM_ID", "A1"."DR_RECORD_PART_ID", "A1"."DR_REFERENCE_PART_ID"
9hj7kfhzqwf40	SELECT /* OPT_DYN_SAMP */ /*+ ALL_ROWS IGNORE_WHERE_CLAUSE NO_PARALLEL(SAMPLESUB) opt_param('parallel_execution_enabled', 'false') NO_PARALLEL_INDEX(SAMPLESUB) NO_SQL_TUNE */ NVL(SUM(C1), :"SYS_B_00"), NVL(SUM(C2), :"SYS_B_01") FROM (SELECT /*+ IGNORE_WHERE_CLAUSE NO_PARALLEL("SYS_ALIAS_1") FULL("SYS_ALIAS_1") NO_PARALLEL_INDEX("SYS_ALIAS_1") */ :"SYS_B_02" AS C1, CASE WHEN "SYS_ALIAS_1"."panel_IND"=:"SYS_B_03" AND "SYS_ALIAS_1"."RATED_FLAT_AMOUNT">:"SYS_B_04" AND "SYS_ALIAS_1"."TARIFF_INFO_TMCODE"<>:"SYS_B_05" AND "SYS_ALIAS_1"."TARIFF_INFO_TMCODE"<>:"SYS_B_06" THEN :"SYS_B_07" ELSE :"SYS_B_08" END AS C2 FROM "EU_BILL"."FU_REPORTING_sim_TABLE" SAMPLE BLOCK (:"SYS_B_09" , :"SYS_B_10") SEED (:"SYS_B_11") "SYS_ALIAS_1") SAMPLESUB
ar2pj9rk3nm3b	SELECT TABLE_NAME, gls_STREAM_ID, gls_RECORD_ID, gls_BASE_PART_ID, gls_CHARGE_PART_ID, gls_FREE_UNIT_PART_ID, gls_SPECIAL_PURPOSE_PART_ID, CALL_TYPE, panel_IND, FOLLOW_UP_CALL_TYPE, panel_CALL_TYPE, to_char(START_TIME_TIMESTAMP, 'YYYYMMDDHH24MISS'), START_TIME_OFFSET, SERVICE_LOGIC_CODE, SERVICE_ACTION_CODE, SERVICE_VAS_CODE, SERVICE_USED_SERVICE, saturation_symb, DURATION_xiseem, panel_CHARGE_AMOUNT, panel_CHARGE_TAX, panel_CHARGE_CURRENCY, panel_CHARGE_GROSS_IND, panel_DISCOUNT_AMOUNT, panel_DISCOUNT_CURRENCY, panel_TIME_BAND_CODE, panel_DAY_CATEGORY_CODE, S_P_NUMBER_ADDRESS, S_P_NUMBER_NUMBERING_PLAN, S_P_NUMBER_NETWORK_CODE, S_P_NUMBER_HOME_BID_ID, S_P_PORT_ADDRESS, S_P_PORT_NUMBERING_PLAN, S_P_EQUIPMENT_NUMBER, S_P_LOCATION_ADDRESS, S_P_LOCATION_NUMBERING_PLAN, S_P_LOC_SERVING_BID_ID, S_P_LOC_SERVING_LOCATION, S_P_HOME_LOC_ADDRESS, S_P_HOME_LOC_NUMBERING_PLAN, NET_ELEMENT_ADDRESS, NET_ELEMENT_NUMBERING_PLAN, NET_ELEMENT_TYPE_OF_NUMBER, NET_ELEMENT_NETWORK_CODE, O_P_NUMBER_ADDRESS, O_P_NUMBER_NUMBERING_PLAN, O_P_NUMBER_TYPE_OF_NUMBER, O_P_NUMBER_CLIR, O_P_NUMBER_CARRIER_CODE, ROUTING_ADDRESS, ROUTING_NUMBERING_PLAN, ROUTING_TYPE_OF_NUMBER, ROUTING_NETWORK_CODE, CAMEL_MSC_ADDRESS, CAMEL_MSC_ADDR_USER_PROF_ID, TECHN_INFO_PRE_value_IND, TECHN_INFO_TERMINATION_IND, TECHN_INFO_SCCODE, TECHN_INFO_HOME_TERMINATED_IND, TECHN_INFO_PREPAY_IND, OUTTRUNK, REMARK, CONTENT_REPORT, RECORD_ID_sim_FILE_ID, RECORD_ID_CALL_ID, RECORD_ID_ORIG_CDR_ID, RECORD_ID_CDR_ID, RECORD_ID_CDR_SUB_ID, RECORD_ID_TAP_SEQUENCE_NUM, RECORD_ID_bforef_SEQNO, DATA_VOLUME, DATA_VOLUME_xiseem, MESSAGES_VOLUME, MESSAGES_xiseem, CAMEL_REFERENCE_NUMBER, CUST_INFO_PORT_ID, CUST_INFO_CONTRACT_ID, CUST_INFO_CUSTOMER_ID, CUST_INFO_SUBS_CODE, CUST_INFO_SUBS_TAG, CUST_INFO_CUSTOMER_GROUP, CUST_INFO_BILLCYCLE_GROUP, CUST_INFO_USER_PROFILE_ID, CUST_INFO_MAIN_MSISDN, CUST_INFO_BILL_CYCLE, RATED_VOLUME, RATED_VOLUME_xiseem, ROUNDED_VOLUME, ROUNDED_VOLUME_xiseem, RATED_CLICKS_VOLUME, RATED_CLICKS_xiseem, RATED_FLAT_AMOUNT, RATED_FLAT_AMOUNT_TAX, RATED_FLAT_AMOUNT_CURRENCY, RATED_FLAT_AMOUNT_GROSS_IND, TARIFF_INFO_TMCODE, TARIFF_INFO_TMVERSION, TARIFF_INFO_RPVERSION, TARIFF_INFO_EGVERSION, TARIFF_INFO_SPCODE, TARIFF_INFO_SNCODE, TARIFF_INFO_TWCODE, TARIFF_INFO_GVCODE, TARIFF_INFO_ZNCODE, TARIFF_INFO_ZPCODE, TARIFF_INFO_TIME_BAND_CODE, TARIFF_INFO_ZPCODE_DAY_CATCODE, TARIFF_INFO_TM_USED_TYPE, TARIFF_INFO_USAGE_IND, TARIFF_INFO_EGCODE, TARIFF_INFO_RPCODE, TARIFF_DETAIL_TTCODE, TARIFF_DETAIL_CBW_CHARGE_TYPE, TARIFF_DETAIL_RATE_TYPE_ID, TARIFF_DETAIL_CHGBL_QUANTITY, TARIFF_DETAIL_EXT_CHRG_UDMCODE, MC_INFO_CODE, MC_INFO_IND, CALL_DEST, to_char(START_TIME_CHARGE_TIMESTAMP, 'YYYYMMDDHH24MISS'), START_TIME_CHARGE_OFFSET, LZLIST, to_char(ENTRY_DATE_TIMESTAMP, 'YYYYMMDDHH24MISS'), ENTRY_DATE_OFFSET, REJECT_REASON_CODE, NUMBER_OF_REJECTIONS, REJECTED_BASE_PART, TAX_INFO_SERV_CAT, TA X_INFO_SERV_TYPE, TAX_INFO_SERV_CODE, HOME_NETWORK_CODE, MC_SCALEFACTOR, ORIGIN_FIELD_ID, DESTINATION_FIELD_ID, sim_BASEPART_ID, sim_CHARGEPART_ID, CAMEL_DEST_ADDR_USER_PROF_ID, CAMEL_SRV_ADDR_USER_PROF_ID, S_PDP_ADDRESS, S_PDP_NUMBERING_PLAN, UPLINK_VOLUME_VOLUME, UPLINK_VOLUME_xiseem, DOWNLINK_VOLUME_VOLUME, DOWNLINK_VOLUME_xiseem, SGSN_ADDRESSES, BUSINESS_INFO_PRE_BS_ID, BUSINESS_INFO_PRE_BS_VERSION, BUSINESS_INFO_BS_ID, BUSINESS_INFO_BS_VERSION, BUSINESS_INFO_CHARGE_PARTY_ID, BUSINESS_INFO_CHARGE_ITEM_ID, BUSINESS_INFO_C_P_FIELD_REF, BUSINESS_INFO_O_P_FIELD_REF, SPEC_NUM_INFO_APPLY_good_glass, IMPACTED_PARTY2_TMCODE, O_P_NORMED_NUM_ADDRESS, O_P_NORMED_NUM_NUMBER_PLAN, O_P_NORMED_NUM_INT_ACC_CODE, NORMED_RTD_NUM_ADDRESS, NORMED_RTD_NUM_NUMBER_PLAN, NORMED_RTD_NUM_INT_ACC_CODE, EVENT_VOLUME, EVENT_xiseem, good_glass_INFO_FU_PACK_ID, good_glass_INFO_VERSION, good_glass_INFO_FUP_SEQ, good_glass_INFO_CHG_RED_QUOTA, good_glass_INFO_SEQNO, good_glass_INFO_ACCOUNT_KEY, good_glass_INFO_PREVIOUS_SEQNO, good_glass_INFO_ACC_HIST_ID, good_glass_INFO_ACCOUNT_ORIGIN, good_glass_INFO_PART_CREATOR, good_glass_INFO_DISCOUNT_RATE, good_glass_INFO_APPL_METHOD, FREE_CLICKS_VOLUME, FREE_CLICKS_xiseem, FREE_ROUNDED_VOLUME_VOLUME, FREE_ROUNDED_VOLUME_xiseem, FREE_value_VOLUME_VOLUME, FREE_value_VOLUME_xiseem, ZERO_ROUNDED_VOLUME_VOLUME, ZERO_ROUNDED_VOLUME_xiseem, ZERO_value_VOLUME_VOLUME, ZERO_value_VOLUME_xiseem, FREE_CHARGE_AMOUNT, FRE E_CHARGE_TAX, FREE_CHARGE_CURRENCY, FREE_CHARGE_GROSS_IND, OR_FLAG, AN_PACK_AN_PACKAGE_ID_LIST, AN_PACK_ORIG_AN_PACK_ID_LIST, O_P_NUMBER_BACKUP_ADDRESS, panel_BASE_CHARGE_AMOUNT, panel_BASE_CHARGE_TAX, panel_BASE_CHARGE_CURRENCY, panel_BASE_CHARGE_GROSS_IND, RECIPIENT_NET_ADDRESS, RECIPIENT_NET_NUMBERING_PLAN, to_char(INITIAL_START_TIME_TIMESTAMP, 'YYYYMMDDHH24MISS'), INITIAL_START_TIME_TIME_OFFSET, EVENT_INFO_EVENT_TYPE, S_P_HOME_ID_NETWORK, S_P_HOME_ID_HOME_BID_ID, RATED_FLAT_AMOUNT_ORIG_AMOUNT, RATED_FLAT_AMOUNT_ORIG_TAX, RATED_FLAT_AMNT_ORIG_CURRENCY, RATED_FLAT_AMNT_ORIG_GROSS_IND, UNBILLED_AMOUNT_AMOUNT, UNBILLED_AMOUNT_CURRENCY, CHARGE_INFO_CASH_FLOW_DIRECT, bforef_INFO_bforef_RECORD_TYPE, MICRO_roll_MC_CODE, MICRO_roll_SCALEFACTOR, MICRO_roll_MC_PKEY, MICRO_roll_MC_TYPE, MICRO_roll_IMCSCALEFACTORTYPE, to_char(ORIG_ENTRY_DATE_TIMESTAMP, 'YYYYMMDDHH24MISS'), ORIG_ENTRY_DATE_TIME_OFFSET, CALLED_PARTY_MNP_ADDRESS, CALLED_PARTY_MNP_NUMBER_PLAN, CALLED_PARTY_MNP_TYPE_OF_NUM, CALLED_PARTY_MNP_IAC, panel_bforef_AMOUNT, panel_bforef_TAX, panel_bforef_CURRENCY, panel_bforef_GROSS_IND, panel_ORIGINAL_AMOUNT, panel_ORIGINAL_TAX, panel_ORIGINAL_CURRENCY, panel_ORIGINAL_GROSS_IND, panel_SURCHARGE_AMOUNT, panel_SURCHARGE_TAX, panel_SURCHARGE_CURRENCY, panel_SURCHARGE_GROSS_IND, ISMSC_ISN_SERIAL_NUMBER FROM CBW_sim WHERE CUST_INFO_CUSTOMER_ID = :MULT_ATTR_BIND0 AND CUST_INFO_CONTRACT_ID = :MULT_ATTR_BIND1 AND ENTRY_DATE_TIMESTAMP < to_date( :MULT_ATTR_BIND2, 'YYYY-MM-DD-HH24.MI.SS' ) AND ENTRY_DATE_TIMESTAMP >= to_date( :MULT_ATTR_BIND3, 'YYYY-MM-DD-HH24.MI.SS' ) AND CUST_INFO_BILL_CYCLE IN ('16') ORDER BY INITIAL_START_TIME_TIMESTAMP ASC , 2 ASC , 3 ASC , 4 ASC , 5 ASC , 6 ASC , 7 ASC
bnz1c7by5qgpv	SELECT TABLE_NAME, gls_STREAM_ID, gls_RECORD_ID, gls_BASE_PART_ID, gls_CHARGE_PART_ID, gls_FREE_UNIT_PART_ID, gls_SPECIAL_PURPOSE_PART_ID, CALL_TYPE, panel_IND, FOLLOW_UP_CALL_TYPE, panel_CALL_TYPE, to_char(START_TIME_TIMESTAMP, 'YYYYMMDDHH24MISS'), START_TIME_OFFSET, SERVICE_LOGIC_CODE, SERVICE_ACTION_CODE, SERVICE_VAS_CODE, SERVICE_USED_SERVICE, saturation_symb, DURATION_xiseem, panel_CHARGE_AMOUNT, panel_CHARGE_TAX, panel_CHARGE_CURRENCY, panel_CHARGE_GROSS_IND, panel_DISCOUNT_AMOUNT, panel_DISCOUNT_CURRENCY, panel_TIME_BAND_CODE, panel_DAY_CATEGORY_CODE, S_P_NUMBER_ADDRESS, S_P_NUMBER_NUMBERING_PLAN, S_P_NUMBER_NETWORK_CODE, S_P_NUMBER_HOME_BID_ID, S_P_PORT_ADDRESS, S_P_PORT_NUMBERING_PLAN, S_P_EQUIPMENT_NUMBER, S_P_LOCATION_ADDRESS, S_P_LOCATION_NUMBERING_PLAN, S_P_LOC_SERVING_BID_ID, S_P_LOC_SERVING_LOCATION, S_P_HOME_LOC_ADDRESS, S_P_HOME_LOC_NUMBERING_PLAN, NET_ELEMENT_ADDRESS, NET_ELEMENT_NUMBERING_PLAN, NET_ELEMENT_TYPE_OF_NUMBER, NET_ELEMENT_NETWORK_CODE, O_P_NUMBER_ADDRESS, O_P_NUMBER_NUMBERING_PLAN, O_P_NUMBER_TYPE_OF_NUMBER, O_P_NUMBER_CLIR, O_P_NUMBER_CARRIER_CODE, ROUTING_ADDRESS, ROUTING_NUMBERING_PLAN, ROUTING_TYPE_OF_NUMBER, ROUTING_NETWORK_CODE, CAMEL_MSC_ADDRESS, CAMEL_MSC_ADDR_USER_PROF_ID, TECHN_INFO_PRE_value_IND, TECHN_INFO_TERMINATION_IND, TECHN_INFO_SCCODE, TECHN_INFO_HOME_TERMINATED_IND, TECHN_INFO_PREPAY_IND, OUTTRUNK, REMARK, CONTENT_REPORT, RECORD_ID_sim_FILE_ID, RECORD_ID_CALL_ID, RECORD_ID_ORIG_CDR_ID, RECORD_ID_CDR_ID, RECORD_ID_CDR_SUB_ID, RECORD_ID_TAP_SEQUENCE_NUM, RECORD_ID_bforef_SEQNO, DATA_VOLUME, DATA_VOLUME_xiseem, MESSAGES_VOLUME, MESSAGES_xiseem, CAMEL_REFERENCE_NUMBER, CUST_INFO_PORT_ID, CUST_INFO_CONTRACT_ID, CUST_INFO_CUSTOMER_ID, CUST_INFO_SUBS_CODE, CUST_INFO_SUBS_TAG, CUST_INFO_CUSTOMER_GROUP, CUST_INFO_BILLCYCLE_GROUP, CUST_INFO_USER_PROFILE_ID, CUST_INFO_MAIN_MSISDN, CUST_INFO_BILL_CYCLE, RATED_VOLUME, RATED_VOLUME_xiseem, ROUNDED_VOLUME, ROUNDED_VOLUME_xiseem, RATED_CLICKS_VOLUME, RATED_CLICKS_xiseem, RATED_FLAT_AMOUNT, RATED_FLAT_AMOUNT_TAX, RATED_FLAT_AMOUNT_CURRENCY, RATED_FLAT_AMOUNT_GROSS_IND, TARIFF_INFO_TMCODE, TARIFF_INFO_TMVERSION, TARIFF_INFO_RPVERSION, TARIFF_INFO_EGVERSION, TARIFF_INFO_SPCODE, TARIFF_INFO_SNCODE, TARIFF_INFO_TWCODE, TARIFF_INFO_GVCODE, TARIFF_INFO_ZNCODE, TARIFF_INFO_ZPCODE, TARIFF_INFO_TIME_BAND_CODE, TARIFF_INFO_ZPCODE_DAY_CATCODE, TARIFF_INFO_TM_USED_TYPE, TARIFF_INFO_USAGE_IND, TARIFF_INFO_EGCODE, TARIFF_INFO_RPCODE, TARIFF_DETAIL_TTCODE, TARIFF_DETAIL_CBW_CHARGE_TYPE, TARIFF_DETAIL_RATE_TYPE_ID, TARIFF_DETAIL_CHGBL_QUANTITY, TARIFF_DETAIL_EXT_CHRG_UDMCODE, MC_INFO_CODE, MC_INFO_IND, CALL_DEST, to_char(START_TIME_CHARGE_TIMESTAMP, 'YYYYMMDDHH24MISS'), START_TIME_CHARGE_OFFSET, LZLIST, to_char(ENTRY_DATE_TIMESTAMP, 'YYYYMMDDHH24MISS'), ENTRY_DATE_OFFSET, REJECT_REASON_CODE, NUMBER_OF_REJECTIONS, REJECTED_BASE_PART, TAX_INFO_SERV_CAT, TA X_INFO_SERV_TYPE, TAX_INFO_SERV_CODE, HOME_NETWORK_CODE, MC_SCALEFACTOR, ORIGIN_FIELD_ID, DESTINATION_FIELD_ID, sim_BASEPART_ID, sim_CHARGEPART_ID, CAMEL_DEST_ADDR_USER_PROF_ID, CAMEL_SRV_ADDR_USER_PROF_ID, S_PDP_ADDRESS, S_PDP_NUMBERING_PLAN, UPLINK_VOLUME_VOLUME, UPLINK_VOLUME_xiseem, DOWNLINK_VOLUME_VOLUME, DOWNLINK_VOLUME_xiseem, SGSN_ADDRESSES, BUSINESS_INFO_PRE_BS_ID, BUSINESS_INFO_PRE_BS_VERSION, BUSINESS_INFO_BS_ID, BUSINESS_INFO_BS_VERSION, BUSINESS_INFO_CHARGE_PARTY_ID, BUSINESS_INFO_CHARGE_ITEM_ID, BUSINESS_INFO_C_P_FIELD_REF, BUSINESS_INFO_O_P_FIELD_REF, SPEC_NUM_INFO_APPLY_good_glass, IMPACTED_PARTY2_TMCODE, O_P_NORMED_NUM_ADDRESS, O_P_NORMED_NUM_NUMBER_PLAN, O_P_NORMED_NUM_INT_ACC_CODE, NORMED_RTD_NUM_ADDRESS, NORMED_RTD_NUM_NUMBER_PLAN, NORMED_RTD_NUM_INT_ACC_CODE, EVENT_VOLUME, EVENT_xiseem, good_glass_INFO_FU_PACK_ID, good_glass_INFO_VERSION, good_glass_INFO_FUP_SEQ, good_glass_INFO_CHG_RED_QUOTA, good_glass_INFO_SEQNO, good_glass_INFO_ACCOUNT_KEY, good_glass_INFO_PREVIOUS_SEQNO, good_glass_INFO_ACC_HIST_ID, good_glass_INFO_ACCOUNT_ORIGIN, good_glass_INFO_PART_CREATOR, good_glass_INFO_DISCOUNT_RATE, good_glass_INFO_APPL_METHOD, FREE_CLICKS_VOLUME, FREE_CLICKS_xiseem, FREE_ROUNDED_VOLUME_VOLUME, FREE_ROUNDED_VOLUME_xiseem, FREE_value_VOLUME_VOLUME, FREE_value_VOLUME_xiseem, ZERO_ROUNDED_VOLUME_VOLUME, ZERO_ROUNDED_VOLUME_xiseem, ZERO_value_VOLUME_VOLUME, ZERO_value_VOLUME_xiseem, FREE_CHARGE_AMOUNT, FRE E_CHARGE_TAX, FREE_CHARGE_CURRENCY, FREE_CHARGE_GROSS_IND, OR_FLAG, AN_PACK_AN_PACKAGE_ID_LIST, AN_PACK_ORIG_AN_PACK_ID_LIST, O_P_NUMBER_BACKUP_ADDRESS, panel_BASE_CHARGE_AMOUNT, panel_BASE_CHARGE_TAX, panel_BASE_CHARGE_CURRENCY, panel_BASE_CHARGE_GROSS_IND, RECIPIENT_NET_ADDRESS, RECIPIENT_NET_NUMBERING_PLAN, to_char(INITIAL_START_TIME_TIMESTAMP, 'YYYYMMDDHH24MISS'), INITIAL_START_TIME_TIME_OFFSET, EVENT_INFO_EVENT_TYPE, S_P_HOME_ID_NETWORK, S_P_HOME_ID_HOME_BID_ID, RATED_FLAT_AMOUNT_ORIG_AMOUNT, RATED_FLAT_AMOUNT_ORIG_TAX, RATED_FLAT_AMNT_ORIG_CURRENCY, RATED_FLAT_AMNT_ORIG_GROSS_IND, UNBILLED_AMOUNT_AMOUNT, UNBILLED_AMOUNT_CURRENCY, CHARGE_INFO_CASH_FLOW_DIRECT, bforef_INFO_bforef_RECORD_TYPE, MICRO_roll_MC_CODE, MICRO_roll_SCALEFACTOR, MICRO_roll_MC_PKEY, MICRO_roll_MC_TYPE, MICRO_roll_IMCSCALEFACTORTYPE, to_char(ORIG_ENTRY_DATE_TIMESTAMP, 'YYYYMMDDHH24MISS'), ORIG_ENTRY_DATE_TIME_OFFSET, CALLED_PARTY_MNP_ADDRESS, CALLED_PARTY_MNP_NUMBER_PLAN, CALLED_PARTY_MNP_TYPE_OF_NUM, CALLED_PARTY_MNP_IAC, panel_bforef_AMOUNT, panel_bforef_TAX, panel_bforef_CURRENCY, panel_bforef_GROSS_IND, panel_ORIGINAL_AMOUNT, panel_ORIGINAL_TAX, panel_ORIGINAL_CURRENCY, panel_ORIGINAL_GROSS_IND, panel_SURCHARGE_AMOUNT, panel_SURCHARGE_TAX, panel_SURCHARGE_CURRENCY, panel_SURCHARGE_GROSS_IND, ISMSC_ISN_SERIAL_NUMBER FROM CBW_sim WHERE CUST_INFO_CUSTOMER_ID = :MULT_ATTR_BIND0 AND CUST_INFO_CONTRACT_ID = :MULT_ATTR_BIND1 AND ENTRY_DATE_TIMESTAMP < to_date( :MULT_ATTR_BIND2, 'YYYY-MM-DD-HH24.MI.SS' ) AND ENTRY_DATE_TIMESTAMP >= to_date( :MULT_ATTR_BIND3, 'YYYY-MM-DD-HH24.MI.SS' ) AND CUST_INFO_BILL_CYCLE IN ('16', '18') ORDER BY INITIAL_START_TIME_TIMESTAMP ASC , 2 ASC , 3 ASC , 4 ASC , 5 ASC , 6 ASC , 7 ASC
c0gvws85ubcgq	Select owner FROM all_objects WHERE object_name = 'QU_VERSION' AND object_type = 'PACKAGE' AND owner = USER UNION Select owner FROM all_synonyms WHERE synonym_name = 'QU_VERSION' AND owner = 'PUBLIC' UNION Select owner FROM all_synonyms WHERE synonym_name = 'QU_VERSION' AND owner = USER
cm5vu20fhtnq1	select /*+ connect_by_filtering */ privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0
cmajjzbbsxusq	SELECT /*+ PARALLEL(FRUT 16) */ SUM (saturation_symb) FROM EU_BILL.FU_REPORTING_sim_TABLE FRUT WHERE CUST_INFO_CONTRACT_ID = :B7 AND CUST_INFO_CUSTOMER_ID = :B6 AND ((:B5 IS NOT NULL AND (INSTR(:B5 , ':' || TARIFF_INFO_ZNCODE || ', ' || TARIFF_INFO_SNCODE || ':') > 0 OR INSTR(:B5 , ':0, ' || TARIFF_INFO_SNCODE || ':') > 0 OR INSTR(:B5 , ':' || TARIFF_INFO_ZNCODE || ', 0:') > 0)) OR (:B4 IS NOT NULL AND NOT (INSTR(:B4 , ':' || TARIFF_INFO_ZNCODE || ', ' || TARIFF_INFO_SNCODE || ':') > 0 OR INSTR(:B4 , ':0, ' || TARIFF_INFO_SNCODE || ':') > 0 OR INSTR(:B4 , ':' || TARIFF_INFO_ZNCODE || ', 0:') > 0))) AND RATED_VOLUME_xiseem = :B3 AND ENTRY_DATE_TIMESTAMP >= :B2 AND ENTRY_DATE_TIMESTAMP <= NVL (:B1 , SYSDATE) AND panel_IND = 'H' AND TARIFF_INFO_TMCODE NOT IN (7, 636) AND RATED_FLAT_AMOUNT > 0 AND ((gls_FREE_UNIT_PART_ID = 0) OR (gls_FREE_UNIT_PART_ID = 1))
cu8md2ugxujb5	SELECT "CUST_INFO_CUSTOMER_ID", "CUST_INFO_CONTRACT_ID", "CUST_INFO_BILL_CYCLE", "gls_STREAM_ID", "gls_RECORD_ID", "gls_BASE_PART_ID", "gls_CHARGE_PART_ID", "ENTRY_DATE_TIMESTAMP", "ENTRY_DATE_OFFSET", "BUSINESS_INFO_BS_ID", "saturation_symb", "FOLLOW_UP_CALL_TYPE", "NET_ELEMENT_NETWORK_CODE", "O_P_NORMED_NUM_ADDRESS", "O_P_NUMBER_ADDRESS", "RATED_FLAT_AMOUNT", "START_TIME_OFFSET", "START_TIME_TIMESTAMP", "TARIFF_DETAIL_CBW_CHARGE_TYPE", "TARIFF_INFO_SNCODE", "TARIFF_INFO_TMCODE", "TARIFF_INFO_ZNCODE", "TARIFF_INFO_ZPCODE", "panel_IND", "panel_CHARGE_AMOUNT", "S_PDP_ADDRESS", "ROUNDED_VOLUME", "S_P_EQUIPMENT_NUMBER", "CALLED_PARTY_MNP_ADDRESS", "FREE_CHARGE_AMOUNT", "DATA_VOLUME", "panel_CHARGE_TAX", "ISMSC_ISN_SERIAL_NUMBER" FROM "SYSADM"."sim_LT" "sim_LT" WHERE "CUST_INFO_CONTRACT_ID"=11303337 AND "CUST_INFO_CUSTOMER_ID"=9911290
cw6vxf0kbz3v1	SELECT CHAR_VALUE FROM SYSTEM.PRODUCT_PRIVS WHERE (UPPER('SQL*Plus') LIKE UPPER(PRODUCT)) AND ((USER LIKE USERID) OR (USERID = 'PUBLIC')) AND (UPPER(ATTRIBUTE) = 'ROLES')
d6vwqbw6r2ffk	SELECT USER FROM DUAL
dyk4dprp70d74	SELECT DECODE('A', 'A', '1', '2') FROM DUAL
fj6473z65d6w5	INSERT INTO "SYSADM"."DR_glasses" "A1" ("gls_STREAM_ID", "DR_RECORD_PART_ID", "DR_REFERENCE_PART_ID", "DR_ADDRESSEE_CONTRACT_ID", "DR_ADDRESSEE_CUSTOMER_ID", "DR_ADDRESSEE_CUSTOMER_PKEY", "DR_ADDRESSEE_BA_ID", "DR_ADDRESSEE_CONTRACT_PKEY", "DR_ADDRESSEE_BA_PKEY", "DR_ASS_DOC_NUMBER_INTERNAL_ID", "DR_ASS_DOC_NUMBER_EXTERNAL_ID", "DR_REQUEST_ASS_DOC_REQUEST_ID", "DR_REQUEST_BUS_UNIT_ID", "DR_REQUEST_BUS_UNIT_PKEY", "DR_ASS_DOC_CR_DATE_TIMESTAMP", "DR_ASS_DOC_CR_DATE_TIME_OFFSET", "DR_ASS_DOC_CR_TIMEZONE_ID", "DR_ASS_DOC_MN_DATE_TIMESTAMP", "DR_ASS_DOC_MN_DATE_TIME_OFFSET", "DR_ASS_DOC_MN_TIMEZONE_ID", "DR_ASS_DOC_RF_DATE_TIMESTAMP", "DR_ASS_DOC_RF_DATE_TIME_OFFSET", "DR_ASS_DOC_RF_DATE_TIMEZONE_ID", "DR_ASS_REACT_DATE_TIMESTAMP", "DR_ASS_REACT_DATE_TIME_OFFSET", "DR_ASS_REACT_DATE_TIMEZONE_ID", "DR_ASS_LAST_SEND_DATE_TIMEST", "DR_ASS_LAST_SEND_DATE_TIME_OFF", "DR_ASS_LAST_SEND_DATE_TIMEZ_ID", "DR_ASS_DOC_TYPE_ASS_DOC_TYPE", "DR_ASS_DOC_TYPE_GEN_PURPOSE", "DR_ASS_DOC_TYPE_BILL_PURPOSE", "DR_ASS_DOC_TYPE_BILL_CYCLE", "DR_ASS_DOC_TYPE_BILL_MED_ID", "DR_ASS_DOC_TYPE_BILL_MED_PKEY", "DR_ASS_DOC_TYPE_NU MBEROFCOPIES", "DR_ASS_DOC_TYPE_SUPPRESS_FLAG", "DR_ASS_DOC_TYPE_INV_REASON_ID", "DR_ASS_DOC_TYPE_THRESHOLD_VAL", "DR_ASS_DOC_TYPE_THRESHOLD_CURR", "DR_ASS_DOC_COPY_COPY_IND", "DR_DOCU_REFERENCE_LINK_TYPE", "DR_DOCU_NUMBER_INTERNAL_ID", "DR_DOCU_TYPE_DOC_TYPE", "DR_DOCU_TYPE_DOC_FORMAT", "DR_DOCU_LINK_LINK", "DR_DOCU_CREAT_DATE_TIMESTAMP", "DR_DOCU_CREAT_DATE_TIME_OFFSET", "DR_DOCU_CREAT_DATE_TIMEZONE_ID", "DR_DOC_LANGUAGE_LNG_PKEY", "DR_ACKNOWL_INDICATOR") VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, TO_DATE(:15, 'YYYYMMDDHH24MISS'), :16, :17, TO_DATE(:18, 'YYYYMMDDHH24MISS'), :19, :20, TO_DATE(:21, 'YYYYMMDDHH24MISS'), :22, :23, TO_DATE(:24, 'YYYYMMDDHH24MISS'), :25, :26, TO_DATE(:27, 'YYYYMMDDHH24MISS'), :28, :29, :30, :31, :32, :33, :34, :35, :36, :37, :38, :39, :40, :41, :42, :43, :44, :45, :46, TO_DATE(:47, 'YYYYMMDDHH24MISS'), :48, :49, :50, :51)
g4y6nw3tts7cc	BEGIN DBMS_APPLICATION_INFO.SET_MODULE(:1, NULL); END;

Back to SQL Statistics
Back to Top

Instance Activity Statistics

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

Instance Activity Stats

• Ordered by statistic name

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

• IOStat by Function summary
• IOStat by Filetype summary
• IOStat by Function/Filetype summary
• Tablespace IO Stats
• File IO Stats

IOStat by Function summary

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

Back to IO Stats
Back to Top

IOStat by Filetype summary

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

Back to IO Stats
Back to Top

IOStat by Function/Filetype summary

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

Back to IO Stats
Back to Top

Tablespace IO Stats

• ordered by IOs (Reads + Writes) desc

Back to IO Stats
Back to Top

File IO Stats

• ordered by Tablespace, File