ACCEPTしたSQLプロファイルの一覧を表示する

Oracle Database 11g R2 (11.2.0.3) Enterprise Editionで動作確認済み。

SET LONG 1000
SET LONGCHUNKSIZE 1000
SET LINESIZE 255
SET TRIMS ON
ALTER SESSION SET nls_timestamp_format = 'YYYY/MM/DD HH24:MI';
COL name FORMAT a30
COL category FORMAT a10
COL sql_text FORMAT a80
COL created FORMAT a20
COL last_modified FORMAT a20
COL force_matching FORMAT a5 HEADING 'FORCE|MATCH'
SELECT name, category, created, last_modified, force_matching, sql_text
  FROM dba_sql_profiles
 ORDER BY created DESC;