|
|
| (6 intermediate revisions by the same user not shown) |
| Line 1: |
Line 1: |
| − | {{SQWareRepositoryPresSgbd|Oracle|d'un schéma|instances}} | + | {{SQWareRepositoryPresSgbd|Oracle|schema|instances|ora}} |
| − | == Contenu du schéma == | + | == Specific database content for Oracle == |
| − | {{SQWareRepositoryTables|tsqw_Repository| | + | |
| − | <nowiki>Repository d'instance</nowiki>| | + | {{SQWareRepositoryTables|tsqwora_AwrBufferGets| |
| | + | <nowiki>...</nowiki>| |
| | <pre> | | <pre> |
| − | /* Repository d'instance */
| + | Field Type |
| − | CREATE TABLE &&UserIndicator..tsqw_Repository (
| + | dbalias varchar(80) |
| − | ORACLE_SID VARCHAR2(9) NOT NULL,
| + | gather_date datetime |
| − | VIRT_HOST_NAME VARCHAR2 (64) NOT NULL,
| + | report varchar(50) |
| − | HOST_NAME VARCHAR2 (64) NOT NULL,
| + | buffergets decimal(12,0) |
| − | USERNAME VARCHAR2 (60) NOT NULL,
| + | executions decimal(12,0) |
| − | PORT NUMBER NOT NULL,
| + | getsperexec decimal(12,0) |
| − | COMMENTS VARCHAR2(500),
| + | pcttotal decimal(12,0) |
| − | CONTACT VARCHAR2(100),
| + | cpu decimal(12,0) |
| − | STATUS VARCHAR2(10) default 'ON',
| + | elapsed decimal(12,0) |
| − | CLIENT VARCHAR2 (60) default 'N.A',
| + | sql_sid varchar(13) |
| − | UPD_DATE DATE default sysdate,
| |
| − | ENV CHAR(3)
| |
| − | ) | |
| − | TABLESPACE &&UserIndicator.D
| |
| − | ;
| |
| − | | |
| − | create public synonym tsqw_Repository for &&UserIndicator..tsqw_Repository;
| |
| − | grant all on &&UserIndicator..tsqw_Repository to &&UserIndicator._RMAJ;
| |
| − | grant all on &&UserIndicator..tsqw_Repository to &&UserIndicator._RLEC;
| |
| − | | |
| − | ALTER TABLE &&UserIndicator..tsqw_Repository ADD (
| |
| − | CONSTRAINT isqw_Repository_pk PRIMARY KEY (ORACLE_SID)
| |
| − | DEFERRABLE
| |
| − | USING INDEX
| |
| − | TABLESPACE &&UserIndicator.X) NOPARALLEL;
| |
| − | | |
| | </pre> | | </pre> |
| | }} | | }} |
| | | | |
| − | {{SQWareRepositoryTables|tsqw_RepositoryOther| | + | {{SQWareRepositoryTables|tsqwora_AwrBufferGetsAft112| |
| − | <nowiki>Repository d'instance autres (pour noeud cluster passif par ex)</nowiki>| | + | <nowiki>...</nowiki>| |
| | <pre> | | <pre> |
| − | /* Repository d'instance autres (pour noeud cluster passif par ex) */
| + | Field Type |
| − | CREATE TABLE &&UserIndicator..tsqw_RepositoryOther (
| + | dbalias varchar(80) |
| − | ORACLE_SID VARCHAR2(9) NOT NULL,
| + | gather_date datetime |
| − | VIRT_HOST_NAME VARCHAR2 (64) NOT NULL,
| + | report varchar(50) |
| − | HOST_NAME VARCHAR2 (64) NOT NULL,
| + | buffergets decimal(12,0) |
| − | USERNAME VARCHAR2 (60) NOT NULL,
| + | executions decimal(12,0) |
| − | PORT NUMBER NOT NULL,
| + | getsperexec decimal(12,0) |
| − | COMMENTS VARCHAR2(500),
| + | pcttotal decimal(12,0) |
| − | CONTACT VARCHAR2(100),
| + | elapsed decimal(12,0) |
| − | STATUS VARCHAR2(10) default 'ON',
| + | pctcpu decimal(12,0) |
| − | CLIENT VARCHAR2 (60) default 'N.A',
| + | pctio decimal(12,0) |
| − | UPD_DATE DATE default sysdate,
| + | sql_sid varchar(13) |
| − | ENV CHAR(3)
| |
| − | ) | |
| − | TABLESPACE &&UserIndicator.D
| |
| − | ;
| |
| − | | |
| − | create public synonym tsqw_RepositoryOther for &&UserIndicator..tsqw_RepositoryOther;
| |
| − | grant all on &&UserIndicator..tsqw_RepositoryOther to &&UserIndicator._RMAJ;
| |
| − | grant select on &&UserIndicator..tsqw_RepositoryOther to &&UserIndicator._RLEC;
| |
| − | | |
| | </pre> | | </pre> |
| | }} | | }} |
| | | | |
| − | {{SQWareRepositoryTables|tsqw_JobsExec| | + | {{SQWareRepositoryTables|tsqwora_AwrBufferGetsBef111| |
| − | <nowiki>Monitoring d'exécution des jobs</nowiki>| | + | <nowiki>...</nowiki>| |
| | <pre> | | <pre> |
| − | /* Monitoring d'exécution des jobs */
| + | Field Type |
| − | CREATE TABLE &&UserIndicator..tsqw_JobsExec
| + | dbalias varchar(80) |
| − | ( | + | gather_date datetime |
| − | ORACLE_SID VARCHAR2(9) NOT NULL,
| + | report varchar(50) |
| − | BEGINNING DATE NOT NULL,
| + | buffergets decimal(12,0) |
| − | SCRIPT CHAR(80) NOT NULL,
| + | executions decimal(12,0) |
| − | PARAMETERS VARCHAR2(400) NOT NULL,
| + | getsperexec decimal(12,0) |
| − | END DATE,
| + | pcttotal decimal(12,0) |
| − | DURATION CHAR(8 BYTE),
| + | cpu decimal(12,0) |
| − | STATUS NUMBER(3)
| + | elapsed decimal(12,0) |
| − | ) | + | sql_sid varchar(13) |
| − | TABLESPACE &&UserIndicator.D;
| |
| − | | |
| − | ALTER TABLE &&UserIndicator..tsqw_JobsExec ADD (
| |
| − | CONSTRAINT isqw_JobsExec_pk PRIMARY KEY (ORACLE_SID, BEGINNING, SCRIPT)
| |
| − | DEFERRABLE
| |
| − | USING INDEX
| |
| − | TABLESPACE &&UserIndicator.X);
| |
| − | | |
| − | create public synonym tsqw_JobsExec for &&UserIndicator..tsqw_JobsExec;
| |
| − | grant all on &&UserIndicator..tsqw_JobsExec to &&UserIndicator._RMAJ;
| |
| − | grant select on &&UserIndicator..tsqw_JobsExec to &&UserIndicator._RLEC;
| |
| − | | |
| | </pre> | | </pre> |
| | }} | | }} |
| | | | |
| − | {{SQWareRepositoryTables|tsqw_VolBackups| | + | {{SQWareRepositoryTables|tsqwora_AwrCpu| |
| − | <nowiki>Table de suivi des backups</nowiki>| | + | <nowiki>...</nowiki>| |
| | <pre> | | <pre> |
| − | /* Table de suivi des backups */
| + | Field Type |
| − | CREATE TABLE &&UserIndicator..tsqw_VolBackups (
| + | dbalias varchar(80) |
| − | ORACLE_SID VARCHAR2(9) NOT NULL,
| + | gather_date datetime |
| − | BEGINNING DATE NOT NULL,
| + | report varchar(50) |
| − | BCK_TYPE VARCHAR2(50) NOT NULL,
| + | elapsed decimal(12,0) |
| − | TOOLS VARCHAR2(12) NOT NULL,
| + | cpu decimal(12,0) |
| − | END DATE NOT NULL,
| + | executions decimal(12,0) |
| − | DURATION CHAR(8) NOT NULL,
| + | elapsedperexec decimal(12,0) |
| − | STATUS NUMBER(3) DEFAULT 0,
| + | pcttotal decimal(12,0) |
| − | SIZE_BCK NUMBER DEFAULT 0
| + | sql_sid varchar(13) |
| − | ) | |
| − | TABLESPACE &&UserIndicator.D
| |
| − | ;
| |
| − | | |
| − | create public synonym tsqw_VolBackups for &&UserIndicator..tsqw_VolBackups;
| |
| − | grant all on &&UserIndicator..tsqw_VolBackups to &&UserIndicator._RMAJ;
| |
| − | grant select on &&UserIndicator..tsqw_VolBackups to &&UserIndicator._RLEC;
| |
| − | | |
| − | ALTER TABLE &&UserIndicator..tsqw_VolBackups ADD (
| |
| − | CONSTRAINT isqw_VolBackups_pk PRIMARY KEY (ORACLE_SID,BEGINNING)
| |
| − | DEFERRABLE
| |
| − | USING INDEX
| |
| − | TABLESPACE &&UserIndicator.X) NOPARALLEL;
| |
| − | | |
| | </pre> | | </pre> |
| | }} | | }} |
| | | | |
| − | {{SQWareRepositoryTables|tsqw_VolBackupsExclude| | + | {{SQWareRepositoryTables|tsqwora_AwrCpu111| |
| − | <nowiki>Table d'exclusion du check backup</nowiki>| | + | <nowiki>...</nowiki>| |
| | <pre> | | <pre> |
| − | /* Table d'exclusion du check backup */
| + | Field Type |
| − | CREATE TABLE &&UserIndicator..tsqw_VolBackupsExclude
| + | dbalias varchar(80) |
| − | (
| + | gather_date datetime |
| − | ORACLE_SID VARCHAR2(9) NOT NULL,
| + | report varchar(50) |
| − | DBANAME VARCHAR2(50) NOT NULL,
| + | cpu decimal(12,0) |
| − | COMMENTS VARCHAR2(50) NOT NULL,
| + | elapsed decimal(12,0) |
| − | UPD_DATE DATE default trunc(sysdate)
| + | executions decimal(12,0) |
| − | ) | + | cpuperexec decimal(12,0) |
| − | TABLESPACE &&UserIndicator.D;
| + | pcttotal decimal(12,0) |
| − | | + | pctdbtime decimal(12,0) |
| − | create public synonym tsqw_VolBackupsExclude for &&UserIndicator..tsqw_VolBackupsExclude;
| + | sql_sid varchar(13) |
| − | grant all on &&UserIndicator..tsqw_VolBackupsExclude to &&UserIndicator._RMAJ;
| |
| − | grant select on &&UserIndicator..tsqw_VolBackupsExclude to &&UserIndicator._RLEC;
| |
| − | | |
| − | ALTER TABLE &&UserIndicator..tsqw_VolBackupsExclude ADD (
| |
| − | CONSTRAINT isqw_VolBackupsExclude_pk PRIMARY KEY (ORACLE_SID)
| |
| − | DEFERRABLE
| |
| − | USING INDEX
| |
| − | TABLESPACE &&UserIndicator.X);
| |
| − | | |
| | </pre> | | </pre> |
| | }} | | }} |
| | | | |
| − | {{SQWareRepositoryTables|tsqw_VolBackupsMonitoring| | + | {{SQWareRepositoryTables|tsqwora_AwrCpuAft112| |
| − | <nowiki>Table de suivi des volumetries et taux de remplissage au cours des backups</nowiki>| | + | <nowiki>...</nowiki>| |
| | <pre> | | <pre> |
| − | /* Table de suivi des volumetries et taux de remplissage au cours des backups */
| + | Field Type |
| − | CREATE TABLE &&UserIndicator..tsqw_VolBackupsMonitoring (
| + | dbalias varchar(80) |
| − | ORACLE_SID VARCHAR2(9) NOT NULL,
| + | gather_date datetime |
| − | BEGINNING DATE NOT NULL,
| + | report varchar(50) |
| − | GATHER_DATE DATE NOT NULL,
| + | cpu decimal(12,0) |
| − | SIZE_BCK NUMBER DEFAULT 0,
| + | executions decimal(12,0) |
| − | SIZE_FS NUMBER DEFAULT 0,
| + | cpuperexec decimal(12,0) |
| − | USED_FS NUMBER DEFAULT 0,
| + | pcttotal decimal(12,0) |
| − | FREE_FS NUMBER DEFAULT 0,
| + | elapsed decimal(12,0) |
| − | RATE_FS NUMBER DEFAULT 0
| + | pctcpu decimal(12,0) |
| − | ) | + | pctio decimal(12,0) |
| − | TABLESPACE &&UserIndicator.D
| + | sql_sid varchar(13) |
| − | ;
| |
| − | | |
| − | create public synonym tsqw_VolBackupsMonitoring for &&UserIndicator..tsqw_VolBackupsMonitoring;
| |
| − | grant all on &&UserIndicator..tsqw_VolBackupsMonitoring to &&UserIndicator._RMAJ;
| |
| − | grant select on &&UserIndicator..tsqw_VolBackupsMonitoring to &&UserIndicator._RLEC;
| |
| − | | |
| − | ALTER TABLE &&UserIndicator..tsqw_VolBackupsMonitoring ADD (
| |
| − | CONSTRAINT isqw_VolBackupsMonitoring_pk PRIMARY KEY (ORACLE_SID,BEGINNING,GATHER_DATE)
| |
| − | DEFERRABLE
| |
| − | USING INDEX
| |
| − | TABLESPACE &&UserIndicator.X) NOPARALLEL;
| |
| − | | |
| | </pre> | | </pre> |
| | }} | | }} |
| | | | |
| − | {{SQWareRepositoryTables|tsqw_VolTbs| | + | {{SQWareRepositoryTables|tsqwora_AwrCpuBef111| |
| − | <nowiki>Volumétrie des Tablespaces</nowiki>| | + | <nowiki>...</nowiki>| |
| | <pre> | | <pre> |
| − | /* Volumétrie des Tablespaces */
| + | Field Type |
| − | CREATE TABLE &&UserIndicator..tsqw_VolTbs (
| + | dbalias varchar(80) |
| − | ORACLE_SID VARCHAR2(9) NOT NULL,
| + | gather_date datetime |
| − | GATHER_DATE DATE NOT NULL,
| + | report varchar(50) |
| − | TABLESPACE_NAME VARCHAR2 (30) NOT NULL,
| + | cpu decimal(12,0) |
| − | CONTENTS VARCHAR2 (9) NOT NULL,
| + | elapsed decimal(12,0) |
| − | SIZE_TBS NUMBER DEFAULT 0,
| + | executions decimal(12,0) |
| − | MAXSIZE NUMBER DEFAULT 0,
| + | cpuperexec decimal(12,0) |
| − | FREE NUMBER DEFAULT 0
| + | pcttotal decimal(12,0) |
| − | ) | + | sql_sid varchar(13) |
| − | TABLESPACE &&UserIndicator.D
| |
| − | ;
| |
| − | | |
| − | create public synonym tsqw_VolTbs for &&UserIndicator..tsqw_VolTbs;
| |
| − | grant all on &&UserIndicator..tsqw_VolTbs to &&UserIndicator._RMAJ;
| |
| − | grant select on &&UserIndicator..tsqw_VolTbs to &&UserIndicator._RLEC;
| |
| − | | |
| − | ALTER TABLE &&UserIndicator..tsqw_VolTbs ADD (
| |
| − | CONSTRAINT isqw_VolTbs_pk PRIMARY KEY (ORACLE_SID, GATHER_DATE, TABLESPACE_NAME)
| |
| − | DEFERRABLE
| |
| − | USING INDEX
| |
| − | TABLESPACE &&UserIndicator.X) NOPARALLEL;
| |
| − | | |
| | </pre> | | </pre> |
| | }} | | }} |
| | | | |
| − | {{SQWareRepositoryTables|tsqw_VolTbsThreshold| | + | {{SQWareRepositoryTables|tsqwora_AwrElapsed| |
| − | <nowiki>Definition des seuils dynamiques spéciques pour les TBS</nowiki>| | + | <nowiki>...</nowiki>| |
| | <pre> | | <pre> |
| − | /* Definition des seuils dynamiques spéciques pour les TBS */
| + | Field Type |
| − | CREATE TABLE &&UserIndicator..tsqw_VolTbsThreshold (
| + | dbalias varchar(80) |
| − | ORACLE_SID VARCHAR2(9) NOT NULL,
| + | gather_date datetime |
| − | TABLESPACE_NAME VARCHAR2 (30) NOT NULL,
| + | report varchar(50) |
| − | THRESHOLD_C NUMBER NOT NULL,
| + | elapsed decimal(12,0) |
| − | THRESHOLD_W NUMBER NOT NULL
| + | cpu decimal(12,0) |
| − | ) | + | executions decimal(12,0) |
| − | TABLESPACE &&UserIndicator.D
| + | elapsedperexec decimal(12,0) |
| − | ;
| + | pcttotal decimal(12,0) |
| − | | + | sql_sid varchar(13) |
| − | create public synonym tsqw_VolTbsThreshold for &&UserIndicator..tsqw_VolTbsThreshold;
| |
| − | grant all on &&UserIndicator..tsqw_VolTbsThreshold to &&UserIndicator._RMAJ;
| |
| − | grant select on &&UserIndicator..tsqw_VolTbsThreshold to &&UserIndicator._RLEC;
| |
| − | | |
| − | ALTER TABLE &&UserIndicator..tsqw_VolTbsThreshold ADD (
| |
| − | CONSTRAINT isqw_VolTbsThreshold_pk PRIMARY KEY (ORACLE_SID, TABLESPACE_NAME)
| |
| − | DEFERRABLE
| |
| − | USING INDEX
| |
| − | TABLESPACE &&UserIndicator.X) NOPARALLEL;
| |
| − | | |
| | </pre> | | </pre> |
| | }} | | }} |
| | | | |
| − | {{SQWareRepositoryTables|tsqw_VolTbsThresholdDef| | + | {{SQWareRepositoryTables|tsqwora_AwrElapsedAft112| |
| − | <nowiki>Definition des seuils dynamiques par défaut pour les TBS</nowiki>| | + | <nowiki>...</nowiki>| |
| | <pre> | | <pre> |
| − | /* Definition des seuils dynamiques par défaut pour les TBS */
| + | Field Type |
| − | CREATE TABLE &&UserIndicator..tsqw_VolTbsThresholdDef (
| + | dbalias varchar(80) |
| − | SIZE_TBS NUMBER NOT NULL,
| + | gather_date datetime |
| − | THRESHOLD_C NUMBER NOT NULL,
| + | report varchar(50) |
| − | THRESHOLD_W NUMBER NOT NULL
| + | elapsed decimal(12,0) |
| − | ) | + | executions decimal(12,0) |
| − | TABLESPACE &&UserIndicator.D
| + | elapsedperexec decimal(12,0) |
| − | ;
| + | pcttotal decimal(12,0) |
| − | | + | pctcpu decimal(12,0) |
| − | create public synonym tsqw_VolTbsThresholdDef for &&UserIndicator..tsqw_VolTbsThresholdDef;
| + | pctio decimal(12,0) |
| − | grant all on &&UserIndicator..tsqw_VolTbsThresholdDef to &&UserIndicator._RMAJ;
| + | sql_sid varchar(13) |
| − | grant select on &&UserIndicator..tsqw_VolTbsThresholdDef to &&UserIndicator._RLEC;
| |
| − | | |
| − | ALTER TABLE &&UserIndicator..tsqw_VolTbsThresholdDef ADD (
| |
| − | CONSTRAINT isqw_VolTbsThresholdDef_pk PRIMARY KEY (SIZE_TBS)
| |
| − | DEFERRABLE
| |
| − | USING INDEX
| |
| − | TABLESPACE &&UserIndicator.X) NOPARALLEL;
| |
| − | | |
| − | insert into tsqw_VolTbsThresholdDef (SIZE_TBS, THRESHOLD_C, THRESHOLD_W) values (2048, 90, 80);
| |
| − | insert into tsqw_VolTbsThresholdDef (SIZE_TBS, THRESHOLD_C, THRESHOLD_W) values (10240, 92, 85);
| |
| − | insert into tsqw_VolTbsThresholdDef (SIZE_TBS, THRESHOLD_C, THRESHOLD_W) values (20480, 95, 90);
| |
| − | insert into tsqw_VolTbsThresholdDef (SIZE_TBS, THRESHOLD_C, THRESHOLD_W) values (10240000000, 99, 97);
| |
| − | commit;
| |
| − | | |
| | </pre> | | </pre> |
| | }} | | }} |
| | | | |
| − | {{SQWareRepositoryTables|tsqw_VolDb| | + | {{SQWareRepositoryTables|tsqwora_AwrElapsedBef111| |
| − | <nowiki>Volumétrie des Bases</nowiki>| | + | <nowiki>...</nowiki>| |
| | <pre> | | <pre> |
| − | /* Volumétrie des Bases */
| + | Field Type |
| − | CREATE TABLE &&UserIndicator..tsqw_VolDb (
| + | dbalias varchar(80) |
| − | ORACLE_SID VARCHAR2(9) NOT NULL,
| + | gather_date datetime |
| − | GATHER_DATE DATE NOT NULL,
| + | report varchar(50) |
| − | SIZE_DB NUMBER DEFAULT 0,
| + | elapsed decimal(12,0) |
| − | FREE NUMBER DEFAULT 0
| + | cpu decimal(12,0) |
| − | ) | + | executions decimal(12,0) |
| − | TABLESPACE &&UserIndicator.D
| + | elapsedperexec decimal(12,0) |
| − | ;
| + | pcttotal decimal(12,0) |
| − | | + | sql_sid varchar(13) |
| − | create public synonym tsqw_VolDb for &&UserIndicator..tsqw_VolDb;
| |
| − | grant all on &&UserIndicator..tsqw_VolDb to &&UserIndicator._RMAJ;
| |
| − | grant select on &&UserIndicator..tsqw_VolDb to &&UserIndicator._RLEC;
| |
| − | | |
| − | ALTER TABLE &&UserIndicator..tsqw_VolDb ADD (
| |
| − | CONSTRAINT isqw_VolDb_pk PRIMARY KEY (ORACLE_SID, GATHER_DATE)
| |
| − | DEFERRABLE
| |
| − | USING INDEX
| |
| − | TABLESPACE &&UserIndicator.X) NOPARALLEL;
| |
| − | | |
| | </pre> | | </pre> |
| | }} | | }} |
| | | | |
| − | {{SQWareRepositoryTables|tsqw_VolArchlogs| | + | {{SQWareRepositoryTables|tsqwora_AwrExecutions| |
| − | <nowiki>Table de suivi des archives logs</nowiki>| | + | <nowiki>...</nowiki>| |
| | <pre> | | <pre> |
| − | /* Table de suivi des archives logs */
| + | Field Type |
| − | CREATE TABLE &&UserIndicator..tsqw_VolArchlogs (
| + | dbalias varchar(80) |
| − | ORACLE_SID VARCHAR2(9) NOT NULL,
| + | gather_date datetime |
| − | GATHER_DATE DATE NOT NULL,
| + | report varchar(50) |
| − | NB_ARCH NUMBER DEFAULT 0,
| + | executions decimal(12,0) |
| − | SIZE_ARCH NUMBER DEFAULT 0
| + | rowsprocessed decimal(12,0) |
| − | ) | + | rowsperexec decimal(12,0) |
| − | TABLESPACE &&UserIndicator.D
| + | cpu decimal(12,0) |
| − | ;
| + | elapsed decimal(12,0) |
| − | | + | sql_sid varchar(13) |
| − | create public synonym tsqw_VolArchlogs for &&UserIndicator..tsqw_VolArchlogs;
| |
| − | grant all on &&UserIndicator..tsqw_VolArchlogs to &&UserIndicator._RMAJ;
| |
| − | grant select on &&UserIndicator..tsqw_VolArchlogs to &&UserIndicator._RLEC;
| |
| − | | |
| − | ALTER TABLE &&UserIndicator..tsqw_VolArchlogs ADD (
| |
| − | CONSTRAINT isqw_VolArchlogs_pk PRIMARY KEY (ORACLE_SID, GATHER_DATE)
| |
| − | DEFERRABLE
| |
| − | USING INDEX
| |
| − | TABLESPACE &&UserIndicator.X) NOPARALLEL;
| |
| − | | |
| | </pre> | | </pre> |
| | }} | | }} |
| | | | |
| − | {{SQWareRepositoryTables|tsqw_VolSchema| | + | {{SQWareRepositoryTables|tsqwora_AwrExecutionsAft112| |
| − | <nowiki>Volumétrie des schemas</nowiki>| | + | <nowiki>...</nowiki>| |
| | <pre> | | <pre> |
| − | /* Volumétrie des schemas */
| + | Field Type |
| − | CREATE TABLE &&UserIndicator..tsqw_VolSchema (
| + | dbalias varchar(80) |
| − | ORACLE_SID VARCHAR2(9) NOT NULL,
| + | gather_date datetime |
| − | GATHER_DATE DATE NOT NULL,
| + | report varchar(50) |
| − | OWNER VARCHAR2 (30) NOT NULL,
| + | executions decimal(12,0) |
| − | SIZE_SCH NUMBER DEFAULT 0
| + | rowsprocessed decimal(12,0) |
| − | ) | + | rowsperexec decimal(12,0) |
| − | TABLESPACE &&UserIndicator.D
| + | elapsed decimal(12,0) |
| − | ;
| + | pctcpu decimal(12,0) |
| − | | + | pctio decimal(12,0) |
| − | create public synonym tsqw_VolSchema for &&UserIndicator..tsqw_VolSchema;
| + | sql_sid varchar(13) |
| − | grant all on &&UserIndicator..tsqw_VolSchema to &&UserIndicator._RMAJ;
| |
| − | grant select on &&UserIndicator..tsqw_VolSchema to &&UserIndicator._RLEC;
| |
| − | | |
| − | ALTER TABLE &&UserIndicator..tsqw_VolSchema ADD (
| |
| − | CONSTRAINT isqw_VolSchema_pk PRIMARY KEY (ORACLE_SID, GATHER_DATE, OWNER)
| |
| − | DEFERRABLE
| |
| − | USING INDEX
| |
| − | TABLESPACE &&UserIndicator.X) NOPARALLEL;
| |
| − | | |
| | </pre> | | </pre> |
| | }} | | }} |
| | | | |
| − | {{SQWareRepositoryTables|tsqw_VolSegments| | + | {{SQWareRepositoryTables|tsqwora_AwrExecutionsBef111| |
| − | <nowiki>Volumétrie des segments</nowiki>| | + | <nowiki>...</nowiki>| |
| | <pre> | | <pre> |
| − | /* Volumétrie des segments */
| + | Field Type |
| − | CREATE TABLE &&UserIndicator..tsqw_VolSegments (
| + | dbalias varchar(80) |
| − | ORACLE_SID VARCHAR2(9) NOT NULL,
| + | gather_date datetime |
| − | GATHER_DATE DATE NOT NULL,
| + | report varchar(50) |
| − | OWNER VARCHAR2 (30) NOT NULL,
| + | executions decimal(12,0) |
| − | SEGMENT_NAME VARCHAR2 (30) NOT NULL,
| + | rowsprocessed decimal(12,0) |
| − | SEGMENT_TYPE VARCHAR2 (30) NOT NULL,
| + | rowsperexec decimal(12,0) |
| − | SIZE_SEG NUMBER DEFAULT 0
| + | cpu decimal(12,0) |
| − | ) | + | elapsed decimal(12,0) |
| − | TABLESPACE &&UserIndicator.D
| + | sql_sid varchar(13) |
| − | ;
| |
| − | | |
| − | create public synonym tsqw_VolSegments for &&UserIndicator..tsqw_VolSegments;
| |
| − | grant all on &&UserIndicator..tsqw_VolSegments to &&UserIndicator._RMAJ;
| |
| − | grant select on &&UserIndicator..tsqw_VolSegments to &&UserIndicator._RLEC;
| |
| − | | |
| − | ALTER TABLE &&UserIndicator..tsqw_VolSegments ADD (
| |
| − | CONSTRAINT isqw_VolSegments_pk PRIMARY KEY (ORACLE_SID, GATHER_DATE, OWNER, SEGMENT_NAME, SEGMENT_TYPE)
| |
| − | DEFERRABLE
| |
| − | USING INDEX
| |
| − | TABLESPACE &&UserIndicator.X) NOPARALLEL;
| |
| − | | |
| | </pre> | | </pre> |
| | }} | | }} |
| | | | |
| − | {{SQWareRepositoryTables|tsqw_GenInfos| | + | {{SQWareRepositoryTables|tsqwora_AwrHits| |
| − | <nowiki>Infos générales sur la database et l'instance</nowiki>| | + | <nowiki>...</nowiki>| |
| | <pre> | | <pre> |
| − | /* Infos générales sur la database et l'instance */
| + | Field Type |
| − | CREATE TABLE &&UserIndicator..tsqw_GenInfos (
| + | dbalias varchar(80) |
| − | ORACLE_SID VARCHAR2(9) NOT NULL,
| + | gather_date datetime |
| − | GATHER_DATE DATE NOT NULL,
| + | report varchar(50) |
| − | VERSION VARCHAR2 (17) NOT NULL,
| + | buffernowait decimal(12,2) |
| − | STARTUP_TIME DATE NOT NULL,
| + | bufferhit decimal(12,2) |
| − | HOST_NAME VARCHAR2 (64) NOT NULL,
| + | libraryhit decimal(12,2) |
| − | DBID NUMBER NOT NULL,
| + | redonowait decimal(12,2) |
| − | RESETLOGS_TIME DATE NOT NULL,
| + | inmemorysort decimal(12,2) |
| − | LOG_MODE VARCHAR2 (12) NOT NULL,
| + | softparse decimal(12,2) |
| − | NLS_CHARACTERSET VARCHAR2 (40) NOT NULL,
| + | latchhit decimal(12,2) |
| − | NB_USERS INTEGER NOT NULL
| |
| − | ) | |
| − | TABLESPACE &&UserIndicator.D
| |
| − | ;
| |
| − | | |
| − | create public synonym tsqw_GenInfos for &&UserIndicator..tsqw_GenInfos;
| |
| − | grant all on &&UserIndicator..tsqw_GenInfos to &&UserIndicator._RMAJ;
| |
| − | grant select on &&UserIndicator..tsqw_GenInfos to &&UserIndicator._RLEC;
| |
| − | | |
| − | ALTER TABLE &&UserIndicator..tsqw_GenInfos ADD (
| |
| − | CONSTRAINT isqw_GenInfos_pk PRIMARY KEY (ORACLE_SID, GATHER_DATE)
| |
| − | DEFERRABLE
| |
| − | USING INDEX
| |
| − | TABLESPACE &&UserIndicator.X) NOPARALLEL;
| |
| − | | |
| | </pre> | | </pre> |
| | }} | | }} |
| | | | |
| − | {{SQWareRepositoryTables|tsqw_StartedInstances| | + | {{SQWareRepositoryTables|tsqwora_AwrMonitorHits| |
| − | <nowiki>Tables des instances démarrées</nowiki>| | + | <nowiki>...</nowiki>| |
| | <pre> | | <pre> |
| − | /* Tables des instances démarrées */
| + | Field Type |
| − | CREATE TABLE &&UserIndicator..tsqw_StartedInstances (
| + | dbalias varchar(80) |
| − | ORACLE_SID VARCHAR2(9) NOT NULL,
| + | gather_date datetime |
| − | GATHER_DATE DATE NOT NULL,
| + | buffernowait decimal(12,2) |
| − | HOST_NAME VARCHAR2 (64) NOT NULL,
| + | bufferhit decimal(12,2) |
| − | USERNAME VARCHAR2 (60) NOT NULL
| + | libraryhit decimal(12,2) |
| − | ) | + | redonowait decimal(12,2) |
| − | TABLESPACE &&UserIndicator.D
| + | inmemorysort decimal(12,2) |
| − | ;
| + | softparse decimal(12,2) |
| − | | + | latchhit decimal(12,2) |
| − | create public synonym tsqw_StartedInstances for &&UserIndicator..tsqw_StartedInstances;
| |
| − | grant all on &&UserIndicator..tsqw_StartedInstances to &&UserIndicator._RMAJ;
| |
| − | | |
| − | ALTER TABLE &&UserIndicator..tsqw_StartedInstances ADD (
| |
| − | CONSTRAINT isqw_StartedInstances_pk PRIMARY KEY (ORACLE_SID, GATHER_DATE)
| |
| − | DEFERRABLE
| |
| − | USING INDEX
| |
| − | TABLESPACE &&UserIndicator.X) NOPARALLEL;
| |
| − | | |
| | </pre> | | </pre> |
| | }} | | }} |
| | | | |
| − | {{SQWareRepositoryTables|tsqw_VolFS| | + | {{SQWareRepositoryTables|tsqwora_AwrMonitorWkl| |
| − | <nowiki>Volumétrie des FS</nowiki>| | + | <nowiki>...</nowiki>| |
| | <pre> | | <pre> |
| − | /* Volumétrie des FS */
| + | Field Type |
| − | CREATE TABLE &&UserIndicator..tsqw_VolFS (
| + | dbalias varchar(80) |
| − | ORACLE_SID VARCHAR2(9) NOT NULL,
| + | gather_date datetime |
| − | GATHER_DATE DATE NOT NULL,
| + | elapsed decimal(12,2) |
| − | HOST_NAME VARCHAR2 (64) NOT NULL,
| + | dbtime decimal(12,2) |
| − | FILESYSTEM VARCHAR2 (200) NOT NULL,
| + | ratiodb decimal(12,2) |
| − | SIZE_FS NUMBER NOT NULL,
| + | redosize decimal(12,2) |
| − | USED NUMBER NOT NULL,
| + | logicalreads decimal(12,2) |
| − | FREE NUMBER NOT NULL,
| + | blockchanges decimal(12,2) |
| − | RATE NUMBER NOT NULL,
| + | physicalreads decimal(12,2) |
| − | MOUNT VARCHAR2 (200)
| + | physicalwrites decimal(12,2) |
| − | ) | |
| − | TABLESPACE &&UserIndicator.D
| |
| − | ;
| |
| − | | |
| − | create public synonym tsqw_VolFS for &&UserIndicator..tsqw_VolFS;
| |
| − | grant all on &&UserIndicator..tsqw_VolFS to &&UserIndicator._RMAJ;
| |
| − | grant select on &&UserIndicator..tsqw_VolFS to &&UserIndicator._RLEC;
| |
| − | | |
| − | ALTER TABLE &&UserIndicator..tsqw_VolFS ADD (
| |
| − | CONSTRAINT isqw_VolFS_pk PRIMARY KEY (ORACLE_SID, GATHER_DATE,MOUNT)
| |
| − | DEFERRABLE
| |
| − | USING INDEX
| |
| − | TABLESPACE &&UserIndicator.X) NOPARALLEL;
| |
| − | | |
| | </pre> | | </pre> |
| | }} | | }} |
| | | | |
| − | {{SQWareRepositoryTables|tsqw_VolFSThreshold| | + | {{SQWareRepositoryTables|tsqwora_AwrPhysicalReads| |
| − | <nowiki>Definition des seuils dynamiques spécifiques pour les FS</nowiki>| | + | <nowiki>...</nowiki>| |
| | <pre> | | <pre> |
| − | /* Definition des seuils dynamiques spécifiques pour les FS */
| + | Field Type |
| − | CREATE TABLE &&UserIndicator..tsqw_VolFSThreshold (
| + | dbalias varchar(80) |
| − | ORACLE_SID VARCHAR2(9) NOT NULL,
| + | gather_date datetime |
| − | MOUNT VARCHAR2 (200),
| + | report varchar(50) |
| − | THRESHOLD_C NUMBER NOT NULL,
| + | physicalreads decimal(12,0) |
| − | THRESHOLD_W NUMBER NOT NULL
| + | executions decimal(12,0) |
| − | ) | + | readsperexec decimal(12,0) |
| − | TABLESPACE &&UserIndicator.D
| + | pcttotal decimal(12,0) |
| − | ;
| + | cpu decimal(12,0) |
| − | | + | elapsed decimal(12,0) |
| − | create public synonym tsqw_VolFSThreshold for &&UserIndicator..tsqw_VolFSThreshold;
| + | sql_sid varchar(13) |
| − | grant all on &&UserIndicator..tsqw_VolFSThreshold to &&UserIndicator._RMAJ;
| |
| − | grant select on &&UserIndicator..tsqw_VolFSThreshold to &&UserIndicator._RLEC;
| |
| − | | |
| − | ALTER TABLE &&UserIndicator..tsqw_VolFSThreshold ADD (
| |
| − | CONSTRAINT isqw_VolFSThreshold_pk PRIMARY KEY (ORACLE_SID, MOUNT)
| |
| − | DEFERRABLE
| |
| − | USING INDEX
| |
| − | TABLESPACE &&UserIndicator.X) NOPARALLEL;
| |
| − | | |
| | </pre> | | </pre> |
| | }} | | }} |
| | | | |
| − | {{SQWareRepositoryTables|tsqw_VolFSThresholdDef| | + | {{SQWareRepositoryTables|tsqwora_AwrPhysicalReadsAft112| |
| − | <nowiki>Definition des seuils dynamiques par défaut pour les FS</nowiki>| | + | <nowiki>...</nowiki>| |
| | <pre> | | <pre> |
| − | /* Definition des seuils dynamiques par défaut pour les FS */
| + | Field Type |
| − | CREATE TABLE &&UserIndicator..tsqw_VolFSThresholdDef (
| + | dbalias varchar(80) |
| − | SIZE_FS NUMBER NOT NULL,
| + | gather_date datetime |
| − | THRESHOLD_C NUMBER NOT NULL,
| + | report varchar(50) |
| − | THRESHOLD_W NUMBER NOT NULL
| + | physicalreads decimal(12,0) |
| − | ) | + | executions decimal(12,0) |
| − | TABLESPACE &&UserIndicator.D
| + | readsperexec decimal(12,0) |
| − | ;
| + | pcttotal decimal(12,0) |
| − | | + | elapsed decimal(12,0) |
| − | create public synonym tsqw_VolFSThresholdDef for &&UserIndicator..tsqw_VolFSThresholdDef;
| + | pctcpu decimal(12,0) |
| − | grant all on &&UserIndicator..tsqw_VolFSThresholdDef to &&UserIndicator._RMAJ;
| + | pctio decimal(12,0) |
| − | grant select on &&UserIndicator..tsqw_VolFSThresholdDef to &&UserIndicator._RLEC;
| + | sql_sid varchar(13) |
| − | | |
| − | ALTER TABLE &&UserIndicator..tsqw_VolFSThresholdDef ADD (
| |
| − | CONSTRAINT isqw_VolFSThresholdDef_pk PRIMARY KEY (SIZE_FS)
| |
| − | DEFERRABLE
| |
| − | USING INDEX
| |
| − | TABLESPACE &&UserIndicator.X) NOPARALLEL;
| |
| − | | |
| − | insert into tsqw_VolFSThresholdDef (SIZE_FS, THRESHOLD_C, THRESHOLD_W) values (2048, 90, 80);
| |
| − | insert into tsqw_VolFSThresholdDef (SIZE_FS, THRESHOLD_C, THRESHOLD_W) values (10240, 92, 85);
| |
| − | insert into tsqw_VolFSThresholdDef (SIZE_FS, THRESHOLD_C, THRESHOLD_W) values (20480, 95, 90);
| |
| − | insert into tsqw_VolFSThresholdDef (SIZE_FS, THRESHOLD_C, THRESHOLD_W) values (10240000000, 98, 95);
| |
| − | commit;
| |
| − | | |
| | </pre> | | </pre> |
| | }} | | }} |
| | | | |
| − | {{SQWareRepositoryTables|tsqw_AwrElapsedBef111| | + | {{SQWareRepositoryTables|tsqwora_AwrPhysicalReadsBef111| |
| − | <nowiki>Stats AWR Top Elapsed <= 11.1</nowiki>| | + | <nowiki>...</nowiki>| |
| | <pre> | | <pre> |
| − | /* Stats AWR Top Elapsed <= 11.1 */
| + | Field Type |
| − | CREATE TABLE &&UserIndicator..tsqw_AwrElapsedBef111 (
| + | dbalias varchar(80) |
| − | ORACLE_SID VARCHAR2(9) NOT NULL,
| + | gather_date datetime |
| − | GATHER_DATE DATE NOT NULL,
| + | report varchar(50) |
| − | REPORT VARCHAR2(50) NOT NULL,
| + | physicalreads decimal(12,0) |
| − | Elapsed INTEGER NOT NULL,
| + | executions decimal(12,0) |
| − | Cpu INTEGER NOT NULL,
| + | readsperexec decimal(12,0) |
| − | Executions INTEGER NOT NULL,
| + | pcttotal decimal(12,0) |
| − | ElapsedperExec INTEGER NOT NULL,
| + | cpu decimal(12,0) |
| − | PctTotal INTEGER NOT NULL,
| + | elapsed decimal(12,0) |
| − | SQL_SID VARCHAR2(13) NOT NULL
| + | sql_sid varchar(13) |
| − | )
| |
| − | TABLESPACE &&UserIndicator.D
| |
| − | ;
| |
| − | ALTER TABLE &&UserIndicator..tsqw_AwrElapsedBef111 ADD (
| |
| − | CONSTRAINT isqw_AwrElapsedBef111_PK PRIMARY KEY (ORACLE_SID,REPORT,SQL_SID)
| |
| − | DEFERRABLE
| |
| − | USING INDEX
| |
| − | TABLESPACE &&UserIndicator.X) NOPARALLEL;
| |
| − | | |
| − | create public synonym tsqw_AwrElapsedBef111 for &&UserIndicator..tsqw_AwrElapsedBef111;
| |
| − | grant all on &&UserIndicator..tsqw_AwrElapsedBef111 to &&UserIndicator._RMAJ;
| |
| − | grant select on &&UserIndicator..tsqw_AwrElapsedBef111 to &&UserIndicator._RLEC;
| |
| − | | |
| | </pre> | | </pre> |
| | }} | | }} |
| | | | |
| − | {{SQWareRepositoryTables|tsqw_AwrElapsedAft112| | + | {{SQWareRepositoryTables|tsqwora_AwrUnOptimizedReads| |
| − | <nowiki>Stats AWR Top Elapsed >= 11.2</nowiki>| | + | <nowiki>...</nowiki>| |
| | <pre> | | <pre> |
| − | /* Stats AWR Top Elapsed >= 11.2 */
| + | Field Type |
| − | CREATE TABLE &&UserIndicator..tsqw_AwrElapsedAft112 (
| + | dbalias varchar(80) |
| − | ORACLE_SID VARCHAR2(9) NOT NULL,
| + | gather_date datetime |
| − | GATHER_DATE DATE NOT NULL,
| + | report varchar(50) |
| − | REPORT VARCHAR2(50) NOT NULL,
| + | unoptimizedreads decimal(12,0) |
| − | Elapsed INTEGER NOT NULL,
| + | physicalreads decimal(12,0) |
| − | Executions INTEGER NOT NULL,
| + | executions decimal(12,0) |
| − | ElapsedperExec INTEGER NOT NULL,
| + | readsperexec decimal(12,0) |
| − | PctTotal INTEGER NOT NULL,
| + | pctopt decimal(12,0) |
| − | PctCpu INTEGER NOT NULL,
| + | pcttotal int(11) |
| − | PctIO INTEGER NOT NULL,
| + | sql_sid varchar(13) |
| − | SQL_SID VARCHAR2(13) NOT NULL
| |
| − | )
| |
| − | TABLESPACE &&UserIndicator.D
| |
| − | ;
| |
| − | ALTER TABLE &&UserIndicator..tsqw_AwrElapsedAft112 ADD (
| |
| − | CONSTRAINT isqw_AwrElapsedAft112_PK PRIMARY KEY (ORACLE_SID,REPORT,SQL_SID)
| |
| − | DEFERRABLE
| |
| − | USING INDEX
| |
| − | TABLESPACE &&UserIndicator.X) NOPARALLEL;
| |
| − | | |
| − | create public synonym tsqw_AwrElapsedAft112 for &&UserIndicator..tsqw_AwrElapsedAft112;
| |
| − | grant all on &&UserIndicator..tsqw_AwrElapsedAft112 to &&UserIndicator._RMAJ;
| |
| − | grant select on &&UserIndicator..tsqw_AwrElapsedAft112 to &&UserIndicator._RLEC;
| |
| − | | |
| − | create or replace view &&UserIndicator..tsqw_AwrElapsed (
| |
| − | ORACLE_SID,
| |
| − | GATHER_DATE,
| |
| − | REPORT,
| |
| − | Elapsed,
| |
| − | Cpu,
| |
| − | Executions,
| |
| − | ElapsedperExec,
| |
| − | PctTotal,
| |
| − | SQL_SID
| |
| − | ) | |
| − | as select ORACLE_SID, GATHER_DATE, REPORT, Elapsed, Cpu, Executions, ElapsedperExec, PctTotal, SQL_SID
| |
| − | from &&UserIndicator..tsqw_AwrElapsedBef111
| |
| − | union all
| |
| − | select ORACLE_SID, GATHER_DATE, REPORT, Elapsed, PctCpu, Executions, ElapsedperExec, PctTotal, SQL_SID
| |
| − | from &&UserIndicator..tsqw_AwrElapsedAft112
| |
| − | ;
| |
| − | | |
| − | create public synonym tsqw_AwrElapsed for &&UserIndicator..tsqw_AwrElapsed;
| |
| − | grant select on &&UserIndicator..tsqw_AwrElapsed to &&UserIndicator._RLEC;
| |
| − | | |
| | </pre> | | </pre> |
| | }} | | }} |
| | | | |
| − | {{SQWareRepositoryTables|tsqw_AwrCpuBef111| | + | {{SQWareRepositoryTables|tsqwora_AwrWkl| |
| − | <nowiki>Stats AWR Top CPU <= 10.2</nowiki>| | + | <nowiki>...</nowiki>| |
| | <pre> | | <pre> |
| − | /* Stats AWR Top CPU <= 10.2 */
| + | Field Type |
| − | CREATE TABLE &&UserIndicator..tsqw_AwrCpuBef111 (
| + | dbalias varchar(80) |
| − | ORACLE_SID VARCHAR2(9) NOT NULL,
| + | gather_date datetime |
| − | GATHER_DATE DATE NOT NULL,
| + | report varchar(50) |
| − | REPORT VARCHAR2(50) NOT NULL,
| + | elapsed decimal(12,2) |
| − | Cpu INTEGER NOT NULL,
| + | dbtime decimal(12,2) |
| − | Elapsed INTEGER NOT NULL,
| + | ratiodb decimal(12,2) |
| − | Executions INTEGER NOT NULL,
| + | redosize decimal(12,2) |
| − | CpuperExec INTEGER NOT NULL,
| + | logicalreads decimal(12,2) |
| − | PctTotal INTEGER NOT NULL,
| + | blockchanges decimal(12,2) |
| − | SQL_SID VARCHAR2(13) NOT NULL
| + | physicalreads decimal(12,2) |
| − | ) | + | physicalwrites decimal(12,2) |
| − | TABLESPACE &&UserIndicator.D
| |
| − | ;
| |
| − | ALTER TABLE &&UserIndicator..tsqw_AwrCpuBef111 ADD (
| |
| − | CONSTRAINT isqw_AwrCpuBef111_PK PRIMARY KEY (ORACLE_SID,REPORT,SQL_SID)
| |
| − | DEFERRABLE
| |
| − | USING INDEX
| |
| − | TABLESPACE &&UserIndicator.X) NOPARALLEL;
| |
| − | | |
| − | create public synonym tsqw_AwrCpuBef111 for &&UserIndicator..tsqw_AwrCpuBef111;
| |
| − | grant all on &&UserIndicator..tsqw_AwrCpuBef111 to &&UserIndicator._RMAJ;
| |
| − | grant select on &&UserIndicator..tsqw_AwrCpu111 to &&UserIndicator._RLEC;
| |
| − | | |
| | </pre> | | </pre> |
| | }} | | }} |
| | | | |
| − | {{SQWareRepositoryTables|tsqw_AwrCpu111| | + | {{SQWareRepositoryTables|tsqwora_Fra| |
| − | <nowiki>Stats AWR Top CPU = 11.1</nowiki>| | + | <nowiki>...</nowiki>| |
| | <pre> | | <pre> |
| − | /* Stats AWR Top CPU = 11.1 */
| + | Field Type |
| − | CREATE TABLE &&UserIndicator..tsqw_AwrCpu111 (
| + | dbalias varchar(80) |
| − | ORACLE_SID VARCHAR2(9) NOT NULL,
| + | gather_date datetime |
| − | GATHER_DATE DATE NOT NULL,
| + | name varchar(513) |
| − | REPORT VARCHAR2(50) NOT NULL,
| + | space_limit decimal(12,2) |
| − | Cpu INTEGER NOT NULL,
| + | space_used decimal(12,2) |
| − | Elapsed INTEGER NOT NULL,
| + | space_reclaimable decimal(12,2) |
| − | Executions INTEGER NOT NULL,
| + | number_of_files decimal(12,2) |
| − | CpuperExec INTEGER NOT NULL,
| |
| − | PctTotal INTEGER NOT NULL,
| |
| − | PctDbTime INTEGER NOT NULL,
| |
| − | SQL_SID VARCHAR2(13) NOT NULL
| |
| − | )
| |
| − | TABLESPACE &&UserIndicator.D
| |
| − | ;
| |
| − | ALTER TABLE &&UserIndicator..tsqw_AwrCpu111 ADD (
| |
| − | CONSTRAINT isqw_AwrCpu111_PK PRIMARY KEY (ORACLE_SID,REPORT,SQL_SID)
| |
| − | DEFERRABLE
| |
| − | USING INDEX
| |
| − | TABLESPACE &&UserIndicator.X) NOPARALLEL;
| |
| − | | |
| − | create public synonym tsqw_AwrCpu111 for &&UserIndicator..tsqw_AwrCpu111;
| |
| − | grant all on &&UserIndicator..tsqw_AwrCpu111 to &&UserIndicator._RMAJ;
| |
| − | grant select on &&UserIndicator..tsqw_AwrCpu111 to &&UserIndicator._RLEC;
| |
| − | | |
| | </pre> | | </pre> |
| | }} | | }} |
| | | | |
| − | {{SQWareRepositoryTables|tsqw_AwrCpuAft112| | + | {{SQWareRepositoryTables|tsqwora_GenInfos| |
| − | <nowiki>Stats AWR Top CPU >= 11.2</nowiki>| | + | <nowiki>...</nowiki>| |
| | <pre> | | <pre> |
| − | /* Stats AWR Top CPU >= 11.2 */
| + | Field Type |
| − | CREATE TABLE &&UserIndicator..tsqw_AwrCpuAft112 (
| + | dbalias varchar(80) |
| − | ORACLE_SID VARCHAR2(9) NOT NULL,
| + | gather_date datetime |
| − | GATHER_DATE DATE NOT NULL,
| + | version varchar(17) |
| − | REPORT VARCHAR2(50) NOT NULL,
| + | startup_time datetime |
| − | Cpu INTEGER NOT NULL,
| + | host_name varchar(64) |
| − | Executions INTEGER NOT NULL,
| + | dbid decimal(12,2) |
| − | CpuperExec INTEGER NOT NULL,
| + | resetlogs_time datetime |
| − | PctTotal INTEGER NOT NULL,
| + | log_mode varchar(12) |
| − | Elapsed INTEGER NOT NULL,
| + | nls_characterset varchar(40) |
| − | PctCpu INTEGER NOT NULL,
| + | nb_users int(11) |
| − | PctIO INTEGER NOT NULL,
| |
| − | SQL_SID VARCHAR2(13) NOT NULL
| |
| − | ) | |
| − | TABLESPACE &&UserIndicator.D
| |
| − | ;
| |
| − | ALTER TABLE &&UserIndicator..tsqw_AwrCpuAft112 ADD (
| |
| − | CONSTRAINT isqw_AwrCpuAft112_PK PRIMARY KEY (ORACLE_SID,REPORT,SQL_SID)
| |
| − | DEFERRABLE
| |
| − | USING INDEX
| |
| − | TABLESPACE &&UserIndicator.X) NOPARALLEL;
| |
| − | | |
| − | create public synonym tsqw_AwrCpuAft112 for &&UserIndicator..tsqw_AwrCpuAft112;
| |
| − | grant all on &&UserIndicator..tsqw_AwrCpuAft112 to &&UserIndicator._RMAJ;
| |
| − | grant select on &&UserIndicator..tsqw_AwrCpuAft112 to &&UserIndicator._RLEC;
| |
| − | | |
| − | create or replace view &&UserIndicator..tsqw_AwrCpu (
| |
| − | ORACLE_SID,
| |
| − | GATHER_DATE,
| |
| − | REPORT,
| |
| − | Elapsed,
| |
| − | Cpu,
| |
| − | Executions,
| |
| − | ElapsedperExec,
| |
| − | PctTotal,
| |
| − | SQL_SID
| |
| − | ) | |
| − | as select ORACLE_SID, GATHER_DATE, REPORT, Cpu, Elapsed, Executions, CpuperExec, PctTotal, SQL_SID
| |
| − | from &&UserIndicator..tsqw_AwrCpuBef111
| |
| − | union all
| |
| − | select ORACLE_SID, GATHER_DATE, REPORT, Cpu, Elapsed, Executions, CpuperExec, PctTotal, SQL_SID
| |
| − | from &&UserIndicator..tsqw_AwrCpu111
| |
| − | union all
| |
| − | select ORACLE_SID, GATHER_DATE, REPORT, Cpu, Elapsed, Executions, CpuperExec, PctTotal, SQL_SID
| |
| − | from &&UserIndicator..tsqw_AwrCpuAft112
| |
| − | ;
| |
| − | | |
| − | create public synonym tsqw_AwrCpu for &&UserIndicator..tsqw_AwrCpu;
| |
| − | grant select on &&UserIndicator..tsqw_AwrCpu to &&UserIndicator._RLEC;
| |
| − | | |
| | </pre> | | </pre> |
| | }} | | }} |
| | | | |
| − | {{SQWareRepositoryTables|tsqw_AwrBufferGetsBef111| | + | {{SQWareRepositoryTables|tsqwora_MaxLog| |
| − | <nowiki>Stats AWR Top Buffer gets <= 11.1</nowiki>| | + | <nowiki>...</nowiki>| |
| | <pre> | | <pre> |
| − | /* Stats AWR Top Buffer gets <= 11.1 */
| + | Field Type |
| − | CREATE TABLE &&UserIndicator..tsqw_AwrBufferGetsBef111 (
| + | dbalias varchar(80) |
| − | ORACLE_SID VARCHAR2(9) NOT NULL,
| + | gather_date datetime |
| − | GATHER_DATE DATE NOT NULL,
| + | full_date datetime |
| − | REPORT VARCHAR2(50) NOT NULL,
| + | sequence decimal(12,2) |
| − | BufferGets INTEGER NOT NULL,
| + | thread decimal(12,2) |
| − | Executions INTEGER NOT NULL,
| |
| − | GetsperExec INTEGER NOT NULL,
| |
| − | PctTotal INTEGER NOT NULL,
| |
| − | Cpu INTEGER NOT NULL,
| |
| − | Elapsed INTEGER NOT NULL,
| |
| − | SQL_SID VARCHAR2(13) NOT NULL
| |
| − | )
| |
| − | TABLESPACE &&UserIndicator.D
| |
| − | ;
| |
| − | ALTER TABLE &&UserIndicator..tsqw_AwrBufferGetsBef111 ADD (
| |
| − | CONSTRAINT isqw_AwrBufferGetsBef111_PK PRIMARY KEY (ORACLE_SID,REPORT,SQL_SID)
| |
| − | DEFERRABLE
| |
| − | USING INDEX
| |
| − | TABLESPACE &&UserIndicator.X) NOPARALLEL;
| |
| − | | |
| − | create public synonym tsqw_AwrBufferGetsBef111 for &&UserIndicator..tsqw_AwrBufferGetsBef111;
| |
| − | grant all on &&UserIndicator..tsqw_AwrBufferGetsBef111 to &&UserIndicator._RMAJ;
| |
| − | grant select on &&UserIndicator..tsqw_AwrBufferGetsBef111 to &&UserIndicator._RLEC;
| |
| − | | |
| | </pre> | | </pre> |
| | }} | | }} |
| | | | |
| − | {{SQWareRepositoryTables|tsqw_AwrBufferGetsAft112| | + | {{SQWareRepositoryTables|tsqwora_Parameters| |
| − | <nowiki>Stats AWR Top Buffer gets >= 11.2</nowiki>| | + | <nowiki>...</nowiki>| |
| | <pre> | | <pre> |
| − | /* Stats AWR Top Buffer gets >= 11.2 */
| + | Field Type |
| − | CREATE TABLE &&UserIndicator..tsqw_AwrBufferGetsAft112 (
| + | dbalias varchar(80) |
| − | ORACLE_SID VARCHAR2(9) NOT NULL,
| + | gather_date datetime |
| − | GATHER_DATE DATE NOT NULL,
| + | inst_id decimal(12,2) |
| − | REPORT VARCHAR2(50) NOT NULL,
| + | name varchar(80) |
| − | BufferGets INTEGER NOT NULL,
| + | value varchar(512) |
| − | Executions INTEGER NOT NULL,
| + | isdefault varchar(9) |
| − | GetsperExec INTEGER NOT NULL,
| |
| − | PctTotal INTEGER NOT NULL,
| |
| − | Elapsed INTEGER NOT NULL,
| |
| − | PctCpu INTEGER NOT NULL,
| |
| − | PctIO INTEGER NOT NULL,
| |
| − | SQL_SID VARCHAR2(13) NOT NULL
| |
| − | )
| |
| − | TABLESPACE &&UserIndicator.D
| |
| − | ;
| |
| − | ALTER TABLE &&UserIndicator..tsqw_AwrBufferGetsAft112 ADD (
| |
| − | CONSTRAINT isqw_AwrBufferGetsAft112_PK PRIMARY KEY (ORACLE_SID,REPORT,SQL_SID)
| |
| − | DEFERRABLE
| |
| − | USING INDEX
| |
| − | TABLESPACE &&UserIndicator.X) NOPARALLEL;
| |
| − | | |
| − | create public synonym tsqw_AwrBufferGetsAft112 for &&UserIndicator..tsqw_AwrBufferGetsAft112;
| |
| − | grant all on &&UserIndicator..tsqw_AwrBufferGetsAft112 to &&UserIndicator._RMAJ;
| |
| − | grant select on &&UserIndicator..tsqw_AwrBufferGetsAft112 to &&UserIndicator._RLEC;
| |
| − | | |
| − | create or replace view &&UserIndicator..tsqw_AwrBufferGets (
| |
| − | ORACLE_SID,
| |
| − | GATHER_DATE,
| |
| − | REPORT,
| |
| − | BufferGets,
| |
| − | Executions,
| |
| − | GetsperExec,
| |
| − | PctTotal,
| |
| − | Cpu,
| |
| − | Elapsed,
| |
| − | SQL_SID
| |
| − | ) | |
| − | as select ORACLE_SID, GATHER_DATE, REPORT, BufferGets, Executions, GetsperExec, PctTotal, Cpu, Elapsed, SQL_SID
| |
| − | from &&UserIndicator..tsqw_AwrBufferGetsBef111
| |
| − | union all
| |
| − | select ORACLE_SID, GATHER_DATE, REPORT, BufferGets, Executions, GetsperExec, PctTotal, PctCpu, Elapsed, SQL_SID
| |
| − | from &&UserIndicator..tsqw_AwrBufferGetsAft112
| |
| − | ;
| |
| − | | |
| − | create public synonym tsqw_AwrBufferGets for &&UserIndicator..tsqw_AwrBufferGets;
| |
| − | grant select on &&UserIndicator..tsqw_AwrBufferGets to &&UserIndicator._RLEC;
| |
| − | | |
| | </pre> | | </pre> |
| | }} | | }} |
| | | | |
| − | {{SQWareRepositoryTables|tsqw_AwrPhysicalReadsBef111| | + | {{SQWareRepositoryTables|tsqwora_RepositoryDg| |
| − | <nowiki>Stats AWR Top Physical Reads <= 11.1</nowiki>| | + | <nowiki>...</nowiki>| |
| | <pre> | | <pre> |
| − | /* Stats AWR Top Physical Reads <= 11.1 */
| + | Field Type |
| − | CREATE TABLE &&UserIndicator..tsqw_AwrPhysicalReadsBef111 (
| + | dbalias_primary varchar(80) |
| − | ORACLE_SID VARCHAR2(9) NOT NULL,
| + | dbalias_standby varchar(80) |
| − | GATHER_DATE DATE NOT NULL,
| |
| − | REPORT VARCHAR2(50) NOT NULL,
| |
| − | PhysicalReads INTEGER NOT NULL,
| |
| − | Executions INTEGER NOT NULL,
| |
| − | ReadsperExec INTEGER NOT NULL,
| |
| − | PctTotal INTEGER NOT NULL,
| |
| − | Cpu INTEGER NOT NULL,
| |
| − | Elapsed INTEGER NOT NULL,
| |
| − | SQL_SID VARCHAR2(13) NOT NULL
| |
| − | ) | |
| − | TABLESPACE &&UserIndicator.D
| |
| − | ;
| |
| − | ALTER TABLE &&UserIndicator..tsqw_AwrPhysicalReadsBef111 ADD (
| |
| − | CONSTRAINT isqw_AwrPhysicalReadsBef111_PK PRIMARY KEY (ORACLE_SID,REPORT,SQL_SID)
| |
| − | DEFERRABLE
| |
| − | USING INDEX
| |
| − | TABLESPACE &&UserIndicator.X) NOPARALLEL;
| |
| − | | |
| − | create public synonym tsqw_AwrPhysicalReadsBef111 for &&UserIndicator..tsqw_AwrPhysicalReadsBef111;
| |
| − | grant all on &&UserIndicator..tsqw_AwrPhysicalReadsBef111 to &&UserIndicator._RMAJ;
| |
| − | grant select on &&UserIndicator..tsqw_AwrPhysicalReadsBef111 to &&UserIndicator._RLEC;
| |
| − | | |
| | </pre> | | </pre> |
| | }} | | }} |
| | | | |
| − | {{SQWareRepositoryTables|tsqw_AwrPhysicalReadsAft112| | + | {{SQWareRepositoryTables|tsqwora_RepositoryRac| |
| − | <nowiki>Stats AWR Top Physical Reads >= 11.2</nowiki>| | + | <nowiki>...</nowiki>| |
| | <pre> | | <pre> |
| − | /* Stats AWR Top Physical Reads >= 11.2 */
| + | Field Type |
| − | CREATE TABLE &&UserIndicator..tsqw_AwrPhysicalReadsAft112 (
| + | dbalias varchar(80) |
| − | ORACLE_SID VARCHAR2(9) NOT NULL,
| + | instance_name varchar(80) |
| − | GATHER_DATE DATE NOT NULL,
| + | virt_host_name varchar(64) |
| − | REPORT VARCHAR2(50) NOT NULL,
| + | host_name varchar(64) |
| − | PhysicalReads INTEGER NOT NULL,
| + | port decimal(12,2) |
| − | Executions INTEGER NOT NULL,
| |
| − | ReadsperExec INTEGER NOT NULL,
| |
| − | PctTotal INTEGER NOT NULL,
| |
| − | Elapsed INTEGER NOT NULL,
| |
| − | PctCpu INTEGER NOT NULL,
| |
| − | PctIO INTEGER NOT NULL,
| |
| − | SQL_SID VARCHAR2(13) NOT NULL
| |
| − | )
| |
| − | TABLESPACE &&UserIndicator.D
| |
| − | ;
| |
| − | ALTER TABLE &&UserIndicator..tsqw_AwrPhysicalReadsAft112 ADD (
| |
| − | CONSTRAINT isqw_AwrPhysicalReadsAft112_PK PRIMARY KEY (ORACLE_SID,REPORT,SQL_SID)
| |
| − | DEFERRABLE
| |
| − | USING INDEX
| |
| − | TABLESPACE &&UserIndicator.X) NOPARALLEL;
| |
| − | | |
| − | create public synonym tsqw_AwrPhysicalReadsAft112 for &&UserIndicator..tsqw_AwrPhysicalReadsAft112;
| |
| − | grant all on &&UserIndicator..tsqw_AwrPhysicalReadsAft112 to &&UserIndicator._RMAJ;
| |
| − | grant select on &&UserIndicator..tsqw_AwrPhysicalReadsAft112 to &&UserIndicator._RLEC;
| |
| − | | |
| − | create or replace view &&UserIndicator..tsqw_AwrPhysicalReads (
| |
| − | ORACLE_SID,
| |
| − | GATHER_DATE,
| |
| − | REPORT,
| |
| − | PhysicalReads,
| |
| − | Executions,
| |
| − | ReadsperExec,
| |
| − | PctTotal,
| |
| − | Cpu,
| |
| − | Elapsed,
| |
| − | SQL_SID
| |
| − | ) | |
| − | as select ORACLE_SID, GATHER_DATE, REPORT, PhysicalReads, Executions, ReadsperExec, PctTotal, Cpu, Elapsed, SQL_SID
| |
| − | from &&UserIndicator..tsqw_AwrPhysicalReadsBef111
| |
| − | union all
| |
| − | select ORACLE_SID, GATHER_DATE, REPORT, PhysicalReads, Executions, ReadsperExec, PctTotal, PctCpu, Elapsed, SQL_SID
| |
| − | from &&UserIndicator..tsqw_AwrPhysicalReadsAft112
| |
| − | ;
| |
| − | | |
| − | create public synonym tsqw_AwrPhysicalReads for &&UserIndicator..tsqw_AwrPhysicalReads;
| |
| − | grant select on &&UserIndicator..tsqw_AwrPhysicalReads to &&UserIndicator._RLEC;
| |
| − | | |
| | </pre> | | </pre> |
| | }} | | }} |
| | | | |
| − | {{SQWareRepositoryTables|tsqw_AwrUnOptimizedReads| | + | {{SQWareRepositoryTables|tsqwora_StartedInstances| |
| − | <nowiki>Stats AWR Top UnOptimized Physical Reads</nowiki>| | + | <nowiki>...</nowiki>| |
| | <pre> | | <pre> |
| − | /* Stats AWR Top UnOptimized Physical Reads */
| + | Field Type |
| − | CREATE TABLE &&UserIndicator..tsqw_AwrUnOptimizedReads (
| + | dbalias varchar(80) |
| − | ORACLE_SID VARCHAR2(9) NOT NULL,
| + | gather_date datetime |
| − | GATHER_DATE DATE NOT NULL,
| + | host_name varchar(64) |
| − | REPORT VARCHAR2(50) NOT NULL,
| + | username varchar(60) |
| − | UnOptimizedReads INTEGER NOT NULL,
| |
| − | PhysicalReads INTEGER NOT NULL,
| |
| − | Executions INTEGER NOT NULL,
| |
| − | ReadsperExec INTEGER NOT NULL,
| |
| − | PctOpt INTEGER NOT NULL,
| |
| − | PctTotal INTEGER NOT NULL,
| |
| − | SQL_SID VARCHAR2(13) NOT NULL
| |
| − | ) | |
| − | TABLESPACE &&UserIndicator.D
| |
| − | ;
| |
| − | ALTER TABLE &&UserIndicator..tsqw_AwrUnOptimizedReads ADD (
| |
| − | CONSTRAINT isqw_AwrUnOptimizedReads_PK PRIMARY KEY (ORACLE_SID,REPORT,SQL_SID)
| |
| − | DEFERRABLE
| |
| − | USING INDEX
| |
| − | TABLESPACE &&UserIndicator.X) NOPARALLEL;
| |
| − | | |
| − | create public synonym tsqw_AwrUnOptimizedReads for &&UserIndicator..tsqw_AwrUnOptimizedReads;
| |
| − | grant all on &&UserIndicator..tsqw_AwrUnOptimizedReads to &&UserIndicator._RMAJ;
| |
| − | grant select on &&UserIndicator..tsqw_AwrUnOptimizedReads to &&UserIndicator._RLEC;
| |
| − | | |
| | </pre> | | </pre> |
| | }} | | }} |
| | | | |
| − | {{SQWareRepositoryTables|tsqw_AwrExecutionsBef111| | + | {{SQWareRepositoryTables|tsqwora_VolArchlogs| |
| − | <nowiki>Stats AWR Top Executions <= 11.1</nowiki>| | + | <nowiki>...</nowiki>| |
| | <pre> | | <pre> |
| − | /* Stats AWR Top Executions <= 11.1 */
| + | Field Type |
| − | CREATE TABLE &&UserIndicator..tsqw_AwrExecutionsBef111 (
| + | dbalias varchar(80) |
| − | ORACLE_SID VARCHAR2(9) NOT NULL,
| + | gather_date datetime |
| − | GATHER_DATE DATE NOT NULL,
| + | nb_arch decimal(12,2) |
| − | REPORT VARCHAR2(50) NOT NULL,
| + | size_arch decimal(12,2) |
| − | Executions INTEGER NOT NULL,
| |
| − | RowsProcessed INTEGER NOT NULL,
| |
| − | RowsperExec INTEGER NOT NULL,
| |
| − | Cpu INTEGER NOT NULL,
| |
| − | Elapsed INTEGER NOT NULL,
| |
| − | SQL_SID VARCHAR2(13) NOT NULL
| |
| − | )
| |
| − | TABLESPACE &&UserIndicator.D
| |
| − | ;
| |
| − | ALTER TABLE &&UserIndicator..tsqw_AwrExecutionsBef111 ADD (
| |
| − | CONSTRAINT isqw_AwrExecutionsBef111_PK PRIMARY KEY (ORACLE_SID,REPORT,SQL_SID)
| |
| − | DEFERRABLE
| |
| − | USING INDEX
| |
| − | TABLESPACE &&UserIndicator.X) NOPARALLEL;
| |
| − | | |
| − | create public synonym tsqw_AwrExecutionsBef111 for &&UserIndicator..tsqw_AwrExecutionsBef111;
| |
| − | grant all on &&UserIndicator..tsqw_AwrExecutionsBef111 to &&UserIndicator._RMAJ;
| |
| − | grant select on &&UserIndicator..tsqw_AwrExecutionsBef111 to &&UserIndicator._RLEC;
| |
| − | | |
| | </pre> | | </pre> |
| | }} | | }} |
| | | | |
| − | {{SQWareRepositoryTables|tsqw_AwrExecutionsAft112| | + | {{SQWareRepositoryTables|tsqwora_VolArchlogsInst| |
| − | <nowiki>Stats AWR Top Executions >= 11.2</nowiki>| | + | <nowiki>...</nowiki>| |
| | <pre> | | <pre> |
| − | /* Stats AWR Top Executions >= 11.2 */
| + | Field Type |
| − | CREATE TABLE &&UserIndicator..tsqw_AwrExecutionsAft112 (
| + | dbalias varchar(80) |
| − | ORACLE_SID VARCHAR2(9) NOT NULL,
| + | gather_date datetime |
| − | GATHER_DATE DATE NOT NULL,
| + | inst_id decimal(12,2) |
| − | REPORT VARCHAR2(50) NOT NULL,
| + | nb_arch decimal(12,2) |
| − | Executions INTEGER NOT NULL,
| + | size_arch decimal(12,2) |
| − | RowsProcessed INTEGER NOT NULL,
| |
| − | RowsperExec INTEGER NOT NULL,
| |
| − | Elapsed INTEGER NOT NULL,
| |
| − | PctCpu INTEGER NOT NULL,
| |
| − | PctIO INTEGER NOT NULL,
| |
| − | SQL_SID VARCHAR2(13) NOT NULL
| |
| − | )
| |
| − | TABLESPACE &&UserIndicator.D
| |
| − | ;
| |
| − | ALTER TABLE &&UserIndicator..tsqw_AwrExecutionsAft112 ADD (
| |
| − | CONSTRAINT isqw_AwrExecutionsAft112_PK PRIMARY KEY (ORACLE_SID,REPORT,SQL_SID)
| |
| − | DEFERRABLE
| |
| − | USING INDEX
| |
| − | TABLESPACE &&UserIndicator.X) NOPARALLEL;
| |
| − | | |
| − | create public synonym tsqw_AwrExecutionsAft112 for &&UserIndicator..tsqw_AwrExecutionsAft112;
| |
| − | grant all on &&UserIndicator..tsqw_AwrExecutionsAft112 to &&UserIndicator._RMAJ;
| |
| − | grant select on &&UserIndicator..tsqw_AwrExecutionsAft112 to &&UserIndicator._RLEC;
| |
| − | | |
| − | create or replace view &&UserIndicator..tsqw_AwrExecutions (
| |
| − | ORACLE_SID,
| |
| − | GATHER_DATE,
| |
| − | REPORT,
| |
| − | Executions,
| |
| − | RowsProcessed,
| |
| − | RowsperExec,
| |
| − | Cpu,
| |
| − | Elapsed,
| |
| − | SQL_SID
| |
| − | ) | |
| − | as select ORACLE_SID, GATHER_DATE, REPORT, Executions, RowsProcessed, RowsperExec, Cpu, Elapsed, SQL_SID
| |
| − | from &&UserIndicator..tsqw_AwrExecutionsBef111
| |
| − | union all
| |
| − | select ORACLE_SID, GATHER_DATE, REPORT, Executions, RowsProcessed, RowsperExec, PctCpu, Elapsed, SQL_SID
| |
| − | from &&UserIndicator..tsqw_AwrExecutionsAft112
| |
| − | ;
| |
| − | | |
| − | create public synonym tsqw_AwrExecutions for &&UserIndicator..tsqw_AwrExecutions;
| |
| − | grant select on &&UserIndicator..tsqw_AwrExecutions to &&UserIndicator._RLEC;
| |
| − | | |
| | </pre> | | </pre> |
| | }} | | }} |
| | | | |
| − | {{SQWareRepositoryTables|tsqw_AwrHits| | + | {{SQWareRepositoryTables|tsqwora_VolBackupsMonitoring| |
| − | <nowiki>Stats AWR Hits ratios</nowiki>| | + | <nowiki>...</nowiki>| |
| | <pre> | | <pre> |
| − | /* Stats AWR Hits ratios */
| + | Field Type |
| − | CREATE TABLE &&UserIndicator..tsqw_AwrHits (
| + | dbalias varchar(80) |
| − | ORACLE_SID VARCHAR2(9) NOT NULL,
| + | beginning timestamp |
| − | GATHER_DATE DATE NOT NULL,
| + | gather_date datetime |
| − | REPORT VARCHAR2(50) NOT NULL,
| + | size_bck decimal(12,2) |
| − | BufferNowait INTEGER NOT NULL,
| + | size_fs decimal(12,2) |
| − | BufferHit INTEGER NOT NULL,
| + | used_fs decimal(12,2) |
| − | LibraryHit INTEGER NOT NULL,
| + | free_fs decimal(12,2) |
| − | RedoNoWait INTEGER NOT NULL,
| + | rate_fs decimal(12,2) |
| − | InmemorySort INTEGER NOT NULL,
| |
| − | SoftParse INTEGER NOT NULL,
| |
| − | LatchHit INTEGER NOT NULL
| |
| − | ) | |
| − | TABLESPACE &&UserIndicator.D
| |
| − | ;
| |
| − | ALTER TABLE &&UserIndicator..tsqw_AwrHits ADD (
| |
| − | CONSTRAINT isqw_AwrHits_PK PRIMARY KEY (ORACLE_SID,REPORT)
| |
| − | DEFERRABLE
| |
| − | USING INDEX
| |
| − | TABLESPACE &&UserIndicator.X) NOPARALLEL;
| |
| − | | |
| − | create public synonym tsqw_AwrHits for &&UserIndicator..tsqw_AwrHits;
| |
| − | grant all on &&UserIndicator..tsqw_AwrHits to &&UserIndicator._RMAJ;
| |
| − | grant select on &&UserIndicator..tsqw_AwrHits to &&UserIndicator._RLEC;
| |
| − | | |
| | </pre> | | </pre> |
| | }} | | }} |
| | | | |
| − | {{SQWareRepositoryTables|tsqw_GenHisto| | + | {{SQWareRepositoryTables|tsqwora_VolPdb| |
| − | <nowiki>Infos générales mensuelles</nowiki>| | + | <nowiki>...</nowiki>| |
| | <pre> | | <pre> |
| − | /* Infos générales mensuelles */
| + | Field Type |
| − | CREATE TABLE &&UserIndicator..tsqw_GenHisto (
| + | dbalias varchar(80) |
| − | ORACLE_SID VARCHAR2(9) NOT NULL,
| + | gather_date datetime |
| − | MONTH DATE NOT NULL,
| + | pdb_name varchar(255) |
| − | GATHER_DATE DATE NOT NULL,
| + | size_pdb decimal(12,2) |
| − | VERSION VARCHAR2 (17),
| + | free decimal(12,2) |
| − | MAJ_VERSION VARCHAR2 (5),
| |
| − | SIZE_DB NUMBER DEFAULT 0,
| |
| − | FREE NUMBER DEFAULT 0,
| |
| − | CLIENT VARCHAR2 (60),
| |
| − | ENV CHAR(3)
| |
| − | )
| |
| − | TABLESPACE &&UserIndicator.D
| |
| − | ;
| |
| − | | |
| − | create public synonym tsqw_GenHisto for &&UserIndicator..tsqw_GenHisto;
| |
| − | grant all on &&UserIndicator..tsqw_GenHisto to &&UserIndicator._RMAJ;
| |
| − | grant select on &&UserIndicator..tsqw_GenHisto to &&UserIndicator._RLEC;
| |
| − | | |
| − | ALTER TABLE &&UserIndicator..tsqw_GenHisto ADD (
| |
| − | CONSTRAINT isqw_GenHisto_pk PRIMARY KEY (ORACLE_SID,MONTH)
| |
| − | DEFERRABLE
| |
| − | USING INDEX
| |
| − | TABLESPACE &&UserIndicator.X) NOPARALLEL;
| |
| − | | |
| − | CREATE UNIQUE INDEX &&UserIndicator..isqw_GenHisto_u ON &&UserIndicator..tsqw_GenHisto(MONTH, ORACLE_SID)
| |
| − | TABLESPACE &&UserIndicator.X;
| |
| − | | |
| | </pre> | | </pre> |
| | }} | | }} |
| | | | |
| − | {{SQWareRepositoryTables|tsqw_AlertFile| | + | {{SQWareRepositoryTables|tsqwora_VolSchema| |
| − | <nowiki>Alert log location</nowiki>| | + | <nowiki>...</nowiki>| |
| | <pre> | | <pre> |
| − | /* Alert log location*/
| + | Field Type |
| − | CREATE TABLE &&UserIndicator..tsqw_AlertFile (
| + | dbalias varchar(80) |
| − | ORACLE_SID VARCHAR2(9) NOT NULL,
| + | gather_date datetime |
| − | GATHER_DATE DATE NOT NULL,
| + | owner varchar(255) |
| − | ALERT_FILE VARCHAR2 (800)
| + | size_sch decimal(12,2) |
| − | )
| |
| − | 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;
| |
| − | | |
| | </pre> | | </pre> |
| | }} | | }} |
| | | | |
| − | {{SQWareRepositoryTables|tsqw_CheckInstance| | + | {{SQWareRepositoryTables|tsqwora_VolSegments| |
| − | <nowiki>Checks instance</nowiki>| | + | <nowiki>...</nowiki>| |
| | <pre> | | <pre> |
| − | /* Checks instance */
| + | Field Type |
| − | CREATE TABLE &&UserIndicator..tsqw_CheckInstance (
| + | dbalias varchar(80) |
| − | ORACLE_SID VARCHAR2(9) NOT NULL,
| + | gather_date datetime |
| − | GATHER_DATE DATE NOT NULL,
| + | owner varchar(255) |
| − | TypeCheck VARCHAR2 (80),
| + | segment_name varchar(255) |
| − | TypeWar VARCHAR2 (80),
| + | segment_type varchar(30) |
| − | Comments VARCHAR2 (800)
| + | size_seg decimal(12,2) |
| − | ) | |
| − | TABLESPACE &&UserIndicator.D
| |
| − | ;
| |
| − | | |
| − | create public synonym tsqw_CheckInstance for &&UserIndicator..tsqw_CheckInstance;
| |
| − | grant all on &&UserIndicator..tsqw_CheckInstance to &&UserIndicator._RMAJ;
| |
| − | grant select on &&UserIndicator..tsqw_CheckInstance to &&UserIndicator._RLEC;
| |
| − | | |
| − | CREATE INDEX &&UserIndicator..isqw_CheckInstance ON &&UserIndicator..tsqw_CheckInstance(GATHER_DATE, ORACLE_SID, TypeCheck, TypeWar)
| |
| − | TABLESPACE &&UserIndicator.X;
| |
| − | | |
| | </pre> | | </pre> |
| | }} | | }} |
| | | | |
| − | {{SQWareRepositoryTables|tsqw_CheckInstanceExclude| | + | {{SQWareRepositoryTables|tsqwora_VolTbs| |
| − | <nowiki>Checks instance justification</nowiki>| | + | <nowiki>...</nowiki>| |
| | <pre> | | <pre> |
| − | /* Checks instance justification */
| + | Field Type |
| − | CREATE TABLE &&UserIndicator..tsqw_CheckInstanceExclude (
| + | dbalias varchar(80) |
| − | ORACLE_SID VARCHAR2(9) NOT NULL,
| + | gather_date datetime |
| − | TypeCheck VARCHAR2 (80),
| + | tablespace_name varchar(255) |
| − | TypeWar VARCHAR2 (80),
| + | contents varchar(9) |
| − | Comments VARCHAR2 (80),
| + | size_tbs decimal(12,2) |
| − | Justification VARCHAR2 (255)
| + | maxsize decimal(12,2) |
| − | ) | + | free decimal(12,2) |
| − | TABLESPACE &&UserIndicator.D
| |
| − | ;
| |
| − | | |
| − | create public synonym tsqw_CheckInstanceExclude for &&UserIndicator..tsqw_CheckInstanceExclude;
| |
| − | grant all on &&UserIndicator..tsqw_CheckInstanceExclude to &&UserIndicator._RMAJ;
| |
| − | grant select on &&UserIndicator..tsqw_CheckInstanceExclude to &&UserIndicator._RLEC;
| |
| − | | |
| − | ALTER TABLE &&UserIndicator..tsqw_CheckInstanceExclude ADD (
| |
| − | CONSTRAINT isqw_CheckInstanceExclude_pk PRIMARY KEY (ORACLE_SID,TypeCheck,TypeWar,Comments)
| |
| − | DEFERRABLE
| |
| − | USING INDEX
| |
| − | TABLESPACE &&UserIndicator.X) NOPARALLEL;
| |
| − | | |
| − | | |
| | </pre> | | </pre> |
| | }} | | }} |
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 tsqwora_% or isqwora_% are specific for Oracle.
Installation guide for SQWareRepository for Oracle
Naming convention
All specific objects for Oracle are named with prefixes:
- tsqwora_% : for tables
- isqwora_% : for index
- isqwora_%_u : for uniques
- isqwora_%_pk : for primary key
Warning: Do not change the standard tables of the tool. For your custom objects, use another name convention than dbSQWare.
This will facilitate version upgrades.
Specific database content for Oracle
tsqwora_AwrBufferGets
This table contains :
...
Desc of tsqwora_AwrBufferGets :
Field Type
dbalias varchar(80)
gather_date datetime
report varchar(50)
buffergets decimal(12,0)
executions decimal(12,0)
getsperexec decimal(12,0)
pcttotal decimal(12,0)
cpu decimal(12,0)
elapsed decimal(12,0)
sql_sid varchar(13)
tsqwora_AwrBufferGetsAft112
This table contains :
...
Desc of tsqwora_AwrBufferGetsAft112 :
Field Type
dbalias varchar(80)
gather_date datetime
report varchar(50)
buffergets decimal(12,0)
executions decimal(12,0)
getsperexec decimal(12,0)
pcttotal decimal(12,0)
elapsed decimal(12,0)
pctcpu decimal(12,0)
pctio decimal(12,0)
sql_sid varchar(13)
tsqwora_AwrBufferGetsBef111
This table contains :
...
Desc of tsqwora_AwrBufferGetsBef111 :
Field Type
dbalias varchar(80)
gather_date datetime
report varchar(50)
buffergets decimal(12,0)
executions decimal(12,0)
getsperexec decimal(12,0)
pcttotal decimal(12,0)
cpu decimal(12,0)
elapsed decimal(12,0)
sql_sid varchar(13)
tsqwora_AwrCpu
This table contains :
...
Desc of tsqwora_AwrCpu :
Field Type
dbalias varchar(80)
gather_date datetime
report varchar(50)
elapsed decimal(12,0)
cpu decimal(12,0)
executions decimal(12,0)
elapsedperexec decimal(12,0)
pcttotal decimal(12,0)
sql_sid varchar(13)
tsqwora_AwrCpu111
This table contains :
...
Desc of tsqwora_AwrCpu111 :
Field Type
dbalias varchar(80)
gather_date datetime
report varchar(50)
cpu decimal(12,0)
elapsed decimal(12,0)
executions decimal(12,0)
cpuperexec decimal(12,0)
pcttotal decimal(12,0)
pctdbtime decimal(12,0)
sql_sid varchar(13)
tsqwora_AwrCpuAft112
This table contains :
...
Desc of tsqwora_AwrCpuAft112 :
Field Type
dbalias varchar(80)
gather_date datetime
report varchar(50)
cpu decimal(12,0)
executions decimal(12,0)
cpuperexec decimal(12,0)
pcttotal decimal(12,0)
elapsed decimal(12,0)
pctcpu decimal(12,0)
pctio decimal(12,0)
sql_sid varchar(13)
tsqwora_AwrCpuBef111
This table contains :
...
Desc of tsqwora_AwrCpuBef111 :
Field Type
dbalias varchar(80)
gather_date datetime
report varchar(50)
cpu decimal(12,0)
elapsed decimal(12,0)
executions decimal(12,0)
cpuperexec decimal(12,0)
pcttotal decimal(12,0)
sql_sid varchar(13)
tsqwora_AwrElapsed
This table contains :
...
Desc of tsqwora_AwrElapsed :
Field Type
dbalias varchar(80)
gather_date datetime
report varchar(50)
elapsed decimal(12,0)
cpu decimal(12,0)
executions decimal(12,0)
elapsedperexec decimal(12,0)
pcttotal decimal(12,0)
sql_sid varchar(13)
tsqwora_AwrElapsedAft112
This table contains :
...
Desc of tsqwora_AwrElapsedAft112 :
Field Type
dbalias varchar(80)
gather_date datetime
report varchar(50)
elapsed decimal(12,0)
executions decimal(12,0)
elapsedperexec decimal(12,0)
pcttotal decimal(12,0)
pctcpu decimal(12,0)
pctio decimal(12,0)
sql_sid varchar(13)
tsqwora_AwrElapsedBef111
This table contains :
...
Desc of tsqwora_AwrElapsedBef111 :
Field Type
dbalias varchar(80)
gather_date datetime
report varchar(50)
elapsed decimal(12,0)
cpu decimal(12,0)
executions decimal(12,0)
elapsedperexec decimal(12,0)
pcttotal decimal(12,0)
sql_sid varchar(13)
tsqwora_AwrExecutions
This table contains :
...
Desc of tsqwora_AwrExecutions :
Field Type
dbalias varchar(80)
gather_date datetime
report varchar(50)
executions decimal(12,0)
rowsprocessed decimal(12,0)
rowsperexec decimal(12,0)
cpu decimal(12,0)
elapsed decimal(12,0)
sql_sid varchar(13)
tsqwora_AwrExecutionsAft112
This table contains :
...
Desc of tsqwora_AwrExecutionsAft112 :
Field Type
dbalias varchar(80)
gather_date datetime
report varchar(50)
executions decimal(12,0)
rowsprocessed decimal(12,0)
rowsperexec decimal(12,0)
elapsed decimal(12,0)
pctcpu decimal(12,0)
pctio decimal(12,0)
sql_sid varchar(13)
tsqwora_AwrExecutionsBef111
This table contains :
...
Desc of tsqwora_AwrExecutionsBef111 :
Field Type
dbalias varchar(80)
gather_date datetime
report varchar(50)
executions decimal(12,0)
rowsprocessed decimal(12,0)
rowsperexec decimal(12,0)
cpu decimal(12,0)
elapsed decimal(12,0)
sql_sid varchar(13)
tsqwora_AwrHits
This table contains :
...
Desc of tsqwora_AwrHits :
Field Type
dbalias varchar(80)
gather_date datetime
report varchar(50)
buffernowait decimal(12,2)
bufferhit decimal(12,2)
libraryhit decimal(12,2)
redonowait decimal(12,2)
inmemorysort decimal(12,2)
softparse decimal(12,2)
latchhit decimal(12,2)
tsqwora_AwrMonitorHits
This table contains :
...
Desc of tsqwora_AwrMonitorHits :
Field Type
dbalias varchar(80)
gather_date datetime
buffernowait decimal(12,2)
bufferhit decimal(12,2)
libraryhit decimal(12,2)
redonowait decimal(12,2)
inmemorysort decimal(12,2)
softparse decimal(12,2)
latchhit decimal(12,2)
tsqwora_AwrMonitorWkl
This table contains :
...
Desc of tsqwora_AwrMonitorWkl :
Field Type
dbalias varchar(80)
gather_date datetime
elapsed decimal(12,2)
dbtime decimal(12,2)
ratiodb decimal(12,2)
redosize decimal(12,2)
logicalreads decimal(12,2)
blockchanges decimal(12,2)
physicalreads decimal(12,2)
physicalwrites decimal(12,2)
tsqwora_AwrPhysicalReads
This table contains :
...
Desc of tsqwora_AwrPhysicalReads :
Field Type
dbalias varchar(80)
gather_date datetime
report varchar(50)
physicalreads decimal(12,0)
executions decimal(12,0)
readsperexec decimal(12,0)
pcttotal decimal(12,0)
cpu decimal(12,0)
elapsed decimal(12,0)
sql_sid varchar(13)
tsqwora_AwrPhysicalReadsAft112
This table contains :
...
Desc of tsqwora_AwrPhysicalReadsAft112 :
Field Type
dbalias varchar(80)
gather_date datetime
report varchar(50)
physicalreads decimal(12,0)
executions decimal(12,0)
readsperexec decimal(12,0)
pcttotal decimal(12,0)
elapsed decimal(12,0)
pctcpu decimal(12,0)
pctio decimal(12,0)
sql_sid varchar(13)
tsqwora_AwrPhysicalReadsBef111
This table contains :
...
Desc of tsqwora_AwrPhysicalReadsBef111 :
Field Type
dbalias varchar(80)
gather_date datetime
report varchar(50)
physicalreads decimal(12,0)
executions decimal(12,0)
readsperexec decimal(12,0)
pcttotal decimal(12,0)
cpu decimal(12,0)
elapsed decimal(12,0)
sql_sid varchar(13)
tsqwora_AwrUnOptimizedReads
This table contains :
...
Desc of tsqwora_AwrUnOptimizedReads :
Field Type
dbalias varchar(80)
gather_date datetime
report varchar(50)
unoptimizedreads decimal(12,0)
physicalreads decimal(12,0)
executions decimal(12,0)
readsperexec decimal(12,0)
pctopt decimal(12,0)
pcttotal int(11)
sql_sid varchar(13)
tsqwora_AwrWkl
This table contains :
...
Desc of tsqwora_AwrWkl :
Field Type
dbalias varchar(80)
gather_date datetime
report varchar(50)
elapsed decimal(12,2)
dbtime decimal(12,2)
ratiodb decimal(12,2)
redosize decimal(12,2)
logicalreads decimal(12,2)
blockchanges decimal(12,2)
physicalreads decimal(12,2)
physicalwrites decimal(12,2)
tsqwora_Fra
This table contains :
...
Desc of tsqwora_Fra :
Field Type
dbalias varchar(80)
gather_date datetime
name varchar(513)
space_limit decimal(12,2)
space_used decimal(12,2)
space_reclaimable decimal(12,2)
number_of_files decimal(12,2)
tsqwora_GenInfos
This table contains :
...
Desc of tsqwora_GenInfos :
Field Type
dbalias varchar(80)
gather_date datetime
version varchar(17)
startup_time datetime
host_name varchar(64)
dbid decimal(12,2)
resetlogs_time datetime
log_mode varchar(12)
nls_characterset varchar(40)
nb_users int(11)
tsqwora_MaxLog
This table contains :
...
Desc of tsqwora_MaxLog :
Field Type
dbalias varchar(80)
gather_date datetime
full_date datetime
sequence decimal(12,2)
thread decimal(12,2)
tsqwora_Parameters
This table contains :
...
Desc of tsqwora_Parameters :
Field Type
dbalias varchar(80)
gather_date datetime
inst_id decimal(12,2)
name varchar(80)
value varchar(512)
isdefault varchar(9)
tsqwora_RepositoryDg
This table contains :
...
Desc of tsqwora_RepositoryDg :
Field Type
dbalias_primary varchar(80)
dbalias_standby varchar(80)
tsqwora_RepositoryRac
This table contains :
...
Desc of tsqwora_RepositoryRac :
Field Type
dbalias varchar(80)
instance_name varchar(80)
virt_host_name varchar(64)
host_name varchar(64)
port decimal(12,2)
tsqwora_StartedInstances
This table contains :
...
Desc of tsqwora_StartedInstances :
Field Type
dbalias varchar(80)
gather_date datetime
host_name varchar(64)
username varchar(60)
tsqwora_VolArchlogs
This table contains :
...
Desc of tsqwora_VolArchlogs :
Field Type
dbalias varchar(80)
gather_date datetime
nb_arch decimal(12,2)
size_arch decimal(12,2)
tsqwora_VolArchlogsInst
This table contains :
...
Desc of tsqwora_VolArchlogsInst :
Field Type
dbalias varchar(80)
gather_date datetime
inst_id decimal(12,2)
nb_arch decimal(12,2)
size_arch decimal(12,2)
tsqwora_VolBackupsMonitoring
This table contains :
...
Desc of tsqwora_VolBackupsMonitoring :
Field Type
dbalias varchar(80)
beginning timestamp
gather_date datetime
size_bck decimal(12,2)
size_fs decimal(12,2)
used_fs decimal(12,2)
free_fs decimal(12,2)
rate_fs decimal(12,2)
tsqwora_VolPdb
This table contains :
...
Desc of tsqwora_VolPdb :
Field Type
dbalias varchar(80)
gather_date datetime
pdb_name varchar(255)
size_pdb decimal(12,2)
free decimal(12,2)
tsqwora_VolSchema
This table contains :
...
Desc of tsqwora_VolSchema :
Field Type
dbalias varchar(80)
gather_date datetime
owner varchar(255)
size_sch decimal(12,2)
tsqwora_VolSegments
This table contains :
...
Desc of tsqwora_VolSegments :
Field Type
dbalias varchar(80)
gather_date datetime
owner varchar(255)
segment_name varchar(255)
segment_type varchar(30)
size_seg decimal(12,2)
tsqwora_VolTbs
This table contains :
...
Desc of tsqwora_VolTbs :
Field Type
dbalias varchar(80)
gather_date datetime
tablespace_name varchar(255)
contents varchar(9)
size_tbs decimal(12,2)
maxsize decimal(12,2)
free decimal(12,2)
