script to check SQL profile status in oracle database

set lines 200 pages 200
select name,type,status,created from dba_sql_profiles;