DX Unified Infrastructure Management

Hi,

I use oracle probe to monitor my customer oracle DB. My customer told me that he found the running query in their oracle DB like this:

SELECT  a.serial# as serial, a.sid, a.username, b.type, b.ctime, lmode, a.osuser, c.sql_text 

FROM v$session a, v$lock b, v$sqlarea c 

WHERE b.type in ('TM', 'TX', 'UL') 

and a.sid=b.sid and lmode > 0 

and ((a.PREV_HASH_VALUE = c.hash_value 

and a.prev_sql_addr = c.address 

and a.sql_hash_value = 0) 

or (c.hash_value=a.sql_hash_value 

and c.address = a.sql_address));

Does this query is generated by Oracle probe? If yes, what Oracle information are gathered from this query?

Thank you

Rio

Rio -

That is the query that the oracle probe will make for the user_locks checkpoint.

For a full list of the queries the oracle probe makes for each checkpoint you can check out the following Knowledge Document:

 KB000034630 : Oracle Checkpoint Queries

Hi Kathryn,

Thank you for the answer.

Another question, can we customize this query? If yes, how to customize it and is there any limitation for the customization.

Regards

Rio

Hi Rio,

You cannot change the out of the box oracle checkpoint query but you can create a new custom oracle checkpoint.

Here are some helpful links:

https://docops.ca.com/ca-unified-infrastructure-management-probes/ga/en/alphabetical-probe-articles/oracle-oracle-database-monitoring/oracle-ac-configuration#oracleACConfiguration-(Optional)CreateCustomCheckpoints 

https://comm.support.ca.com/kb/oracle-custom-checkpoint-not-working-generating-qos/kb000131000

Steve