/*###################################################################### | */ |
/*# | */ |
/*# 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