Database Tuning (MOSC)

MOSC Banner

Filtering based on parsing schemas for loading into STS for creating baseline

in Database Tuning (MOSC) 13 commentsAnswered ✓

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center