Submit a ticketCall us

AnnouncementsChange Is Inevitable

Get valuable help when it comes to tracking and monitoring changes. SolarWinds® Server Configuration Monitor (SCM) is designed to help you: detect, track, and receive alerts when changes occur, correlate system performance against configuration changes, compare server and application configuration against custom baselines, and verify application and system changes.

Learn more.

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,110 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