How does Policy Server execute Polling to Oracle Database store ?

Products

• CA Single Sign On Secure Proxy Server (SiteMinder)
• CA Single Sign On SOA Security Manager (SiteMinder)
• CA Single Sign-On

Issue/Introduction

How does Policy Server execute Polling to Oracle Database store ?

Environment

Release:
Component: SMPLC

Resolution

Policy Server create query to Oracle Data store at 15 seconds interval.

 

*******************************************************************************

1525      93.924436           10.131.xxx.xxx       10.131.xxx.xxx     TNS       164        Request, Data (6), Data

 

0000   ac a0 16 0a 45 00 00 50 56 9b 18 1c 08 00 45 00  ....E..PV.....E.

0010   00 96 29 99 40 00 40 06 78 d7 0a 83 3f 4f 0a 83  ..)[email protected]@.x...?O..

0020   43 9d c0 d5 05 f1 49 fb ac 54 89 2f df 2f 80 18  C.....I..T././..

0030   01 f5 98 7a 00 00 01 01 08 0a 00 10 53 b6 42 86  ...z........S.B.

0040   1e 2c 00 62 00 00 06 00 00 00 00 00 03 5e 00 02  .,.b.........^..

0050   80 21 01 03 01 01 21 01 01 0d 00 00 00 00 04 7f  .!....!.........

0060   ff ff ff 00 00 00 00 00 00 00 00 00 00 00 01 00  ................

0070   00 00 00 00 73 65 6c 65 63 74 20 74 6f 5f 63 68  ....select to_ch

0080   61 72 28 73 79 73 64 61 74 65 29 20 66 72 6f 6d  ar(sysdate) from

0090   20 64 75 61 6c 01 01 00 00 00 00 00 00 01 01 00   dual...........

00a0   00 00 00 00                                      ....

 

*******************************************************************************

Additional Information

What is the purpose of update query for Policy Store ?

https://www.ca.com/us/services-support/ca-support/ca-support-online/knowledge-base-articles.TEC1470324.html