Attachment 851074 Details for Bug 1054224 – stats with bug reproduced

stats with bug reproduced

01007809bug.stats.log (text/x-log), 1.44 KB, created by Matthew Robson on 2014-01-16 13:38:25 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Matthew Robson

Created: 2014-01-16 13:38:25 UTC

Size: 1.44 KB

patch

obsolete

>[standalone@localhost:9999 /] /subsystem=datasources/data-source=testpool/statistics=pool:read-resource(include-runtime=true)
>{
>    "outcome" => "success",
>    "result" => {
>        "ActiveCount" => "15",
>        "AvailableCount" => "0",
>        "AverageBlockingTime" => "0",
>        "AverageCreationTime" => "351",
>        "CreatedCount" => "15",
>        "DestroyedCount" => "0",
>        "InUseCount" => "15",
>        "MaxCreationTime" => "4727",
>        "MaxUsedCount" => "15",
>        "MaxWaitCount" => "0",
>        "MaxWaitTime" => "0",
>        "TimedOut" => "0",
>        "TotalBlockingTime" => "0",
>        "TotalCreationTime" => "5277"
>    }
>}
>
>After Disable:
>[root@mrobson ~]# netstat -anp | grep 1521 | grep '28733'
>tcp        0      0 127.0.0.1:53727             127.0.0.1:1521              ESTABLISHED 28733/java          
>tcp        0      0 127.0.0.1:53729             127.0.0.1:1521              ESTABLISHED 28733/java          
>tcp        0      0 127.0.0.1:53726             127.0.0.1:1521              ESTABLISHED 28733/java          
>tcp        0      0 127.0.0.1:53725             127.0.0.1:1521              ESTABLISHED 28733/java          
>tcp        0      0 127.0.0.1:53728             127.0.0.1:1521              ESTABLISHED 28733/java
>
>SQL> select sid,username from v$session where username='SYSTEM';
>
>       SID USERNAME
>---------- ------------------------------
>	10 SYSTEM
>	13 SYSTEM
>	53 SYSTEM
>	92 SYSTEM
>	98 SYSTEM
>       142 SYSTEM
>
>6 rows selected.

Actions: View

Attachments on bug 1054224: 851073 | 851074 | 851075