Index

ALL_TAB_COLUMNS

adding data from other classes to, 4-34

analysis

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

See Oracle Capacity Planner

AUDSID field, 5-10

Automatic button

Options Refresh, 5-19

auto-scaling

chart data, 4-38

bar charts, 3-11

Broken Jobs event, 6-3

Buffer Cache event, 6-24

Capacity Planner

catbloxx.sql, 2-5

Change Database Connection menu item

Choose Statistics for Display dialog box, 5-13

chart group

definition of, 3-9

charts

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

COMMAND field, 5-10

Data Gatherer to collect data, 2-2

configuring

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

a user-defined class, 4-24

Continued Row event, 6-26

copying

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

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

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

Error Transactions event, 6-5

Event Management

Oracle events, 6-1

excluding a data point from a chart, 4-36

Exit menu item

from Oracle TopSessions, 5-20

exiting

Failed Jobs event, 6-6

Fast Segment Growth event, 6-15

File menu

filtering chart data, 3-12

FIXED_TABLE_SEQUENCE field, 5-12

Free Buffer Wait event, 6-28

General page, 5-9

of Session Details display, 5-9

green dot on class icon in navigator panel

meaning of, 4-18

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

In Memory Sort event, 6-31

Index Rebuild event, 6-30

Kill menu item, 5-8

in Oracle TopSessions, 5-6

in Performance Manager, 3-14

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

selecting the length of time between, 4-11

loader passes

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

MACHINE field, 5-11

of Oracle Performance Manager, 3-6

main window

of Oracle TopSessions, 5-3

Manual button

of Options Refresh page, 5-19

Maximum Extents event, 6-16

menu bar

About Oracle TopSessions menu item, 5-7

menu items

Change Database Connection

or Oracle TopSessions, 5-7

Contents menu item

Details menu item, 5-6, 5-8

Exit menu item

in Oracle TopSessions, 5-6

Kill menu item, 5-8

in Performance Manager, 5-6

Options

Oracle TopSessions, 5-7

Refresh menu item

Search for Help On menu item

Status Bar menu item

Toolbar menu item

Using Help menu item

menus

File menu

Help menu

of Oracle Top Sessions, 5-6

Sessions menu

View menu

Mode Requested field, 5-16

Mode Held 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

Net I/O event, 6-33

Node Fault Management Events, 6-38

Node Performance Management Events, 6-41

Node Space Management Events, 6-40

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

See Oracle Performance Manager

overview charts

viewing, 3-9

PADDR field, 5-10

Performance Manager

performance statistics

projecting, 4-38

pie chart, 3-11

PLAN_TABLE

displaying or hiding the list of, 4-30

predefined analyses

definition, 4-27

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

PROCESS field, 5-11

Process Limit event, 6-22

PROGRAM field, 5-11

Options property sheet, 5-17

property sheets

purging

determining how much historical data to keep before, 4-14

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

changing from Oracle TopSessions toolbar, 5-5

refresh mode

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

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

modifying for class data in an analysis, 4-35

selection criteria

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

data in a table chart, 3-16

Sort Statistic list box

Options Sort page, 5-18

sorting

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

Status Bar menu item

STATUS field, 5-10

collection of data for a data source or data item, 4-18

stopping

strip charts, 3-11

Swap Full event, 6-41

SYS.DBA_OBJECTS

SysStat Table Delta event, 6-37

SysStat Table event, 6-36

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

specifying and performing, 4-39

TopSessions

setting up, 2-5

Trace

formatter tables, 2-7

setting up, 2-7

trend analysis

definition, 4-38

to a point in time, 4-38

to a value, 4-38

troubleshooting

collection and load problems, 4-25

TYPE field, 5-11

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

using Oracle Capacity Planner help, 4-4

utlxplxx.sql, 2-5

V$LOCK view, 5-15

V$OPEN_CURSOR

V$ROLLNAME

V$ROLLNAME view, 5-15

V$SESSION view, 5-7, 5-9

V$SESSTAT

V$SESSTAT view, 5-12

V$SQLTEXT view

V$STATNAME view, 5-18

vertical orientation

of a chart, 3-16

View menu