SNAPSHOT

Query to check snapshot refresh are successfully completed and refresh for materialized views.

Please use the below query.   SELECT DISTINCT(TRUNC(last_refresh)) FROM dba_snapshot_refresh_times;   select owner, mview_name, last_refresh_type, last_refresh_date from dba_mviews;

Read More

Steps to Export and Import AWR Stats

Please find the steps to export and import AWR stats. Exporting AWR snapshot data:- ***************************** SQL> @?/rdbms/admin/awrextr.sql AWR EXTRACT **************************************************** This script will extract the AWR data for a range of snapshots into a dump file. The script…

Read More