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!
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
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