Submit a ticketCall us

WebinarUpcoming Webinar: Know What’s Changed – with NEW Server Configuration Monitor

Change management in IT is critical. But, even with a good change management process, changes are too often not correctly tracked, if at all. The configuration of your servers and applications is a key factor in their performance, availability, and security. Many incidents can be tracked back to an authorized (and sometimes unauthorized) configuration change, whether to a system file, configuration file, or Windows® Registry entry. Join SolarWinds VP of product management Brandon Shopp to discover how the new SolarWinds® Server Configuration Monitor is designed to help you.

Register now.

Home > Success Center > Database Performance Analyzer (DPA) > DPA - Knowledgebase Articles > Script to create the X$ views for monitoring Oracle Amazon RDS

Script to create the X$ views for monitoring Oracle Amazon RDS

Table of contents
No headers
Created by Interspire Import, last modified by MindTouch on Jun 23, 2016

Views: 1,082 Votes: 0 Revisions: 9

This article applies to: DPA 9.0, Ignite 8.x

As part of monitoring an Oracle Amazon RDS instance, these are the X$ views that DPA requires to be created in the instance owner's schema. This article is linked from the instructions KB provided here: http://support.confio.com/kb/1679/

CREATE OR REPLACE VIEW x$ksuse AS SELECT
   machine ksusemnm,osuser ksuseunm,username ksuudlna,program ksusepnm,sql_hash_value ksusesqh,
   sid indx,serial# ksuseser,wait_time ksusetim,event# ksuseopc,p1 ksusep1,p2 ksusep2,p3 ksusep3,
   blocking_session ksuseblocker,module ksuseapp,0 ksusesph,sql_child_number ksusesch,0 ksuseqcsid,
   row_wait_obj# ksuseobj,1 ksspaflg,1 ksuseflg,action ksuseact,5 ksuseidl
FROM v$session
WHERE status='ACTIVE';

CREATE OR REPLACE VIEW &Ignite_Username..x$kglcursor AS SELECT
   hash_value kglnahsh,child_number kglobt09,sorts kglobt01,executions kglhdexc,
   parse_calls kglobt12,disk_reads kglobt13,buffer_gets kglobt14,rows_processed kglobt15,
   sql_id kglobt03,(select instance_number from v$instance) inst_id,child_address kglhdadr,
   address kglhdpar,command_type kglobt02
FROM v$sql;

CREATE OR REPLACE VIEW x$kglna1 AS SELECT
   (select instance_number from v$instance) inst_id,address kglhdadr,hash_value kglnahsh,
   sql_id kglnasqlid,command_type kgloboct,piece piece,sql_text name
FROM v$sqltext;

Last modified

Tags

Classifications

Public