show_cached_text

Displays the SQL text for cached statements longer than 16K.

Syntax

show_cached_text_long(statement_id)

Parameters

statement_id – is the ID of the statement. Derived from the SSQLID column of monCachedStatement.

Examples

Example 1 – This selects the SQL text from the monCachedStatement monitoring table (the result set has been shortened for easier readability):

select show_cached_text_long(SSQLID) as sql_text, StatementSize from monCachedStatement

sql_text                                                                                                              StatementSize
-----------------------------------------------------------------------------------------------------------------------
SELECT first_column ...... 
188888

Usage

show_cached_text_long displays up to 2M of SQL text.
show_cached_text_long returns a text datatype.
Using show_cached_text_long requires you to configure set textsize value at a large value. If you configure a value that is too small, SAP ASE clients (for example, isql) truncate the show_cached_text_long result set.

Permissions

The permission checks for show_cached_text_long differ based on your granular permissions settings.

Granular Permissions	Description
Enabled	With granular permissions enabled, you must be a user with mon_role, or have `monitor qp performance` permission to execute show_cached_text_long.
Disabled	With granular permissions disabled, you must be a user with mon_role or sa_role to execute show_cached_text_long.