15.10 - SetSessionRate - Teradata Database

Teradata Database Application Programming Reference

prodname
Teradata Database
vrm_release
15.10
category
Programming Reference
featnum
B035-1090-151K

Sets the global rates for updating session-level statistics in memory.

REPLACE FUNCTION SetSessionRate
  (SampleRate  INTEGER
  )
RETURNS INTEGER
          .
          .
          .
;
 

Parameter

Description

SampleRate

Sets the global rate. The value ranges from 1 to 3600 seconds. If the rate is set to zero an error is reported.

Note: The collection rate applies to global queries.

There is no option equivalent to the PMPC SET SESSION RATE request
Local_Change = Y option because when using the SetSessionRate function, there is no local MONITOR PARTITION in which to apply the rate to.

You can set the SetSessionRate function to a global (SesMonitorSys) rate. That is, a collection rate at which session-level statistics are collected in memory. This rate is returned in the SesMonitorSys data value by the MonitorVirtualSummary function.

The SetSessionRate function provides similar functionality to the PMPC SET SESSION RATE request. For information about this interface, see “SET SESSION RATE” on page 214.

This function returns the previous collection rate value in seconds.

SELECT SetSessionRate(600);
 
 *** Query completed. One row found. One column returned.
 *** Total elapsed time was 1 second.
 
SetSessionRate(600)
-----------------------
                     60