


Running sqltrpt.sql for SQL ID bk3p70gc73zat
This creates and executes a SQL Tuning Advisor task.

15 Most expensive SQL in the cursor cache
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

SQL_ID           ELAPSED SQL_TEXT_FRAGMENT
------------- ---------- -------------------------------------------------------
b39m8n96gxk7c   8,887.46 call dbms_autotask_prvt.run_autotask ( :0,:1 )
ampw9ddqufjd3   8,878.16 begin /*KAPI:capture*/ dbms_auto_index_internal.capture
c61ajdcqbqn42   8,437.22 SELECT  new.sql_seq, old.plan_hash_value, sqlset_row(ne
7hnc5ucz8grnt   7,899.36 SELECT VALUE(P) FROM TABLE(DBMS_SQLTUNE.SELECT_CURSOR_C
fn0stp00nzmj6   7,089.83  SELECT /*+ first_rows(1) */ sql_id, force_matching_sig
b6usrg82hwsa3   1,482.37 call dbms_stats.gather_database_stats_job_proc (  )
as2dr3ag24gay     441.63 select not_stale.obj# from (select s.obj# obj#, count(*
gn56shm8rfjgf     241.45 MERGE /*+ dynamic_sampling(ST 4) dynamic_sampling_est_c
5pj6mtazkhmdd     173.98 BEGIN /* KSXM:FLUSH DML_MON */    dbms_stats_internal.g
8gbt6t0s3jn0t     112.42 MERGE /*+ OPT_PARAM('_parallel_syspls_obey_force' 'fals
5sf7xj9w1zhuv      98.34 select t5.obj#, t5.intcol#, t6.obj#, t6.intcol#, case w
b9nbhsbx8tqz5      64.67 SELECT /*+ OPT_PARAM('_parallel_syspls_obey_force' 'fal
f705bwx3q0ydq      49.92 select count(*) from dba_autotask_window_clients c, (se
cu8ydfsrrjm87      44.19 begin   :begin_snap := dbms_workload_repository.create_
3qk9bh5x55an0      41.84 SELECT COUNT(*) FROM SYS.STATS_ADVISOR_FILTER_OBJ$ WHER

15 Most expensive SQL in the workload repository
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

SQL_ID           ELAPSED
------------- ----------
SQL_TEXT_FRAGMENT
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
b39m8n96gxk7c   8,887.46
call dbms_autotask_prvt.run_autotask ( :0,:1 )

ampw9ddqufjd3   8,878.16
begin /*KAPI:capture*/ dbms_auto_index_internal.capture

c61ajdcqbqn42   8,437.22
SELECT  new.sql_seq, old.plan_hash_value, sqlset_row(ne

7hnc5ucz8grnt   7,899.36
SELECT VALUE(P) FROM TABLE(DBMS_SQLTUNE.SELECT_CURSOR_C

fn0stp00nzmj6   7,089.83
 SELECT /*+ first_rows(1) */ sql_id, force_matching_sig

b39m8n96gxk7c   4,884.97
call dbms_autotask_prvt.run_autotask ( :0,:1 )

ampw9ddqufjd3   4,881.02
begin /*KAPI:capture*/ dbms_auto_index_internal.capture

c61ajdcqbqn42   4,694.45
SELECT  new.sql_seq, old.plan_hash_value, sqlset_row(ne

7hnc5ucz8grnt   4,460.82
SELECT VALUE(P) FROM TABLE(DBMS_SQLTUNE.SELECT_CURSOR_C

fn0stp00nzmj6   4,102.34
 SELECT /*+ first_rows(1) */ sql_id, force_matching_sig

b6usrg82hwsa3   1,403.95
call dbms_stats.gather_database_stats_job_proc (  )

b6usrg82hwsa3     588.28
call dbms_stats.gather_database_stats_job_proc (  )

as2dr3ag24gay     441.63
select not_stale.obj# from (select s.obj# obj#, count(*

gn56shm8rfjgf     241.45
MERGE /*+ dynamic_sampling(ST 4) dynamic_sampling_est_c

as2dr3ag24gay     188.49
select not_stale.obj# from (select s.obj# obj#, count(*


Specify the Sql id
~~~~~~~~~~~~~~~~~~

Sql Id specified: bk3p70gc73zat

Tune the sql
~~~~~~~~~~~~

GENERAL INFORMATION SECTION
-------------------------------------------------------------------------------
Tuning Task Name   : TASK_14
Tuning Task Owner  : OPS$AXION\CODEXSANDBOXOFFLINE
Workload Type      : Single SQL Statement
Scope              : COMPREHENSIVE
Time Limit(seconds): 1800
Completion Status  : COMPLETED
Started at         : 08/04/2026 03:35:14
Completed at       : 08/04/2026 03:35:16

-------------------------------------------------------------------------------
Schema Name   : OPS$AXION\CODEXSANDBOXOFFLINE
Container Name: ORCLPDB
SQL ID        : bk3p70gc73zat
SQL Text      : SELECT /*+ gather_plan_statistics monitor full(o)
                               qb_name(DBACORNER_LAB_BAD) */ COUNT(*) FROM
                DBC_LAB_ORDERS O WHERE O.CUSTOMER_ID = 4242 AND O.STATUS =
                'COMPLETE'

-------------------------------------------------------------------------------
There are no recommendations to improve the statement.

-------------------------------------------------------------------------------

