How to Bring one particular SQL to AWR report

Raj Aru

I am looking to bring the select statement  sql which I am running in the database to AWR report Is there any way to pin a sql to awr report

AndrewSayer

Raj Aru wrote:I am looking to bring the select statement sql which I am running in the database to AWR report Is there any way to pin a sql to awr report

Yes, it's called coloring for some reason. Use dbms_workload_repository.add_colored_sql https://docs.oracle.com/en/database/oracle/oracle-database/19/arpls/DBMS_WORKLOAD_REPOSITORY.html#GUID-243BBE24-DF37-45F…

AndrewSayer

Raj Aru wrote:I am looking to bring the select statement sql which I am running in the database to AWR report Is there any way to pin a sql to awr report

Yes, it's called coloring for some reason. Use dbms_workload_repository.add_colored_sql https://docs.oracle.com/en/database/oracle/oracle-database/19/arpls/DBMS_WORKLOAD_REPOSITORY.html#GUID-243BBE24-DF37-45F…

Adityanath Dewoolkar

Yes you can do that:

Oracle Performance and Backup Blog: How to color (mark) SQL for AWR snapshots

Regards,
Adi

Raj Aru

Thanks AndrewSayer for the quick help

Jonathan Lewis

A little add-on to the note about coloring - the statement won't necessarily appear in the standard AWR report because it may not have done enough work in any of the ordinary categories; however it will have been captured in the repository and you can report it in the "AWR SQL report" - which I usually run from SQL*Plus: $ORACLE_HOME/rdbms/admin/awrsqrpt.sql

See:  https://jonathanlewis.wordpress.com/2018/10/19/add_colored_sql/

Regards

Jonathan Lewis

Raj Aru

Thanks Lewis