Submit a ticketCall us

Don’t fall victim to a ransomware attack
Backups are helpful, but sometimes that’s not enough to protect your business against ransomware. At our live webcast we will discuss how to protect against ransomware attacks with SolarWinds® Patch Manager and how to leverage log data to detect ransomware. Register now for our live webcast.

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: 65 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