how to perform an ebs database health …days...an ebs database health check before going to ... •...
TRANSCRIPT
-
HOW TO PERFORM
AN EBS DATABASE
HEALTH CHECK
BEFORE GOING TO
THE CLOUDDIMAS CHBANEACCENTURE ENKITEC GROUP
-
Copyright 2016 Accenture All rights reserved. | 2
AGENDA
A word about the cloud Why you should do a Health Check Database Parameters Gathering Statistics Patching Analyzers Diving in:
EDB360 SQLD360
-
Copyright 2016 Accenture All rights reserved. | 3
WHO I AM
Dimas Chbane
Consultant / DBA / Analyst
Focus areas:
Databases
EBusiness Suite
Twitter: DChbaneBlog: dimas-chbane.netEmai: [email protected]
-
A WORD ABOUT THE CLOUD
-
Copyright 2016 Accenture All rights reserved. | 5
CLOUD IS ASSUMED:ITS NOT A QUESTION OF IF, BUT WHEN
Challenges exist for enterprises
Every enterprise starting point is different
Questions to ask What business problem are you trying to solve with a
cloud implementation? How many people does this problem affect in your
organization? How are you currently solving this problem? Has a budget been established to solve this problem with
cloud? How are you going to divorce your cloud partner if you
are not happy?
-
BACK TO THE HEALTH CHECK
6
-
Copyright 2016 Accenture All rights reserved. | 7
ANALOGY
How would you like it to be
How it really is
Optimistic view: It is broken only on one side!
What you want to avoid
How your boss expects you to fix it
-
Copyright 2016 Accenture All rights reserved. | 8
WHY A DB HEALTH CHECK?
Proactively looking for problems before they manifest
Looking for opportunities for improvement
To use as baseline before an upgrade or migration
Before moving to a new platform
If having performance, stability or scalability issues
Checking for cloud readiness
-
Copyright 2016 Accenture All rights reserved. | 9
FIRST THINGS FIRST:
Fundamental things for good performance:
Database Parameter Settings
Gatherings Statistics
-
Copyright 2016 Accenture All rights reserved. | 10
DATABASE PARAMETERS Database Initialization Parameters for Oracle Applications 11i (Doc ID 216205.1) Database Initialization Parameters for Oracle Applications R12 (Doc ID 396009.1) bde_chk_cbo.sql - Reports Database Init Parameters related to an Apps 12 or 11i (Doc ID 174605.1) EBS Database Parameter Settings Analyzer (Doc ID 1953468.1)
Parameters: Mandatory Sizeable
Example for Database 12c: Optimizer_adaptive_features=False
-
Copyright 2016 Accenture All rights reserved. | 11
GATHERING STATISTICS For most of the objects, gathering stats once a week is enough
If there are volatile objects, gather stats only for those objects
Supported ways: using Gather Schema Statistics concurrent program or FND_STATS Dont use DBMS_STATS directly for EBS objects (because FND_HISTOGRAM_COLS)
Consider using GATHER_AUTO option Modification threshold defaults to 10%, but can be changed Stats will be gather on objects that have %DML > 10% of (total number of rows)
Consider using Auto Sample Size In DB 11g and 12c, Auto Sample Size is the default Uses new hash algorithm that Oracle says that is almost as good as 100% sample size
Remember of Data Dictionary and Fixed Objects stats
Review: Best Practices for Gathering Statistics with Oracle E-Business Suite (Doc ID 1586374.1)
-
Copyright 2016 Accenture All rights reserved. | 12
DB PATCHING
Keep database and application versions current Release Schedule of Current Database Releases (Doc ID 742060.1) Oracle Recommended Patches -- Oracle Database (Doc ID 756671.1)
-
Copyright 2016 Accenture All rights reserved. | 13
EBS PATCHING
Make sure to apply the patches listed in the Release Notes: Oracle E-Business Suite Release 12.2.5 Readme(Doc ID 1983050.1) Oracle E-Business Suite Release 12.2.4 Readme (Doc ID 1617458.1) Oracle E-Business Suite Release 12.1.3 Readme(Doc ID 1080973.1)
Each product has a separate Release Note Oracle E-Business Suite Product Specific Release Notes, Release 12.2.2 (Doc ID 1585844.1)
Performance Patches Oracle E-Business Suite Recommended Performance Patches (Doc ID 244040.1)
Patch Wizard How to Find E-Business Suite Recommended Patches (Note 1400757.1)
-
Copyright 2016 Accenture All rights reserved. | 14
ANALYZERS
Get Proactive with Oracle E-Business Suite - Product Support Analyzer Index (Doc ID 1545562.1) EBS Database Parameter Settings Analyzer (Doc ID 1953468.1)
EBS Workflow (WF) Analyzer(Doc ID 1369938.1)
EBS Concurrent Processing (CP) Analyzer(Doc ID 1411723.1)
Orachk / Exachk ORAchk - Health Checks for the Oracle Stack (Doc ID 1268927.2)
-
Copyright 2016 Accenture All rights reserved. | 15
DIVE IN..Several tools available
-
EDB360
-
Copyright 2016 Accenture All rights reserved. | 17
EDB360
A shell script runs eDB360 on all databases
Installs nothing and it is free!
Set of files driven by one index.html file
One ZIP file with a set of files (thousands)
-
Copyright 2016 Accenture All rights reserved. | 18
0001_edb360_dbname_index.html
-
Copyright 2016 Accenture All rights reserved. | 19
sqld360
-
Copyright 2016 Accenture All rights reserved. |
EDB360 / SQLD360 GIVE YOU THE PARTS
You just need to put them together
20
-
DEMO
-
THANK YOU
QA&