[cisco-voip] UCCX Enterprise database queries

[Teixeira, Mike]

Hello,

UCCX version: 7.0.1 SR5.

Enterprise Database Configuration:

ODBC, obviously :)
RetryConnectInterval: 15000
NumAttempt: 5
LoginTimeout: 0
SQLState: |HY000|

Issue:

I have Enterprise database connections setup to go to Oracle, SQL2000, and SQL2005 databases that are used in my IVR scripts. I am noticing that the slave node is running the following select statement against my oracle server. Against my SQL servers it is running a remote procedure call. This is happening every couple of seconds. My end goal is to reduce the load on the oracle server. This is my 4th highest sql statement in a 6 hour sample of awrrpt.sql.

SELECT /*+ RULE */ DISTINCT '', OWNER, '', '', '' FROM ALL_OBJECTS WHERE OWNER != 'PUBLIC' AND (OBJECT_TYPE='TABLE' OR OBJECT_TYPE='VIEW') ORDER BY OWNER

My first thought this was a keep alive for UCCX and the enterprise database configuration. Any thoughts on this and how to reduce the frequency it will  run this SQL statement?

Thanks,
Mike

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20110927/18a99867/attachment.html>