Oracle: DBA_WORKLOAD_CAPTURES

select
   cpt.id,
   cpt.name,
   cpt.status,   
   cpt.plsql_mode,
   cpt.transactions, cpt.transactions_total,
   cpt.user_calls, cpt.user_calls_total, cpt.user_calls_unreplayable,
   cpt.directory,
   cpt.dir_path,
   cpt.capture_size,   
   cpt.dir_path_shared,
   cpt.default_action,
   cpt.errors, cpt.error_code, cpt.error_message,   
   cpt.awr_begin_snap,
   cpt.start_scn , cpt.end_scn,   
   cpt.start_time, cpt.end_time,
   cpt.duration_secs,   
   cpt.awr_end_snap,
   cpt.awr_exported,
   cpt.connects, cpt.connects_total,
   cpt.dbid,
   cpt.awr_dbid,   
   cpt.dbname,
   cpt.dbtime,
   cpt.dbtime_total,
   cpt.encryption, cpt.encryption_verifier,
   cpt.filters_used,
   cpt.parallel,
   cpt.patch_name,
   cpt.plsql_calls,
   cpt.plsql_dbtime,
   cpt.plsql_subcall_size,
   cpt.plsql_subcalls,
   cpt.sqlset_name,
   cpt.sqlset_owner,
   cpt.storage_type,
   cpt.dbversion,      cpt.last_processed_version
from
   sys.dba_workload_captures cpt;