SQL_FULLTEXT
From: Nenad Noveljic <nenad.noveljic_at_gmail.com>
Date: Fri, 12 May 2023 09:42:03 +0200
Message-ID: <CAESzRbmP53EYt7eSGTndpDFFsD_nFURNW5zv0z4WccvjcTnH4g_at_mail.gmail.com>
What's the least disruptive view to query to obtain the full SQL text?
Date: Fri, 12 May 2023 09:42:03 +0200
Message-ID: <CAESzRbmP53EYt7eSGTndpDFFsD_nFURNW5zv0z4WccvjcTnH4g_at_mail.gmail.com>
What's the least disruptive view to query to obtain the full SQL text?
It should be V$SQLSTATS, but unfortunately V$SQLSTATS.SQL_FULLTEXT doesn't contain the full text. The support note "V$SQLSTATS.SQL_FULLTEXT does not show full of sql statements (Doc ID 2398100.1)" advises querying V$SQLAREA instead of V$SQLSTATS.
Best regards,
Nenad
-- http://www.freelists.org/webpage/oracle-lReceived on Fri May 12 2023 - 09:42:03 CEST