10035 event tracing no more records sql_texts to alert.log
Cursordump is the way to go. I’ve moved my blog from https://insanedba.blogspot.com to https://dincosman.com Please update your bookmarks and follow/subscribe at the new address for all the latest updates and content. More up-to-date content of this post may be available there. Parse failures are actually not stored in the data dictionary and therefore cannot be identified through querying the data dictionary. As of Oracle 10g, event 10035 can be used to report all failed parses. With the 19.16 Release Update, Oracle does not record SQL statements to alert.log. Any statement that fails at the parsing stage is recorded with the error number and the process OSPID. Also, setting the hidden "_kks_parse_error_warning" parameter to 1 does not help report ...