SQL> SELECT
2 name s_name
3 , ROUND(busy / (busy + idle) * 100, 2) s_busy
4 FROM v$shared_server
5 ORDER BY name;
S_NA S_BUSY
---- ----------
S000 100
S001 99.68
S002 99.89
S003 100
S004 99.92
S005 99.78
S006 99.97
S007 99.98
S008 99.96
S009 99.95
S010 99.86
S_NA S_BUSY
---- ----------
S011 99.84
S012 99.87
S013 99.8
S014 99.82
S015 99.93
S016 99.7
S017 99.98
S018 99.99
S019 99.98
20 rows selected.
Tidak ada komentar:
Posting Komentar