Sql profiles test

Hi team,

I need to do test of current implemented and enabled Sql profiles in our new production database. We now have profiles implemented for various sql statements, and we are doing migration from database version 10.2.0.5 to version 12.1.0.2.0.

Can you please explain also this, first statement returns only enabled profiles, currently 20 of them:

select

  sql_text

from

  dba_sql_profiles

where

  status = 'ENABLED';

But second one returns Profile Attribute Detail, and output of this is big number of attributes (over 800)

select

  created, profile_name, attr_value, sql_text

from 

dba_sql_profiles         p,

  dbmshsxp_sql_profile_attr a

where p.name=a.profile_name