Oracle(R) Enterprise Manager Getting Started with the Oracle Diagnostics Pack
Release 2.1
A76915-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
A
About Oracle TopSessions menu item, 5-7
ACTION field, 5-11
ACTION_HASH field, 5-12
Add New Service button, 3-3,
4-3
Add New Service command, 3-8
Add User-Defined Chart button, 3-21
adding
a data item to a user-defined class, 4-22
advanced events
setting up, 2-1
Agent data gathering service
See Data Gatherer
Alert File Large event, 6-9
ALL_CATALOG
significance for Oracle TopSessions, 5-2
ALL_TAB_COLUMNS
significance for Oracle TopSessions, 5-1
analysis
adding data from other classes to, 4-34
copying, 4-31
creating from a data class, 4-28
generating a report for an, 4-41
identifying user-defined and predefined, 4-30
modifying the selection criteria for an existing, 4-35
printing, 4-41
saving predefined, 4-40
saving results of, 4-40
saving user-defined, 4-40
viewing and modifying an existing, 4-30
See also charts
Analysis window
overview of, 4-33
using the scroll bar, 4-37
zooming in, 4-37
zooming out, 4-37
analyzing
collected historical data, 4-26
annotation box
moving in an analysis chart, 4-40
Archive Full (%) event, 6-11
Archive Full event, 6-10
Archiver Hung event, 6-2
AUDIT_ACTIONS
significance for Oracle TopSessions, 5-2
AUDSID field, 5-10
Automatic button
Options Refresh, 5-19
auto-scaling
chart data, 4-38
B
bar charts, 3-11
Broken Jobs event, 6-3
Buffer Cache event, 6-24
C
Capacity Planner
See Oracle Capacity Planner
catbloxx.sql, 2-5
Change Database Connection menu item
of Oracle TopSessions, 5-6
chart group
definition of, 3-9
charts
auto-scaling the data included in, 4-38
chart-specific commands, 3-14
constraints, 3-11
displaying or hiding the chart legend, 4-36
drilling down, 3-14
excluding data points from, 4-36
filtering chart data, 3-12
formats of, 3-11
generating reports for, 3-18
getting help on, 3-18
hiding the chart legend, 4-36
orientations, 3-16
printing, 3-18
removing lines from, 4-35
saving your changes, 3-17
scaling the data in, 4-38
selecting a line in, 4-34
setting chart options, 3-12
sorting data in table, 3-16
viewing, 3-8
viewing the values of data points in, 4-33
See also analysis
Choose Statistics for Display dialog box, 5-13
Chunk Small event, 6-12
class
contents of data tables in the historical database, 4-44
definition of, 4-15
modifying selection criteria for including in an analysis, 4-35
names of data tables in the historical database, 4-43
specifying for historical data collection, 4-15
specifying selection criteria for including in an analysis, 4-29
understanding the data tables in the historical database, 4-43
class reference table
understanding, 4-43
CLIENT_INFO field, 5-12
collected data
analyzing, 4-26
browsing, 4-27
definition of, 3-10
collection frequency
specifying for a service, 4-9
collection problems
troubleshooting, 4-25
COMMAND field, 5-10
of Oracle TopSessions main display, 5-8
configuring
Data Gatherer to collect data, 2-2
connecting
manually to a service, 3-7
to a discovered service, 3-7
to a service, 3-8
to an historical database, 4-26
constraints
selecting chart, 3-11
Contents menu item
of Oracle TopSessions, 5-7
Continued Row event, 6-26
copying
a user-defined class, 4-24
an analysis, 4-31
user-defined charts, 3-23
Count page
of the Options dialog box, 5-20
CPU Paging Rate event, 6-42
CPU Utilization event, 6-41,
6-42
creating
a copy of an analysis, 4-31
a user-defined class, 4-20
an analysis from a data class, 4-28
classes like existing user-defined classes, 4-24
like user-defined charts, 3-23
Trace Formatter tables, 2-7
user-defined charts, 3-21
Current button
of Options Sort page, 5-18
Cursors page, 5-14
Custom category of statistics
selecting statistics for the, 5-13
custom set of statistics
displaying, 5-13
modifying, 5-13
selecting, 5-13
Custom toolbar button
selecting statistics for the Custom category, 5-13
D
data
analyzing collected, 4-26
browsing collected, 4-27
determining what is being collected, 4-17
organization of collected, 4-27
selecting collected, 3-10
Data Block Corruption event, 6-4
data class
definition of, 4-16
in Capacity Planner analysis view, 4-27
modifying selection criteria, 4-35
saving as an analysis, 4-28
specifying for historical data collection, 4-15
specifying selection criteria for, 4-29
viewing an analysis for, 4-28
data collection
See historical data collection
Data Dictionary Cache event, 6-27
Data Gatherer
accessing through intermediate host, 3-2,
4-3
checking the log file, 4-25
checking the status of, 4-25
configuring, 2-2
setting the location of, 3-2,
4-3
troubleshooting, 4-25
Data Gatherer Alert event, 6-38
Data Gatherer UpDown (Node) event, 6-39
data item
adding to a user-defined class, 4-22
definition of, 4-17
modifying in a user-defined class, 4-22
removing from a user-defined class, 4-22
selecting for collection, 4-17
stopping collection for a, 4-18
Data Items page in user-defined charts, 3-21
data point
displaying a currently excluded point in a chart, 4-36
excluding from a chart, 4-36
viewing the value of a, 4-33
data samples
specifying the length of time between, 4-10
specifying the number to collect for a time interval, 4-10
data source
definition of, 3-10,
4-17
designating for a user-defined class, 4-21
examples of, 4-17
selecting, 3-10
selecting for collection, 4-17
stopping collection for a, 4-18
Database Alert event, 6-2
Database Fault Management Events, 6-2
Database Resource Management Events, 6-20
Datafile Limit event, 6-21
Deferred Transactions event, 6-5
deleting
a data item from a user-defined class, 4-22
lines from a chart, 4-35
recordings, 3-21
user-defined analysis, 4-32
user-defined classes, 4-25
Delta button
of Options Sort page, 5-19
designating a data source for a user-defined class, 4-21
Details menu item, 5-6,
5-8
disconnecting
from historical database, 4-26
Disk Full (%) event, 6-40
Disk Full event, 6-40
Disk I/O event, 6-28
Display All Sessions button
of Options Count page, 5-20
Display Top N Sessions button
of Options Count page, 5-20
Display Value group
Options Sort, 5-18
displaying
a chart legend, 4-36
existing user-defined analyses, 4-30
predefined analyses, 4-30
drill-down charts, 3-14
drilling down to historical data, 3-15
Dump Full (%) event, 6-14
Dump Full event, 6-14
E
Error Transactions event, 6-5
Event Management
Oracle events, 6-1
excluding a data point from a chart, 4-36
Exit menu item
of Oracle TopSessions, 5-6
exiting
from Oracle TopSessions, 5-20
F
Failed Jobs event, 6-6
Fast Segment Growth event, 6-15
File menu
of Oracle TopSessions, 5-5
filtering chart data, 3-12
FIXED_TABLE_SEQUENCE field, 5-12
Free Buffer Wait event, 6-28
G
General page, 5-9
of Session Details display, 5-9
green dot on class icon in navigator panel
meaning of, 4-18
H
help
accessing for Oracle Capacity Planner, 4-4
for charts, 3-18
Help menu in Oracle TopSessions, 5-7
hiding
a chart legend, 4-36
the list of predefined analyses, 4-30
hierarchical charts, 3-11
historical data collection
aggregation of data in, 4-12
setting up a, 4-6
specifying a service for, 4-7
specifying the age of the data saved for analysis, 4-14
specifying the classes of data to collect, 4-15
stopping for a class of data, 4-18
historical database
connecting to, 4-26
contents of data tables for classes in, 4-44
disconnecting from, 4-26
names of data tables for a class, 4-43
specifying the location of a, 4-11
understanding the class reference table, 4-43
understanding the data tables for a class in, 4-43
understanding the logical structure of, 4-42
understanding the service reference table, 4-42
unsupported modifications to, 4-42
horizontal orientation
of a chart, 3-16
I
In Memory Sort event, 6-31
Index Rebuild event, 6-30
K
Kill menu item, 5-8
in Oracle TopSessions, 5-6
in Performance Manager, 3-14
L
LAST_CALL_ET field, 5-12
Library Cache event, 6-32
line charts, 3-11
load frequency
specifying for a service, 4-11
load problems
troubleshooting, 4-25
loader passes
selecting the length of time between, 4-11
selecting the number for a time interval, 4-11
Lock Limit event, 6-21
Lock Type field, 5-16
Lock Types list box, 5-15
Locks page, 5-15
LOCKWAIT field, 5-10
log file for Data Gatherer, 4-25
LOGON_TIME field, 5-12
M
MACHINE field, 5-11
of Oracle TopSessions main display, 5-8
main window
of Oracle Performance Manager, 3-6
of Oracle TopSessions, 5-3
Manual button
of Options Refresh page, 5-19
Maximum Extents event, 6-16
menu bar
of Oracle TopSessions, 5-5
menu items
About Oracle TopSessions menu item, 5-7
Change Database Connection
of Oracle TopSessions, 5-6
Contents menu item
or Oracle TopSessions, 5-7
Details menu item, 5-6,
5-8
Exit menu item
of Oracle TopSessions, 5-6
Kill menu item, 5-8
in Oracle TopSessions, 5-6
in Performance Manager, 5-6
Options
Oracle TopSessions, 5-7
Refresh menu item
of Oracle TopSessions, 5-6
Search for Help On menu item
of Oracle TopSessions, 5-7
Status Bar menu item
of Oracle TopSessions, 5-6
Toolbar menu item
of Oracle TopSessions, 5-6
Using Help menu item
of Oracle TopSessions, 5-7
menus
File menu
of Oracle TopSessions, 5-5
Help menu
of Oracle TopSessions, 5-7
Sessions menu
of Oracle Top Sessions, 5-6
View menu
of Oracle TopSessions, 5-6
Mode Held field, 5-16
Mode Requested field, 5-16
modifying
a data item in a user-defined class, 4-22
existing analysis, 4-30
selection criteria for a class of data in an analysis chart, 4-35
user-defined classes, 4-23
modifying user-defined charts, 3-22
MODULE field, 5-11
MODULE_HASH field, 5-11
moving
annotation box in an analysis chart, 4-40
Multiple Extents event, 6-17
N
Net I/O event, 6-33
Node Fault Management Events, 6-38
Node Performance Management Events, 6-41
Node Space Management Events, 6-40
O
Object Name field, 5-16
Object Owner field, 5-16
Object Type field, 5-16
ObjectID field, 5-16
Options dialog box, 5-17,
5-19
Count Page, 5-20
Sort page, 5-18
Oracle Capacity Planner
drilling down to, 3-15
functions of, 4-1
how it collects and stores data, 4-2
setting up, 2-2
starting, 4-4
two-step process for using, 4-5
usage scenarios for, 4-4
Oracle Data Gatherer
See Data Gatherer
Oracle events, 6-1
Oracle Performance Manager
functions of, 3-1
setting up, 2-2
starting, 3-4
usage scenarios for, 3-3
Oracle TopSessions
exiting, 5-20
main window, 5-3
menus, 5-5
required views for, 5-1
Session Details display, 5-9
Sessions menu, 5-6
starting, 5-2
status bar, 5-5
title bar, 5-4
toolbar, 5-4
OSUSER field, 5-10
of Oracle TopSessions main display, 5-8
overview charts
viewing, 3-9
P
PADDR field, 5-10
Performance Manager
See Oracle Performance Manager
performance statistics
projecting, 4-38
pie chart, 3-11
PLAN_TABLE
significance for Oracle TopSessions, 5-2
predefined analyses
definition, 4-27
displaying or hiding the list of, 4-30
identifying icon, 4-30
PREV_HASH_VALUE field, 5-11
PREV_SQL_ADDR field, 5-11
printing
a chart, 3-18
an analysis, 4-41
Probe event, 6-7
problems
troubleshooting, 4-25
PROCESS field, 5-11
Process Limit event, 6-22
PROGRAM field, 5-11
of Oracle TopSessions main display, 5-8
property sheets
Options property sheet, 5-17
purging
determining how much historical data to keep before, 4-14
R
recording chart data, 3-19
recordings
removing, 3-21
starting, 3-19
stopping, 3-19
Recordings folder, 3-6
Redo Log Allocation event, 6-34
Refresh Interval list boxes
of Options Refresh page, 5-19
Refresh menu item
of Oracle TopSessions, 5-6
refresh mode
changing from Oracle TopSessions toolbar, 5-5
Refresh page, 5-19
refresh time
for the Session Details display, 5-17
Oracle TopSessions main display, 5-19
removing
a data item from a user-defined class, 4-22
a line from a chart, 4-35
renaming
a data item in a user-defined class, 4-22
a user-defined analysis, 4-32
a user-defined class, 4-23
report
generating for an analysis report, 4-41
reports
generating for charts, 3-18
repository
automatically created, 3-5
not connected to, 3-6
required views on a database
for Oracle TopSessions, 5-1
right mouse button
using in Oracle TopSessions, 5-8
Rollback Contention event, 6-35
ROW_WAIT_BLOCK# field, 5-12
ROW_WAIT_FILE# field, 5-12
ROW_WAIT_OBJ# field, 5-12
ROW_WAIT_ROW# field, 5-12
S
SADDR field, 5-9
saving
analysis results, 4-40
class data as a user-defined analysis, 4-28
Performance Manager charts, 3-17
SCHEMA# field, 5-10
SCHEMANAME field, 5-10
scrolling
in the Analysis window, 4-37
Search for Help On menu item
of Oracle TopSessions, 5-7
selection criteria
modifying for class data in an analysis, 4-35
SERIAL# field, 5-10
SERVER field, 5-10
service
connecting manually, 3-7
connecting to discovered, 3-7
selecting for historical data collection, 4-7
specifying the classes of data to collect from, 4-15
specifying the collection frequency for, 4-9
specifying the load frequency for, 4-11
service reference table
understanding, 4-42
session activity
obtaining an overview of, 5-7
Session Details display, 5-9,
5-15
Cursors page, 5-14,
5-15
for multiple sessions simultaneously, 5-17
General page, 5-9
General page of, 5-9
Locks page of, 5-15
Statistics page, 5-12
Statistics page of, 5-12
Session ID field, 5-15
Session Limit event, 6-23
Session Terminated event, 6-7
sessions
viewing details about, 5-9
Set Data Gatherer Location menu item, 3-3,
4-3
Set Options button, 3-13
setting up
Advanced Events, 2-1
Capacity Planner, 2-2
Performance Manager, 2-2
TopSessions, 2-5
Trace, 2-7
Show Cursors list box
of Session Details Cursor page, 5-14
Show Explain Plan button
of Session Details Cursors page, 5-14
Show Overview Charts
menu option, 3-9
toolbar button, 3-9
SID field, 5-10
of Oracle TopSessions main display, 5-7
smptsixx.sql, 2-5
SnapShot Log Full event, 6-19
Sort page, 5-18
sort statistic field
of Oracle TopSessions main display, 5-8
Sort Statistic list box
Options Sort page, 5-18
sorting
data in a table chart, 3-16
SQL script
evaluating in a user-defined chart, 3-21
SQL_ADDRESS field, 5-11
SQL_HASH_VALUE field, 5-11
starting
Oracle Capacity Planner, 4-4
Oracle Performance Manager, 3-4
Oracle TopSessions, 5-2
Statistic Filter list box
Options Sort, 5-18
statistics
selecting a custom set of statistics to display for a session, 5-13
selecting the statistics to display for a session, 5-12
Statistics page, 5-12
of Session Details display, 5-12
status
of session, 5-8
status bar
of Oracle TopSessions, 5-5
Status Bar menu item
of Oracle TopSessions, 5-6
STATUS field, 5-10
of Oracle TopSessions main display, 5-8
stopping
collection of data for a data source or data item, 4-18
strip charts, 3-11
Swap Full event, 6-41
SYS.DBA_OBJECTS
significance for Oracle TopSessions, 5-2
SysStat Table Delta event, 6-37
SysStat Table event, 6-36
T
table charts, 3-11
sorting data in, 3-16
Tablespace Full event, 6-20
TADDR field, 5-10
TERMINAL field, 5-11
The, 5-6
title bar
of Oracle TopSessions, 5-4
toolbar
of Oracle TopSessions, 5-4
Toolbar menu item
of Oracle TopSessions, 5-6
TopSessions
setting up, 2-5
Trace
formatter tables, 2-7
setting up, 2-7
trend analysis
definition, 4-38
specifying and performing, 4-39
to a point in time, 4-38
to a value, 4-38
troubleshooting
collection and load problems, 4-25
TYPE field, 5-11
U
Unscheduled Jobs event, 6-8
usage scenarios
for Oracle Capacity Planner, 4-4
for Oracle Performance Manager, 3-3
User Audit event, 6-37
User Blocks event, 6-9
User Limit event, 6-23
User Name field, 5-15
USER# field, 5-10
user-defined analysis
creating, 4-28
definition, 4-27
deleting, 4-32
identifying icon, 4-30
renaming, 4-32
user-defined charts, 3-21
copying, 3-23
creating like, 3-23
Data Items page, 3-21
defining a new chart, 3-21
modifying, 3-22
restriction when drilling down, 3-15
user-defined class
adding a data item to, 4-22
copying, 4-24
creating, 4-20
creating another class like, 4-24
deleting, 4-25
designating a data source for, 4-21
modifying, 4-23
modifying a data item in, 4-22
removing a data item from, 4-22
specifying the SQL statement to create, 4-20
starting collection for, 4-21
stopping collection for, 4-25
USERNAME field, 5-10
of Oracle TopSessions main display, 5-7
Using Help menu item
of Oracle TopSessions, 5-7
using Oracle Capacity Planner help, 4-4
utlxplxx.sql, 2-5
V
V$LOCK view, 5-15
significance for Oracle TopSessions, 5-1
V$OPEN_CURSOR
significance for Oracle TopSessions, 5-1
V$ROLLNAME
significance for Oracle TopSessions, 5-2
V$ROLLNAME view, 5-15
V$SESSION view, 5-7,
5-9
significance for Oracle TopSessions, 5-1
V$SESSTAT
significance for Oracle TopSessions, 5-1
V$SESSTAT view, 5-12
V$SQLTEXT view
significance for Oracle TopSessions, 5-1
V$STATNAME view, 5-18
significance for Oracle TopSessions, 5-1
vertical orientation
of a chart, 3-16
View menu
of Oracle TopSessions, 5-6
viewing
an analysis of a data class, 4-28
an existing analysis, 4-30
chart data by zooming and scrolling, 4-37
overview charts, 3-9
Performance Manager charts, 3-8
the selection criteria for a class of data in an analysis, 4-35
views
required by Oracle TopSessions, 5-1
Z
zoom buttons
on Analysis window toolbar, 4-37
Prev
Copyright © 2000 Oracle Corporation.
All Rights Reserved.
Library
Product
Contents