RE: CPU and Memory Monitoring
Date: Thu, 2 Feb 2017 18:29:25 -0500
Message-ID: <0B1FC56F0BC344449B08F62866E2ACBD_at_RAMPC>
V$OSSTAT may provide what you are looking for. There is also historical information captured in DBA_HIST_OSSTAT.
Thanks
Ramsankar Cheruvattath (Ram)
407-209-6276
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]
On Behalf Of Sanjay Mishra (Redacted sender "smishra_97" for DMARC)
Sent: Thursday, February 02, 2017 4:49 PM
To: Oracle-L Freelists
Does anyone has setup to collect Database Server CPU and memory utilization
from database when you are missing the access to the database server ? I
want to collect Oracle Memory and CPU utilization every 15min to 30 min and
record in table for analysis.
I know OSwatcher can take care of it all but there is no access to this
critical production environment where our company is on supporting
application and want to make sure system resources as well as application
utilization is good. We only have Database user to access using SQl or
client tool but has permission to access any Database views.
I saw one of the very good article for the same to measure CPU from C.
Antognini at Report Information about CPU Activity
<https://antognini.ch/2009/05/report-information-about-cpu-activity-in-sqlpl
us/> in SQL*Plus - Striving for Optimal Performance and it work very fine
to get CPU details. as long as I had permission to create the objects but I
had only access granted using Role
So if someone has other details to get the same for Memory and other direct
query to run as plSQL script or sharing any more information.
TIA
Sanjay
Subject: CPU and Memory Monitoring
--
http://www.freelists.org/webpage/oracle-l
Received on Fri Feb 03 2017 - 00:29:25 CET