Database Tuning (MOSC)

MOSC Banner

SQL Performance Analyzer for Database Replay sessions

edited Dec 19, 2018 7:42AM in Database Tuning (MOSC) 10 commentsAnswered
I would like to use the SQL Performance Analyzer to compare two runs of the Database Replay, however the option to capture SQL statements in a Tuning Sets does not present itself on the Replay Workload: Initialize Options and not surprisingly, selecting the Run SQL Performance Analyzer Report from the Report tab of the Replay results in 'SQL tuning sets are not available'.  The documentation indicates there should be a selection to capture STS during the replay (http://download.oracle.com/docs/cd/E11882_01/server.112/e16540/dbr_replay.htm#CHDEBCIC), and that it is the default action, but it does not appear for me.  I am presented only with Replay Name and Identify Source, not the SQL Performance Analzyer.

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