SQL Text is showing ?????????????????????????????? in AWR Reports
(Doc ID 2617954.1)
Last updated on DECEMBER 16, 2019
Applies to:
Oracle Database - Enterprise Edition - Version 11.2.0.4 and laterInformation in this document applies to any platform.
Symptoms
- SQL Text is showing ?????????????????????????????? in AWR Reports:
SQL ordered by Elapsed TimeElapsed Time (s) Executions Elapsed Time per Exec (s) %Total %CPU %IO SQL Id SQL Module SQL Text
202.58 4,143,442 0.00 0.71 25.93 0.00 3816shzkg26s7 ??????????????????????????????...
SQL> select a.sql_id, a.sql_text from DBA_HIST_SQLTEXT a where a.sql_id in ('3816shzkg26s7','fztpf8fvmc0k6','5jar9cbrk8x1h');
SQL_ID
-------------
SQL_TEXT
--------------------------------------------------------------------------------
5jar9cbrk8x1h
????????????????????????????????????????????????????????????????????????????????
?????????????????????????????????????????????????????????????3816shzkg26s7
?????????????????????????????????????????????????????????????????????????fztpf8fvmc0k6
???????????????????????????
Changes
None
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! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |