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)
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 Go to next message
juniordbanewbie
Messages: 239
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!
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 Go to previous messageGo to next message
John Watson
Messages: 8075
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?
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 Go to previous message
juniordbanewbie
Messages: 239
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!
Previous Topic: No more data to read from socket
Next Topic: scripts of Oracle SQL Performance Tuning and Optimization
Goto Forum:
  


Current Time: Sun Dec 08 18:12:54 CST 2019