Index
A, B
Absolute values
Active session history (ASH) reports
design
performance degradation
SQL statements
tools
Automaticed database diagnostics and monitoring (ADDM)
description
limitations
memory
performance
report
SQL statements
Automaticed Workload Repository (AWR)
data sets
data sources
load profile section
metrics
Redo size
reports
Average active sessions (AAS)
C
Case studies
alert log example
configuration problem
ADDM report excerpt
category count view
leaf node splits
log file
metrics aggregate view
resource manager metrics
surrogate metric
CPU problem
CPU utilization graph
metrics aggregate view
metrics-based analysis
metrics category count view
metrics time-series view
time ratio graph
server busy errors
DOPA process
metrics aggregate view
metrics time-series view
SQL tuning problem
Category count view
Central limit theorem
Code snippet
Collectively exhaustive (CE) principle
Correlation analysis
coefficient
metric view
time-series view
Create table as select (CTAS)
Custom queries
log file data
v$log_history
D, E
Database tuner
Data preparation
AWR data sources
custom queries (
see
Custom queries)
DBA_HIST_SYSMETRIC_SUMMARY
DBA_HIST_SYSSTAT
delta values conversion
metrics identification
normalization (
see
Normalization data)
union normalized metrics
dba_hist_sqlstat
advisor analysis
database management systems
metrics collection
tables and StatsPack
Decision-making process
Delta values conversion
AWR snapshot period
Oracle’s LAG function
Response Time Per Txn
Dynamic Oracle Performance Analytics (DOPA) process
AWR data
components
AWR metrics
data flow
graphical representation
normalized metrics
overview
customized metrics
decision-making process
flagged metrics
implementation
inputs/set variables (
see
Inputs/Set variables)
metrics time-series view
model-building process
performance tuner
precondition
predictive model
ranking
running
SQL database
taxonomy
F, G
Feature selection
active parallel sessions
clinical blood chemistry analysis
DOPA process
flagged metrics
flagging process
flag ratio
machine learning methods
Oracle performance analysis
performance tuning
predictive model
variable
Flagged values
Flagging process
Flag ratio
H
Heat of battle
I, J
Inputs/Set variables
date range
establishing normals
metric data
problem interval
flagged values
flag ratio
metric name
metric sources
outlier sensitivity settings
taxonomy
K, L
Key-value pair (KVP)
M
Machine learning
applied to ranking
building taxonomies
capacity planning
correlation analysis
definition
methods
metric analysis
tools
Metric frequency distributions
bind variables
histogram
Oracle function
Metrics aggregate view
Metrics analysis
Metrics time-series view
Model-building process
date ranges
flagged values
flag ratio
metric name
metric sources
outlier sensitivity
taxonomy
Model parameters
Monitoring
absolute values
arithmetic expression
automated
costs
DOPA process
high-level requirements, DOPA
implementations, database
key-value pair structure
metric thresholding approach
normal ranges, database
AAS time series
metrics aggregate view
multiple DBs, DOPA process
threshold setting
percentile-based approach
persisting baselines
products
small model approaches
SQL
tools
Multicolumn table (MCT)
Mutually exclusive (ME) principle
N
Normalization data
DBA_HIST_IOSTAT_FUNCTION
KVP format
MCT format
DBA_HIST_LATCH
KVP format
MCT format
DBA_HIST_SYSTEM_EVENT
KVP format
MCT format
SQL code snippet
KVP
MCT
SQL source code
O
Oracle error message
Oracle memory error
Oracle performance analysis
Oracle’s Enterprise Manager (OEM)
ASH analytics
performance
SQL analysis
Oracle taxonomy
DOPA process
subcomponents/subsystems
P, Q
Performance investigation
AAS
ADDM report
AWR report
dba_hist_sqlstat
metrics time-series view
Performance tuners
Postgres/MongoDB
Predictive model
R
Reporting, DOPA process
category count view
metrics aggregate view
metrics time-series view
Review, statistics
mean
variance
S
SQL problem identification
SQL statement
Standard deviation
Statistical analysis
concepts
DBA
DOPA process
AWR retention setting
code
data set
identifying outliers
interquartile range method
IOR calculation
MEAN
normal range of values
removal, outliers
result
single-block latency
standard deviation
values, upper bound
variance
identify metrics
metrics
review
variance calculation
T, U
Taxonomy
definition
infrastructure
table
usage
Three-sigma rule
Time-series graphs
Tuning analysis
V, W, X, Y, Z
Variance calculation, Oracle
central limit theorem
empirical rule
normal distribution
outliers
sample code
standard deviation
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.