Filtering based on parsing schemas for loading into STS for creating baseline
Hello
We have a question on creating baseline from AWR snapshots
The databases in question are 12cR2 and 19c
Lets say we have identified 2 ranges of AWR snapshots that has the data / SQLs of interest
Begin Snap ID End Snap ID
1011 1014
and
1025 1027
So, we will create a empty STS first
begin
DBMS_SQLTUNE.CREATE_SQLSET(SQLSET_NAME => 'STS_AWR_LOAD', DESCRIPTION => 'Empty STS for loading data from AWR snaps for Baseline');
END;
/
After that, here is what we are trying to accomplish
1. Load the SQLs from the above 2 ranges
2. Filter the SQL for only a couple of parsing schemas, i.e load only the SQLs for 2 schemas only ('APPU1' and 'APPBATCH') and disregard / do not capture any other SQLs belong to any other schemas