Return-Path: X-Original-To: oracle-l@orafaq.com Delivered-To: oracle-l@orafaq.com Received: from puck1183.startdedicated.com (localhost [127.0.0.1]) by puck1183.startdedicated.com (Postfix) with ESMTP id 21D5A1961498 for ; Thu, 2 Feb 2017 23:08:15 +0100 (CET) Received: from turing.freelists.org (turing.freelists.org [206.53.239.180]) by puck1183.startdedicated.com (Postfix) with ESMTPS for ; Thu, 2 Feb 2017 23:08:15 +0100 (CET) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id B18C06C5C1; Thu, 2 Feb 2017 17:08:13 -0500 (EST) X-Virus-Scanned: Debian amavisd-new at turing.freelists.org Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id zFlqSeV2dO6A; Thu, 2 Feb 2017 17:08:13 -0500 (EST) Received: from turing.freelists.org (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 44FE16C4E8; Thu, 2 Feb 2017 17:08:01 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Thu, 02 Feb 2017 17:06:39 -0500 (EST) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 75C6A6BFBE for ; Thu, 2 Feb 2017 17:06:39 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id NAEk9jlo2o-F for ; Thu, 2 Feb 2017 17:06:39 -0500 (EST) Received: from BLU004-OMC1S17.hotmail.com (blu004-omc1s17.hotmail.com [65.55.116.28]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-SHA384 (256/256 bits)) (No client certificate requested) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTPS id 0EB466BF29 for ; Thu, 2 Feb 2017 17:06:38 -0500 (EST) Received: from NAM02-SN1-obe.outbound.protection.outlook.com ([65.55.116.9]) by BLU004-OMC1S17.hotmail.com over TLS secured channel with Microsoft SMTPSVC(7.5.7601.23008); Thu, 2 Feb 2017 14:06:38 -0800 Received: from SN1NAM02FT013.eop-nam02.prod.protection.outlook.com (10.152.72.56) by SN1NAM02HT181.eop-nam02.prod.protection.outlook.com (10.152.73.141) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_CBC_SHA384_P384) id 15.1.874.2; Thu, 2 Feb 2017 22:06:35 +0000 Received: from MWHPR10MB1680.namprd10.prod.outlook.com (10.152.72.54) by SN1NAM02FT013.mail.protection.outlook.com (10.152.72.98) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_CBC_SHA384_P384) id 15.1.874.2 via Frontend Transport; Thu, 2 Feb 2017 22:06:35 +0000 Received: from MWHPR10MB1680.namprd10.prod.outlook.com ([10.172.52.22]) by MWHPR10MB1680.namprd10.prod.outlook.com ([10.172.52.22]) with mapi id 15.01.0860.027; Thu, 2 Feb 2017 22:06:34 +0000 From: Upendra nerilla To: Oracle-L Freelists , "dmarc-noreply@freelists.org" Subject: Re: CPU and Memory Monitoring Thread-Topic: CPU and Memory Monitoring Date: Thu, 2 Feb 2017 22:06:34 +0000 Message-ID: References: <562905937.3317891.1486072130231.ref@mail.yahoo.com>,<562905937.3317891.1486072130231@mail.yahoo.com> In-Reply-To: <562905937.3317891.1486072130231@mail.yahoo.com> Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: authentication-results: freelists.org; dkim=none (message not signed) header.d=none;freelists.org; dmarc=none action=none header.from=hotmail.com; x-incomingtopheadermarker: OriginalChecksum:EC80182F95DF07AAEB5EE04BFC2E8F68FF0F2642BFD61F92D35381215E1E6102;UpperCasedChecksum:B3CECB4BDA6D4204E06714B6B84E4BB1E080464F8FB81AD0C8B7E3E01565282C;SizeAsReceived:7806;Count:39 x-ms-exchange-messagesentrepresentingtype: 1 x-tmn: [Z42I9lgiLPmgg/2e5Ntq37/V8GcUuP26] x-incomingheadercount: 39 x-eopattributedmessage: 0 x-microsoft-exchange-diagnostics: 1;SN1NAM02HT181;5:11P23LMdp7i08GWrc+9lzTrvI2Lgagub+WV5aXEEShpTL7+Cv+9mS1TP7tWDVPqfgeL5Ysz5RGAw4/CwhjzbRI8Kld7sofcfaifPvF8kC2/Lwo2Vk5g8omKRi4E0Ht/dHZLwKOjBeJbMUX7Uhl9AQ7EaYdf4XgVMJ8DQQ9C9Bi0=;24:S3zh68DyGOGLpnF10Vfmq0PSB/iB13dINPpWzUfa/zPg9qHIfMnFbbioShbaaNg5DTuIBc13cgZEeATd9fefqc+F0CBK2nlT4JG+30z36Jw=;7:ZTXkfmo+evEQHEDRA5WcoZn/K7zHlzKojtsTiEnDA3hdRWt1dBKzxRvxdYIxnGCPm5NB0OVIwhFGszRyEcNkyD7GcxebhQW+eS7WQCLdzw+kWUKz98YWrrj9sTeJJQzOnT7r92UAFVqSC+tZdEwX2bDYjqF8vvPBThSmckK5ICvwkNhrpqLp+cFcuxSkDEueyi+GZuK6gSmTkxVGhL6G2cb0TLPqhWiehpe3jopxnJkzyKyZ1eR099Rp0Pmnwe7uDTa0Q1Qm3zFqmwY8O6xvAqDPu4esyKAzBro6Dknzv4Fgr0vJm8xUsR3X0Z/Z02wJXUbnn+TU/turz4cyTprimoTaDCSd2JIq/1RJelXwW7pJrau8u6zPPPeJnNQMgRGS8qNCVIfr2yteEa/wlHQwacfvf1q9TCX/ldIm7JwCH3gMNfnyHbh4FbFAyK1vnxSnHSigkdvNzm//LbYeEwj/Z8Q24AhmDiZNA8fB4pE7ohu8d1bDGbNVgIx8ktAbXpGS4SY/l8bliScatvqgK+zhkg== x-forefront-antispam-report: EFV:NLI;SFV:NSPM;SFS:(10019020)(98900005);DIR:OUT;SFP:1102;SCL:1;SRVR:SN1NAM02HT181;H:MWHPR10MB1680.namprd10.prod.outlook.com;FPR:;SPF:None;LANG:en; x-ms-office365-filtering-correlation-id: 9cf6a965-63ac-45b9-8f43-08d44bb7c097 x-microsoft-antispam: UriScan:;BCL:0;PCL:0;RULEID:(22001)(1601124038)(5061506425)(5061507331)(1603103135)(1603101367)(1601125103)(1701031045);SRVR:SN1NAM02HT181; x-exchange-antispam-report-cfa-test: BCL:0;PCL:0;RULEID:(444111334)(432015059)(82015046);SRVR:SN1NAM02HT181;BCL:0;PCL:0;RULEID:;SRVR:SN1NAM02HT181; x-forefront-prvs: 02065A9E77 spamdiagnosticoutput: 1:99 spamdiagnosticmetadata: NSPM Content-Type: multipart/alternative; boundary="_000_MWHPR10MB1680AD2213BE9ACCF876E8B3D84C0MWHPR10MB1680namp_" MIME-Version: 1.0 X-OriginatorOrg: hotmail.com X-MS-Exchange-CrossTenant-originalarrivaltime: 02 Feb 2017 22:06:34.5216 (UTC) X-MS-Exchange-CrossTenant-fromentityheader: Internet X-MS-Exchange-CrossTenant-id: 84df9e7f-e9f6-40af-b435-aaaaaaaaaaaa X-MS-Exchange-Transport-CrossTenantHeadersStamped: SN1NAM02HT181 X-OriginalArrivalTime: 02 Feb 2017 22:06:38.0269 (UTC) FILETIME=[A02CB6D0:01D27DA0] X-archive-position: 67573 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: nupendra@hotmail.com Precedence: normal Reply-To: nupendra@hotmail.com List-help: List-unsubscribe: List-software: Ecartis version 1.0.0 List-Id: oracle-l X-List-ID: oracle-l List-subscribe: List-owner: List-post: List-archive: X-list: oracle-l --_000_MWHPR10MB1680AD2213BE9ACCF876E8B3D84C0MWHPR10MB1680namp_ Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable If you have Oracle Enterprise Manager installed in the environment, you cou= ld gather the metrics and store in the OEM repository that you can view/que= ry off of. OEM could be configured without having to share the OS credentials to you a= nd/or provide you with limited access. ________________________________ From: oracle-l-bounce@freelists.org on beha= lf of Sanjay Mishra 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 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 Report Information about CPU Activity 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 usi= ng 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 --_000_MWHPR10MB1680AD2213BE9ACCF876E8B3D84C0MWHPR10MB1680namp_ Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

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 yo= u and/or provide you with limited access.


From: oracle-l-bounce@free= lists.org <oracle-l-bounce@freelists.org> on behalf of Sanjay Mishra = <dmarc-noreply@freelists.org>
Sent: Thursday, February 2, 2017 4:48 PM
To: Oracle-L Freelists
Subject: CPU and Memory Monitoring
 
Does anyone ha= s setup to collect Database Server CPU and memory utilization from database= when you are missing the access to the database server ?  I want to c= ollect Oracle Memory and CPU utilization every 15min to 30 min and record in table for analysis. 

I know OSwatch= er can take care of it all but there is no access to this critical producti= on environment where our company is on supporting application and want to m= ake sure system resources as well as application utilization is good. We only have Database user to access usin= g SQl or client tool but has permission to access any Database views.

I saw one of t= he very good article for the same to measure CPU from C. Antognini at  = ;Report Information about CPU Activity in SQL*Plus – Striving for Optimal Pe= rformance and it work very fine to get CPU details. as long as I h= ad permission to create the objects but I had only access granted using Rol= e 

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

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