Oracle EBS Performance Improvement

Hmm,it looks new to us,we will do some rearch on it and get back to you.

calike;

Thank you for the opportunity to assist in your campaign.  Is there a possibility to get 10-96 AWR text files to review?  I would like to run the files through our Workload Profile Assessment for Oracle.  The tool will give us an overview of their existing IOPS and drive estimates, tablespaces and key timed events as well as identify performance issues.  We can then process the information and send you a precise PowerPoint with recommendations.

You can contact me directly for further discussion.

Nick

The following information is required for an assessment.

1. A brief description of the Oracle issue.
2. The Application(s) running on the database.
3. The underlying storage system.
4. Database activity report in the form of the Oracle Automatic Workload Repository (AWR)
5. Please submit 48 - 96 AWR text files in a .zip file.  AWR reports should be gathered in 15-minute increments around the time of the performance issue. (Note: If there is pushback on the requested number of AWR files, the graphs will be populated with as little as 10 AWR files.)
6. Optional: DBclassify, NAR reports and EMC Grab Reports.

  A document containing a set of instructions on how to gather and package a set of AWR Report or StatsPack files in a manner which is compatible with the miTrend tool is located at: OracleAWRStatspackStatisticsGatheringProcedures_10gR1OrHigher_v8[1].docx 

Please bear in mind the following guidelines:

This tool is limited to Oracle database servers running Oracle Database single-instance or RAC 10g Release 1 or higher.

• For each production database instance we would like a set of 48 to 96 reports where each report is generated on a 30 or 60 minute snapshot or sample interval. (I.e., 48 to 96 individual files per database instance where each file contains one sample 30 or 60 minute interval report.)
• The following AWR or Statspack reports are requested:
  • A total of 48 to 96 Statspack or AWR reports capturing peak activity in 30 minute or 1 hour increments
  • Shorter time intervals and more reports are fine.
  • Make the best attempt to identify the peak activity periods for the reports:
    • Including prime heavy usage business hours timeframes
    • Including batch processing timeframes
• If you are generating AWR reports, please generate them in TXT format, not HTML.
• If this is a RAC environment, then reports are requested for each instance in the RAC cluster.
• Create an individual .ZIP file with the AWR/Statspack text files for each database and with RAC all instances of a database in one .ZIP file.
• Please note the section “Oracle 10gR1 or Higher Batch AWR Generation” contains a shell script and a SQL script either of which can be used to ease the AWR report generation for versions 10g and higher of the database.  And the section “Oracle 10gR1 or Higher Statspack Report Batch Generation” contains a shell script and a SQL script either of which can be used to ease the Statspack report generation.

These scripts also are bundled in the zip file AWRStatspackReportGenScripts.zip

NOTE: This tool is presently limited to only EMC employees or partners. If you are an EMC customer, simply get with your EMC sales rep, and he or she will work with you on getting your database assessment completed. 

Hi Nick,

In the below link you can see the required information. If you need further information please do not hesitate to contact me.

http://ftp.emc.com/action/login?domain=ftp.emc.com&username=Rs8r55w35&password=BI9B9B9ApB

Thanks and kind regards,

Feyza

Feyza;

The zip file is corrupted.  Pease resend.  Thank you kindly.

Nick

Hi Nick,

Could you please try again?

Thanks and kind regards,

Feyza

Feyza;

I managed to open the zip file but, it consisted of html files and not txt.  I am not able to use our tool on html.  I will need to go through them manually.  Is it possible to obtain awr.txt files?

Thank you kindly.

Nick

• If you are generating AWR reports, please generate them in TXT format, not HTML.