I want to be able to display the times for all of
my AWR snapshots without issuing the AWR report (awrrpt.sql)
command. What dba_hist view contains a list of all of
the AWR snapshots on my database?
Answer: While the standard AWR
report (awrrpt.sql) will list the snapshots to choose from,
you can manually list all of the AWR snapshots and the time
of each AWR snapshot.
Here is how to take an AWR
SQL > exec
This script will list all AWR snapshots
in Linux, Windows or UNIX::
Also see MOSC note 1301503.1:
"Troubleshooting: AWR Snapshot Collection issues"