Database Tuning (MOSC)

MOSC Banner

top_n_sql & top_n_sql_max & top_sql_pct in DBMS_WORKLOAD_REPOSITORY.AWR_SET_REPORT_THRESHOLDS

edited Jan 22, 2015 10:32AM in Database Tuning (MOSC) 6 commentsAnswered

top_n_sql - number of most significant SQL statements to be included

top_n_sql_max - number of SQL statements to be included if their activity is greater than that specified by  top_sql_pct

top_sql_pct - significance threshold for SQL statements between top_n_sql and top_n_max_sql

What the document  says made me confused. Such as when talking about the top_n_sql_max what's the meaning of activity in "number of SQL statements to be included if their activity is greater than that specified by  top_sql_pct".

And does top_sql_pct stand for a percent?

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

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center