SQWareRepository:oracle

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)