Hello Gyus
In my database TOPNSQL is set as DEFAULT which means top 30 sqls will be flushed for each SQL criteria for each snapshot.
After that i used below command to display 50 queries in AWR for each criteria :-
SQL> exec dbms_workload_repository.awr_set_report_thresholds(top_n_sql=>50,top_n_sql_max=>50);
PL/SQL procedure successfully completed.
SQL> @?/rdbms/admin/awrrpt.sql
Now my questions is :- If oracle is flushing top 30 sql for each snapshot then how am i getting 50 sqls in AWR for different criteria.? Please correct me i am getting any concepts in wrong way .
Database Version : 12.1.0.2