ref: http://blog.tanelpoder.com/2009/05/06/free-dba_hist-awr-views-in-11g/
When you access Oracle AWR (and other licensed features/tables/views) then these do show up in DBA_FEATURE_USAGE_STATISTICS. Exporting the contents is the same as accessing these with your SQL.
All data dictionary views beginning with the prefix DBA_HIST_ are part of this pack, along with their underlying tables.The only exception are the views: DBA_HIST_SNAPSHOT, DBA_HIST_DATABASE_INSTANCE, DBA_HIST_SNAP_ERROR, DBA_HIST_SEG_STAT, DBA_HIST_SEG_STAT_OBJ, and DBA_HIST_UNDOSTAT. They can be used without the Diagnostic Pack license.
DBA_HIST_SNAPSHOT – The table holds AWR snapshots information for all snapshots.
DBA_HIST_SQLSTAT – The informaiton and statistics in this table are taken from V$SQL with each AWR snapshot, it chooses the top SQL statements from the dynamic view. The number of statements depends on the value of STATISTICS_LEVEL parameter.
DBA_HIST_SQL_PLAN – This table is pretty much the same as V$SQL_PLAN. the greatest thing about it is that it keeps execution plans of all statements and the informaiton is not purged when snapshots are deleted.
DBA_HIST_SQLTEXT – Same as DBA_HIST_SQL_PLAN but with V$SQL_TEXT.
DBA_HIST_SEG_STAT – Same as DBA_HIST_SQLSTAT but with V$SEGMENT_STATISTICS, the columns are slightly different from the V$, the HIST table has a column for each statistic instead of the STATISTIC_NAME column that the V$ has. This table also holds information of the top segments of each snapshot and the number is also controlled by the STATISTIC_LEVEL parameter.
DBA_HIST_SYSTEM_EVENT – The HIST of V$SYSTEM_EVENT, holds the wait events information for every snapshot.
DBA_HIST_ACTIVE_SESS_HISTORY – The HIST table of V$ACTIVE_SESSION_HISTORY