Difference between revisions of "SQWareRepository:oracle"
Expdbtools (talk | contribs) (→Contenu du schéma) |
Expdbtools (talk | contribs) |
||
| Line 1: | Line 1: | ||
{{SQWareRepositoryPresSgbd|Oracle|d'un schéma|instances}} | {{SQWareRepositoryPresSgbd|Oracle|d'un schéma|instances}} | ||
== Contenu du schéma == | == Contenu du schéma == | ||
| − | {{SQWareRepositoryTables|tsqw_AwrExecutionsBef111|Stats AWR Top Executions | + | {{SQWareRepositoryTables|tsqw_AwrExecutionsBef111|Stats AWR Top Executions = 11.1| |
<pre> | <pre> | ||
Revision as of 21:51, 19 July 2010
Presentation
It is the repository module, and stores rdbms indicators for all RDBMS.
It is a MySQL database.
Objects prefix by tsqw_% or isqw_% are generic.
Objects prefix by tsqw{{{4}}}_% or isqw{{{4}}}_% are specific for Oracle.
Installation guide for SQWareRepository for Oracle
Naming convention
All specific objects for Oracle are named with prefixes:
- tsqw{{{4}}}_% : for tables
- isqw{{{4}}}_% : for index
- isqw{{{4}}}_%_u : for uniques
- isqw{{{4}}}_%_pk : for primary key
Contenu du schéma
tsqw_AwrExecutionsBef111
This table contains :
/* Alert log location*/
CREATE TABLE &&UserIndicator..tsqw_AlertFile (
ORACLE_SID VARCHAR2(9) NOT NULL,
GATHER_DATE DATE NOT NULL,
ALERT_FILE VARCHAR2 (800)
)
TABLESPACE &&UserIndicator.D
;
create public synonym tsqw_AlertFile for &&UserIndicator..tsqw_AlertFile;
grant all on &&UserIndicator..tsqw_AlertFile to &&UserIndicator._RMAJ;
grant select on &&UserIndicator..tsqw_AlertFile to &&UserIndicator._RLEC;
ALTER TABLE &&UserIndicator..tsqw_AlertFile ADD (
CONSTRAINT isqw_AlertFile_pk PRIMARY KEY (ORACLE_SID)
DEFERRABLE
USING INDEX
TABLESPACE &&UserIndicator.X) NOPARALLEL;
Desc of tsqw_AwrExecutionsBef111 :
{{{3}}}
