iSelfSchooling.com  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    |

 

More Resources by Google:

Performance check list

 

Summary:

Performance analysis using WLA Performance View

 

Objectives:

Following this exercise, participants should be able to:

Perform a basic performance analysis using WLA Performance View

 

 

Perform a ‘Performance Checkup’.

 

Check Cache Performance:

What is the average cache hit percentage for this workload? 

What is the worst cache hit ratio observed in this data? 

Was the hit ratio inflated by write activity? 

 

Check Balance Across the Front End:

Is the activity constant over time? 

Is the activity balanced across all the channels?  

 

Check Balance Across the Back End:

Is the activity balanced across the back end? 

 

Check Balance Between Front End and Back End:

Is the front end more active than the back end? 

 

Check Logical Volume Balance:

Are the average IOs per second spread uniformly? 

Does there appear to be any significant striping? 

 

Check Supplemental Data:

What additional areas would you want to explore, given that this is an energy company ERP application? 

 

Perform a ‘Performance Checkup’.

Check Cache Performance:

Run the System à System Cache Utilization ViewGraph.  You will see

What is the average cache hit percentage for this workload? 

What is the worst cache hit ratio observed in this data?

Was the hit ratio inflated by write activity?

 

Check Balance Across the Front End:

There are only Fibre directors here, so run the Dir-Fibre>All Fibre Directors-IO Rates ViewGraph.  You will see

Is the activity constant over time? 

Is the activity balanced across all the channels?  

 

Check Balance Across the Back End:

Run the Dir-DA>All Disk Directors > IOs per Sec ViewGraph.  You will see

Is the activity balanced across the back end?

 

Check Balance Between Front End and Back End:

Run the System>All Directors – IOs per Sec ViewGraph.

Is the front end more active than the back end? 

 

Check Logical Volume Balance:

Run the Devices>Average IOs per Sec ViewGraph.

Are the average IOs per second spread uniformly?

Does there appear to be any significant striping?

 

Check Supplemental Data:

There is none.  What additional areas would you want to explore, given that this is an energy company ERP application?  Some possibilities are

·        hours of peak activity (are the users in the same time zone? national? global?)

·        spikes in activity?  (Ask the customer what work was being run then)

 

Good Luck!

 

Google
 
Web web site