|
Obtaining a Memory Statistical Information
using OEM
Introduction
As a DBA, you
are responsible for obtaining statistical
information about the memory for performance
and tuning purposes. The following is a
summary of your task:
Covers:
Using the
Diagnostics Pack Tool
Selecting a
target database
Obtaining
Session CPU Activity
Obtaining
Session Memory Use
Obtaining
Session Efficiency
Obtaining
Memory Size
Obtaining I/O
statistics
Obtaining
Session Identification
Obtaining
detailed session information
Obtaining SQL
statements
Hands-on
In this
exercise you will learn how to get
statistical information about a session,
such as "Session CPU Activity," "Session
Memory Use," "Session Efficiency," "Memory
Sizes," "Session I/O statistics" "Session
Identification" and etc from the "Top SQL"
tool, using the Oracle Enterprise Management
tool (OEM).
Expand the databases.
Select the DBS4RMAN database.
On the "Diagnostics Pack" tool and click on
the "Top Sessions" icon.
Wait for the first 10 top sessions to be
displayed. On this report, you will find
"Session identification," "Session CPU
Activity," "Session Memory Use," and etc.
Double click on any open session to display
detailed information about the session and
wait for a refresh.
Check on: "Session Identification," "Current
State," "Session CPU Activity," "Cumulative
CPU statistics," "CPU Rates Per second,"
"Session Memory Use," "Session Efficiency,"
"Memory Sizes," "Buffer Access Rates per
Second," "Session I/O Activity," "Cumulative
I/O Statistics," �I/O Rates Per Second."
Close the window, without saving the chart
option.
Select another session.
Browse through the SQL statement.
Now, the page was refreshed to display the
session information statistics.
Find more information on the "Session
Statistics" tab.
Now, back to the "Session Detail" tab.
Close the window.
Do not save any chart options.
Close the "Top Sessions" window and don't
save any chart options.
We assume you that know how to Interpret and
make sense of the output statistics.
|
