SQWareRepository:oracle: Difference between revisions

From Wiki_dbSQWare
Jump to navigation Jump to search
← Older edit
No edit summary
No edit summary
 
(2 intermediate revisions by the same user not shown)
Line 1: Line 1:
{{SQWareRepositoryPresSgbd|Oracle|schema|instances|ora}}
{{SQWareRepositoryPresSgbd|Oracle|schema|instances|ora}}
== Schema content ==
== Specific database content for Oracle ==
{{SQWareRepositoryTables|tsqw_Repository|
 
<nowiki>Instance repository</nowiki>|
{{SQWareRepositoryTables|tsqwora_AwrBufferGets|
<nowiki>...</nowiki>|
<pre>
<pre>
/* Instance repository */
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>Other instances repository (for passive cluster node for example)</nowiki>|
<nowiki>...</nowiki>|
<pre>
<pre>
/* Other instances repository (for passive cluster node for example) */
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>Jobs execution monitoring</nowiki>|
<nowiki>...</nowiki>|
<pre>
<pre>
/* Jobs execution monitoring */
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>Monitoring backups</nowiki>|
<nowiki>...</nowiki>|
<pre>
<pre>
/* Monitoring 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>Exclusion of check backup</nowiki>|
<nowiki>...</nowiki>|
<pre>
<pre>
/* Exclusion of 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>Monitoring backups FS during backups</nowiki>|
<nowiki>...</nowiki>|
<pre>
<pre>
/* Monitoring backups FS during 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>Volumetry of Tablespaces</nowiki>|
<nowiki>...</nowiki>|
<pre>
<pre>
/* Volumetry of 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 of dynamic thresholds specic for TBS</nowiki>|
<nowiki>...</nowiki>|
<pre>
<pre>
/* Definition of dynamic thresholds specic for 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 of default dynamic thresholds for TBS</nowiki>|
<nowiki>...</nowiki>|
<pre>
<pre>
/* Definition of default dynamic thresholds for 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>Volumetry of Bases</nowiki>|
<nowiki>...</nowiki>|
<pre>
<pre>
/* Volumetry of 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>Volumetry of schemas</nowiki>|
<nowiki>...</nowiki>|
<pre>
<pre>
/* Volumetry of 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>Volumetry of segments</nowiki>|
<nowiki>...</nowiki>|
<pre>
<pre>
/* Volumetry of 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>Volumetry of FS</nowiki>|
<nowiki>...</nowiki>|
<pre>
<pre>
/* Volumetry of 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 of dynamic thresholds specic for FS</nowiki>|
<nowiki>...</nowiki>|
<pre>
<pre>
/* Definition of dynamic thresholds specic for 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 of default dynamic thresholds for FS</nowiki>|
<nowiki>...</nowiki>|
<pre>
<pre>
/* Definition of default dynamic thresholds for 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>Monthly general Informations</nowiki>|
<nowiki>...</nowiki>|
<pre>
<pre>
/* Monthly general Informations */
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>
}}
}}

Latest revision as of 19:15, 8 August 2015

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)
Retrieved from "https://wiki.dbsqware.com/index.php?title=SQWareRepository:oracle&oldid=7267"