Define the problem - where is the time going? Identify the techs tack components in-play, refer to architecture Ex. Problem in wrong Linux library, which is not in the Oracle "stack"!
Gather the right data to analyze issue, 1121043.1 for Best Practices, get a "good" SQL trace -> time in the DB? -> time in SQL execution? -> a few bad SQLs?, enhanced performance diagnostics for EBS 1362660.1 -> Gather Diagnostic Data for Traced Session, monitor OS stats -> 301137.1 461053.1, TKPROF 39817.1, Trace Analyzer TRCA 224270.1, SQLTXPLAIN 215187.1, AWR -> $ORACLE_HOME/rdbms/admin/awrrpt.sql
Identify root cause
Search for solution
If it is a product issue, pass it on to Support/Development through MOS, do not just ignore it or deny Oracle feedback!
Try to identify temporary workaround until permanent fix!
If you have a bottleneck that is concurrency related, use global hash-partitioned indexes for hot leaf blocks which can be identified by AWR.
Recommendations about optimization:
Stay current - recommended performance patches 244040.1 & http://blogs.oracle.com/stevenChan/resource/certifications.html
Use optimal logging settings - FND: Debug Log Level set to Unexpected
Optimize Workflow Processes - 260884.1, 1129203.1
Run (research) $FND TOP/sql/wffngen.sql - I forget why Samer suggested this, but there was something about this optimizing workflow for you.
Research RAC affinity - this was something about getting SQL or processes pinning to a certain node and I need to do some research on it too.
Optimize Forms Processes
Optimize JVM Processes
Size the Middle Tier for Concurrency - JVM, forms, CM processes (especially Java programs)
There is a formula to calculate physical memory for oacore heap!
R12.2 1905593.1 and E22950 are good documents on MOS for sizing!
Optimize the Concurrent Manager - manage CM jobs lifecycle and CM managers - 1 or 2 managers per CPU cores, CM state data -> 842850.1 - 2GB reports.log! (that is in MY presentation too!), CM schedules, Workload Management Strategy
Tune init.ora 396009.1 & 216205.1 R12/11i
Huge Pages in Linux 744769.1
ORION - 727062.1
Optimize Backend Code Execution Path - pin top PL/SQL packages, check for cursor leaks, consider dropping old editions if you get to 25 in R12.2!
Gather Application Statistics - disable 10/11g automatic jobs, 1586374.1, analyze schemas at 10% as a general rule.
Gather Dictionary and Fixed Stats - DBMS_STATS.GATHER_DICTIONARY_STATS or DBMS STATS.GATHER_FIXED_OBJECTS_STATS
9:45 AM - 10:45 AM - Rusty Schmidt (me!) (@TheOracleEMT) - E-Business Suite R12: Application Lessons Learned for Support and Implementers
For the first run of this presentation, it was a pretty good experience!! The only thing that tripped me up a bit was the room monitor did not kick the previous presenter out so I only had 5 minutes to set up and catch a breath, and that was when I realized that the notes of the presentation were not showing at all like they should be but by then I was already in it and thankfully I have done enough testing that I got through it! I heard some really good feedback in the COLLABORATE app, and from some people afterwards, plus I saw lots of people scribbling notes down so I think it was a presentation that really had the 40-50 people engaged and hopefully will lead them to better patches/upgrades or at least to read MOS a bit more! I did catch myself saying um a few times, and there was one thing I spaced on, so I will grade myself at a 9.5 and even though it was not a perfect 10 I am really happy with it! Looking forward to giving this again for either OAUG or Oracle at the upcoming OpenWorld!!
11 AM - Noon - Werner De Gruyter (@Yoda_EM) & Courtney Llamas (@courtneyllamas) - Under the Hood of Enterprise Manager - A Troubleshooting Primer
I think honestly I misread this session, as I was expecting how to use EM12c to troubleshoot an issue/problem, but it was all about troubleshooting EM12c ITSELF! Of course the Internet blowing up a bit about the new Star Wars trailer or my relief at getting my presentation done may have contributed to not paying attention a bit since Werner went WAYYYY into details I never dreamed of so I will look forward to getting the materials so I can learn about it on my own time.
EM12c is total cloud control!
4 key processes - notifications, data loading, jobs & tasks, and user interaction & real time monitoring.
Information flows are initiated by background processes (callbacks).
Beacons can be added so you can monitor responsiveness of EM over time - very meta because you are monitoring the monitor!
Use EMCLI to trace any UI - I think this is what he was saying there.
More memory in Java heap size with more targets, which sounds like a no duh kind of thing but it is good to mention anyways.
Default 150 sessions, based in Apache limits.
12:15 PM - 1:15 PM - Mazen Arar and Jake Westphal - Testing Oracle E-Business Suite Applications: Best Practices from Development
Testing challenges - schedule, scope, resource - optimizing any of these negatively affects quality!
Testing is 30-50% AT LEAST of your project.
Cost of fixing an error is greatest post release!
Methods for testing - Users, Process, Governance, Technology, Data
Users - theme based testing, exploratory testing (usage patterns, vulnerable areas, derived exploratory testing)
Process - Process Flow Testing
Governance - Role Based Testing (what, why, how), Use Cases, Security Testing (what, why, how)
Technology - Online Patching Testing (during upgrade, during OLP, after OLP), EBS architecture -> QA perspective
Data - Test Data Management, subsetting and masking
<manual ------ automated> - this is the typical range the "Methods for testing" above follows.
Do we test everything? How much testing is enough?
Oracle Application Testing Suite - Oracle Functional Testing Suite for Oracle Applications - QA reduced automation time by 60%, need to redo 70% of your 70% with some changes
Demo recorded, pausing every few seconds to talk through it - which I thought was interesting how you could record a small 2-3 minute demo and make it last 5-10 minutes with talking through it. I wonder what demos I will be doing in the future after seeing all of these going on this week!
EDIT 4/26/15: Modified the title slightly, and fixed some formatting in the post as well.
EDIT 4/26/15: Modified the title slightly, and fixed some formatting in the post as well.
No comments:
Post a Comment