Checking if a Sql Profile is being used

1. Check for Sql Profiles
SQL>SELECT NAME,sql_text FROM dba_sql_profiles;

2. String Check for Sql Profile Name
SQL>SELECT hash_value,sql_id,other_xml FROM v$sql_plan WHERE dbms_lob.INSTR(other_xml,'WEBLOGICII') > 0;