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

[Message index]

		Is there a need to install os monitoring tools since gv$osstat already has the os statistics By: juniordbanewbie on Wed, 17 October 2018 02:09
		Re: Is there a need to install os monitoring tools since gv$osstat already has the os statistics By: John Watson on Wed, 17 October 2018 02:14
		Re: Is there a need to install os monitoring tools since gv$osstat already has the os statistics By: juniordbanewbie on Wed, 17 October 2018 02:43

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: Tue Apr 23 17:59:55 CDT 2024