Hands-On 11 (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 task:

1. Using the Diagnostics Pack Tool

2. Selecting a target database

3. Obtaining Session CPU Activity

4. Obtaining Session Memory Use

5. Obtaining Session Efficiency

6. Obtaining Memory Size

7. Obtaining I/O statistics

8. Obtaining Session Identification

9. Obtaining detailed session information

10. Obtaining SQL statements

Hands-On 11 (Obtaining a Memory Statistical Information using OEM)

Description:

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).


==Start.
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.

==

For more information about the subject, you are encouraged
to read from a wide selection of available books.

Good Luck!