Re: CPU and Memory Monitoring
Date: Thu, 2 Feb 2017 23:32:23 +0000
Message-ID: <9C4B03DD-340F-4492-B9FC-10B1A31B0898_at_mufalani.com.br>
Hi,
Take a look on v$sysmetric view, there is a lot of useful metric there.
[ ]'s
#mufalani
Desculpe por erros! Este e-mail foi escrito do meu smartphone!
Sorry for typos! This mail was written from my smartphone!!!
Em 2 de fev de 2017, ?s 20:14, Sanjay Mishra <dmarc-noreply_at_freelists.org<mailto:dmarc-noreply_at_freelists.org>> escreveu:
Thanks Upendra for the update. Unfortunately what we have been given is client access using SQL/Developer/Toad kind of access to check information about App log tables and other system data. Don;t have access to OEM as then will be able to even generate all graphs too from available repository.
Tx
Sanjay
On Thursday, February 2, 2017 5:07 PM, Upendra nerilla <nupendra_at_hotmail.com<mailto:nupendra_at_hotmail.com>> wrote:
If you have Oracle Enterprise Manager installed in the environment, you could gather the metrics and store in the OEM repository that you can view/query off of.
OEM could be configured without having to share the OS credentials to you and/or provide you with limited access.
From: oracle-l-bounce_at_freelists.org<mailto:oracle-l-bounce_at_freelists.org> <oracle-l-bounce_at_freelists.org<mailto:oracle-l-bounce_at_freelists.org>> on behalf of Sanjay Mishra <dmarc-noreply_at_freelists.org<mailto:dmarc-noreply_at_freelists.org>> Sent: Thursday, February 2, 2017 4:48 PM To: Oracle-L Freelists
Subject: CPU and Memory Monitoring
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 in SQL*Plus - Striving for Optimal Performance<https://antognini.ch/2009/05/report-information-about-cpu-activity-in-sqlplus/> 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
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Feb 03 2017 - 00:32:23 CET