Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to Bring one particular SQL to AWR report

Raj AruNov 26 2019 — edited Nov 27 2019

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

This post has been answered by AndrewSayer on Nov 26 2019
Jump to Answer

Comments

SH_INT
Answer

You need to look in the tPOVPartition table (which is the FDM table that stores all the location related information). There is a field in this table which tells you the numer of the tDataSeg table used by each location

Marked as Answer by user17 · Sep 27 2020
1 - 1

Post Details

Added on Nov 26 2019
5 comments
1,173 views