Since 1999     References  |  Search more  | Oracle Syntax  | Free Online Oracle Training

    Home      .Services     Login       Start Learning     Certification      .                 .Share your BELIEF(s)...


. Online Accounting        .Copyright & User Agreement   |
    .Vision      .Biography     .Acknowledgement

.Contact Us      .Comments/Suggestions       Email2aFriend    |


Online Oracle Training for beginners and advanced - The most comprehensive Oracle tutorial

The authors do not guarantee or take any responsibility for the accuracy, or completeness of the information.



Lesson 01 | Lesson 02 | Lesson 03 | Lesson 04 | Lesson 05 | Lesson 06 | Lesson 07 | Lesson 08 | Lesson 09 | Lesson 10 | Lesson 11 | Lesson 12 | Lesson 13 | Lesson 14 | Lesson 15 | Lesson 16 |


Lesson 11

"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



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:



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



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.