Taking Control of your Oracle Applications Environment

1
Taking Control of your Oracle Applications
Environment

• Joe Young
• Senior Marketing Manager, ERP

2
Challenges of Managing Oracle Applications
Scarcity of Oracle Apps expertise
Meeting service level expectations
Environment complexity
3
Challenges of Managing Oracle Applications

• Environment complexity
• Multiple systems multiple layers
• Oracle Applications process complexity
• Constant growth and change
• Oracle Applications expertise
• High demand
• Long ramp-up for new staff
• Exposure when people leave
• Do more with less
• Meeting service level expectations
• Availability
• Performance

4
Environment Complexity
5
Environment ComplexityMultiple layers, systems
versions to manage
6
Environment Complexity Multiple layers, systems
versions to manage
7
Environment Complexity Multiple layers, systems
versions to manage
Version 10.7NCA 11 Architecture
8
Oracle Applications Critical Points of Failure
As in any ERP system, there is a single database
and a large number of users so database
availability and performance is key.
Database
Internal Manager
If this goes down, none of the background
requests can be dispatched to the concurrent
managers for processing.
If a concurrent manager fails it could impact the
system by creating a backlog of requests so
performance will be slower to the end-users.
Concurrent Managers
(In dynamic 3 tier environment only) is a single
point of failure. If the metrics server goes
down, no users can access the Oracle Apps system.
Metrics Server
(2 tier or static 3-tier environment) If this
goes down, the users assigned to this forms
server cannot access the application.
Forms Server
9
Environment ComplexitySingle Point Management

• Multiple systems
• Multiple versions
• Multiple instances
• Scalability

10
Oracle Apps Expertise
11
Challenge of Oracle Applications Expertise
12
Challenge of Oracle Apps Expertise
Improved Productivity

• Eliminates routine checks
• Admin tasks can be executed immediately through
  simple menu commands

13
Challenge of Oracle Apps ExpertiseOracle
Applications Processes
Background Request Processing
Write to database
Online Users
14
Challenge of Oracle Apps Expertise Oracle Apps
Background Processes

• Background processes
• Concurrent Managers - The Bottleneck
• Concurrent Requests - The Barometer

15
Challenge of Oracle Apps Expertise Oracle Apps
Background Processing
Concurrent Managers
Request Queue
Oracle Applications
Request 1 Request 2 Request 3 Request 4 Request
5 Request 6 Request 7 Request 8 Request 9 Request
10 . . . . . Request n
General Ledger
Standard Manager Target Process
Accounts Payable
Internal Manager
Order Entry
Receiving Manager Target Process
Inventory
Inventory Manager Target Process
Oracle RDBMS
16
Challenge of Oracle Apps Expertise Oracle Apps
Background Processing
What if there are too few Concurrent Managers?
Concurrent Manager 1
Request Table
Target Process 1 Target Process 2 Target Process 3
Concurrent Manager 2
Target Process 1 Target Process 2 Target Process 3
17
What if there are too many Concurrent Managers?
Challenge of Oracle Apps Expertise Oracle Apps
Background Processing
Concurrent Manager 1
Target Process 1 Target Process 2 Target Process
3 . . Target Process n
Request Table
Request 1 Request 2 Request 3
Concurrent Manager 2
Target Process 1 Target Process 2 Target Process
3 . . Target Process n
18
Challenge of Oracle Apps Expertise Oracle Apps
Background Processing
Concurrent Manager 1
Request Table
Target Process 1 Target Process 2 Target Process
3 . . Target Process n
Concurrent Manager 2
Target Process 1 Target Process 2 Target Process
3 . . Target Process n
What if I have the wrong types of Concurrent
Managers?
19
Challenge of Oracle Apps Expertise Simplifying
Management of Concurrent Managers

• Wait time statistics (busiest / peak times)
• Concurrent manager utilization (over-utilized /
  under-utilized)
• Active concurrent managers and target processes
• Monitor long-running and long-pending requests
• Concurrent manager status
• Activate/deactivate individual concurrent
  managers
• Startup/shutdown internal manager

20
Challenge of Oracle Apps Expertise Simplifying
Management of Concurrent Requests

• Identify the number of running requests
• Identify the number of pending requests
• Identify long-running and long-pending requests
• Customized long-running and long-pending
  thresholds
• Identify top consumers
• Identify requests ending in error
• Analyze concurrent request history
• Identify the user requesting the process

21
Meeting Service Level Expectations
22
Meeting Service Level Expectations

• Users
• OnlineUsers / Processes - The Customer and the
  Culprit

23
Meeting Service Level ExpectationsCan users
access the system?

• Middle Tier
• Forms servers
• Forms clients
• Metrics server
• Metrics clients
• Web listeners
• Web request broker (WRB)
• Database Tier
• Oracle database server

24
Meeting Service Level ExpectationsHow do users
impact the system?

• Online Users
• Too many users
• Too many user sessions
• Users consuming too much CPU
• Impacted by non-Oracle Applications related
  database queries
• Idle user sessions

25
Proactive Management
Meeting Service Level Expectations

• Immediate alerts on availability performance
  issues of key components
• Take action before end user is impacted

26
(No Transcript)
27
AvailabilityPATROL DB-Stats

• In depth object-level statistics
• Displays most active objects
• Indicates specific tables and indexes to reorg
• Provides optimal recommendations for storage
  parameters

28
AvailabilityPATROL DB-Reorg

• Minimize maintenance downtime
• Fast unload Technology and SQLLoader
• Flexible reorg options
• Works with multiple objects
• Allows modification of datafiles
• Drill down granularity
• Decrease human error
• Reorgs Oracle databases correctly the first time,
  every time

29
SQL-BackTrack for Oracle

• Application backup recovery with a reliable
  process
• Guarantees application availability
• Expedites time to recovery
• Automatic archive log management monitoring
• Lower costs through guided recovery
• Guided recovery
• Extraction of tables from physical backups

30
IT Process Automation -- INCONTROL

• Production management
• Controls production management and automation
  for the enterprise
• Achieves comprehensive job scheduling
• Output management
• Achieves output consistency across the enterprise
• Provides the end user a single tool for viewing
  and analyzing corporate reports
• Security management
• Increases enterprise-wide security levels

31
How BMC helps simplify the Management of Oracle
Applications
Scarcity of Oracle Apps expertise
Meeting service level expectations
Environment complexity
32
How BMC helps

• Environment complexity
• Single point of management
• One console with enterprise view
• Scalability
• Scarcity of Oracle Apps expertise
• Can be used by operators and administrators
• Ease of use
• Increased productivity

33
How BMC helps

• Meeting service level expectations
• Minimizing unplanned downtime
• 24x7 monitoring of all critical components
• Alerts before end-user is impacted
• Automated corrective actions
• Minimizing planned downtime
• Re-org only when required
• Fast, online backup

34
How BMC Software Helps

• Provide solutions that
• Optimize your Oracle Applications investment
• Leverage your existing resources
• Enable you to navigate the challenges of each
  stage in the lifecycle and move onto the next
• Frees IT to concentrate on the application of
  technology not the technology of the application