Hi All,
i upgraded a production database from 11.2.0.3 to 12.2.0.1 .
After upgrade, i see warnings like below in alert.log. I searched it in metalink and found a discussion about it. İt says error:923 means ora-923. and statement is "SELECT 1" . Well, I can not catch which user is getting this errror. I m using ospid to find sid but i dont.
This production database and Application is same . Probably, these case were already present in 11.2.0.3 but it was not writing these warning to alert.log. Have you ever met this warnings in 12.2 ? Any idea ? Any parameter to prevent these warnings in alert.log ? Thanks advance..
WARNING: too many parse errors, count=7500 SQL hash=0xec3987d3
PARSE ERROR: ospid=59769040, error=923 for statement:
2017-10-05T10:00:40.053467+03:00
SELECT 1
Additional information: hd=7000100066b2e30 phd=70001000fcad080 flg=0x28 cisid=58 sid=58 ciuid=58 uid=58