OraFAQ Forum: Performance Tuning » Is there a need to install os monitoring tools since gv$osstat already has the os statistics

Home » RDBMS Server » Performance Tuning » Is there a need to install os monitoring tools since gv$osstat already has the os statistics (12.2.0.1 Windows 2016)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Is there a need to install os monitoring tools since gv$osstat already has the os statistics [message #672508]

Wed, 17 October 2018 02:09

juniordbanewbie
Messages: 250
Registered: April 2014

Senior Member

Dear all,

Quote:

V$OSSTAT displays system utilization statistics from the operating system. One row is returned for each system statistic.

SELECT stat_name, value, cumulative FROM v$osstat ORDER BY stat_name;

STAT_NAME                                                             VALUE CUM
---------------------------------------------------------------- ---------- ---
AVG_BUSY_TIME                                                        697019 NO
AVG_IDLE_TIME                                                     182355398 NO
AVG_SYS_TIME                                                         343787 NO
AVG_USER_TIME                                                        292501 NO
BUSY_TIME                                                           3460280 YES
FREE_MEMORY_BYTES                                                1087365120 NO
IDLE_TIME                                                         730241824 YES
NUM_CPUS                                                                  4 NO
NUM_CPU_CORES                                                             4 NO
NUM_CPU_SOCKETS                                                           2 NO
PHYSICAL_MEMORY_BYTES                                            4294361088 NO
RSRC_MGR_CPU_WAIT_TIME                                                   88 YES
SYS_TIME                                                            1941453 YES
USER_TIME                                                           1563739 YES

https://docs.oracle.com/en/database/oracle/oracle-database/12.2/refrn/V-OSSTAT.html#GUID-E1E48692-47FA-4AE3-9402-82477E66FFC0

I was wondering why trace file analyzer include OS watcher in unix platform but not in windows platform. so I was wondering if we really need to have an additional tools to monitor CPU, Memory and Disk IO

Thanks a lot!

Report message to a moderator

Re: Is there a need to install os monitoring tools since gv$osstat already has the os statistics [message #672509 is a reply to message #672508]

Wed, 17 October 2018 02:14

John Watson
Messages: 8804
Registered: January 2010
Location: Global Village

Senior Member

There is no oswatcher for Windows because Windows doesn't have the utilities it uses: vmstat, iostat, netstat, probably a few others. As for whether you need those tools, well, the information shown in v$osstat is pretty limited, isn't it?

Report message to a moderator

Re: Is there a need to install os monitoring tools since gv$osstat already has the os statistics [message #672511 is a reply to message #672509]

Wed, 17 October 2018 02:43

juniordbanewbie
Messages: 250
Registered: April 2014

Senior Member

Dear John,

from https://docs.oracle.com/cd/E11882_01/win.112/e10845/monitor.htm#NTQRF234

Quote:

Using Oracle Counters for Windows Performance Monitor

in the 11.2.0.4 we have oracle counters for windows performance monitor, but the feature is no longer available in 12.2.0.1

I was wondering what are the counters that I should add or is there a official or mos documentation that have the list of counters that we should monitor?

of course some counters are pretty obvious that we should add like

logical disk
%disk read time
%disk time
%disk write time

thanks!

Report message to a moderator

Previous Topic:	No more data to read from socket
Next Topic:	scripts of Oracle SQL Performance Tuning and Optimization

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Mar 23 23:16:46 CDT 2023