Date: Thu, 2 Feb 2017 21:48:50 +0000 (UTC)
From: "Sanjay Mishra" <dmarc-noreply@freelists.org> (Redacted sender
 "smishra_97" for DMARC)
To: Oracle-L Freelists <oracle-l@freelists.org>
Message-ID: <562905937.3317891.1486072130231@mail.yahoo.com>
Subject: CPU and Memory Monitoring
MIME-Version: 1.0
Content-Type: multipart/alternative; 
 boundary="----=_Part_3317890_52576521.1486072130228"
References: <562905937.3317891.1486072130231.ref@mail.yahoo.com>
Sender: oracle-l-bounce@freelists.org
Errors-to: oracle-l-bounce@freelists.org
Precedence: normal
Reply-To: dmarc-noreply@freelists.org
------=_Part_3317890_52576521.1486072130228
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

Does anyone has setup to collect Database Server CPU and memory utilization=
 from database when you are missing the access to the database server ? =C2=
=A0I want to collect Oracle Memory and CPU utilization every 15min to 30 mi=
n and record in table for analysis.=C2=A0
I know OSwatcher can take care of it all but there is no access to this cri=
tical 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. Anto=
gnini at =C2=A0Report Information about CPU Activity in SQL*Plus =E2=80=93 =
Striving for Optimal Performance=C2=A0and it work very fine to get CPU deta=
ils. as long as I had permission to create the objects but I had only acces=
s granted using Role=C2=A0
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

------=_Part_3317890_52576521.1486072130228
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

<html xmlns=3D"http://www.w3.org/1999/xhtml" xmlns:v=3D"urn:schemas-microso=
ft-com:vml" xmlns:o=3D"urn:schemas-microsoft-com:office:office"><head><!--[=
if gte mso 9]><xml><o:OfficeDocumentSettings><o:AllowPNG/><o:PixelsPerInch>=
96</o:PixelsPerInch></o:OfficeDocumentSettings></xml><![endif]--></head><bo=
dy><div style=3D"color:#000; background-color:#fff; font-family:HelveticaNe=
ue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;font-size:1=
2px"><div dir=3D"ltr" id=3D"yui_3_16_0_ym19_1_1486071440502_4428">Does anyo=
ne has setup to collect Database Server CPU and memory utilization from dat=
abase when you are missing the access to the database server ? &nbsp;I want=
 to collect Oracle Memory and CPU utilization every 15min to 30 min and rec=
ord in table for analysis.&nbsp;</div><div dir=3D"ltr" id=3D"yui_3_16_0_ym1=
9_1_1486071440502_4429"><br></div><div dir=3D"ltr" id=3D"yui_3_16_0_ym19_1_=
1486071440502_4430">I know OSwatcher can take care of it all but there is n=
o access to this critical production environment where our company is on su=
pporting application and want to make sure system resources as well as appl=
ication utilization is good. We only have Database user to access using SQl=
 or client tool but has permission to access any Database views.</div><div =
dir=3D"ltr" id=3D"yui_3_16_0_ym19_1_1486071440502_4431"><br></div><div dir=
=3D"ltr" id=3D"yui_3_16_0_ym19_1_1486071440502_4432">I saw one of the very =
good article for the same to measure CPU from C. Antognini at &nbsp;<a href=
=3D"https://antognini.ch/2009/05/report-information-about-cpu-activity-in-s=
qlplus/" class=3D"enhancr2_e727d794-43d4-8e35-b88a-68c6cc1d9fbd" id=3D"yui_=
3_16_0_ym19_1_1486071440502_4510">Report Information about CPU Activity in =
SQL*Plus =E2=80=93 Striving for Optimal Performance</a>&nbsp;and it work ve=
ry fine to get CPU details. as long as I had permission to create the objec=
ts but I had only access granted using Role&nbsp;</div><div dir=3D"ltr" id=
=3D"yui_3_16_0_ym19_1_1486071440502_4432"><br></div><div dir=3D"ltr" id=3D"=
yui_3_16_0_ym19_1_1486071440502_4432">So if someone has other details to ge=
t the same for Memory and other direct query to run as plSQL script or shar=
ing any more information.</div><div dir=3D"ltr" id=3D"yui_3_16_0_ym19_1_148=
6071440502_4432"><br></div><div dir=3D"ltr" id=3D"yui_3_16_0_ym19_1_1486071=
440502_4432">TIA</div><div dir=3D"ltr" id=3D"yui_3_16_0_ym19_1_148607144050=
2_4432"><br></div><div dir=3D"ltr" id=3D"yui_3_16_0_ym19_1_1486071440502_44=
32">Sanjay</div><div id=3D"yui_3_16_0_ym19_1_1486071440502_4521"><br></div>=
</div></body></html>
------=_Part_3317890_52576521.1486072130228--
--
http://www.freelists.org/webpage/oracle-l