| SQL Id | SQL Text |
|---|
| 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 |
| 0kkhhb2w93cx0 | 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, bitmapranges=:19 where ts#=:1 and file#=:2 and block#=:3 |
| 0qnq5z54k66cg |
SELECT xmlelement( "ash", (SELECT xmlagg( xmlelement( "total_ash_count", dim_count ) ORDER BY dim_count desc ) FROM ( SELECT 1 , count(*) as dim_count, rank() over (order by count(*) desc, 1 ) as dim_rank FROM ( SELECT unified_ash.* FROM ( ( SELECT d.dbid, inst.instance_number, 0 as snap_id, a.sample_id, a.sample_time, a.session_id, a.session_serial#, a.session_type, a.session_state, a.flags, a.user_id, a.sql_id, a.sql_opcode, a.top_level_sql_id, a.sql_child_number, a.sql_plan_hash_value, a.sql_plan_line_id, a.sql_plan_operation, a.sql_plan_options, a.sql_exec_id, a.force_matching_signature, a.plsql_entry_object_id, a.plsql_entry_subprogram_id, a.plsql_object_id, a.plsql_subprogram_id, a.service_hash, a.qc_session_id, a.qc_instance_id, a.qc_session_serial#, nvl(a.event, 'CPU + Wait for CPU') as event, nvl(a.event_id, 1) as event_id, nvl(a.wait_class, 'CPU') as wait_class, nvl(a.wait_class_id, 9999) as wait_class_id, a.seq#, a.p1, a.p1text, a.p2, a.p2text, a.p3, a.p3text, a.wait_time, a.time_waited, a.xid,
a.blocking_session, a.blocking_session_serial#, a.blocking_session_status, a.current_obj#, a.current_file#, a.current_block#, a.program, a.module, a.action, a.client_id, a.remote_instance#, a.in_connection_mgmt, a.in_parse, a.in_hard_parse, a.in_sql_execution, a.in_plsql_execution, a.in_plsql_rpc, a.in_plsql_compilation, a.in_java_execution, a.in_bind, a.in_cursor_close FROM V$ACTIVE_SESSION_HISTORY a, V$DATABASE d, V$INSTANCE inst WHERE 1=1 and :ash_enable_mem_view = 1 and a.sample_time between :ash_mem_btime and :ash_mem_etime and (:ash_enable_disk_view = 0 OR mod(a.sample_id, :ash_disk_filter) = 0) ) UNION ALL ( SELECT a.dbid, a.instance_number, a.snap_id, a.sample_id, a.sample_time, a.session_id, a.session_serial#, a.session_type, a.session_state, a.flags, a.user_id, a.sql_id, a.sql_opcode, a.top_level_sql_id, a.sql_child_number, a.sql_plan_hash_value, a.sql_plan_line_id, a.sql_plan_operation, a.sql_plan_options, a.sql_exec_id, a.force_matching_signature, a.plsql_entry_object_id, a.plsql_entry_subprogram_id, a.plsql_object_id, a.plsql_subprogram_id, a.service_hash,
a.qc_session_id, a.qc_instance_id, a.qc_session_serial#, nvl(a.event, 'CPU + Wait for CPU') as event, nvl(a.event_id, 1) as event_id, nvl(a.wait_class, 'CPU') as wait_class, nvl(a.wait_class_id, 9999) as wait_class_id, a.seq#, a.p1, a.p1text, a.p2, a.p2text, a.p3, a.p3text, a.wait_time, a.time_waited, a.xid, a.blocking_session, a.blocking_session_serial#, a.blocking_session_status, a.current_obj#, a.current_file#, a.current_block#, a.program, a.module, a.action, a.client_id, a.remote_instance#, a.in_connection_mgmt, a.in_parse, a.in_hard_parse, a.in_sql_execution, a.in_plsql_execution, a.in_plsql_rpc, a.in_plsql_compilation, a.in_java_execution, a.in_bind, a.in_cursor_close FROM DBA_HIST_ACTIVE_SESS_HISTORY a WHERE 1=1 and :ash_enable_disk_view = 1 and a.sample_time between :ash_disk_btime and :ash_disk_etime ) ) unified_ash WHERE dbid = :dbid AND (:inst_num IS NULL or instance_number = :inst_num) AND ((snap_id = 0) OR (snap_id between :bid and :eid)) AND sample_time between :ash_begin_time and :ash_end_time AND (:ash_num_samples = :ash_num_samples) AND (:ash_sid IS NULL OR session_id = :ash_sid OR (qc_session_id
= :ash_sid AND qc_instance_id = :inst_num) ) AND (:ash_sql_id IS NULL OR sql_id like :ash_sql_id) AND (:ash_wait_class IS NULL OR wait_class like :ash_wait_class) AND (:ash_service_hash IS NULL OR service_hash = :ash_service_hash) AND (:ash_module IS NULL OR module like :ash_module) AND (:ash_action IS NULL OR action like :ash_action) AND (:ash_client_id IS NULL OR client_id like :ash_client_id) AND (:ash_plsql_entry IS NULL OR ( (unified_ash.dbid, unified_ash.plsql_entry_object_id, unified_ash.plsql_entry_subprogram_id) IN (select d.dbid, object_id, subprogram_id from ( select object_id, subprogram_id, object_type, owner, object_name, procedure_name, overload from dba_procedures ) plsname1, v$database d where dbms_ash_internal.format_plsql(plsname1.owner, plsname1.object_name, plsname1.object_type, plsname1.procedure_name, plsname1.overload) like :ash_plsql_entry) ) ) ) a WHERE 1 = 1 GROUP BY 1 ) WHERE 1 = 1 ) ) FROM dual
|
| 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') |
| 0wvttswphs2ky | BEGIN
AP.PKG_LOAD_GENERATOR.RandomDML(250);
COMMIT;
END; |
| 0ytkqyqa89xq7 | SELECT XMLCONCAT( :B1 , DBMS_ASH_INTERNAL.ASH_ROLLUP_XML_2D( 'top_service_module_actions' ) ) FROM DUAL |
| 102hp0n5bz675 |
SELECT xmlelement( "top_sql_events", (SELECT xmlagg( dbms_ash_internal.build_sql_tag( sql_id => sql_id,
planhash => max(sql_plan_hash_value),
ash_num_executions => count(distinct sql_exec_id),
ash_count => count(*), xtra => (SELECT xmlagg( dbms_ash_internal.build_event_tag ( event_name => nvl(event, 'CPU + wait for CPU'),
ash_count => count(*) ) ORDER BY count(*) desc ) FROM ( SELECT unified_ash.* FROM ( ( SELECT d.dbid, inst.instance_number, 0 as snap_id, a.sample_id, a.sample_time, a.session_id, a.session_serial#, a.session_type, a.session_state, a.flags, a.user_id, a.sql_id, a.sql_opcode, a.top_level_sql_id, a.sql_child_number, a.sql_plan_hash_value, a.sql_plan_line_id, a.sql_plan_operation, a.sql_plan_options, a.sql_exec_id, a.force_matching_signature, a.plsql_entry_object_id, a.plsql_entry_subprogram_id, a.plsql_object_id, a.plsql_subprogram_id, a.service_hash, a.qc_session_id, a.qc_instance_id, a.qc_session_serial#, nvl(a.event, 'CPU + Wait for CPU') as event, nvl(a.event_id, 1) as event_i
d, nvl(a.wait_class, 'CPU') as wait_class, nvl(a.wait_class_id, 9999) as wait_class_id, a.seq#, a.p1, a.p1text, a.p2, a.p2text, a.p3, a.p3text, a.wait_time, a.time_waited, a.xid, a.blocking_session, a.blocking_session_serial#, a.blocking_session_status, a.current_obj#, a.current_file#, a.current_block#, a.program, a.module, a.action, a.client_id, a.remote_instance#, a.in_connection_mgmt, a.in_parse, a.in_hard_parse, a.in_sql_execution, a.in_plsql_execution, a.in_plsql_rpc, a.in_plsql_compilation, a.in_java_execution, a.in_bind, a.in_cursor_close FROM V$ACTIVE_SESSION_HISTORY a, V$DATABASE d, V$INSTANCE inst WHERE 1=1 and :ash_enable_mem_view = 1 and a.sample_time between :ash_mem_btime and :ash_mem_etime and (:ash_enable_disk_view = 0 OR mod(a.sample_id, :ash_disk_filter) = 0) ) UNION ALL ( SELECT a.dbid, a.instance_number, a.snap_id, a.sample_id, a.sample_time, a.session_id, a.session_serial#, a.session_type, a.session_state, a.flags, a.user_id, a.sql_id, a.sql_opcode, a.top_level_sql_id, a.sql_child_number, a.sql_plan_hash_value, a.sql_plan_line_id,
a.sql_plan_operation, a.sql_plan_options, a.sql_exec_id, a.force_matching_signature, a.plsql_entry_object_id, a.plsql_entry_subprogram_id, a.plsql_object_id, a.plsql_subprogram_id, a.service_hash, a.qc_session_id, a.qc_instance_id, a.qc_session_serial#, nvl(a.event, 'CPU + Wait for CPU') as event, nvl(a.event_id, 1) as event_id, nvl(a.wait_class, 'CPU') as wait_class, nvl(a.wait_class_id, 9999) as wait_class_id, a.seq#, a.p1, a.p1text, a.p2, a.p2text, a.p3, a.p3text, a.wait_time, a.time_waited, a.xid, a.blocking_session, a.blocking_session_serial#, a.blocking_session_status, a.current_obj#, a.current_file#, a.current_block#, a.program, a.module, a.action, a.client_id, a.remote_instance#, a.in_connection_mgmt, a.in_parse, a.in_hard_parse, a.in_sql_execution, a.in_plsql_execution, a.in_plsql_rpc, a.in_plsql_compilation, a.in_java_execution, a.in_bind, a.in_cursor_close FROM DBA_HIST_ACTIVE_SESS_HISTORY a WHERE 1=1 and :ash_enable_disk_view = 1 and a.sample_time between :ash_disk_btime and :ash_disk_etime ) ) unified_ash WHERE dbid = :dbid AND (:inst_num IS NULL or instance_number = :inst_num) AND ((snap_id = 0) OR
(snap_id between :bid and :eid)) AND sample_time between :ash_begin_time and :ash_end_time AND (:ash_num_samples = :ash_num_samples) AND (:ash_sid IS NULL OR session_id = :ash_sid OR (qc_session_id = :ash_sid AND qc_instance_id = :inst_num) ) AND (:ash_sql_id IS NULL OR sql_id like :ash_sql_id) AND (:ash_wait_class IS NULL OR wait_class like :ash_wait_class) AND (:ash_service_hash IS NULL OR service_hash = :ash_service_hash) AND (:ash_module IS NULL OR module like :ash_module) AND (:ash_action IS NULL OR action like :ash_action) AND (:ash_client_id IS NULL OR client_id like :ash_client_id) AND (:ash_plsql_entry IS NULL OR ( (unified_ash.dbid, unified_ash.plsql_entry_object_id, unified_ash.plsql_entry_subprogram_id) IN (select d.dbid, object_id, subprogram_id from ( select object_id, subprogram_id, object_type, owner, object_name, procedure_name, overload from dba_procedures ) plsname1, v$database d where dbms_ash_internal.format_plsql(plsname1.owner, plsname1.object_name, plsname1.object_type, plsname1.procedure_name, plsname1.overload)
like :ash_plsql_entry) ) ) ) d2 WHERE 1 = 1 and bitand(flags, 4) > 0 and d1.sql_id is not null and d2.sql_id = d1.sql_id GROUP BY event ) ) ORDER BY count(*) desc ) FROM ( SELECT unified_ash.* FROM ( ( SELECT d.dbid, inst.instance_number, 0 as snap_id, a.sample_id, a.sample_time, a.session_id, a.session_serial#, a.session_type, a.session_state, a.flags, a.user_id, a.sql_id, a.sql_opcode, a.top_level_sql_id, a.sql_child_number, a.sql_plan_hash_value, a.sql_plan_line_id, a.sql_plan_operation, a.sql_plan_options, a.sql_exec_id, a.force_matching_signature, a.plsql_entry_object_id, a.plsql_entry_subprogram_id, a.plsql_object_id, a.plsql_subprogram_id, a.service_hash, a.qc_session_id, a.qc_instance_id, a.qc_session_serial#, nvl(a.event, 'CPU + Wait for CPU') as event, nvl(a.event_id, 1) as event_id, nvl(a.wait_class, 'CPU') as wait_class, nvl(a.wait_class_id, 9999) as wait_class_id, a.seq#, a.p1, a.p1text, a.p2, a.p2text, a.p3, a.p3text, a.wait_time, a.time_waited, a.xid, a.blocking_session, a.blocking_session_serial#, a.blocking_session_status, a.current_obj#, a.cu
rrent_file#, a.current_block#, a.program, a.module, a.action, a.client_id, a.remote_instance#, a.in_connection_mgmt, a.in_parse, a.in_hard_parse, a.in_sql_execution, a.in_plsql_execution, a.in_plsql_rpc, a.in_plsql_compilation, a.in_java_execution, a.in_bind, a.in_cursor_close FROM V$ACTIVE_SESSION_HISTORY a, V$DATABASE d, V$INSTANCE inst WHERE 1=1 and :ash_enable_mem_view = 1 and a.sample_time between :ash_mem_btime and :ash_mem_etime and (:ash_enable_disk_view = 0 OR mod(a.sample_id, :ash_disk_filter) = 0) ) UNION ALL ( SELECT a.dbid, a.instance_number, a.snap_id, a.sample_id, a.sample_time, a.session_id, a.session_serial#, a.session_type, a.session_state, a.flags, a.user_id, a.sql_id, a.sql_opcode, a.top_level_sql_id, a.sql_child_number, a.sql_plan_hash_value, a.sql_plan_line_id, a.sql_plan_operation, a.sql_plan_options, a.sql_exec_id, a.force_matching_signature, a.plsql_entry_object_id, a.plsql_entry_subprogram_id, a.plsql_object_id, a.plsql_subprogram_id, a.service_hash, a.qc_session_id, a.qc_instance_id, a.qc_session_serial#, nvl(a.event, 'CPU + Wait for CPU') as event,
nvl(a.event_id, 1) as event_id, nvl(a.wait_class, 'CPU') as wait_class, nvl(a.wait_class_id, 9999) as wait_class_id, a.seq#, a.p1, a.p1text, a.p2, a.p2text, a.p3, a.p3text, a.wait_time, a.time_waited, a.xid, a.blocking_session, a.blocking_session_serial#, a.blocking_session_status, a.current_obj#, a.current_file#, a.current_block#, a.program, a.module, a.action, a.client_id, a.remote_instance#, a.in_connection_mgmt, a.in_parse, a.in_hard_parse, a.in_sql_execution, a.in_plsql_execution, a.in_plsql_rpc, a.in_plsql_compilation, a.in_java_execution, a.in_bind, a.in_cursor_close FROM DBA_HIST_ACTIVE_SESS_HISTORY a WHERE 1=1 and :ash_enable_disk_view = 1 and a.sample_time between :ash_disk_btime and :ash_disk_etime ) ) unified_ash WHERE dbid = :dbid AND (:inst_num IS NULL or instance_number = :inst_num) AND ((snap_id = 0) OR (snap_id between :bid and :eid)) AND sample_time between :ash_begin_time and :ash_end_time AND (:ash_num_samples = :ash_num_samples) AND (:ash_sid IS NULL OR session_id = :ash_sid OR (qc_session_id = :ash_sid AND qc_instance_id = :inst_num) ) AND (:ash_sql_id IS NULL OR sql_id l
ike :ash_sql_id) AND (:ash_wait_class IS NULL OR wait_class like :ash_wait_class) AND (:ash_service_hash IS NULL OR service_hash = :ash_service_hash) AND (:ash_module IS NULL OR module like :ash_module) AND (:ash_action IS NULL OR action like :ash_action) AND (:ash_client_id IS NULL OR client_id like :ash_client_id) AND (:ash_plsql_entry IS NULL OR ( (unified_ash.dbid, unified_ash.plsql_entry_object_id, unified_ash.plsql_entry_subprogram_id) IN (select d.dbid, object_id, subprogram_id from ( select object_id, subprogram_id, object_type, owner, object_name, procedure_name, overload from dba_procedures ) plsname1, v$database d where dbms_ash_internal.format_plsql(plsname1.owner, plsname1.object_name, plsname1.object_type, plsname1.procedure_name, plsname1.overload) like :ash_plsql_entry) ) ) ) d1 WHERE 1 = 1 and bitand(flags, 4) > 0 and d1.sql_id is not null GROUP BY sql_id ) ) FROM dual
|
| 1bshjy696nrzg | BEGIN
AP.PKG_LOAD_GENERATOR.RandomDML(375);
COMMIT;
END; |
| 1dmv3vasxtjtu | INSERT INTO AP.INVOICE_ITEMS ( INVOICE_ID , LINE_ITEM_NBR , ACTIVE_IND , PRODUCT_ID , QTY , EXTENDED_AMT , TAXABLE_IND ) VALUES( :B6 , :B5 , 'Y' , :B4 , :B3 , :B2 , :B1 ) |
| 1uzhrfn574t12 | SELECT ATTRIBUTE, SCOPE, NUMERIC_VALUE, CHAR_VALUE, DATE_VALUE FROM SYSTEM.PRODUCT_PRIVS WHERE (UPPER('SQL*Plus') LIKE UPPER(PRODUCT)) AND (UPPER(USER) LIKE USERID) |
| 1vu8j8vxpak4v | BEGIN :1 := dbms_workload_replay.report(:2, :3); END; |
| 209fr01svbb5s | update sys.aud$ set action#=:2, returncode=:3, logoff$time=cast(SYS_EXTRACT_UTC(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 |
| 2cfatxwm4dtjp | SELECT P.LIST_PRICE FROM OE.PRODUCT_INFORMATION P WHERE PRODUCT_ID = :B1 |
| 2syvqzbxp4k9z | select u.name, o.name, a.interface_version#, o.obj# from association$ a, user$ u, obj$ o where a.obj# = :1 and a.property = :2 and a.statstype# = o.obj# and u.user# = o.owner# |
| 2xyb5d6xg9srh | select a.default_cpu_cost, a.default_io_cost from association$ a where a.obj# = :1 and a.property = :2 |
| 39m4sx9k63ba2 | select /*+ index(idl_ub2$ i_idl_ub21) +*/ piece#, length, piece from idl_ub2$ where obj#=:1 and part=:2 and version=:3 order by piece# |
| 3ktacv9r56b51 | select owner#, name, namespace, remoteowner, linkname, p_timestamp, p_obj#, nvl(property, 0), subname, type#, d_attrs from dependency$ d, obj$ o where d_obj#=:1 and p_obj#=obj#(+) order by order# |
| 3mqbg0gn1ky0v | insert into wrr$_replay_divergence (id, time, type, exp_num_rows, obs_num_rows, exp_error, obs_error, file_id, call_counter, sql_id, session_id, session_serial#, service, module, action) select :rep_id, time, type, exp_num_rows, obs_num_rows, exp_error, obs_error, file_id, call_counter, sql_id, session_id, session_serial#, service, module, action from x$kecpdentry |
| 3z5b10rcvwbc0 | BEGIN dbms_workload_replay.start_replay(); END; |
| 41n4g99ucshck | INSERT INTO AP.INVOICES ( INVOICE_ID , ACTIVE_IND , INVOICE_TYPE , VENDOR_ID , CUSTOMER_ID , BALANCE_DUE , TAXABLE_AMT ) VALUES( :B3 , 'Y' , 'C' , :B2 , :B1 , 0 , 0 ) |
| 459f3z9u4fb3u | select value$ from props$ where name = 'GLOBAL_DB_NAME' |
| 4cpkqmdsq46br | BEGIN
AP.PKG_LOAD_GENERATOR.SpinCPUs(250);
END; |
| 4vs91dcv7u1p6 | 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, obj$edition, dbid) 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, :35, :36) |
| 4wjn4yqfuykz8 | DECLARE
rcout AP.PKG_LOAD_GENERATOR.rcReport;
BEGIN
AP.PKG_LOAD_GENERATOR.RandomQuery(250, rcout);
END; |
| 4ymp71aaj3bud | BEGIN
AP.PKG_LOAD_GENERATOR.RandomDML(500);
COMMIT;
END; |
| 51ns8aw6c5wq5 | SELECT DBMS_ASH_INTERNAL.BUILD_DATABASE_HEADER_TAG( R.DBID, R.DBNAME, R.DBVERSION, R.PARALLEL, NULL, NULL, NULL, XMLCONCAT(XMLELEMENT( "replay_name", R.NAME), XMLELEMENT( "replay_status", R.STATUS))), CAPTURE_ID FROM DBA_WORKLOAD_REPLAYS R WHERE ID = :B1 |
| 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 |
| 6c9wx6z8w9qpu | select a.default_selectivity from association$ a where a.obj# = :1 and a.property = :2 |
| 7snbfvf2qc0v4 | begin :1 := dbms_workload_replay.client_connect( dbms_workload_replay.KECP_CLIENT_CONNECT_GOODBYE ); end; |
| 8nqkx2x3yj2ng | SELECT APPENDCHILDXML(PRVT_REPORT_TAGS.BUILD_REPORT_TAG(:B2 ), '/*', :B1 ) FROM DUAL |
| 8swypbbr0m372 | select order#, columns, types from access$ where d_obj#=:1 |
| 9cgwmxs9wdnx4 | SELECT PRODUCT_ID FROM (SELECT PRODUCT_ID FROM OE.PRODUCT_INFORMATION SAMPLE(3) WHERE LIST_PRICE IS NOT NULL ORDER BY DBMS_RANDOM.VALUE) WHERE ROWNUM < 2 |
| abchp6whju3fy | SELECT CUSTOMER_ID FROM (SELECT CUSTOMER_ID FROM OE.CUSTOMERS SAMPLE(3) ORDER BY DBMS_RANDOM.VALUE) WHERE ROWNUM < 2 |
| aquqna9vhr57b | DECLARE
rcout AP.PKG_LOAD_GENERATOR.rcReport;
BEGIN
AP.PKG_LOAD_GENERATOR.RandomQuery(500, rcout);
END; |
| auu0bcau5ff55 | SELECT XMLCONCAT( :B1 , DBMS_ASH_INTERNAL.ASH_ROLLUP_XML_2D( 'top_sql_events' ) ) FROM DUAL |
| bgjhtnqhr5u9h | select procedure#, entrypoint# from procedureplsql$ where obj#=:1 order by procedure# |
| bsa0wjtftg3uw | select file# from file$ where ts#=:1 |
| bzbqb10q243ct | UPDATE AP.INVOICES SET BALANCE_DUE = :B3 , TAXABLE_AMT = :B2 WHERE INVOICE_ID = :B1 |
| c32jw7cwf856w |
SELECT xmlelement( "top_session_events", (SELECT xmlagg( dbms_ash_internal.build_session_tag( session_id => session_id,
session_serial => session_serial#,
user_name => dbms_ash_internal.get_user_name(max(user_id)),
program_name => to_char(max(program)),
ash_num_transactions => count(distinct xid),
ash_count => count(*), xtra => (SELECT xmlagg( dbms_ash_internal.build_event_tag ( event_name => nvl(event, 'CPU + wait for CPU'),
ash_count => count(*) ) ORDER BY count(*) desc ) FROM ( SELECT unified_ash.* FROM ( ( SELECT d.dbid, inst.instance_number, 0 as snap_id, a.sample_id, a.sample_time, a.session_id, a.session_serial#, a.session_type, a.session_state, a.flags, a.user_id, a.sql_id, a.sql_opcode, a.top_level_sql_id, a.sql_child_number, a.sql_plan_hash_value, a.sql_plan_line_id, a.sql_plan_operation, a.sql_plan_options, a.sql_exec_id, a.force_matching_signature, a.plsql_entry_object_id, a.plsql_entry_subprogram_id, a.plsql_object_id, a.plsql_subprogram_id, a.service_hash,
a.qc_session_id, a.qc_instance_id, a.qc_session_serial#, nvl(a.event, 'CPU + Wait for CPU') as event, nvl(a.event_id, 1) as event_id, nvl(a.wait_class, 'CPU') as wait_class, nvl(a.wait_class_id, 9999) as wait_class_id, a.seq#, a.p1, a.p1text, a.p2, a.p2text, a.p3, a.p3text, a.wait_time, a.time_waited, a.xid, a.blocking_session, a.blocking_session_serial#, a.blocking_session_status, a.current_obj#, a.current_file#, a.current_block#, a.program, a.module, a.action, a.client_id, a.remote_instance#, a.in_connection_mgmt, a.in_parse, a.in_hard_parse, a.in_sql_execution, a.in_plsql_execution, a.in_plsql_rpc, a.in_plsql_compilation, a.in_java_execution, a.in_bind, a.in_cursor_close FROM V$ACTIVE_SESSION_HISTORY a, V$DATABASE d, V$INSTANCE inst WHERE 1=1 and :ash_enable_mem_view = 1 and a.sample_time between :ash_mem_btime and :ash_mem_etime and (:ash_enable_disk_view = 0 OR mod(a.sample_id, :ash_disk_filter) = 0) ) UNION ALL ( SELECT a.dbid, a.instance_number, a.snap_id, a.sample_id, a.sample_time, a.session_id, a.session_serial#, a.session_type, a.session_state, a.flags,
a.user_id, a.sql_id, a.sql_opcode, a.top_level_sql_id, a.sql_child_number, a.sql_plan_hash_value, a.sql_plan_line_id, a.sql_plan_operation, a.sql_plan_options, a.sql_exec_id, a.force_matching_signature, a.plsql_entry_object_id, a.plsql_entry_subprogram_id, a.plsql_object_id, a.plsql_subprogram_id, a.service_hash, a.qc_session_id, a.qc_instance_id, a.qc_session_serial#, nvl(a.event, 'CPU + Wait for CPU') as event, nvl(a.event_id, 1) as event_id, nvl(a.wait_class, 'CPU') as wait_class, nvl(a.wait_class_id, 9999) as wait_class_id, a.seq#, a.p1, a.p1text, a.p2, a.p2text, a.p3, a.p3text, a.wait_time, a.time_waited, a.xid, a.blocking_session, a.blocking_session_serial#, a.blocking_session_status, a.current_obj#, a.current_file#, a.current_block#, a.program, a.module, a.action, a.client_id, a.remote_instance#, a.in_connection_mgmt, a.in_parse, a.in_hard_parse, a.in_sql_execution, a.in_plsql_execution, a.in_plsql_rpc, a.in_plsql_compilation, a.in_java_execution, a.in_bind, a.in_cursor_close FROM DBA_HIST_ACTIVE_SESS_HISTORY a WHERE 1=1 and :ash_enable_disk_view = 1 and a.sample_time between :ash_disk_btime and :ash_disk
_etime ) ) unified_ash WHERE dbid = :dbid AND (:inst_num IS NULL or instance_number = :inst_num) AND ((snap_id = 0) OR (snap_id between :bid and :eid)) AND sample_time between :ash_begin_time and :ash_end_time AND (:ash_num_samples = :ash_num_samples) AND (:ash_sid IS NULL OR session_id = :ash_sid OR (qc_session_id = :ash_sid AND qc_instance_id = :inst_num) ) AND (:ash_sql_id IS NULL OR sql_id like :ash_sql_id) AND (:ash_wait_class IS NULL OR wait_class like :ash_wait_class) AND (:ash_service_hash IS NULL OR service_hash = :ash_service_hash) AND (:ash_module IS NULL OR module like :ash_module) AND (:ash_action IS NULL OR action like :ash_action) AND (:ash_client_id IS NULL OR client_id like :ash_client_id) AND (:ash_plsql_entry IS NULL OR ( (unified_ash.dbid, unified_ash.plsql_entry_object_id, unified_ash.plsql_entry_subprogram_id) IN (select d.dbid, object_id, subprogram_id from ( select object_id, subprogram_id, object_type, owner, object_name, procedure_name, overload from dba_procedures ) plsname1, v$database d where dbms_ash_internal.format_plsql(plsname1.owner, plsname1.object_name, plsname1.
object_type, plsname1.procedure_name, plsname1.overload) like :ash_plsql_entry) ) ) ) d2 WHERE 1 = 1 and bitand(flags, 4) > 0 and d2.session_id = d1.session_id and d2.session_serial# = d1.session_serial# GROUP BY event ) ) ORDER BY count(*) desc ) FROM ( SELECT unified_ash.* FROM ( ( SELECT d.dbid, inst.instance_number, 0 as snap_id, a.sample_id, a.sample_time, a.session_id, a.session_serial#, a.session_type, a.session_state, a.flags, a.user_id, a.sql_id, a.sql_opcode, a.top_level_sql_id, a.sql_child_number, a.sql_plan_hash_value, a.sql_plan_line_id, a.sql_plan_operation, a.sql_plan_options, a.sql_exec_id, a.force_matching_signature, a.plsql_entry_object_id, a.plsql_entry_subprogram_id, a.plsql_object_id, a.plsql_subprogram_id, a.service_hash, a.qc_session_id, a.qc_instance_id, a.qc_session_serial#, nvl(a.event, 'CPU + Wait for CPU') as event, nvl(a.event_id, 1) as event_id, nvl(a.wait_class, 'CPU') as wait_class, nvl(a.wait_class_id, 9999) as wait_class_id, a.seq#, a.p1, a.p1text, a.p2, a.p2text, a.p3, a.
p3text, a.wait_time, a.time_waited, a.xid, a.blocking_session, a.blocking_session_serial#, a.blocking_session_status, a.current_obj#, a.current_file#, a.current_block#, a.program, a.module, a.action, a.client_id, a.remote_instance#, a.in_connection_mgmt, a.in_parse, a.in_hard_parse, a.in_sql_execution, a.in_plsql_execution, a.in_plsql_rpc, a.in_plsql_compilation, a.in_java_execution, a.in_bind, a.in_cursor_close FROM V$ACTIVE_SESSION_HISTORY a, V$DATABASE d, V$INSTANCE inst WHERE 1=1 and :ash_enable_mem_view = 1 and a.sample_time between :ash_mem_btime and :ash_mem_etime and (:ash_enable_disk_view = 0 OR mod(a.sample_id, :ash_disk_filter) = 0) ) UNION ALL ( SELECT a.dbid, a.instance_number, a.snap_id, a.sample_id, a.sample_time, a.session_id, a.session_serial#, a.session_type, a.session_state, a.flags, a.user_id, a.sql_id, a.sql_opcode, a.top_level_sql_id, a.sql_child_number, a.sql_plan_hash_value, a.sql_plan_line_id, a.sql_plan_operation, a.sql_plan_options, a.sql_exec_id, a.force_matching_signature, a.plsql_entry_object_id, a.plsql_entry_subprogram_id, a.plsql_o
bject_id, a.plsql_subprogram_id, a.service_hash, a.qc_session_id, a.qc_instance_id, a.qc_session_serial#, nvl(a.event, 'CPU + Wait for CPU') as event, nvl(a.event_id, 1) as event_id, nvl(a.wait_class, 'CPU') as wait_class, nvl(a.wait_class_id, 9999) as wait_class_id, a.seq#, a.p1, a.p1text, a.p2, a.p2text, a.p3, a.p3text, a.wait_time, a.time_waited, a.xid, a.blocking_session, a.blocking_session_serial#, a.blocking_session_status, a.current_obj#, a.current_file#, a.current_block#, a.program, a.module, a.action, a.client_id, a.remote_instance#, a.in_connection_mgmt, a.in_parse, a.in_hard_parse, a.in_sql_execution, a.in_plsql_execution, a.in_plsql_rpc, a.in_plsql_compilation, a.in_java_execution, a.in_bind, a.in_cursor_close FROM DBA_HIST_ACTIVE_SESS_HISTORY a WHERE 1=1 and :ash_enable_disk_view = 1 and a.sample_time between :ash_disk_btime and :ash_disk_etime ) ) unified_ash WHERE dbid = :dbid AND (:inst_num IS NULL or instance_number = :inst_num) AND ((snap_id = 0) OR (snap_id between :bid and :eid)) AND sample_time between :ash_begin_time and :ash_end_time AND (:ash_num_samples = :ash_num_samples) AND (:ash_sid IS N
ULL OR session_id = :ash_sid OR (qc_session_id = :ash_sid AND qc_instance_id = :inst_num) ) AND (:ash_sql_id IS NULL OR sql_id like :ash_sql_id) AND (:ash_wait_class IS NULL OR wait_class like :ash_wait_class) AND (:ash_service_hash IS NULL OR service_hash = :ash_service_hash) AND (:ash_module IS NULL OR module like :ash_module) AND (:ash_action IS NULL OR action like :ash_action) AND (:ash_client_id IS NULL OR client_id like :ash_client_id) AND (:ash_plsql_entry IS NULL OR ( (unified_ash.dbid, unified_ash.plsql_entry_object_id, unified_ash.plsql_entry_subprogram_id) IN (select d.dbid, object_id, subprogram_id from ( select object_id, subprogram_id, object_type, owner, object_name, procedure_name, overload from dba_procedures ) plsname1, v$database d where dbms_ash_internal.format_plsql(plsname1.owner, plsname1.object_name, plsname1.object_type, plsname1.procedure_name, plsname1.overload) like :ash_plsql_entry) ) ) ) d1 WHERE 1 = 1 and bitand(flags, 4) > 0 GROUP BY 1, session_id, session_serial# ) ) F
ROM dual |
| c4pc3jhzjcmc7 | SELECT CHAR_VALUE FROM SYSTEM.PRODUCT_PRIVS WHERE (UPPER('SQL*Plus') LIKE UPPER(PRODUCT)) AND ((UPPER(USER) LIKE USERID) OR (USERID = 'PUBLIC')) AND (UPPER(ATTRIBUTE) = 'ROLES') |
| c6awqs517jpj0 | select /*+ index(idl_char$ i_idl_char1) +*/ piece#, length, piece from idl_char$ where obj#=:1 and part=:2 and version=:3 order by piece# |
| cfrvd7bn0fd05 | select seq_name, seq_bnm, seq_bow, first_value, last_value, change, num_values, call_ctr, rank from WRR$_REPLAY_SEQ_DATA where file_id = :file_id and call_ctr >= :call_ctr and rank > :rank order by call_ctr, rank |
| cvn54b7yz0s8u | select /*+ index(idl_ub1$ i_idl_ub11) +*/ piece#, length, piece from idl_ub1$ where obj#=:1 and part=:2 and version=:3 order by piece# |
| d6vwqbw6r2ffk | SELECT USER FROM DUAL |
| db78fxqxwxt7r | select /*+ rule */ bucket, endpoint, col#, epvalue from histgrm$ where obj#=:1 and intcol#=:2 and row#=:3 order by bucket |
| dyk4dprp70d74 | SELECT DECODE('A', 'A', '1', '2') FROM DUAL |
| f6d6y4g13d49s | SELECT XMLCONCAT( :B1 , DBMS_ASH_INTERNAL.ASH_ROLLUP_XML_1D( 'ash' ) ) FROM DUAL |
| fguvzz4t33qbn | SELECT XMLCONCAT( :B1 , DBMS_ASH_INTERNAL.ASH_ROLLUP_XML_2D( 'top_session_events' ) ) FROM DUAL |
| g4y6nw3tts7cc | BEGIN DBMS_APPLICATION_INFO.SET_MODULE(:1, NULL); END; |
| g6f8nqdzgv9xg |
SELECT xmlelement( "top_service_module_actions", (SELECT xmlagg( dbms_ash_internal.build_service_module_tag( service_hash => service_hash,
service_name => max(a.name),
module_name => nvl(module, 'UNNAMED'),
ash_count => count(*), xtra => (SELECT xmlagg( dbms_ash_internal.build_action_tag ( action_name => nvl(action, 'UNNAMED'),
ash_count => count(*) ) ORDER BY count(*) desc ) FROM ( SELECT unified_ash.* FROM ( ( SELECT d.dbid, inst.instance_number, 0 as snap_id, a.sample_id, a.sample_time, a.session_id, a.session_serial#, a.session_type, a.session_state, a.flags, a.user_id, a.sql_id, a.sql_opcode, a.top_level_sql_id, a.sql_child_number, a.sql_plan_hash_value, a.sql_plan_line_id, a.sql_plan_operation, a.sql_plan_options, a.sql_exec_id, a.force_matching_signature, a.plsql_entry_object_id, a.plsql_entry_subprogram_id, a.plsql_object_id, a.plsql_subprogram_id, a.service_hash, a.qc_session_id, a.qc_instance_id, a.qc_session_serial#, nvl(a.event, 'CPU + Wait for CPU') as event, nvl(a.event_id, 1) as e
vent_id, nvl(a.wait_class, 'CPU') as wait_class, nvl(a.wait_class_id, 9999) as wait_class_id, a.seq#, a.p1, a.p1text, a.p2, a.p2text, a.p3, a.p3text, a.wait_time, a.time_waited, a.xid, a.blocking_session, a.blocking_session_serial#, a.blocking_session_status, a.current_obj#, a.current_file#, a.current_block#, a.program, a.module, a.action, a.client_id, a.remote_instance#, a.in_connection_mgmt, a.in_parse, a.in_hard_parse, a.in_sql_execution, a.in_plsql_execution, a.in_plsql_rpc, a.in_plsql_compilation, a.in_java_execution, a.in_bind, a.in_cursor_close FROM V$ACTIVE_SESSION_HISTORY a, V$DATABASE d, V$INSTANCE inst WHERE 1=1 and :ash_enable_mem_view = 1 and a.sample_time between :ash_mem_btime and :ash_mem_etime and (:ash_enable_disk_view = 0 OR mod(a.sample_id, :ash_disk_filter) = 0) ) UNION ALL ( SELECT a.dbid, a.instance_number, a.snap_id, a.sample_id, a.sample_time, a.session_id, a.session_serial#, a.session_type, a.session_state, a.flags, a.user_id, a.sql_id, a.sql_opcode, a.top_level_sql_id, a.sql_child_number, a.sql_plan_hash_value, a.sql_plan_line
_id, a.sql_plan_operation, a.sql_plan_options, a.sql_exec_id, a.force_matching_signature, a.plsql_entry_object_id, a.plsql_entry_subprogram_id, a.plsql_object_id, a.plsql_subprogram_id, a.service_hash, a.qc_session_id, a.qc_instance_id, a.qc_session_serial#, nvl(a.event, 'CPU + Wait for CPU') as event, nvl(a.event_id, 1) as event_id, nvl(a.wait_class, 'CPU') as wait_class, nvl(a.wait_class_id, 9999) as wait_class_id, a.seq#, a.p1, a.p1text, a.p2, a.p2text, a.p3, a.p3text, a.wait_time, a.time_waited, a.xid, a.blocking_session, a.blocking_session_serial#, a.blocking_session_status, a.current_obj#, a.current_file#, a.current_block#, a.program, a.module, a.action, a.client_id, a.remote_instance#, a.in_connection_mgmt, a.in_parse, a.in_hard_parse, a.in_sql_execution, a.in_plsql_execution, a.in_plsql_rpc, a.in_plsql_compilation, a.in_java_execution, a.in_bind, a.in_cursor_close FROM DBA_HIST_ACTIVE_SESS_HISTORY a WHERE 1=1 and :ash_enable_disk_view = 1 and a.sample_time between :ash_disk_btime and :ash_disk_etime ) ) unified_ash WHERE dbid = :dbid AND (:inst_num IS NULL or instance_number = :inst_num) AND ((snap_id = 0) OR
(snap_id between :bid and :eid)) AND sample_time between :ash_begin_time and :ash_end_time AND (:ash_num_samples = :ash_num_samples) AND (:ash_sid IS NULL OR session_id = :ash_sid OR (qc_session_id = :ash_sid AND qc_instance_id = :inst_num) ) AND (:ash_sql_id IS NULL OR sql_id like :ash_sql_id) AND (:ash_wait_class IS NULL OR wait_class like :ash_wait_class) AND (:ash_service_hash IS NULL OR service_hash = :ash_service_hash) AND (:ash_module IS NULL OR module like :ash_module) AND (:ash_action IS NULL OR action like :ash_action) AND (:ash_client_id IS NULL OR client_id like :ash_client_id) AND (:ash_plsql_entry IS NULL OR ( (unified_ash.dbid, unified_ash.plsql_entry_object_id, unified_ash.plsql_entry_subprogram_id) IN (select d.dbid, object_id, subprogram_id from ( select object_id, subprogram_id, object_type, owner, object_name, procedure_name, overload from dba_procedures ) plsname1, v$database d where dbms_ash_internal.format_plsql(plsname1.owner, plsname1.object_name, plsname1.object_type, plsname1.procedure_name, plsname1.overload)
like :ash_plsql_entry) ) ) ) d2 WHERE 1 = 1 and bitand(flags, 4) > 0 and d1.service_hash is not null and d2.service_hash = d1.service_hash and (d2.module = d1.module OR (d2.module IS NULL AND d1.module IS NULL)) GROUP BY action ) ) ORDER BY count(*) desc ) FROM ( SELECT unified_ash.* FROM ( ( SELECT d.dbid, inst.instance_number, 0 as snap_id, a.sample_id, a.sample_time, a.session_id, a.session_serial#, a.session_type, a.session_state, a.flags, a.user_id, a.sql_id, a.sql_opcode, a.top_level_sql_id, a.sql_child_number, a.sql_plan_hash_value, a.sql_plan_line_id, a.sql_plan_operation, a.sql_plan_options, a.sql_exec_id, a.force_matching_signature, a.plsql_entry_object_id, a.plsql_entry_subprogram_id, a.plsql_object_id, a.plsql_subprogram_id, a.service_hash, a.qc_session_id, a.qc_instance_id, a.qc_session_serial#, nvl(a.event, 'CPU + Wait for CPU') as event, nvl(a.event_id, 1) as event_id, nvl(a.wait_class, 'CPU') as wait_class, nvl(a.wait_class_id, 9999) as wait_class_id, a.seq#, a.p1, a.p1text, a.p2, a.p2text, a.p3, a.p3text, a.wait_time, a.time_waited, a.xid, a.bl
ocking_session, a.blocking_session_serial#, a.blocking_session_status, a.current_obj#, a.current_file#, a.current_block#, a.program, a.module, a.action, a.client_id, a.remote_instance#, a.in_connection_mgmt, a.in_parse, a.in_hard_parse, a.in_sql_execution, a.in_plsql_execution, a.in_plsql_rpc, a.in_plsql_compilation, a.in_java_execution, a.in_bind, a.in_cursor_close FROM V$ACTIVE_SESSION_HISTORY a, V$DATABASE d, V$INSTANCE inst WHERE 1=1 and :ash_enable_mem_view = 1 and a.sample_time between :ash_mem_btime and :ash_mem_etime and (:ash_enable_disk_view = 0 OR mod(a.sample_id, :ash_disk_filter) = 0) ) UNION ALL ( SELECT a.dbid, a.instance_number, a.snap_id, a.sample_id, a.sample_time, a.session_id, a.session_serial#, a.session_type, a.session_state, a.flags, a.user_id, a.sql_id, a.sql_opcode, a.top_level_sql_id, a.sql_child_number, a.sql_plan_hash_value, a.sql_plan_line_id, a.sql_plan_operation, a.sql_plan_options, a.sql_exec_id, a.force_matching_signature, a.plsql_entry_object_id, a.plsql_entry_subprogram_id, a.plsql_object_id, a.plsql_subprogram_id, a.service_hash, a.qc_s
ession_id, a.qc_instance_id, a.qc_session_serial#, nvl(a.event, 'CPU + Wait for CPU') as event, nvl(a.event_id, 1) as event_id, nvl(a.wait_class, 'CPU') as wait_class, nvl(a.wait_class_id, 9999) as wait_class_id, a.seq#, a.p1, a.p1text, a.p2, a.p2text, a.p3, a.p3text, a.wait_time, a.time_waited, a.xid, a.blocking_session, a.blocking_session_serial#, a.blocking_session_status, a.current_obj#, a.current_file#, a.current_block#, a.program, a.module, a.action, a.client_id, a.remote_instance#, a.in_connection_mgmt, a.in_parse, a.in_hard_parse, a.in_sql_execution, a.in_plsql_execution, a.in_plsql_rpc, a.in_plsql_compilation, a.in_java_execution, a.in_bind, a.in_cursor_close FROM DBA_HIST_ACTIVE_SESS_HISTORY a WHERE 1=1 and :ash_enable_disk_view = 1 and a.sample_time between :ash_disk_btime and :ash_disk_etime ) ) unified_ash WHERE dbid = :dbid AND (:inst_num IS NULL or instance_number = :inst_num) AND ((snap_id = 0) OR (snap_id between :bid and :eid)) AND sample_time between :ash_begin_time and :ash_end_time AND (:ash_num_samples = :ash_num_samples) AND (:ash_sid IS NULL OR session_id = :ash_sid OR (qc_session_id = :ash_
sid AND qc_instance_id = :inst_num) ) AND (:ash_sql_id IS NULL OR sql_id like :ash_sql_id) AND (:ash_wait_class IS NULL OR wait_class like :ash_wait_class) AND (:ash_service_hash IS NULL OR service_hash = :ash_service_hash) AND (:ash_module IS NULL OR module like :ash_module) AND (:ash_action IS NULL OR action like :ash_action) AND (:ash_client_id IS NULL OR client_id like :ash_client_id) AND (:ash_plsql_entry IS NULL OR ( (unified_ash.dbid, unified_ash.plsql_entry_object_id, unified_ash.plsql_entry_subprogram_id) IN (select d.dbid, object_id, subprogram_id from ( select object_id, subprogram_id, object_type, owner, object_name, procedure_name, overload from dba_procedures ) plsname1, v$database d where dbms_ash_internal.format_plsql(plsname1.owner, plsname1.object_name, plsname1.object_type, plsname1.procedure_name, plsname1.overload) like :ash_plsql_entry) ) ) ) d1 , v$active_services a WHERE 1 = 1 and bitand(flags, 4) > 0 and d1.service_hash is not null and a.name_hash = d1.service_hash GROUP BY service_hash, module )
) FROM dual |
| g8tm45j2jdgq8 | SELECT (SQRT(:B2 /:B1 )) FROM DUAL |
| ga9j9xk5cy9s0 | select /*+ index(idl_sb4$ i_idl_sb41) +*/ piece#, length, piece from idl_sb4$ where obj#=:1 and part=:2 and version=:3 order by piece# |
| gcdp623mad41b | SELECT VENDOR_ID FROM (SELECT VENDOR_ID FROM AP.VENDORS SAMPLE(3) ORDER BY DBMS_RANDOM.VALUE) WHERE ROWNUM < 2 |
| grwydz59pu6mc | select text from view$ where rowid=:1 |
