SQWareRepository:oracle

From Wiki_dbSQWare
Jump to navigation Jump to search
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.

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)