Statspack Running Slow on 11g Databases Due To Slow Statement 'Insert Into Stat$Sql_Plan...'
Last updated on NOVEMBER 23, 2016
Applies to:Oracle Database - Standard Edition - Version 126.96.36.199 and later
Information in this document applies to any platform.
- Executing statspack.snap taking long time
- 10046 trace shows "insert into STATS$SQL_PLAN" taking huge time:
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms