AnsweredAssumed Answered

Does the PowerPack for Oracle support RAC? Version 10.1.0.15 deploy script is using the v$ tables and not the GV$ tables so will presumably only show one of the instances.

Question asked by dave.newington on Jan 8, 2016
Latest reply on Jan 13, 2016 by dave.newington
/*######################################################################*/
/*#                                                                     */
/*#  CA (tm) Introscope(R) PowerPack(tm) for Oracle(R) Databases    */
/*# Database User Privileges                                            */
/*#                                                                     */
/*#   Version: 10.1.0.15                      */
/*#   Build: 990014                   */
/*#                                                                     */
/*# CA Wily Introscope(R) Version 10.1.0 Build 990014   */
/*# Copyright (c) 2015 CA. All Rights Reserved.   */
/*# Introscope(R) is a registered trademark of CA.   */
/*######################################################################*/

 

CREATE USER webteam_ro identified by webteam_ro

DEFAULT TABLESPACE users

QUOTA UNLIMITED ON users;

 

GRANT CONNECT TO webteam_ro;

 

CREATE TABLE webteam_ro.APM_OPP_ROLLSTAT_TEMP   NOLOGGING    AS SELECT gets, waits FROM V$ROLLSTAT;  ---  No reference to which instance in the RAC.
CREATE TABLE webteam_ro.APM_OPP_SGA_TEMP   NOLOGGING    AS SELECT name, value FROM V$SGA;
CREATE TABLE webteam_ro.APM_OPP_ROWCACHE_TEMP   NOLOGGING    AS SELECT getmisses, gets FROM V$ROWCACHE;

CREATE TABLE webteam_ro.APM_OPP_LIBRARYCACHE_TEMP    NOLOGGING    AS SELECT namespace, gethitratio FROM V$LIBRARYCACHE;

CREATE TABLE webteam_ro.APM_OPP_LIBRARYCACHE_TEMP1    NOLOGGING    AS SELECT reloads, pins FROM V$LIBRARYCACHE;

CREATE TABLE webteam_ro.APM_OPP_SQLAREA_TEMP   NOLOGGING    AS SELECT users_opening FROM V$SQLAREA;
CREATE TABLE webteam_ro.APM_OPP_SQLAREA_TEMP1   NOLOGGING    AS SELECT sharable_mem, executions FROM V$SQLAREA;

CREATE TABLE webteam_ro.APM_OPP_DB_OBJECT_CACHE_TEMP    NOLOGGING    AS SELECT sharable_mem FROM V$DB_OBJECT_CACHE;

CREATE TABLE webteam_ro.APM_OPP_SESSTAT_TEMP   NOLOGGING    AS SELECT sid, statistic#, value FROM V$SESSTAT; 
CREATE TABLE webteam_ro.APM_OPP_STATNAME_TEMP   NOLOGGING    AS SELECT statistic#, name, class, stat_id  FROM V$STATNAME;
CREATE TABLE webteam_ro.APM_OPP_FILESTAT_TEMP   NOLOGGING    AS SELECT phyrds, phywrts, file# FROM V$FILESTAT;

CREATE TABLE webteam_ro.APM_OPP_DBA_DATA_FILES_TEMP    NOLOGGING    AS SELECT file_id, tablespace_name, file_name FROM dba_data_files

Outcomes