SQWareRepository:oracle

Presentation

It is the repository module, and stores rdbms indicators for all RDBMS.
It is a MySQL database.
Objects prefix by tsqw_% or isqw_% are generic.
Objects prefix by tsqw{{{4}}}_% or isqw{{{4}}}_% are specific for Oracle.
Installation guide for SQWareRepository for Oracle

Naming convention

All specific objects for Oracle are named with prefixes:

• tsqw{{{4}}}_% : for tables
• isqw{{{4}}}_% : for index
• isqw{{{4}}}_%_u : for uniques
• isqw{{{4}}}_%_pk : for primary key

tsqw_AwrExecutionsBef111

This table contains :

/* Alert log location*/
CREATE TABLE &&UserIndicator..tsqw_AlertFile  (
  ORACLE_SID        VARCHAR2(9) NOT NULL,
  GATHER_DATE       DATE    NOT NULL,
  ALERT_FILE        VARCHAR2 (800)
)
TABLESPACE &&UserIndicator.D
;

create public synonym tsqw_AlertFile for &&UserIndicator..tsqw_AlertFile;
grant all on &&UserIndicator..tsqw_AlertFile to &&UserIndicator._RMAJ;
grant select on &&UserIndicator..tsqw_AlertFile to &&UserIndicator._RLEC;

ALTER TABLE &&UserIndicator..tsqw_AlertFile ADD (
  CONSTRAINT isqw_AlertFile_pk PRIMARY KEY (ORACLE_SID)
    DEFERRABLE
    USING INDEX
    TABLESPACE &&UserIndicator.X) NOPARALLEL;



Desc of tsqw_AwrExecutionsBef111 :

{{{3}}}