Five Keys to Managing Performance of Oracle Forms and Oracle E-Business Suite
March 27, 2012Frank Days, VP Marketing, CorrelsenseMia Urman, CEO of OraPlayer
Agenda• Background• The monitoring challenge• The five keys• Solutions• Q&A
Housekeeping
• Presentation will last 30 minutes• Submit questions via the chat window• Slides will be made available tomorrow
Correlsense Speaker:Frank Days
VP MarketingCorrelsense
Guest Speaker:Mia Urman, CEO, Oraplayer
• Sr. Support Analyst and Product Manager of Forms and ADF at Oracle for 7 years
• 13+ years supporting, training and consulting for Oracle Tools
• Founder of Qesem Consulting. Clients include: Mastercard, Bank of Israel, IBM and Motorola
• CEO of OraPlayer a leading provider of Oracle Forms to SOA integration and mobile
• Leader OUG Oracle Developer user group
BACKGROUND
Oracle Forms Architecture
WebLogic: Typical High Availability topology
WLS
WLS
Oracle DB
Oracle DB
ApacheServeror OHS
ApacheServeror OHS
FirewallLoadBalancer
Internet
Desktop
Firewall
WLS
WLS
Clustered Weblogic Servers
THE MONITORING CHALLENGE
Forms Complex Multi-Tier Architecture
• Need to identify single sessions across all tiers• Hard to effectively identify the degrading element
Users Can Rarely Describe Problems
• “It’s not working”, “It’s slow”, “It’s stuck”• What did the user do when the problem occurred? • Which component is causing the problem?
System Migrations/Upgrades are Complex• Finding problems before move to production• Proving that performance has not degraded• Getting to the root cause of the problem fast?
Forms Users Unique Needs
• Out of the box, easy solution– No need to code or do manual mapping
• Real-end user monitoring – Get business context logs - Form item names and labels
– Complete, real-time end-user experience
• Prevent problems and resolve them fast – Get notifications/alerts of problems before users report them
– Allow system managers to determine and improve SLA
– Identify problems and reduce time to solutions
• Reduce risk in monitoring / upgrade projects – Obtain monitoring data without a performance penalty
– Analyze stress tests across all components before rolling out
THE FIVE KEYS
1. Track All Requests Through All Hops• Track all user requests through all components (not just
Java and .Net)
• Track and meter single end user across entire stack
• Apache, OC4J, Forms Runtime and Oracle Database
AppletApache
OC4JForms Runtime
Specific SQLs
2. Manage User Experience with Meaningful Transaction Names
3. Understand How Components Interact
• Auto-detected• Real-time• Without manual modeling
4. Use Performance Analytics
• Isolate problems in a click• Optimize bottlenecks• Manage rollouts / migrations
TODO – ADD SCREENSHOT
5. Keep Your Stakeholders Aware
• Regular performance reports
MONITORING FORMS APPLICATIONS
Limitations of Existing Solutions
• Java/.Net – no support for Forms runtime processes
• No end-user experience - neglect client-side layer
• Require manual mapping or customized code
• Don’t track user session and requests across all tiers
• Overhead:
-Affect server performance
-threaten server instability
• Lack of transaction-aware analytics
• Incoherent information, relying on monitoring logs
SharePath for Oracle Forms/EBS
• Goes beyond Java/.Net with Forms runtime coverage
– Broadest coverage: rich clients, Forms applet, C++, ESBs …
– Supports the most complex, heterogeneous architectures
• Dashboards for operations, support, and engineering
• No application code changes necessary
• Auto-detects transaction paths
Summary
• Performance is crucial in today’s IT landscape• Forms and EBS bring performance and migration
challenges • SharePath is the only transaction management
offering for Forms based/EBS
Questions?
Request a live demo: [email protected]
Frank [email protected]
Mia [email protected]@miaurmanwww.oraplayer.com
www.OracleFormsInfo.com
