Re: SQL_FULLTEXT

Do you need the SQL full text for a single known SQL_ID? Youl could just query V$SQL.SQL_FULLTEXT WHERE rownum = 1.

Note that page 20 of the 10gR2 era "Understanding Shared Pool Memory Structures" whitepaper mentions improvements to V$OPEN_CURSOR and V$SQLAREA.

https://www.oracle.com/technetwork/database/manageability/ps-s003-274003-106-1-fin-v2-128827.pdf

--
Tanel Poder
https://learn.tanelpoder.com


On Fri, May 12, 2023 at 3:43 AM Nenad Noveljic <nenad.noveljic_at_gmail.com>
wrote:



> 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-l