Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Unable to track SQL TEXT from SQLID

JhilDec 17 2020

Dear Experts,
We could see multiple entries within alert log file and could not track SQL_TEXT for 4bwp0wrq3m1ym.
it is showing no rows selected. Something went wrong, where do i look into it ?
Multiple entires within alert log file
..Current username=PROD_****
...Application: JDBC Thin Client Action:
2020-12-17T10:08:04.290757+00:00
WARNING: too many parse errors, count=285700 SQL hash=0xec3987d3
PARSE ERROR: ospid=64111, error=923 for statement:
2020-12-17T10:08:04.290969+00:00
SELECT 1
Additional information: hd=0x317d876b8 phd=0x31f053cb0 flg=0x28 cisid=119 sid=119 ciuid=119 uid=119 sqlid=4bwp0wrq3m1ym

Thanks

This post has been answered by Billy Verreynne on Dec 17 2020
Jump to Answer
Comments
Post Details
Added on Dec 17 2020
9 comments
1,179 views