Submit a ticketCall us

Looking to compare latest NPM features with previous versions of NPM?
The NPM new feature summary offers a comparison of new features and improvements offered with this release.

 

Home > Success Center > Database Performance Analyzer (DPA) > 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: 27 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
19:17, 22 Jun 2016

Tags

Classifications

Public