ORA-00911 From SQL Performance Analyzer Home When Using Underscore Parameter(_) for Parameter Change
(Doc ID 2730297.1)
Last updated on JULY 20, 2024
Applies to:
Enterprise Manager for Oracle Database - Version 13.4.1.0.0 and later Information in this document applies to any platform.
Symptoms
An EM Job failed at "Parameter Change" in SQL Performance Analyzer Home when Parameter Name is an undercore-Parameter like "_optimizer_squ_bottomup":
Navigate to >> PERFORMANCE >> SQL >> SQL Performance Analyzer Home >> Select Parameter Change Enter Task info...
.
.For parameter change enter any parameter that starts with an underscore As an example: _cursor_obsolete_threshold Schedule it immediately (default) and the job will fail with the following:
Run Detail
Request Start Date
Nov 19, 2020 1:40:10 PM -07:00
Actual Start Date
Nov 19, 2020 1:40:10 PM -07:00
Error #
911
Run Duration (minutes)
0.0
CPU Used (seconds)
0.02
Instance ID
1
Session ID
428,20413
Process ID
32285
Details
ORA-00911: invalid character ORA-06512: at line 1 ORA-00911: invalid character
Output
Cause
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
