0 Replies Latest reply on Aug 17, 2011 6:34 AM by billhong

    How to view/retrieve the value of runtime attributes for specific connection pool?

    billhong

      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!