"The difference
between fiction and reality? Fiction has to make sense." -
Tom Clancy |
Read
first then play the video:
OEM-VIDEO -Obtaining
a Memory Statistical
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.
|