Oracle(R) Enterprise Manager Oracle(R) Trace User's Guide
Release 2.0
A67837-01
Library
Product
Contents
Index
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
S
T
U
V
W
X
Y
Z
Symbols
$ORACLE_HOME, A-5
A
accessing collected data, 1-4
advanced scheduling options, 3-13
ALL event set, 1-4,
3-5,
A-4
Application Programming Interface (API), 1-1
ApplReg event, B-1
Average Elapsed Time data view, 4-8
B
Basic Statistics for Parse/Execute/Fetch drill-down data view, 4-17
binary files, 1-7,
3-22,
A-6
formatting, 1-4
C
CACHEIO event set, 3-5,
A-4
.cdf files
See
collection definition files (.cdf)
client
required components, 1-5
client/server environment, 1-5
collect.dat file, 1-8
collection definition files (.cdf), 1-6,
A-6
defining length of, 3-12
deleting, 2-8,
2-11,
3-25
naming, 3-10
collection entries
deleting, 3-24
Collection menu, 2-10
collection property pages, 3-19
Collection Wizard, 2-10,
3-2
creating collections using, 3-1
collections
changing options, 3-19
creating, 3-1
creating like, 3-22
definition of, 1-2
deleting, 2-10
displaying general information about, 3-20
duration of, 2-9
formatting to database, 2-10,
3-16
managing, 1-2
scheduling, 3-12
stopping, 3-22
collections in Oracle Trace, A-3
Commit interval, 3-24
Connection event, B-1
control files, 1-8
CPU Statistics data view, 4-9
CPU Statistics for Parse/Execute/Fetch drill-down data view, 4-17
creating collections
using Oracle Trace Collection Wizard, 3-1
creating like collections, 3-22
cross-facility 3 event, B-4
cross-product items
See also
cross-facility 3 event, B-3
D
data collection files (.dat), 3-25,
A-6
deleting, 2-8,
2-11
Data View wizard
choosing an event, 4-20
choosing items, 4-21
choosing sort criteria, 4-23
creating data views using, 4-19
defining number of rows, 4-23
Data Viewer, 4-1
computing statistics, 4-5
starting, 4-2
tips on using
collect data for specific wait events, C-15
usage scenarios, 4-2
data views
creating, 4-13
definition of, 4-1
definitions, 4-10
displaying, 4-5
drill down to related events, 4-14
drill-down
selecting, 4-17
modifying, 4-13
descriptions, 4-14
options, 4-14
sort order, 4-14
options, 4-10
saving, 4-19
See also
drill-down data views, 4-1
SQL statement, 4-12
statistics, 4-11,
4-13
viewing data, 4-11
data views in Oracle Trace
Average Elapsed Time, 4-8
CPU Statistics, 4-9
Disk Reads, 4-7
Disk Reads/Execution Ratio, 4-7
Disk Reads/Logical Reads Ratio, 4-8
Disk Reads/Rows Fetched Ratio, 4-7
Execute Elapsed Time, 4-9
Fetch Elapsed Time, 4-9
Logical Reads, 4-7
Logical Reads/Rows Fetched Ratio, 4-7
Number of Rows Processed, 4-9
Parse Elapsed Time, 4-9
Parse/Execution Ratio, 4-8
Re-Parse Frequency, 4-8
Rows Fetched/Fetch Count Ratio, 4-9
Rows Sorted, 4-10
Sorts in Memory, 4-10
Sorts on Disk, 4-10
Total Elapsed Time, 4-8
Waits by Average Wait Time, 4-10
Waits by Event Frequency, 4-10
Waits by Total Wait Time, 4-10
database
formatting collection data to, 2-10,
3-16
number of inserts made into, 3-24
DBMS_ORACLE_TRACE_AGENT
stored procedure, 1-7
DEFAULT event set, 3-5,
A-4
deleting collection files, 3-25
deleting formatted data, 3-25
Detail report, 1-5
Disconnect event, B-1
discovery process, 1-6
starting from Product menu, 2-11
Disk Reads data view, 4-7
Disk Reads/Execution Ratio data view, 4-7
Disk Reads/Logical Reads Ratio data view, 4-8
Disk Reads/Rows Fetched Ratio data view, 4-7
drill-down
of data views, 4-14
drill-down data views
descriptions, 4-15
modifying, 4-18
selecting, 4-17
SQL statement, 4-16
statistics, 4-16
drill-down data views in Oracle Trace
Basic Statistics for Parse/Execute/Fetch, 4-17
CPU Statistics for Parse/Execute/Fetch, 4-17
I/O Statistics for Parse/Execute/Fetch, 4-17
Parse Statistics, 4-17
Row Statistics for Execute/Fetch, 4-17
duration events, 1-3,
B-1
dynamic link library file, 1-8
E
Edit menu, 2-9
EPC_ERROR.LOG file, C-23
errors
during discovery, 2-2
ErrorStack event, B-1
event sets, 1-4,
A-4
in Collection Wizard, 3-4
events, 1-3
server, B-1
Execute Elapsed Time data view, 4-9
Execute event, B-2
exiting Oracle Trace, 2-9
EXPERT event set, 3-5,
A-4
F
facililty.dat files
See also
process.dat files, 1-8
.fdf files
See
product definition files (.fdf)
Fetch Elapsed Time data view, 4-9
Fetch event, B-2
File menu, 2-9
FORMAT command in Oracle Trace, A-1,
A-2
format history, 3-21
formatter tables
creating, 1-7
formatting collections, 3-26
formatting data, 3-16
formatting options
in Collection Wizard, 3-17
G
General page, 3-20
H
help
displaying, 2-11
I
initialization parameters, 1-3,
A-3
INIT.ORA file
ORACLE_TRACE_ENABLE parameter, 1-7,
C-16
INPUT_IO item, B-3
installed products
listing, 3-4
instrumentation, 1-1
of Oracle Server, B-1
I/O Statistics for Parse/Execute/Fetch drill-down data view, 4-17
items, 1-3
cross-product, B-3
standard resource utilization, B-2
types of, B-2
L
Logical Reads data view, 4-7
Logical Reads/Rows Fetched Ratio data view, 4-7
LogicalTX event, B-2
M
managing collections, 1-2
MAXRS_SIZE item, B-3
menus
Collection, 2-10
Edit, 2-9
File, 2-9
Help, 2-11
Product, 2-11
View, 2-9
Migration event, B-1
N
node
preferred credentials for, 3-24
Number of Rows Processed data view, 4-9
O
OEM
See
Oracle Enterprise Manager (OEM)
Oracle Enterprise Manager, 1-2
starting Oracle Trace from, 2-1
Oracle Intelligent Agent, 1-6
Oracle Server events, B-1
Oracle Trace
collections, A-3
command-line interface, A-1
data views
Average Elapsed Time, 4-8
CPU Statistics, 4-9
Disk Reads, 4-7
Disk Reads/Execution Ratio, 4-7
Disk Reads/Logical Reads Ratio, 4-8
Disk Reads/Rows Fetched Ratio, 4-7
Execute Elapsed Time, 4-9
Fetch Elapsed Time, 4-9
Logical Reads, 4-7
Logical Reads/Rows Fetched Ratio, 4-7
Number of Rows Processed, 4-9
Parse Elapsed Time, 4-9
Parse/Execution Ratio, 4-8
Re-Parse Frequency, 4-8
Rows Fetched/Fetch Count Ratio, 4-9
Rows Sorted, 4-10
Sorts in Memory, 4-10
Sorts on Disk, 4-10
Total Elapsed Time, 4-8
Waits by Average Wait Time, 4-10
Waits by Event Frequency, 4-10
Waits by Total Wait Time, 4-10
deleting files, A-3
drill-down data views
Basic Statistics for Parse/Execute/Fetch, 4-17
CPU Statistics for Parse/Execute/Fetch, 4-17
I/O Statistics for Parse/Execute/Fetch, 4-17
Parse Statistics, 4-17
Row Statistics for Execute/Fetch, 4-17
FORMAT command, A-1,
A-2
formatting data, A-7
reporting utility, A-9
START command, A-1
STOP command, A-1,
A-2
Oracle Trace Collection Services, 1-6
Oracle Trace Data Viewer
See
Data Viewer, 4-1
Oracle Trace Manager, 1-1,
A-4
ORACLE_TRACE_COLLECTION_NAME parameter, A-3,
A-4
ORACLE_TRACE_COLLECTION_PATH parameter, A-3
ORACLE_TRACE_COLLECTION_SIZE parameter, A-3
ORACLE_TRACE_ENABLE parameter, 1-7,
A-3,
C-16
ORACLE_TRACE_FACILITY_NAME parameter, A-3,
A-4
ORACLE_TRACE_FACILITY_PATH parameter, A-3
otracexx.dll file, 1-8
otrcfmt command, A-7
otrcfmtc.sql script, A-7
otrcsvr.sql script, 1-7
Output page, 3-21
OUTPUT_IO item, B-3
P
PAGEFAULT_IO item, B-3
PAGEFAULTS item, B-3
Parse Elapsed Time data view, 4-9
Parse event, B-2
Parse Statistics drill-down data view, 4-17
Parse/Execution Ratio data view, 4-8
PhysicalTX event, B-2
point events, 1-3,
B-1
preferences
defining, 3-23
Preferred credentials
identifying default format using, 3-23
process.dat files, 1-8
product definition files (.fdf), 1-4
creating, 2-11
editing, 2-11
Product menu, 2-11
Progress page, 3-22
property pages, 3-19
R
regid.dat file, 1-8
Re-Parse Frequency data view, 4-8
repository, 1-6
Row Statistics for Execute/Fetch drill-down data views, 4-17
Rows Fetched/Fetch Count Ratio data view, 4-9
Rows Sorted data view, 4-10
RowSource event, 1-4,
B-1
S
Schedule page, 3-21
scheduling a collection, 3-12
SCPU item, B-2
scripts
creating stored procedure packages, 1-7
server node
in Collection Wizard, 3-3
required components, 1-6
Sorts in Memory data view, 4-10
Sorts on Disk data view, 4-10
SQL Parse event, 1-3
SQL statements
in data views, 4-12
of drill-down data views, 4-16
SQLSegment event, B-1
standard resource utilization items, B-2
START command in Oracle Trace, A-1
starting Data Viewer, 4-2
from Oracle Enterprise Manager Program Group, 4-3
from within Oracle Trace, 4-3
starting Oracle Trace, 2-1
statistics
computing using Data Viewer, 4-5
of data views, 4-11,
4-13
of drill-down data views, 4-16
status messages, 2-10
STOP command in Oracle Trace, A-1,
A-2
stopping a collection, 3-22
stored procedures
DBMS_ORACLE_TRACE_AGENT, 1-7
DBMS_ORACLE_TRACE_USER, 1-7
SUMMARY event set, 3-5,
A-4
T
tables
See
formatter tables
time zone, 3-15
toolbar
enabling or disabling display, 2-10
icons, 2-7
Total Elapsed Time data view, 4-8
TRACESVR account, 1-7
troubleshooting
conditions to check, A-5
U
UCPU item, B-2
usage scenarios
for Data Viewer, 4-2
V
View menu, 2-9
W
Wait events, B-1
Waits by Average Wait Time data view, 4-10
Waits by Event Frequency data view, 4-10
Waits by Total Wait Time data view, 4-10
wizard
See
Collection Wizard
See
Data View wizard, 4-19
Prev
Copyright © 1999 Oracle Corporation.
All Rights Reserved.
Library
Product
Contents