ORA-907 Error From SQL Tuning Advisor When Running It Against STS SQL Created by SPA
(Doc ID 2331851.1)
Last updated on AUGUST 04, 2018
Oracle Database - Enterprise Edition - Version 184.108.40.206 and later
Information in this document applies to any platform.
- LARGE NUMBER OF ORA-907 ERROR DURING SQL Tuning Advisor Analyzing SQL
- Error SQL is from SQL Tuning Set (STS) which created by SQL Performance Analyzer(SPA)
- Error SQL is like dynamic dynamic sampling statements with the undocumented SAMPLE BLOCK / SEED construct
/* OPT_DYN_SAMP */
/*+ ALL_ROWS IGNORE_WHERE_CLAUSE NO_PARALLEL(SAMPLESUB) opt_param('parallel_execution_enabled', 'false') NO_PARALLEL_INDEX(SAMPLESUB) NO_SQL_TUNE */
END AS C2
FROM <USER.TABL_NAME> SAMPLE BLOCK (:"SYS_B_6" , :"SYS_B_7") SEED (:"SYS_B_8") "A1"
Upgrade 12c using SPA testing.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.