Query to show sql_ids related to SQL Profiles

Hi All,

Hope everyone is doing great.

select count(*) from dba_sql_profiles;

  COUNT(*)

----------

        21

When i try to find the sql_id associated with this sql profiles using the below

I see only one created on 09-APR-15 09.12.33.000000 AM.  There are 10 more profiles created after that which is not showing.  Why is it so?

select p.name,s.sql_id

from dba_sql_profiles p,DBA_HIST_SQLSTAT s

where p.name=s.sql_profile; 

NAME                           SQL_ID

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

SYS_SQLPROF_034c9e4f82020000   2qbgw1phubysy

1 row selected.

Baskar.l