exadata consolidation in retail oracle openworld
DESCRIPTION
Presentation on Exadata Consolidation at Oracle OpenWorld 2014TRANSCRIPT
A RedStack Technology Company
+44 (0) 844 811 [email protected]
www.e-dba.com
Oracle EMEA Database Partner of the Year • Oracle Partner of the Year 2010 & 2012 & 2013 • Oracle Engineered Systems Partner of the Year 2014
Exadata Consolidations: Lessons From Retail
Jason ArneilSolutions Architect
+44 (0) 844 811 [email protected]
www.e-dba.com
A RedStack Technology Company
Oracle EMEA Database Partner of the Year • Oracle Partner of the Year 2010 & 2012 & 2013 • Oracle Engineered Systems Partner of the Year 2014
t was the best of times, it was the worst of times, it was the age of wisdom, it was the age of foolishness
It was the best of times, it was the worst of times…
C. Dickens, A tale of Two Cities
+44 (0) 844 811 [email protected]
www.e-dba.com
A RedStack Technology Company
Oracle EMEA Database Partner of the Year • Oracle Partner of the Year 2010 & 2012 & 2013 • Oracle Engineered Systems Partner of the Year 2014
jarneil.wordpress.com
@jarneil
+44 (0) 844 811 [email protected]
www.e-dba.com
A RedStack Technology Company
Oracle EMEA Database Partner of the Year • Oracle Partner of the Year 2010 & 2012 & 2013 • Oracle Engineered Systems Partner of the Year 2014
t was the best of times, it was the worst of times, it was the age of wisdom, it was the age of foolishness
sve.to
@sgyurov
202cm – 6 feet 7 17/32
+44 (0) 844 811 [email protected]
www.e-dba.com
A RedStack Technology Company
Oracle EMEA Database Partner of the Year • Oracle Partner of the Year 2010 & 2012 & 2013 • Oracle Engineered Systems Partner of the Year 2014
Customers
Some of our Customers
+44 (0) 844 811 [email protected]
www.e-dba.com
A RedStack Technology Company
Oracle EMEA Database Partner of the Year • Oracle Partner of the Year 2010 & 2012 & 2013 • Oracle Engineered Systems Partner of the Year 2014
t was the best of times, it was the worst of times, it was the age of wisdom, it was the age of foolishness
25% of men buy their underwear at Retailer A
+44 (0) 844 811 [email protected]
www.e-dba.com
A RedStack Technology Company
Oracle EMEA Database Partner of the Year • Oracle Partner of the Year 2010 & 2012 & 2013 • Oracle Engineered Systems Partner of the Year 2014
t was the best of times, it was the worst of times, it was the age of wisdom, it was the age of foolishness
1 in ever 8 pounds spentin UK is with Retailer B
+44 (0) 844 811 [email protected]
www.e-dba.com
A RedStack Technology Company
Oracle EMEA Database Partner of the Year • Oracle Partner of the Year 2010 & 2012 & 2013 • Oracle Engineered Systems Partner of the Year 2014
+44 (0) 844 811 [email protected]
www.e-dba.com
A RedStack Technology Company
Oracle EMEA Database Partner of the Year • Oracle Partner of the Year 2010 & 2012 & 2013 • Oracle Engineered Systems Partner of the Year 2014
IBM X40
10
20
30
40
50
60
29.2
47.9
SPEC CPU2006
+44 (0) 844 811 [email protected]
www.e-dba.com
A RedStack Technology Company
Oracle EMEA Database Partner of the Year • Oracle Partner of the Year 2010 & 2012 & 2013 • Oracle Engineered Systems Partner of the Year 2014
IBM X40
20
40
60
80
100
120
29.2
95.8
SPEC CPU2006/License Core Factor
+44 (0) 844 811 [email protected]
www.e-dba.com
A RedStack Technology Company
Oracle EMEA Database Partner of the Year • Oracle Partner of the Year 2010 & 2012 & 2013 • Oracle Engineered Systems Partner of the Year 2014
Agenda
t was the best of times, it was the worst of times, it was the age of wisdom, it was the age of foolishnessCapacity Planning
+44 (0) 844 811 [email protected]
www.e-dba.com
A RedStack Technology Company
Oracle EMEA Database Partner of the Year • Oracle Partner of the Year 2010 & 2012 & 2013 • Oracle Engineered Systems Partner of the Year 2014
t was the best of times, it was the worst of times, it was the age of wisdom, it was the age of foolishness
+44 (0) 844 811 [email protected]
www.e-dba.com
A RedStack Technology Company
Oracle EMEA Database Partner of the Year • Oracle Partner of the Year 2010 & 2012 & 2013 • Oracle Engineered Systems Partner of the Year 2014
Agenda
+44 (0) 844 811 [email protected]
www.e-dba.com
A RedStack Technology Company
Oracle EMEA Database Partner of the Year • Oracle Partner of the Year 2010 & 2012 & 2013 • Oracle Engineered Systems Partner of the Year 2014
Consolidation
t was the best of times, it was the worst of times, it was the age of wisdom, it was the age of foolishness
+44 (0) 844 811 [email protected]
www.e-dba.com
A RedStack Technology Company
Oracle EMEA Database Partner of the Year • Oracle Partner of the Year 2010 & 2012 & 2013 • Oracle Engineered Systems Partner of the Year 2014
Capacity Planning
+44 (0) 844 811 [email protected]
www.e-dba.com
A RedStack Technology Company
Oracle EMEA Database Partner of the Year • Oracle Partner of the Year 2010 & 2012 & 2013 • Oracle Engineered Systems Partner of the Year 2014
Consolidation
t was the best of times, it was the worst of times, it was the age of wisdom, it was the age of foolishness
Migrate
Check Reality
Capacity Plan
+44 (0) 844 811 [email protected]
www.e-dba.com
A RedStack Technology Company
Oracle EMEA Database Partner of the Year • Oracle Partner of the Year 2010 & 2012 & 2013 • Oracle Engineered Systems Partner of the Year 2014
Consolidation
+44 (0) 844 811 [email protected]
www.e-dba.com
A RedStack Technology Company
Oracle EMEA Database Partner of the Year • Oracle Partner of the Year 2010 & 2012 & 2013 • Oracle Engineered Systems Partner of the Year 2014
Consolidation
t was the best of times, it was the worst of times, it was the age of wisdom, it was the age of foolishnessInstance Caging
+44 (0) 844 811 [email protected]
www.e-dba.com
A RedStack Technology Company
Oracle EMEA Database Partner of the Year • Oracle Partner of the Year 2010 & 2012 & 2013 • Oracle Engineered Systems Partner of the Year 2014
Consolidation
t was the best of times, it was the worst of times, it was the age of wisdom, it was the age of foolishnesscpu_count
+44 (0) 844 811 [email protected]
www.e-dba.com
A RedStack Technology Company
Oracle EMEA Database Partner of the Year • Oracle Partner of the Year 2010 & 2012 & 2013 • Oracle Engineered Systems Partner of the Year 2014
Consolidation
t was the best of times, it was the worst of times, it was the age of wisdom, it was the age of foolishnessresource_manager_plan
+44 (0) 844 811 [email protected]
www.e-dba.com
A RedStack Technology Company
Oracle EMEA Database Partner of the Year • Oracle Partner of the Year 2010 & 2012 & 2013 • Oracle Engineered Systems Partner of the Year 2014
Consolidation
t was the best of times, it was the worst of times, it was the age of wisdom, it was the age of foolishnessresmgr: cpu quantum
+44 (0) 844 811 [email protected]
www.e-dba.com
A RedStack Technology Company
Oracle EMEA Database Partner of the Year • Oracle Partner of the Year 2010 & 2012 & 2013 • Oracle Engineered Systems Partner of the Year 2014
Capacity Planning
t was the best of times, it was the worst of times, it was the age of wisdom, it was the age of foolishnessoversubscribe
+44 (0) 844 811 [email protected]
www.e-dba.com
A RedStack Technology Company
Oracle EMEA Database Partner of the Year • Oracle Partner of the Year 2010 & 2012 & 2013 • Oracle Engineered Systems Partner of the Year 2014
Consolidation
t was the best of times, it was the worst of times, it was the age of wisdom, it was the age of foolishnessHuge Pages
+44 (0) 844 811 [email protected]
www.e-dba.com
A RedStack Technology Company
Oracle EMEA Database Partner of the Year • Oracle Partner of the Year 2010 & 2012 & 2013 • Oracle Engineered Systems Partner of the Year 2014
Consolidation
t was the best of times, it was the worst of times, it was the age of wisdom, it was the age of foolishnessbvm.nr_hugepages
+44 (0) 844 811 [email protected]
www.e-dba.com
A RedStack Technology Company
Oracle EMEA Database Partner of the Year • Oracle Partner of the Year 2010 & 2012 & 2013 • Oracle Engineered Systems Partner of the Year 2014
Consolidation
t was the best of times, it was the worst of times, it was the age of wisdom, it was the age of foolishnessuse_large_pages=only
+44 (0) 844 811 [email protected]
www.e-dba.com
A RedStack Technology Company
Oracle EMEA Database Partner of the Year • Oracle Partner of the Year 2010 & 2012 & 2013 • Oracle Engineered Systems Partner of the Year 2014
Consolidation
t was the best of times, it was the worst of times, it was the age of wisdom, it was the age of foolishness
scan listener
services+
+44 (0) 844 811 [email protected]
www.e-dba.com
A RedStack Technology Company
Oracle EMEA Database Partner of the Year • Oracle Partner of the Year 2010 & 2012 & 2013 • Oracle Engineered Systems Partner of the Year 2014
t was the best of times, it was the worst of times, it was the age of wisdom, it was the age of foolishness
dbms_stats.gather_system_stats(‘EXADATA’)
+44 (0) 844 811 [email protected]
www.e-dba.com
A RedStack Technology Company
Oracle EMEA Database Partner of the Year • Oracle Partner of the Year 2010 & 2012 & 2013 • Oracle Engineered Systems Partner of the Year 2014
t was the best of times, it was the worst of times, it was the age of wisdom, it was the age of foolishness
“Lack of Exadata specific stats can lead to less performant optimizer plans.”
+44 (0) 844 811 [email protected]
www.e-dba.com
A RedStack Technology Company
Oracle EMEA Database Partner of the Year • Oracle Partner of the Year 2010 & 2012 & 2013 • Oracle Engineered Systems Partner of the Year 2014
t was the best of times, it was the worst of times, it was the age of wisdom, it was the age of foolishness
“Note this best practice is not a general recommendation to gather system statistics in Exadata mode for all Exadata environments”
+44 (0) 844 811 [email protected]
www.e-dba.com
A RedStack Technology Company
Oracle EMEA Database Partner of the Year • Oracle Partner of the Year 2010 & 2012 & 2013 • Oracle Engineered Systems Partner of the Year 2014
Consolidation
t was the best of times, it was the worst of times, it was the age of wisdom, it was the age of foolishnessparallel_force_local=true
+44 (0) 844 811 [email protected]
www.e-dba.com
A RedStack Technology Company
Oracle EMEA Database Partner of the Year • Oracle Partner of the Year 2010 & 2012 & 2013 • Oracle Engineered Systems Partner of the Year 2014
t was the best of times, it was the worst of times, it was the age of wisdom, it was the age of foolishness
parallel_force_local=TRUE
DEFAULT_MAINTENANCE_PLAN
sessions queuing
parallel slave sessions queuing
resmgr: cpu quantum
+44 (0) 844 811 [email protected]
www.e-dba.com
A RedStack Technology Company
Oracle EMEA Database Partner of the Year • Oracle Partner of the Year 2010 & 2012 & 2013 • Oracle Engineered Systems Partner of the Year 2014
t was the best of times, it was the worst of times, it was the age of wisdom, it was the age of foolishness
Be prepared
+44 (0) 844 811 [email protected]
www.e-dba.com
A RedStack Technology Company
Oracle EMEA Database Partner of the Year • Oracle Partner of the Year 2010 & 2012 & 2013 • Oracle Engineered Systems Partner of the Year 2014
t was the best of times, it was the worst of times, it was the age of wisdom, it was the age of foolishness
Don’t discount politics
+44 (0) 844 811 [email protected]
www.e-dba.com
A RedStack Technology Company
Oracle EMEA Database Partner of the Year • Oracle Partner of the Year 2010 & 2012 & 2013 • Oracle Engineered Systems Partner of the Year 2014
t was the best of times, it was the worst of times, it was the age of wisdom, it was the age of foolishness
Exadata friendly
+44 (0) 844 811 [email protected]
www.e-dba.com
A RedStack Technology Company
Oracle EMEA Database Partner of the Year • Oracle Partner of the Year 2010 & 2012 & 2013 • Oracle Engineered Systems Partner of the Year 2014
t was the best of times, it was the worst of times, it was the age of wisdom, it was the age of foolishness
+44 (0) 844 811 [email protected]
www.e-dba.com
A RedStack Technology Company
Oracle EMEA Database Partner of the Year • Oracle Partner of the Year 2010 & 2012 & 2013 • Oracle Engineered Systems Partner of the Year 2014
t was the best of times, it was the worst of times, it was the age of wisdom, it was the age of foolishness
+44 (0) 844 811 [email protected]
www.e-dba.com
A RedStack Technology Company
Oracle EMEA Database Partner of the Year • Oracle Partner of the Year 2010 & 2012 & 2013 • Oracle Engineered Systems Partner of the Year 2014
t was the best of times, it was the worst of times, it was the age of wisdom, it was the age of foolishness
Plans Change
+44 (0) 844 811 [email protected]
www.e-dba.com
A RedStack Technology Company
Oracle EMEA Database Partner of the Year • Oracle Partner of the Year 2010 & 2012 & 2013 • Oracle Engineered Systems Partner of the Year 2014
t was the best of times, it was the worst of times, it was the age of wisdom, it was the age of foolishness
1 2 3 4 5 6 7 8 9 10 11 120:00:00
0:07:12
0:14:24
0:21:36
0:28:48
0:36:00
0:43:12
DL980
Report Number
Repo
rt D
urati
on
+44 (0) 844 811 [email protected]
www.e-dba.com
A RedStack Technology Company
Oracle EMEA Database Partner of the Year • Oracle Partner of the Year 2010 & 2012 & 2013 • Oracle Engineered Systems Partner of the Year 2014
t was the best of times, it was the worst of times, it was the age of wisdom, it was the age of foolishness
1 2 3 4 5 6 7 8 9 10 11 120:00:00
2:24:00
4:48:00
7:12:00
9:36:00
12:00:00
14:24:00
DL980 + Exadata
Report Number
Repo
rt D
urati
on
+44 (0) 844 811 [email protected]
www.e-dba.com
A RedStack Technology Company
Oracle EMEA Database Partner of the Year • Oracle Partner of the Year 2010 & 2012 & 2013 • Oracle Engineered Systems Partner of the Year 2014
t was the best of times, it was the worst of times, it was the age of wisdom, it was the age of foolishness
1 2 3 4 5 6 7 8 9 10 11 120:00:00
0:07:12
0:14:24
0:21:36
0:28:48
0:36:00
0:43:12
DL980 + Exadata
Report Number
Repo
rt D
urati
on
+44 (0) 844 811 [email protected]
www.e-dba.com
A RedStack Technology Company
Oracle EMEA Database Partner of the Year • Oracle Partner of the Year 2010 & 2012 & 2013 • Oracle Engineered Systems Partner of the Year 2014
t was the best of times, it was the worst of times, it was the age of wisdom, it was the age of foolishness
+44 (0) 844 811 [email protected]
www.e-dba.com
A RedStack Technology Company
Oracle EMEA Database Partner of the Year • Oracle Partner of the Year 2010 & 2012 & 2013 • Oracle Engineered Systems Partner of the Year 2014
t was the best of times, it was the worst of times, it was the age of wisdom, it was the age of foolishness
Garbage in…
+44 (0) 844 811 [email protected]
www.e-dba.com
A RedStack Technology Company
Oracle EMEA Database Partner of the Year • Oracle Partner of the Year 2010 & 2012 & 2013 • Oracle Engineered Systems Partner of the Year 2014
t was the best of times, it was the worst of times, it was the age of wisdom, it was the age of foolishness
+44 (0) 844 811 [email protected]
www.e-dba.com
A RedStack Technology Company
Oracle EMEA Database Partner of the Year • Oracle Partner of the Year 2010 & 2012 & 2013 • Oracle Engineered Systems Partner of the Year 2014
t was the best of times, it was the worst of times, it was the age of wisdom, it was the age of foolishness
It’s a Journey
+44 (0) 844 811 [email protected]
www.e-dba.com
A RedStack Technology Company
Oracle EMEA Database Partner of the Year • Oracle Partner of the Year 2010 & 2012 & 2013 • Oracle Engineered Systems Partner of the Year 2014
Q & A