What is the source of data that populate PPADB2 option 12 Problem SQL from PPA Main Menu?

Document ID : KB000017940
Last Modified Date : 14/02/2018
Show Technical Document Details

Description:

When using option 12 Problem SQL, does PPA read the Plan table to populate that panel or getting the info from somewhere else like catalog?

Solution:

This option does not read the plan_table, but rather the PPA historical database tables(PTPA_ES_EXPL_1200, PTAN_STMT_1200, PTAN_SQL_1200, etc...)

Option 12 reporting is a PPA Historical Database report. An explain with Historical Database explain option set needs to be done to get the explain data saved into the PPA historical database in order to be able to use this reporting option. Otherwise you'll end up with the following message: PP028E: NO DATA WAS FOUND MATCHING THAT CRITERIA.