Oracle Enterprise Manager Oracle Trace User's Guide Go to Product Documentation Library
Library
Go to books for this product
Product
Go to Contents for this book
Contents
Go to Index
Index



Go to previous file in sequence

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 


A

accessing collected data, 1-4
Admin event, B-1
advanced scheduling options, 3-8
ALL event set, 1-4
ALLCLASS event set, 3-5
analyzing fetches and rows, 4-9
analyzing resource wait times, 4-6
Application Programming Interface (API), 1-1
ApplReg event, A-8

B

binary files, 1-8, 3-17, A-7
formatting, 1-4

C

.cdf files
See collection definition files (.cdf)
CF3 event
See cross-facility 3 event
client
required components, 1-6
client/server environment, 1-6
collect.dat file, 1-8
collection definition files (.cdf), 1-7, A-7
defining length of, 3-7
deleting, 2-4, 2-7, 3-21
naming, 3-6
specifying in command-line interface, 3-19
collection entries
deleting, 3-20
Collection menu, 2-6
collection property pages, 3-14
Collection Wizard, 2-6, 3-2
creating collections using, 3-1
collection_eventname.txt file, 4-12
collections
changing options, 3-14
creating, 3-1
creating like, 3-16
definition of, 1-2
deleting, 2-6
displaying general information about, 3-14
duration of, 2-5
formatting to database, 2-6, 3-10
managing, 1-2
scheduling, 3-7
stopping, 3-16
command type
reporting number of executions, 4-10
command-line interface
using, 3-19
Commit interval, 3-18
Connection event, A-8
Connection_ID item, B-3
control files, 1-8
creating collections
using Oracle Trace Collection Wizard, 3-1
creating like collections, 3-16
CROSS_FAC_3 item, B-3
cross-facility 3 event, A-10, B-4
cross-product items
See also cross-facility 3 event, A-9
cursor execution
analyzing rows fetched, 4-9

D

.dat files
See data collection files (.dat)
data collection files (.dat), 3-21, 4-12, A-7
deleting, 2-4, 2-7
database
formatting collection data to, 2-6, 3-10
listing all events in session, 4-10
number of inserts made into, 3-18
reporting activity of, 4-10
DBMS_ORACLE_TRACE_AGENT
stored procedure, 1-9
defining a function, 4-4
deleting collection entries, 3-20
deleting collection files, 3-21
deleting formatted data, 3-20
Detail report, 1-5, A-7
Dev event, B-1
Disconnect event, A-8
discovery process, 1-7
starting from Product menu, 2-7
duration events, 1-3, A-7
calculating elapsed time, 4-4
Duration_Type item, B-3
dynamic link library file, 1-8

E

Edit menu, 2-5
elapsed time
defining a function to calculate, 4-4
epc_collection table, 4-4
EPC_ERROR.LOG file, 2-11
Error event, B-1
error log file, 2-11
errors
during discovery, 2-9
EPC, 2-11
memory access, 2-5
ErrorStack event, A-8
event sets, 1-4, A-3
in Collection Wizard, 3-4
events, 1-3
in SQL*Net, B-1
items associated with, B-3
listing, 4-11
server, A-7
Execute event, 4-7, A-8
exiting Oracle Trace, 2-5

F

facililty.dat files
See also process.dat files, 1-8
Fatal event, 4-11, B-1
.fdf files See product definition files (.fdf)
Fetch event, A-8
File menu, 2-5
format history, 3-15
formatter tables, 1-4
creating, 1-8
formatting collections, 3-19
formatting data, 3-10
using command-line interface, 3-19
formatting options
in Collection Wizard, 3-12
frequency reports
creating, 4-6
Function_ID item, B-2
functions
defining, 4-4

G

General page, 3-14
generating reports, 4-5

H

help
displaying, 2-7
Hex event, B-1
Hex_Dump item, B-2
hexadecimal packet dumps, B-3

I

indexes
defining, 4-3
initialization parameters, 1-3
INIT.ORA file
ORACLE_TRACE_ENABLE parameter, 1-8, 2-11
parameters to control Oracle Trace, A-2
INPUT_IO item, A-9, B-2
installed products
listing, 3-4
instrumentation, 1-1
of Oracle Server, A-7
instrumented events, B-1
instrumented products
discovering, 2-7
items, 1-3
cross-product, A-9
standard resource utilization, A-9, B-2
types of, A-8

L

library cache
analyzing performance, 4-8
logical transactions
reporting frequency of, 4-6
LogicalTX event, A-8

M

managing collections, 1-2
MAXRS_SIZE item, A-9, B-2
memory
error accessing, 2-5
menus
Collection, 2-6
Edit, 2-5
File, 2-5
Help, 2-7
Product, 2-7
View, 2-6
Message item, B-2
messages, 2-11
Migration event, A-8

N

network duration events, B-4
node
preferred credentials for, 3-18

O

occurrence report, 4-5
OEM
See Oracle Enterprise Manager (OEM)
optimizing report performance, 4-7
Oracle Enterprise Manager (OEM), 1-1
starting Oracle Trace from, 2-1
Oracle Intelligent Agent, 1-7
Oracle Server events, A-7
Oracle SQL Worksheet, 4-1
Oracle Trace
SQL*Net events instrumented for, B-1
Oracle Trace Collection Services, 1-7
Oracle Trace Manager, 1-1
Oracle Trace reporting utility
creating reports using, 4-11
$ORACLE_HOME, 3-3, A-3
ORACLE_TRACE_COLLECTION_NAME parameter, A-2
ORACLE_TRACE_COLLECTION_PATH parameter, A-2
ORACLE_TRACE_COLLECTION_SIZE parameter, A-2
ORACLE_TRACE_ENABLE parameter, 1-8, 2-11, A-2
ORACLE_TRACE_FACILITY_NAME parameter, A-2
ORACLE_TRACE_FACILITY_PATH parameter, A-2
otracexx.dll file, 1-8
otrccref.exe image, 2-5
otrcdtl.sql script, 4-7
otrcfmt command, 3-19
otrcfunc.sql script, 4-1, 4-4
otrcrpt1.sql script, 4-5
otrcrpt2.sql script, 4-6
otrcrpt3.sql script, 4-6
otrcrpt4.sql script, 4-6
otrcrpt5.sql script, 4-7
otrcrpt6.sql script, 4-8
otrcrpt7.sql script, 4-9
otrcrpt8.sql script, 4-10
otrcrpt9.sql script, 4-10
otrcrpta.sql script, 4-11
otrcsvr.sql script, 1-9
otrcsyn.sql script, 4-1, 4-2
Output page, 3-15
OUTPUT_IO item, A-9, B-2

P

PAGE_FAULTS item, B-2
PAGEFAULT_IO item, A-9, B-2
PAGEFAULTS item, A-9
parameters
adding or modifying, A-2
Parse event, A-8
performance data
reporting summary of, 4-7
PhysicalTX event, A-8
point events, 1-3, A-7
preferences
defining, 3-17
Preferred credentials
identifying default format using, 3-17
Probe_ID item, B-2
process ID (pid), 4-12
process.dat files, 1-8
product definition files (.fdf), 1-4
creating, 2-7
editing, 2-7
Product menu, 2-7
Progress page, 3-16
property pages, 3-14

R

regid.dat file, 1-8
reports
creating, 4-11
defining elapsed function, 4-1
events for database session, 4-10
frequency of logical transactions, 4-6
frequency of wait events, 4-6
generic templates, 4-5
number of executions per command type, 4-10
optimizing performance of, 4-1
output files created for, 4-12
performance data summary, 4-7
specialized, 4-7
statistical, 4-6
repository, 1-6
resource wait times
analyzing, 4-6
RowSource event, 1-4, A-8

S

sample scripts, 4-1
Schedule page, 3-16
scheduling a collection, 3-7
SCPU item, A-9, B-2
scripts
creating stored procedure packages, 1-9
location of samples, 4-1
otrcdtl.sql, 4-7
otrcfunc.sql, 4-1, 4-4
otrcrpt1.sql, 4-5
otrcrpt2.sql, 4-6
otrcrpt3.sql, 4-6
otrcrpt4.sql, 4-6
otrcrpt5.sql, 4-7
otrcrpt6.sql, 4-8
otrcrpt7.sql, 4-9
otrcrpt8.sql, 4-10
otrcrpt9.sql, 4-10
otrcrpta.sql, 4-11
otrcsyn.sql, 4-1, 4-2
server node
in Collection Wizard, 3-3
required components, 1-7
session
index and serial number variables, 4-10
SQL Parse event, 1-4
SQL statements
generating summary data, 4-7
reporting the number per session, 4-5
SQL*Net events, B-1
SQL*Plus DEFINE command, 4-7
SQLSegment event, A-8
standard resource utilization items, A-9, B-2
starting Oracle Trace, 2-1
statistical functions
generating reports using, 4-6
status messages, 2-6
stopping a collection, 3-16
stored procedures
DBMS_ORACLE_TRACE_AGENT, 1-9
DBMS_ORACLE_TRACE_USER, 1-9
summary data
generating, 4-7
synonyms
defining, 4-2

T

tables
See formatter tables
Time event, B-1
time zone, 3-10
toolbar
enabling or disabling display, 2-6
icons, 2-4
Trace_Masks item, B-2
TRACESVR account, 1-9
troubleshooting, 2-11
conditions to check, A-3

U

UCPU item, A-9, B-2
User event, B-1

V

View menu, 2-6

W

Wait events, A-8
reporting frequency of, 4-6
wizard
See Collection Wizard
worksheet
See Oracle SQL Worksheet


Go to previous file in sequence Prev Oracle
Copyright © 1997 Oracle Corporation.
All Rights Reserved.
Go to Product Documentation Library
Library
Go to books for this product
Product
Go to Contents for this book
Contents
Go to Index
Index