Oracle(R) Enterprise Manager Oracle(R) Trace User's Guide
Release 2.0
A67837-01

Library
Product
Contents

Prev

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
Oracle
Copyright © 1999 Oracle Corporation.
All Rights Reserved.

Library
Product
Contents