<div>
<div class="content wysiwyg-content">
I did the explain plan on a sql query and it says &quot;SQL Profile Used&quot; as below:-<br />
<br />
Note<br />
-----<br />
&nbsp; &nbsp;- dynamic sampling used for this statement (level=5)<br />
&nbsp; &nbsp;- automatic DOP: skipped because of IO calibrate statistics are missing<br />
&nbsp; &nbsp;- SQL profile &quot;SYS_SQLPROF_017cb4701f920<wbr />005&quot; used for this statement<br />
&nbsp; <br />
How can I check what is there in this SQL Profile ?<br />
I mean, Is there any sql or dba view to get the information?
</div>
</div>


I did the explain plan on a sql query and it says "SQL Profile Used" as below:-

Note
-----
   - dynamic sampling used for this statement (level=5)
   - automatic DOP: skipped because of IO calibrate statistics are missing
   - SQL profile "SYS_SQLPROF_017cb4701f920005" used for this statement
  
How can I check what is there in this SQL Profile ?
I mean, Is there any sql or dba view to get the information?

Oracle sql profile used in the query

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.