AWR records top 30 SQLs by default

(Bobby Durrett) I forget that Oracle’s AWR only records the top 30 SQL statements in each snapshot by default. I am not sure how long this link will last but here is a 19c manual page describing the default: 19c manual – see the topnsql setting.

Register to Read