Difference between revisions of "SQWareRepository:oracle"

From Wiki_dbSQWare
Jump to: navigation, search
(Replaced content with '{{SQWareRepositoryPresSgbd|Oracle|schema|instances|ora}} == Specific database content for Oracle ==')
 
Line 1: Line 1:
 
{{SQWareRepositoryPresSgbd|Oracle|schema|instances|ora}}
 
{{SQWareRepositoryPresSgbd|Oracle|schema|instances|ora}}
 
== Specific database content for Oracle ==
 
== Specific database content for Oracle ==
 +
 +
{{SQWareRepositoryTables|tsqwora_AwrBufferGets|
 +
<nowiki>...</nowiki>|
 +
<pre>
 +
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)
 +
</pre>
 +
}}
 +
 +
{{SQWareRepositoryTables|tsqwora_AwrBufferGetsAft112|
 +
<nowiki>...</nowiki>|
 +
<pre>
 +
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)
 +
</pre>
 +
}}
 +
 +
{{SQWareRepositoryTables|tsqwora_AwrBufferGetsBef111|
 +
<nowiki>...</nowiki>|
 +
<pre>
 +
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)
 +
</pre>
 +
}}
 +
 +
{{SQWareRepositoryTables|tsqwora_AwrCpu|
 +
<nowiki>...</nowiki>|
 +
<pre>
 +
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)
 +
</pre>
 +
}}
 +
 +
{{SQWareRepositoryTables|tsqwora_AwrCpu111|
 +
<nowiki>...</nowiki>|
 +
<pre>
 +
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)
 +
</pre>
 +
}}
 +
 +
{{SQWareRepositoryTables|tsqwora_AwrCpuAft112|
 +
<nowiki>...</nowiki>|
 +
<pre>
 +
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)
 +
</pre>
 +
}}
 +
 +
{{SQWareRepositoryTables|tsqwora_AwrCpuBef111|
 +
<nowiki>...</nowiki>|
 +
<pre>
 +
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)
 +
</pre>
 +
}}
 +
 +
{{SQWareRepositoryTables|tsqwora_AwrElapsed|
 +
<nowiki>...</nowiki>|
 +
<pre>
 +
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)
 +
</pre>
 +
}}
 +
 +
{{SQWareRepositoryTables|tsqwora_AwrElapsedAft112|
 +
<nowiki>...</nowiki>|
 +
<pre>
 +
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)
 +
</pre>
 +
}}
 +
 +
{{SQWareRepositoryTables|tsqwora_AwrElapsedBef111|
 +
<nowiki>...</nowiki>|
 +
<pre>
 +
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)
 +
</pre>
 +
}}
 +
 +
{{SQWareRepositoryTables|tsqwora_AwrExecutions|
 +
<nowiki>...</nowiki>|
 +
<pre>
 +
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)
 +
</pre>
 +
}}
 +
 +
{{SQWareRepositoryTables|tsqwora_AwrExecutionsAft112|
 +
<nowiki>...</nowiki>|
 +
<pre>
 +
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)
 +
</pre>
 +
}}
 +
 +
{{SQWareRepositoryTables|tsqwora_AwrExecutionsBef111|
 +
<nowiki>...</nowiki>|
 +
<pre>
 +
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)
 +
</pre>
 +
}}
 +
 +
{{SQWareRepositoryTables|tsqwora_AwrHits|
 +
<nowiki>...</nowiki>|
 +
<pre>
 +
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)
 +
</pre>
 +
}}
 +
 +
{{SQWareRepositoryTables|tsqwora_AwrMonitorHits|
 +
<nowiki>...</nowiki>|
 +
<pre>
 +
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)
 +
</pre>
 +
}}
 +
 +
{{SQWareRepositoryTables|tsqwora_AwrMonitorWkl|
 +
<nowiki>...</nowiki>|
 +
<pre>
 +
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)
 +
</pre>
 +
}}
 +
 +
{{SQWareRepositoryTables|tsqwora_AwrPhysicalReads|
 +
<nowiki>...</nowiki>|
 +
<pre>
 +
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)
 +
</pre>
 +
}}
 +
 +
{{SQWareRepositoryTables|tsqwora_AwrPhysicalReadsAft112|
 +
<nowiki>...</nowiki>|
 +
<pre>
 +
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)
 +
</pre>
 +
}}
 +
 +
{{SQWareRepositoryTables|tsqwora_AwrPhysicalReadsBef111|
 +
<nowiki>...</nowiki>|
 +
<pre>
 +
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)
 +
</pre>
 +
}}
 +
 +
{{SQWareRepositoryTables|tsqwora_AwrUnOptimizedReads|
 +
<nowiki>...</nowiki>|
 +
<pre>
 +
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)
 +
</pre>
 +
}}
 +
 +
{{SQWareRepositoryTables|tsqwora_AwrWkl|
 +
<nowiki>...</nowiki>|
 +
<pre>
 +
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)
 +
</pre>
 +
}}
 +
 +
{{SQWareRepositoryTables|tsqwora_Fra|
 +
<nowiki>...</nowiki>|
 +
<pre>
 +
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)
 +
</pre>
 +
}}
 +
 +
{{SQWareRepositoryTables|tsqwora_GenInfos|
 +
<nowiki>...</nowiki>|
 +
<pre>
 +
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)
 +
</pre>
 +
}}
 +
 +
{{SQWareRepositoryTables|tsqwora_MaxLog|
 +
<nowiki>...</nowiki>|
 +
<pre>
 +
Field Type
 +
dbalias varchar(80)
 +
gather_date datetime
 +
full_date datetime
 +
sequence decimal(12,2)
 +
thread decimal(12,2)
 +
</pre>
 +
}}
 +
 +
{{SQWareRepositoryTables|tsqwora_Parameters|
 +
<nowiki>...</nowiki>|
 +
<pre>
 +
Field Type
 +
dbalias varchar(80)
 +
gather_date datetime
 +
inst_id decimal(12,2)
 +
name varchar(80)
 +
value varchar(512)
 +
isdefault varchar(9)
 +
</pre>
 +
}}
 +
 +
{{SQWareRepositoryTables|tsqwora_RepositoryDg|
 +
<nowiki>...</nowiki>|
 +
<pre>
 +
Field Type
 +
dbalias_primary varchar(80)
 +
dbalias_standby varchar(80)
 +
</pre>
 +
}}
 +
 +
{{SQWareRepositoryTables|tsqwora_RepositoryRac|
 +
<nowiki>...</nowiki>|
 +
<pre>
 +
Field Type
 +
dbalias varchar(80)
 +
instance_name varchar(80)
 +
virt_host_name varchar(64)
 +
host_name varchar(64)
 +
port decimal(12,2)
 +
</pre>
 +
}}
 +
 +
{{SQWareRepositoryTables|tsqwora_StartedInstances|
 +
<nowiki>...</nowiki>|
 +
<pre>
 +
Field Type
 +
dbalias varchar(80)
 +
gather_date datetime
 +
host_name varchar(64)
 +
username varchar(60)
 +
</pre>
 +
}}
 +
 +
{{SQWareRepositoryTables|tsqwora_VolArchlogs|
 +
<nowiki>...</nowiki>|
 +
<pre>
 +
Field Type
 +
dbalias varchar(80)
 +
gather_date datetime
 +
nb_arch decimal(12,2)
 +
size_arch decimal(12,2)
 +
</pre>
 +
}}
 +
 +
{{SQWareRepositoryTables|tsqwora_VolArchlogsInst|
 +
<nowiki>...</nowiki>|
 +
<pre>
 +
Field Type
 +
dbalias varchar(80)
 +
gather_date datetime
 +
inst_id decimal(12,2)
 +
nb_arch decimal(12,2)
 +
size_arch decimal(12,2)
 +
</pre>
 +
}}
 +
 +
{{SQWareRepositoryTables|tsqwora_VolBackupsMonitoring|
 +
<nowiki>...</nowiki>|
 +
<pre>
 +
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)
 +
</pre>
 +
}}
 +
 +
{{SQWareRepositoryTables|tsqwora_VolPdb|
 +
<nowiki>...</nowiki>|
 +
<pre>
 +
Field Type
 +
dbalias varchar(80)
 +
gather_date datetime
 +
pdb_name varchar(255)
 +
size_pdb decimal(12,2)
 +
free decimal(12,2)
 +
</pre>
 +
}}
 +
 +
{{SQWareRepositoryTables|tsqwora_VolSchema|
 +
<nowiki>...</nowiki>|
 +
<pre>
 +
Field Type
 +
dbalias varchar(80)
 +
gather_date datetime
 +
owner varchar(255)
 +
size_sch decimal(12,2)
 +
</pre>
 +
}}
 +
 +
{{SQWareRepositoryTables|tsqwora_VolSegments|
 +
<nowiki>...</nowiki>|
 +
<pre>
 +
Field Type
 +
dbalias varchar(80)
 +
gather_date datetime
 +
owner varchar(255)
 +
segment_name varchar(255)
 +
segment_type varchar(30)
 +
size_seg decimal(12,2)
 +
</pre>
 +
}}
 +
 +
{{SQWareRepositoryTables|tsqwora_VolTbs|
 +
<nowiki>...</nowiki>|
 +
<pre>
 +
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)
 +
</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


Nuvola apps important.png
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"