Index

ALL_TAB_COLUMNS

Choose Statistics for Display dialog box, 7-13

analysis

See also analysis

CLIENT_INFO field, 7-12

collected data

definition of, 3-10

COMMAND field, 7-10

running Change Manager from, A-2

command line

comparison

creating, 6-5

creating a new version of, 6-5

creating, naming, saving, and viewing, 5-8

definition of, 5-5

deleting, 6-5

deleting a previous version of, 6-5

exporting, 6-5, 6-7

importing, 6-5, 6-7

viewing, 6-5

viewing a previous version of, 6-5

viewing history entries for, 6-5

working with a particular version of, 6-7

completed task

refreshing the display, 6-6

viewing, 6-7

conceptual help topics

accessing, 5-12

explained, 5-12

configuring

Data Gatherer to collect data, 2-1

connecting

manually to a service, 3-7

to a discovered service, 3-7

to a service, 3-8

constraints

selecting chart, 3-11

Contents menu item

change management objects to a different repository, 6-8

Contents page for help

accessing, 5-11

context-sensitive help

accessing, 5-11

copying

user-defined charts, 3-21

Count page

of the Options dialog box, 7-20

creating

a new version of a baseline, 6-4

a new version of a comparison, 6-5

baseline, 6-4

comparison, 6-5

like user-defined charts, 3-21

user-defined charts, 3-19

Current button

of Options Sort page, 7-18

Cursors page, 7-14

Custom category of statistics

selecting statistics for the, 7-13

custom set of statistics

displaying, 7-13

modifying, 7-13

selecting, 7-13

Custom toolbar button

selecting statistics for the Custom category, 7-13

data

selecting collected, 3-10

Data Gatherer

accessing through intermediate host, 3-2

configuring, 2-1

setting the location of, 3-2

Data Items page in user-defined charts, 3-19

data source

definition of, 3-10

selecting, 3-10

DB Capture application

capturing definitions in a baseline, 5-7

capturing definitions in SQL DDL format, 5-7

DB Diff application

DBA Studio

starting from Change Manager, 6-4

deleting

a previous version of a baseline, 6-4

a previous version of a comparison, 6-5

a task from the History page, 6-6

baseline, 6-4

comparison, 6-5

recordings, 3-19

Delta button

of Options Sort page, 7-19

Details menu item, 7-6, 7-8

Display All Sessions button

of Options Count page, 7-20

Display Top N Sessions button

of Options Count page, 7-20

Display Value group

Options Sort, 7-18

drill-down charts, 3-14

Exit menu item

from Oracle TopSessions, 7-20

exiting

exporting

baseline, 6-4, 6-7

comparison, 6-5, 6-7

File menu

filtering chart data, 3-12

FIXED_TABLE_SEQUENCE field, 7-12

General page, 7-9

of Session Details display, 7-9

glossary

accessing, 5-12

help

accessing the glossary, 5-12

displaying the Contents page, 5-11

finding a particular type of topic, 5-12

finding a specific topic, 5-11

for charts, 3-16

locating a conceptual or task topic, 5-12

obtaining for a particular context, 5-11

using, 5-11

Help menu

for change management tasks, 5-2

hierarchical charts, 3-11

history entries

saving to a file, 6-7

sorting on the History page, 6-7

viewing for a comparison, 6-5

viewing for a task, 6-6

History page

removing a task, 6-6

viewing new history entries for, 6-6

horizontal orientation

importing

in Performance Manager, 3-14

LAST_CALL_ET field, 7-12

line charts, 3-11

Lock Type field, 7-16

Lock Types list box, 7-15

Locks page, 7-15

LOCKWAIT field, 7-10

log (trace) files

location of, A-4

LOGON_TIME field, 7-12

MACHINE field, 7-11

of Oracle Performance Manager, 3-6

main window

of Oracle TopSessions, 7-3

Manual button

of Options Refresh page, 7-19

menu bar

About Oracle TopSessions menu item, 7-7

menu items

Change Database Connection

or Oracle TopSessions, 7-7

Contents menu item

Details menu item, 7-6, 7-8

Exit menu item

Kill menu item, 7-8

Options

Oracle TopSessions, 7-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

Sessions menu, 7-6

View menu

Mode Requested field, 7-16

Mode Held field, 7-16

modifying user-defined charts, 3-20

MODULE field, 7-11

MODULE_HASH field, 7-11

object definitions

capturing using DB Capture, 5-7

comparing using DB Diff, 5-8

supported by change management applications, 5-4

viewing differences between, 5-8

Object Name field, 7-16

Object Owner field, 7-16

Object Type field, 7-16

ObjectID field, 7-16

objects

created by change management applications, 5-5

ocm.properties file

description of properties, A-3

location of, A-2

using to enable tracing and debugging for applications, A-2

Options dialog box, 7-17, 7-19

Count Page, 7-20

Sort page, 7-18

Oracle Data Gatherer

See Data Gatherer

Oracle Enterprise Manager repository

copying change management objects, 6-8

Oracle Index Tuning wizard, 4-1

Oracle Performance Manager

functions of, 3-1

starting, 3-4

usage scenarios for, 3-3

Oracle TopSessions

exiting, 7-20

main window, 7-3

menus, 7-5

required views for, 7-1

Session Details display, 7-9

See Oracle Performance Manager

overview charts

viewing, 3-9

PADDR field, 7-10

Performance Manager

pie chart, 3-11

PLAN_TABLE

PREV_HASH_VALUE field, 7-11

PREV_SQL_ADDR field, 7-11

printing

a chart, 3-16

PROCESS field, 7-11

PROGRAM field, 7-11

Options property sheet, 7-17

property sheets

recommendations

in Analysis report, 4-4

recording chart data, 3-17

recordings

removing, 3-19

starting, 3-17

stopping, 3-18

Recordings folder, 3-6

Refresh Interval list boxes

of Options Refresh page, 7-19

Refresh menu item

changing from Oracle TopSessions toolbar, 7-5

refresh mode

Refresh page, 7-19

refresh time

for the Session Details display, 7-17

Oracle TopSessions main display, 7-19

refreshing

list of completed tasks, 6-6

removing

a task from the History page, 6-6

reports

generating for charts, 3-16

repository

automatically created, 3-5

not connected to, 3-5

required views on a database

for Oracle TopSessions, 7-1

right mouse button

using in Oracle TopSessions, 7-8

right mouse button support

for Change Manager, 6-3

ROW_WAIT_BLOCK# field, 7-12

ROW_WAIT_FILE# field, 7-12

ROW_WAIT_OBJ# field, 7-12

ROW_WAIT_ROW# field, 7-12

SADDR field, 7-9

saving

Performance Manager charts, 3-15

SCHEMA# field, 7-10

SCHEMANAME field, 7-10

Search for Help On menu item

connecting to discovered, 3-7

SERIAL# field, 7-10

SERVER field, 7-10

service

connecting manually, 3-7

session activity

obtaining an overview of, 7-7

Session Details display, 7-9, 7-15

Cursors page, 7-14, 7-15

for multiple sessions simultaneously, 7-17

General page, 7-9

General page of, 7-9

Locks page of, 7-15

Statistics page, 7-12

Statistics page of, 7-12

Session ID field, 7-15

sessions

viewing details about, 7-9

Set Data Gatherer Location menu item, 3-3

Set Options button, 3-13

setting up

Capacity Planner, 2-1

TopSessions, 2-4

Show Cursors list box

of Session Details Cursor page, 7-14

Show Explain Plan button

of Session Details Cursors page, 7-14

Show Overview Charts

menu option, 3-9

toolbar button, 3-9

SID field, 7-10

of Oracle TopSessions main display, 7-7

smptsixx.sql, 2-4

Sort page, 7-18

sort statistic field

data in a table chart, 3-15

Sort Statistic list box

Options Sort page, 7-18

sorting

history entries for completed tasks or manually moved pending tasks, 6-7

SQL script

evaluating in a user-defined chart, 3-19

SQL statements

capturing definitions using DB Capture, 5-7

SQL_ADDRESS field, 7-11

SQL_HASH_VALUE field, 7-11

starting

change management applications from Change Manager, 6-3

Change Manager, 6-1

Oracle Performance Manager, 3-4

Oracle TopSessions, 7-2

Statistic Filter list box

Options Sort, 7-18

statistics

selecting a custom set of statistics to display for a session, 7-13

selecting the statistics to display for a session, 7-12

Statistics page, 7-12

of Session Details display, 7-12

status

of session, 7-8

status bar

Status Bar menu item

STATUS field, 7-10

supported database objects, 5-4

strip charts, 3-11

SYS.DBA_OBJECTS

removing from the History page, 6-6

table charts, 3-11

sorting data in, 3-15

TADDR field, 7-10

task

history entry for, 5-2

viewing completed, 6-7

viewing history entries for, 6-6

viewing new completed tasks, 6-6

task help topics

accessing, 5-12

explained, 5-12

TERMINAL field, 7-11

The, 7-6

title bar

of Oracle TopSessions, 7-4

toolbar

of Oracle TopSessions, 7-4

Toolbar menu item

using the ocm.properties file, A-2

TopSessions

setting up, 2-4

trace files

location of, A-4

tracking changes, 5-6

troubleshooting

TYPE field, 7-11

updating

list of completed tasks, 6-6

usage scenarios

for change management applications, 5-10

for Oracle Performance Manager, 3-3

User Name field, 7-15

USER# field, 7-10

user-defined charts, 3-19

copying, 3-21

creating like, 3-21

Data Items page, 3-19

defining a new chart, 3-19

modifying, 3-20

USERNAME field, 7-10

of Oracle TopSessions main display, 7-7

Using Help menu item

utlxplxx.sql, 2-4

V$LOCK view, 7-15

V$OPEN_CURSOR

V$ROLLNAME

V$ROLLNAME view, 7-15

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

V$SESSTAT

V$SESSTAT view, 7-12

V$SQLTEXT view

V$STATNAME view, 7-18

version

baseline, 6-7

comparison, 6-7

vertical orientation

of a chart, 3-14

View menu