Adjusting the Oracle SQL PI sampling query frequency (4380526)

An Oracle agent's SQL PI sampling query runs too often. How can this be adjusted to run less often?

The SQL query begins with

SELECT
    SES.sid,
    CASE WHEN px.qcinst_id IS NULL THEN TO_CHAR(ses.sid) ELSE TO_CHAR(px.qcsid) END AS parent_session_sid,
    SES.serial#,
    SES.process,
    SES.username,

By default the Oracle sampling query runs once a second (1000 ms).

From the Global View Databases Dashboard,

1. Select the Oracle agent(s) to be adjusted that has SQL PI enabled and click Settings then Administration

   

2. Choose the SQL Performance Investigator Administration panel

   

3. Click the checkbox next to the agent 

   

4. Click the Settings button

   

5. Adjust the "SQL PI sampling frequency (milliseconds): " value higher (the minimum is 1000 ms)

   

6. Click the Set button