Difference between revisions of "SQWareWeb:oracle"
Expdbtools (talk | contribs) |
Expdbtools (talk | contribs) |
||
| Line 5: | Line 5: | ||
{{SQWareRepositoryLink|oracle|tsqw_VolFSThreshold}} | {{SQWareRepositoryLink|oracle|tsqw_VolFSThreshold}} | ||
{{SQWareRepositoryLink|oracle|tsqw_VolFSThresholdDef}} | {{SQWareRepositoryLink|oracle|tsqw_VolFSThresholdDef}} | ||
| + | | | ||
| + | Globale, TBS, FS, Schéma, Segments, backups | ||
| + | | | ||
| + | *perf : contient les rapports liés aux performences des instances (basé sur AWR) | ||
}} | }} | ||
Revision as of 20:25, 20 July 2010
Presentation
Usage
It is the specific part of 'graphic' restitution of dbSQWare for Oracle.
SQWareWeb Oracle formats (graphs or tables) datas uploaded in SQWareRepository Oracle by many scripts of SQWareProduction module for Oracle.
Almost all of the data presented are dynamically generated (volumes, versions, ...),
only the data type repository or settings are stored manually in the relevant tables.
Example of static table : tsqw_Repository
Examples of pages presented for Oracle:
- Inventory of
- tsqw_RepositoryOther
- tsqw_VolTbsThreshold
- tsqw_VolTbsThresholdDef
- tsqw_VolFSThreshold
- tsqw_VolFSThresholdDef
s Oracle with volumetry, version, environnement, ...
- Distribution of
- tsqw_RepositoryOther
- tsqw_VolTbsThreshold
- tsqw_VolTbsThresholdDef
- tsqw_VolFSThreshold
- tsqw_VolFSThresholdDef
in number/volumetry per environnement/client/version
- Detail of volumetry (
Globale, TBS, FS, Schéma, Segments, backups )
- Trace of scripts executions of SQWareProduction Oracle (beginning, end, options, duration, return code, ...)
- Performances datas
- Capacity planning
- ...
Presentation model of SQWareWeb for Oracle.
Explanation of directories
Directories located in $gvsqw_RootexpdbWebdba/htdocs/oracle :
- bin : Directory containing standard scripts
- general : Directory containing general reports for all managed
- tsqw_RepositoryOther
- tsqw_VolTbsThreshold
- tsqw_VolTbsThresholdDef
- tsqw_VolFSThreshold
- tsqw_VolFSThresholdDef
s
- detail : Directory containing contient specific report for one selected
- tsqw_RepositoryOther
- tsqw_VolTbsThreshold
- tsqw_VolTbsThresholdDef
- tsqw_VolFSThreshold
- tsqw_VolFSThresholdDef
Oracle
- tech : Directory containing contient "technical" reports, some general and others specific per
- tsqw_RepositoryOther
- tsqw_VolTbsThreshold
- tsqw_VolTbsThresholdDef
- tsqw_VolFSThreshold
- tsqw_VolFSThresholdDef
Oracle
- dashboard : Directory containing contient changes on
- tsqw_RepositoryOther
- tsqw_VolTbsThreshold
- tsqw_VolTbsThresholdDef
- tsqw_VolFSThreshold
- tsqw_VolFSThresholdDef
s (removed/created, patched/upgraded), and distributions
- perf : contient les rapports liés aux performences des instances (basé sur AWR)
