between fiction and reality? Fiction has to make sense." -
first then play the video:
a Memory Statistical
Obtaining a Memory
Statistical Information using OEM
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
Using the Diagnostics Pack
Selecting a target database
Obtaining Session CPU
Obtaining Session Memory
Obtaining Memory Size
Obtaining I/O statistics
Obtaining detailed session
Obtaining SQL statements
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
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
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
We assume you that know how to Interpret and make sense of the output