CLEAR_PROFILING
Clears from memory data for the specified profiling type.
Clears from memory data for the specified profiling type.
Note
OpenText™ Analytics Database stores profiled data in memory, so profiling can be memory intensive depending on how much data you collect.This is a meta-function. You must call meta-functions in a top-level SELECT statement.
Behavior type
VolatileSyntax
CLEAR_PROFILING( 'profiling-type' [, 'scope'] )
Parameters
profiling-type- The type of profiling data to clear:
-
session: Clear profiling for basic session parameters and lock time out data. -
query: Clear profiling for general information about queries that ran, such as the query strings used and the duration of queries. -
ee: Clear profiling for information about the execution run of each query.
-
scope- Specifies at what scope to clear profiling on the specified data, one of the following:
-
local: Clear profiling data for the current session. -
global: Clear profiling data across all database sessions.
-
Examples
The following statement clears profiled data for queries:
=> SELECT CLEAR_PROFILING('query');