• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
Techgoeasy

Techgoeasy

Learn Oracle, PHP, HTML,CSS,Perl,UNIX shell scripts

  • Home
  • Oracle
    • Oracle database
    • Oracle Ebusiness Suite
    • Oracle weblogic
    • Oracle Performance Tuning
    • Oracle Hyperion
    • Oracle Cloud Tutorials
  • SQL
  • interview questions
  • Linux
  • PHP and HTML
  • Downloads
  • General
Home » Oracle » Oracle Database » how to find if the sql is using the sql profile

how to find if the sql is using the sql profile

May 16, 2023 by techgoeasy Leave a Comment

When we implement the sql profile for the statement, we will also like to confirm if the sql has started using the sql profile or not. we can use the below query to find out if the sql is using the sql profile

how to find if the sql is using the sql profile

col sql_profile for a30
col sql_text for a60 wrap
col child_number format 99999 heading CHILD
col avg_etime format 9,999,999.99
col avg_lio format 999,999,99
col etime format 9,999,999.99
select sql_id, child_number, plan_hash_value plan_hash, sql_profile, executions execs,
(elapsed_time/1000000)/decode(nvl(executions,0),0,1,executions) avg_etime,
buffer_gets/decode(nvl(executions,0),0,1,executions) avg_lio,
sql_text
from v$sql s
where sql_id like '&sql_id
order by 1, 2, 3
/

Read more about the sql profile at the below links

How to move the sql profiles in Oracle
how to check sql profile in oracle
sql tuning advisor

Filed Under: Oracle, Oracle Database

Reader Interactions

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Primary Sidebar



Subscribe to our mailing list

Enter your email address to subscribe to this blog and receive notifications of new posts by email

Recent Posts

  • how to find if the sql is using the sql profile
  • How to verify stats for the table in EBS
  • STATISTICS_LEVEL in Oracle
  • Move SQL Profiles from One Database to Another in Oracle
  • How to compare statistics using stattab for a table in Oracle

Copyright © 2023 : TechGoEasy

  • Hire me
  • Privacy Policy
  • Contact Us
  • New? Start Here
  • About Us
x
x