-- Index

.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

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

.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

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

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

General page, 3-14

generating reports, 4-5

help

displaying, 2-7

Hex event, B-1

Hex_Dump item, B-2

hexadecimal packet dumps, B-3

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

library cache

analyzing performance, 4-8

logical transactions

reporting frequency of, 4-6

LogicalTX event, A-8

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

network duration events, B-4

node

preferred credentials for, 3-18

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

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

reports

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

resource wait times

RowSource event, 1-4, A-8

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

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

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

reporting frequency of, 4-6

wizard

See Collection Wizard

worksheet

See Oracle SQL Worksheet