Oracle Enterprise Manager Performance Monitoring User's Guide

Library

Product

Contents

Index

Index

# Adj. Free Extents field, 10-6

# Datafiles field

of tablespaces table, 10-6

# Users Active chart, 3-7

# Users Logged On chart, 3-7

# Users Running chart, 3-7

# Users Waiting chart, 3-7

% Free field

of datafiles table, 10-7

of tablespaces table, 10-6

1 line= field

of Segments display, 10-9

3D charts

changing depth of, 4-2

rotating, 4-2

3D View Properties property sheet, 4-2

About Oracle Lock Manager menu item, 8-5

About Oracle Performance Manager menu item, 2-9, 10-5

About Oracle TopSessions menu item, 9-7

ACTION field, 9-11

ACTION_HASH field, 9-11

ALL_TAB_COLUMNS

significance for Oracle TopSessions, 9-1

Area chart type, 2-9

AUDSID field, 9-9

Automatic button

Options Refresh, 9-17

Automatic menu item, 6-3

axes

customizing for a chart, 4-3

specifying values for, 4-3

transposing for a chart, 5-6

Bar chart type, 2-10

Block ID field

of Segments display, 10-9

Blocks field

of Segments display, 10-8

Buffer Cache Hit % chart, 3-3

Buffer Cache Hit chart, 3-7

Buffer Gets Rate chart, 3-3

Change Database Connection

of Oracle Performance Manager, 2-5

Change Database Connection menu item

of Oracle Lock Manager, 8-4

of Oracle TopSessions, 9-5

Change Repository Connection

of Oracle Performance Manager, 2-5

chart definitions

saving and reusing, 7-1

chart legend

clicking the right mouse button on a, 4-4

customizing, 4-4

properties other than location, 4-5

chart type

Area chart type, 2-9

Bar chart type, 2-10

Cube chart type, 2-10

Horizontal Bar chart type, 2-10

Line chart type, 2-9

Pie chart type, 2-10

specifying for a new chart, 5-6

Table chart type, 2-10

chart windows

displaying charts in, 6-1

charts

, 3-3, 3-4, 3-6, 3-7

Buffer Cache Hit % chart, 3-3

Circuit chart, 3-3

complex type, 5-4

customizing display elements of, 4-1

Data Dict Cache Hit %, 3-3

defining new, 5-1

Dispatcher chart, 3-3

File I/O Rate Details chart, 3-4

Latch chart, 3-4

Library Cache Details chart, 3-5

Library Cache Hit % chart, 3-5

Lock chart, 3-5

Memory Allocated chart, 3-5

Memory Sort Hit % chart, 3-5

modifying the basic definition of, 5-10, 5-11

Network Bytes Rate chart, 3-6

No. of Users Logged On chart, 3-6

No. of Users Waiting For Locks chart, 3-7

Overview chart, 3-7

Parse Ratio chart, 3-8

Process chart, 3-8

Queue chart, 3-8

Read Consistency Hit % chart, 3-8

Redo Allocation Hit % chart, 3-9

Redo Statistics Rate chart, 3-9

Rollback Nowait Hit % chart, 3-9

Session chart, 3-9

Shared Server chart, 3-9

sharing chart and window definitions, 7-2

simple type, 5-4

specifying functions for, 5-4

specifying operations for, 5-5

SQL Area chart, 3-10

System Stats chart, 3-10

Table Access chart, 3-10

Table Scan Rows Rate chart, 3-11

Tablespace chart, 3-11

Tablespace Free Space chart, 3-11

Throughput Rate chart, 3-11

transposing axes for, 5-6

types of, 2-9

working with data, 7-1

Charts menu

Performance Manager, 2-7

Circuit chart, 3-3

CLIENT_INFO field, 9-11

Close menu item, 6-2

Coalesce menu item, 10-5

Collapse All menu item

of Oracle Tablespace Manager, 10-5

Collapse Branch menu item

of Oracle Tablespace Manager, 10-5

COMMAND field, 9-9

of Oracle TopSessions main display, 9-7

complex charts

specifying, 5-4

Contention menu item, 2-6

Contents menu item

of Oracle Lock Manager, 8-5

of Oracle Performance Manager, 2-8

of Oracle Tablespace Manager, 10-5

of Oracle TopSessions, 9-6

Count page

of the Options dialog box, 9-18

Cube chart type, 2-10

Current button

of Options Sort page, 9-17

Cursors page, 9-12

customizing

chart legends, 4-4

display elements of charts, 4-1

data

working with in Oracle Performance Manager, 7-1

Data Dict Cache Hit % chart, 3-3

Data Dict Cache Hit chart, 3-7

Database_Instance menu item, 2-6

DBA_DATA_FILES table, 3-11

DBA_FREE_SPACE table, 3-11

DBA_OBJECTS

significance for Oracle Lock Manager, 8-2

DBA_TABLESPACES table, 3-11

DBA_TS_QUOTAS table, 3-11

decimals

overriding default for display in a chart, 4-3

Delete Recorded Data menu item, 2-8

Delta button

of Options Sort page, 9-17

Details menu item, 9-6, 9-8

dialog boxes

Login Information, 1-4

Dimensions menu item, 4-1

Dispatcher chart, 3-3

Display All Sessions button

of Options Count page, 9-18

display area

of a chart window, 6-2

Display menu

of Oracle Performance Manager, 2-6

Display Options page

of New Chart dialog box, 5-3

Display Top N Sessions button

of Options Count page, 9-18

Display Value group

Options Sort, 9-17

drilldown

specifying for a new chart, 5-2

Drilldown menu item, 4-2

example

of defining a new chart, 5-6

Exit menu item

of Oracle Lock Manager, 8-4

of Oracle Performance Manager, 2-5

of Oracle Tablespace Manager, 10-4

of Oracle TopSessions, 9-5

exiting

from Oracle TopSessions, 9-18

Expand One Level menu item

of Oracle Tablespace Manager, 10-4

Extents field

of Segments display, 10-9

File I/O Rate chart, 3-4, 3-7

File I/O Rate Details chart, 3-4

File menu

of Oracle Lock Manager, 8-4

of Oracle Performance Manager, 2-4

of Oracle Tablespace Manager, 10-4

of Oracle TopSessions, 9-5

Filter Folder menu item

of Oracle Tablespace Manager, 10-4

FIXED_TABLE_SEQUENCE field, 9-11

free blocks

joining adjacent, 10-12

Free Blocks field

of datafiles table, 10-6

of tablespaces table, 10-6

Free List Hit % chart, 3-4

function

specifying for a chart, 5-4

General page, 9-9

of Session Details display, 9-9

Help menu

of Oracle Lock Manager, 8-5

of Oracle Performance Manager, 2-8

of Oracle Tablespace Manager, 10-5

of Oracle TopSessions, 9-6

historical data

, 7-7

collecting for display in charts, 7-3

displaying in charts, 7-5

Horizontal Bar chart type, 2-10

I/O menu item, 2-6

Kill menu item, 9-8

of Oracle TopSessions, 9-6

Kill Session menu item

of Oracle Lock Manager, 8-5

labels

specifying in a new chart, 5-4

LAST_CALL_ET field, 9-12

Latch chart, 3-4

legend

customizing for a chart, 4-4

Library Cache Details chart, 3-5

Library Cache Hit % chart, 3-5, 3-7

Line chart type, 2-9

Load Charts menu item

of Oracle Performance Manager, 2-4

Lock chart, 3-5

Lock Type field, 9-14

of Session Details Locks page, 8-6

Lock Types list box, 9-14

locks

obtaining an overview of, 8-5

Locks menu, 8-5

Locks page, 9-13

LOCKWAIT field, 9-10

logarithmic scale

selecting for a chart, 4-4

LOGON_TIME field, 9-12

MACHINE field, 9-10

of Oracle TopSessions main display, 9-7

main window

of Oracle Lock Manager, 8-3

of Oracle Performance Manager, 2-3

of Oracle Tablespace Manager, 10-2

of Oracle TopSessions, 9-3

Manual button

of Options Refresh page, 9-17

Memory Allocated chart, 3-5, 3-7

Memory menu item, 2-6

Memory Sort Hit % chart, 3-5, 3-7

menu bar

of a chart window, 6-2

of Oracle TopSessions, 9-5

of Tablespace Manager, 10-4

Oracle Lock Manager, 8-4

menu items

About Oracle Lock Manager, 8-5

About Oracle Performance Manager menu item, 2-9, 10-5

About Oracle TopSessions menu item, 9-7

Automatic menu item, 6-3

Change Database Connection, 10-4

of Oracle Lock Manager, 8-4

of Oracle Performance Manager, 2-5

of Oracle TopSessions, 9-5

Change Repository Connection

of Oracle Performance Manager, 2-5

Close menu item, 6-2

Coalesce menu item, 10-5

Collapse All menu item

of Oracle Tablespace Manager, 10-5

Collapse Branch menu item

of Oracle Tablespace Manager, 10-5

Contention menu item, 2-6

Contents menu item

of Oracle Lock Manager, 8-5

of Oracle Performance Manager, 2-8

of Oracle Tablespace Manager, 10-5

or Oracle TopSessions, 9-6

Database_Instance menu item, 2-6

Delete Recorded Data menu item, 2-8

Details menu item, 9-6, 9-8

Dimensions menu item, 4-1

Drilldown menu item, 4-2

Exit menu item

of Oracle Lock Manager, 8-4

of Oracle Performance Manager, 2-5

of Oracle Tablespace Manager, 10-4

of Oracle TopSessions, 9-5

Expand One Level menu item

of Oracle Tablespace Manager, 10-4

Filter Folder menu item

of Oracle Tablespace Manager, 10-4

I/O menu item, 2-6

Kill menu item, 9-8

of Oracle TopSessions, 9-6

Load Charts menu item

of Oracle Performance Manager, 2-4

Load menu items, 2-6

Memory menu item, 2-6

Modify SQL Chart menu item, 2-7

Modify Window menu item, 2-7

New SQL Chart menu item, 2-7

New Window menu item, 2-7

Options

Oracle TopSessions, 9-6

Overview menu item, 2-7

Playback menu item, 2-8

Print menu item

of Oracle Performance Manager, 6-2

Print Setup menu item

of Oracle Performance Manager, 2-5

Properties menu item, 4-2

Refresh Data menu item, 10-4

Refresh menu item

of Oracle Tablespace Manager, 10-4

of Oracle TopSessions, 9-6

Save Charts menu item

of Oracle Performance Manager, 2-5

Scale menu item, 4-2

Search for Help On menu item

of Oracle Lock Manager, 8-5

of Oracle Performance Manager, 2-8

of Oracle Tablespace Manager, 10-5

of Oracle TopSessions, 9-7

Start Recording menu item, 2-8

Status Bar menu item

of Oracle Tablespace Manager, 10-5

Statusbar menu item

of Oracle Lock Manager, 8-5

of Oracle TopSessions, 9-6

Stop Recording menu item, 2-8

Toolbar menu item

of Oracle Lock Manager, 8-5

of Oracle Tablespace Manager, 10-5

of Oracle TopSessions, 9-5

Type menu item, 4-2

Update Now menu item, 6-3

User Defined menu item, 2-7

Using Help menu item

of Oracle Lock Manager, 8-5

of Oracle Performance Manager, 2-9

of Oracle Tablespace Manager, 10-5

of Oracle TopSessions, 9-7

menus

File menu

of Oracle Lock Manager, 8-4

of Oracle Performance Manager, 2-4

of Oracle Tablespace Manager, 10-4

of Oracle TopSessions, 9-5

Help menu

of Oracle Lock Manager, 8-5

of Oracle TopSessions, 9-6

Locks menu, 8-5

Sessions menu, 9-6

Tablespace menu, 10-5

View menu

of Oracle Lock Manager, 8-4

of Oracle Tablespace Manager, 10-4

of Oracle TopSessions, 9-5

Mode Held field, 9-14

Mode Requested field, 9-14

Modify Chart property sheet, 5-10, 6-4

Modify SQL Chart menu item, 2-7

Modify Window menu item, 2-7

MODULE field, 9-11

MODULE_HASH field, 9-11

mouse button

using the right, 2-9

Name field

of datafiles table, 10-6

of tablespaces table, 10-6

Network Bytes Rate chart, 3-6

Network I/O Rate chart, 3-6

New Chart property sheet, 5-2

Display Options page, 5-4

SQL Statement page, 5-2

New SQL Chart menu item, 2-7

New Window menu item, 2-7

No. of Users Active, 3-6

No. of Users Logged On chart, 3-6

No. of Users Running chart, 3-6

No. of Users Waiting For Locks chart, 3-7

NoOfBlocks field

of Segments display, 10-9

Object Name field, 9-14

Object Owner field, 9-14

Object Type field, 9-14

ObjectID field, 9-14

operations

specifying for a chart, 5-5

Options dialog box, 9-16, 9-17

Count Page, 9-18

Sort page, 9-16

Oracle Lock Manager

, 8-4, 8-5

main window, 8-3

menus, 8-4

required views to run, 8-2

starting, 8-2

status bar, 8-4

title bar, 8-3

toolbar, 8-3

Oracle Performance Manager

chart types of, 2-9

chart window display area, 6-2

chart window title bar, 6-2

chart window toolbar, 6-2

Charts menu, 2-7

customizing display elements of charts, 4-1

displaying charts in chart windows, 6-1

main window, 2-3

menus, 2-4

overview of features, 1-2

Record menu, 2-8

Refresh menu, 6-2

starting, 2-2

status bar of the chart window, 6-2

title bar, 2-3

using predefined charts, 3-1

using the right mouse button, 2-9

Window menu, 6-2

working with data, 7-1

working with historical data, 7-3

Oracle Tablespace Manager

File menu, 10-4

main window, 10-2

obtaining an overview of datafiles, 10-6

obtaining an overview of tablespaces, 10-5

overview of features, 1-3

starting, 10-1

status bar, 10-3

Tablespace menu, 10-5

toolbar, 10-3

Oracle TopSessions

, 9-5, 9-6

exiting, 9-18

main window, 9-3

menus, 9-5

overview of features, 1-2

required views to run, 9-1

Session Details display, 9-8

Sessions menu, 9-6

starting, 9-2

status bar, 9-5

title bar, 9-4

toolbar, 9-4

OSUSER field, 9-10

of Oracle TopSessions main display, 9-7

Overview chart, 3-7

Overview menu item, 2-7

Owner field

of Segments display, 10-9

PADDR field, 9-9

Parse Ratio chart, 3-8

Pie chart type, 2-10

PLAN_TABLE

significance for Oracle TopSessions, 9-2

Playback menu item, 2-8

predefined charts

, 3-4, 3-5, 3-8, 3-9, 3-10

Buffer Cache Hit % chart, 3-3

Buffer Gets Rate chart, 3-3

Circuit chart, 3-3

Data Dict Cache Hit %, 3-3

default features, 3-1

Dispatcher, 3-3

File I/O Rate chart, 3-4

Free List Hit % chart, 3-4

Latch chart, 3-4

Library Cache Hit % chart, 3-5

Lock chart, 3-5

Memory Sort Hit % chart, 3-5

Network Bytes Rate chart, 3-6

Network I/O Rate chart, 3-6

No. of Users Active chart, 3-6

No. of Users Logged On, 3-6

No. of Users Running chart, 3-6

No. of Users Waiting chart, 3-7

No. of Users Waiting For Locks chart, 3-7

Overview chart, 3-7

overview of, 3-2

Process chart, 3-8

Queue chart, 3-8

Read Consistency Hit % chart, 3-8

Redo Allocation Hit % chart, 3-9

Redo Statistics Rate chart, 3-9

Rollback Nowait Hit % chart, 3-9

scaling of, 3-2

Session chart, 3-9

Sort Rows Rate chart, 3-10

SQL Area chart, 3-10

System I/O Rate chart, 3-10

Table Scan Rows Rate chart, 3-11

tables of, 3-1

Tablespace chart, 3-11

Tablespace Freespace chart, 3-11

Throughput Rate chart, 3-11

PREV_HASH_VALUE field, 9-11

PREV_SQL_ADDR field, 9-10

Print menu item

of Oracle Performance Manager, 6-2

Print Setup menu item

of Oracle Performance Manager, 2-5

Process chart, 3-8

PROCESS field, 9-10

PROGRAM field, 9-10

of Oracle TopSessions main display, 9-7

Properties menu item, 4-2

property sheets

Modify Chart property sheet, 5-10

Modify Charts property sheet, 6-4

New Chart property sheet, 5-2

Options property sheet, 9-16

Queue chart, 3-8

Read Consistency Hit % chart, 3-8

Record menu, 2-8

Redo Allocation Hit % chart, 3-9

Redo Statistics Rate chart, 3-9

Refresh Data menu item, 10-4

Refresh Interval list boxes

of Options Refresh page, 9-17

Refresh menu

of a chart window, 6-2

Refresh menu item

of Oracle Lock Manager, 8-5

of Oracle Tablespace Manager, 10-4

of Oracle TopSessions, 9-6

refresh mode

changing from Oracle TopSessions toolbar, 9-4

Refresh page, 9-17

refresh time

for the Session Details display, 9-15

Oracle TopSessions main display, 9-17

right mouse button

using in Oracle TopSessions, 9-8

Rollback Nowait Hit % chart, 3-7, 3-9

ROW_WAIT_BLOCK# field, 9-11

ROW_WAIT_FILE# field, 9-11

ROW_WAIT_OBJ# field, 9-11

ROW_WAIT_ROW# field, 9-11

SADDR field, 9-9

Save Charts menu item

of Oracle Performance Manager, 2-5

scale

overriding default for a chart, 4-3

selecting linear, 4-4

selecting logarithmic, 4-4

Scale and Numbers property sheet, 4-3

Scale menu item, 4-2

scaling

of predefined charts, 3-2

SCHEMA# field, 9-10

SCHEMANAME field, 9-10

Search for Help On menu item

of Oracle Lock Manager, 8-5

of Oracle Performance Manager, 2-8

of Oracle Tablespace Manager, 10-5

of Oracle TopSessions, 9-7

Secondary Y axis button

of the Scale and Numbers property sheet, 4-3

segments

defragmenting in a tablespace, 10-9

monitoring in a tablespace, 10-7

SERIAL# field, 9-9

SERVER field, 9-10

session activity

obtaining an overview of, 9-7

Session chart, 3-9

Session Details display, 9-8, 9-13

, 9-15

Cursors page, 9-12, 9-13

for multiple sessions simultaneously, 9-15

General page, 9-9

General page of, 9-9

Locks page of, 9-13

Statistics page, 9-12

Statistics page of, 9-12

Session ID field, 9-14

sessions

viewing details about, 9-8

shadows

changing for 3D charts, 4-3

Shared Server chart, 3-9

Show Cursors list box

of Session Details Cursor page, 9-12

Show Explain Plan button

of Session Details Cursors page, 9-12

SID field, 9-9

of Oracle TopSessions main display, 9-7

simple chart

example with drilldown and transposed axes, 5-6

specifying, 5-4

Sort By combo box

of Segments display, 10-8

Sort page, 9-16

Sort Rows Rate chart, 3-10

sort statistic field

of Oracle TopSessions main display, 9-7

Sort Statistic list box

Options Sort page, 9-17

SQL Area chart, 3-10

SQL Statement page

of New Chart property sheet, 5-2

SQL_ADDRESS field, 9-10

SQL_HASH_VALUE field, 9-10

Start Recording menu item, 2-8

starting

from the Console, 1-3

Oracle Performance Manager, 2-2

Oracle Tablespace Manager, 10-1

Oracle TopSessions, 9-2

performance monitoring applications, 1-3

standalone mode, 1-4

Statistic Filter list box

Options Sort, 9-16

Statistics page, 9-12

of Session Details display, 9-12

status

of session, 9-7

status bar

of a chart window, 6-2

of Oracle Lock Manager, 8-4

of Oracle TopSessions, 9-5

Status Bar menu item

of Oracle Tablespace Manager, 10-5

STATUS field, 9-10

of Oracle TopSessions main display, 9-7

Statusbar menu item

of Oracle Lock Manager, 8-5

of Oracle TopSessions, 9-6

Stop Recording menu item, 2-8

SYS.DBA_OBJECTS

significance for Oracle TopSessions, 9-2

System I/O Rate chart, 3-7, 3-10

System Stats chart, 3-10

Table Access chart, 3-10

Table chart type, 2-10

Table Scan Rows Rate chart, 3-11

tables

use in predefined charts, 3-1

Tablespace chart, 3-11

Tablespace Free Space chart, 3-11

Tablespace menu, 10-5

tablespaces

monitoring segments of, 10-7

obtaining an overview of, 10-5

TADDR field, 9-9

TERMINAL field, 9-10

The, 9-6

Throughput chart, 3-7

Throughput Rate chart, 3-11

title bar

of a chart window, 6-2

of Oracle Lock Manager, 8-3

of Oracle Tablespace Manager, 10-3

of Oracle TopSessions, 9-4

toolbar

of a chart window, 6-2

of Oracle Lock Manager, 8-3

of Oracle TopSessions, 9-4

Toolbar menu item

of Oracle Lock Manager, 8-5

of Oracle Tablespace Manager, 10-5

of Oracle TopSessions, 9-5

Total Blocks field

of datafiles table, 10-6

of tablespaces table, 10-6

TYPE field, 9-10

Type field

of Segments display, 10-9

Type menu item, 4-2

Typical Perfomance Monitoring Scenario, 1-5

Update Now menu item, 6-3

User Defined menu item, 2-7

User Name field, 9-14

USER# field, 9-9

USERNAME field, 9-9

of Oracle TopSessions main display, 9-7

Using Help menu item

of Oracle Lock Manager, 8-5

of Oracle Performance Manager, 2-9

of Oracle Tablespace Manager, 10-5

of Oracle TopSessions, 9-7

V$ACCESS view, 3-10

V$CIRCUIT view, 3-3

V$DBFILE view, 3-4

V$DISPATCHER view, 3-3, 3-4

V$FILESTAT view, 3-4

V$LATCH view, 3-4, 3-9

V$LATCHHOLDER view, 3-4

V$LATCHNAME view, 3-4

V$LIBRARYCACHE view, 3-5

V$LICENSE view, 3-6

V$LOCK

significance for Oracle Lock Manager, 8-2

V$LOCK view, 3-5, 9-13

significance for Oracle TopSessions, 9-2

V$OPEN_CURSOR

significance for Oracle TopSessions, 9-2

V$PROCESS view, 3-8, 3-9

V$QUEUE view, 3-8

V$ROLLNAME

significance for Oracle TopSessions, 9-2

V$ROLLNAME view, 3-9, 9-13

V$ROLLSTAT view, 3-9

V$ROWCACHE view, 3-3

V$SESSION

significance for Oracle Lock Manager, 8-2

V$SESSION view, 3-3, 3-5, 3-6, 3-7, 3-8, 3-9, 9-7, 9-9

significance for Oracle TopSessions, 9-1

V$SESSION_WAIT view, 3-6, 3-7

V$SESSSTAT view, 3-5

V$SESSTAT

significance for Oracle TopSessions, 9-1

V$SESSTAT view, 9-12

V$SHARED_SERVER view, 3-3, 3-9

V$SQLAREA view, 3-10

V$SQLTEXT view

significance for Oracle TopSessions, 9-2

V$STATNAME view, 3-5, 9-16

significance for Oracle TopSessions, 9-1

V$SYSSTAT view, 3-3, 3-4, 3-8, 3-9, 3-10, 3-11

V$SYSTEM_EVENT view, 3-6

V$WAITSTAT view, 3-4

View menu

of Oracle Lock Manager, 8-4

of Oracle Tablespace Manager, 10-4

of Oracle TopSessions, 9-5

Window menu

of a chart window, 6-2

windows

components of, 6-1

defining a new, 6-3

modifying existing, 6-4

saving and reusing definitions of, 7-1

X Axis button

of the Scale and Numbers property sheet, 4-3

Y axis

customizing for a chart, 4-3

Prev Next

Copyright © 1996 Oracle Corporation. All Rights Reserved.

Library

Product

Contents

Index