Generate execution plan created from AWR snapshot and SQLID

Generate execution plan created from AWR snapshot and SQLID

We can use $ORACLE_HOME/rdbms/admin/awrsqrpt.sql one can generate execution plan from AWR by passing start snap id, end snap id and SQL ID.

It will ask for most of the same inputs like awrrpt.sql, type of report (html/text), start snap id, end snap id, SQL id and report name and create a output in the file specified.

Example:

SQL> @?/rdbms/admin/awrsqrpt.sql

Please do like and subscribe to my youtube channel: https://www.youtube.com/@foalabs If you like this post please follow,share and comment