What does my SQL Profile exactly do?

Hi all,

I have a simple query that runs for 8 hours. And same query runs on other similar environments also similar times.

select pzlastmodified, pzbinarycontent from OWNER_TLR.pr_engineclasses where (pzpackage = :1 or pzpackage = :2 ) and pzclass = :3 and pzjar = :4 and pzcodeset = :5 and pzcodesetversion = :6 and pzpatchdate = :7

I introduced a SQL Profiles through EM13c and now it runs in seconds.

I want to investigate what this SQL Profile is doing so I can reproduce it on new environments.

This is the content of the Profiles:

SELECT * FROM DBMSHSXP_SQL_PROFILE_ATTR WHERE PROFILE_NAME='SYS_SQLPROF_0169a05e75770001';

<outline_data>

<hint><![CDATA[OPT_ESTIMATE(