Submit a ticketCall us

Webinar: Web Help Desk for HR, Facilities and Accounting Departments
This webinar will focus on use cases for HR, Facilities and Accounting.

Having a unified ticketing and asset management system for all the departments in your company can provide end-users with a seamless experience and make things easier for your IT team. Yet, with different business tasks and objectives, many departments don’t fully understand the capabilities of Web Help Desk and how the software can be customized for effective use in their departments.
Register Now.

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