I tried to use command line client to manage oracle database connection pool in AS7. However, all the runtime attributes were displayed as “undefined”. I tried to use management API to retrieve attributes and the value is undefined as well. Is there a way to view those values at runtime?
The result in my environment is:
[standalone@localhost:9999 data-source=myOracleDS] :read-resource(include-runtime=true)
{
"outcome" => "success",
"result" => {
"ActiveCount" => undefined,
"AvailableCount" => undefined,
"AverageBlockingTime" => undefined,
"AverageCreationTime" => undefined,
"CreatedCount" => undefined,
"DestroyedCount" => undefined,
"MaxCreationTime" => undefined,
"MaxUsedCount" => undefined,
"MaxWaitCount" => undefined,
"MaxWaitTime" => undefined,
"PreparedStatementCacheAccessCount" => undefined,
"PreparedStatementCacheAddCount" => undefined,
"PreparedStatementCacheCurrentSize" => undefined,
"PreparedStatementCacheDeleteCount" => undefined,
"PreparedStatementCacheHitCount" => undefined,
"PreparedStatementCacheMissCount" => undefined,
"TimedOut" => undefined,
"TotalBlockingTime" => undefined,
"TotalCreationTime" => undefined,
...
}
}
Can someone give me helps please. Thanks in advance!