Extended agent for Oracle does not collect data for SQL text attribute group.
Resolving the problem
By default the agent will not get all SQL records from this view; this is to avoid time-out, because the query returns a very high number of records. This attribute group requires two variables DBID and Address for following SQL to be executed:
select inst_id dbid,
So if user creates a new workspace and assign with the default query of RDB_SQLTEXT without the filter info including both DBID and Address, then there is no data returned by agent due to lack of binding variables. The historical collection without the filter info will have no data too.
This attribute group is designed to show up the current SQL text for one active session instead of the overall SQL TEXT list.
|Systems and Asset Management||Tivoli Composite Application Manager for Applications||ITCAM Extended Agent for Oracle Database 5724V09OR v6.3|