Re: CPU and Memory Monitoring

Thanks Carlos. Look like this will provide lots of details. Let me download and work as how to use it. RgdsSanjay

    On Thursday, February 2, 2017 8:20 PM, Carlos Sierra <carlos.sierra.usa_at_gmail.com> wrote:  

 Sanjay
You may want to try eDB360 for a good view of an Oracle database. It is free. You execute it from SQL*Plus. It installs nothing on your database. And it gives you OS stats charts, memory, CPU and a lot more.  Cheers. 

Sent from my iPhone
On Feb 2, 2017, at 3:29 PM, Ram Cheruvattath <ram.cheruvattath_at_gmail.com> wrote:

#yiv1416968175 #yiv1416968175 -- _filtered #yiv1416968175 {font-family:Helvetica;panose-1:2 11 6 4 2 2 2 2 2 4;} _filtered #yiv1416968175 {font-family:Tahoma;panose-1:2 11 6 4 3 5 4 4 2 4;}#yiv1416968175 #yiv1416968175 p.yiv1416968175MsoNormal, #yiv1416968175 li.yiv1416968175MsoNormal, #yiv1416968175 div.yiv1416968175MsoNormal {margin:0in;margin-bottom:.0001pt;font-size:12.0pt;}#yiv1416968175 a:link, #yiv1416968175 span.yiv1416968175MsoHyperlink {color:blue;text-decoration:underline;}#yiv1416968175 a:visited, #yiv1416968175 span.yiv1416968175MsoHyperlinkFollowed {color:blue;text-decoration:underline;}#yiv1416968175 span.yiv1416968175EmailStyle17 {font-family:Arial;color:navy;} _filtered #yiv1416968175 {margin:1.0in 1.25in 1.0in 1.25in;}#yiv1416968175 div.yiv1416968175Section1 {}#yiv1416968175 V$OSSTAT may provide what you are lookingfor.  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, 20174:49 PM To: Oracle-L Freelists
Subject: CPU and Memory Monitoring   Doesanyone has setup to collect Database Server CPU and memory utilization fromdatabase when you are missing the access to the database server ?  I wantto collect Oracle Memory and CPU utilization every 15min to 30 min and recordin table for analysis.    Iknow OSwatcher can take care of it all but there is no access to this criticalproduction environment where our company is on supporting application and wantto make sure system resources as well as application utilization is good. Weonly have Database user to access using SQl or client tool but has permissionto access any Database views.   Isaw one of the very good article for the same to measure CPU from C. Antogniniat  Report Information about CPU Activityin SQL*Plus – Striving for Optimal Performance and it work veryfine to get CPU details. as long as I had permission to create the objects butI had only access granted using Role    Soif someone has other details to get the same for Memory and other direct queryto run as plSQL script or sharing any more information.   TIA   Sanjay      

--
http://www.freelists.org/webpage/oracle-l