UNthink was not something I was looking forward to, but I must say that I am a believer in what Erik has to say because he was SO passionate about getting "outside the box" that it really was a breath of fresh air!!
9:15 AM - 10:15 AM - Mike Donovan (@dbvisitmike) - The DBA as Linchpin, Not Roadblock. Fast Track Your Career in 60 Minutes
Mike started off saying how his presentation was kind of meta - not about the work, but how to address the work and that was pretty true but still awesome!
Cruise ship analogy with how much work the engine does, but nobody pays attention to it, compared to how much work a DBA does with how much nobody thinks about that either.
Complexity and uncertainty
Oracle DBA blog 2.0 - http://dbaharrison.blogspot.com/
DBA stereotypes - territorial, isolated & inaccessible, rigid & distrusting - Do not be this stereotype!
Unique potential in the role!
Sethgodin.com -> Lynchpin book, sounds like worth a read.
Exert emotional labor, invent, lead, connect, happen, create, delight, challenge, love their work are all positive spins on the job!
Demands on the DBA:
Technology - ASM, cloud, virtualization
People - more people, administrator
Business - conflicting demands, cost cutting
The job is more difficult than ever so you can be an indispensable DBA which is an island (holds on to everything) or stream (shares everything, delegates).
DBA.rtisan - DBA is now a craft, an artwork!
Core skills + communicativeness + creativity + resourcefulness
Well ordered, procedures, pleasing
Practical suggestions:
Get certified
Learn how to code
Write & speak
Know your business
www.codeacademy.com - A good resource for learning how to code!
10:30 AM - 11:30 AM - Abhay Kumar and Divya Shampur - Weblogic 12c - Top 12 Fundamental Tips to Boost Your Weblogic Server Performance
After giving an absolutely crazy reason for being 15 mins late to the room, so a total 30 minutes late since they were not there when the previous speaker ended, Abhay got down to business and gave a pretty decent presentation.
Good design, good implementation gets you good system performance - performance tuning is not a silver bullet - do not eliminate all bottlenecks -> sounds a lot like Cary Millsap!
Performance objectives depend on the number of users as well as the number and size of requests.
Amount of data and consistency is very important too!
Determine target CPU with testing so you do not wind up pegging it anywhere below peak load.
Monitor data transfers across the network - I thought this was a pretty good lesson!
Use WebLogic clusters for scalability and load balancing.
Tune the OS since it might not release sockets, adjust TCP wait_time value.
Tune JVM focusing on heap size and GC (Garbage Collection).
Use Work Managers to optimize work - I need to see if we have this in one of our new WebLogic instances!
Tuning network I/O - picking right muxer (kind of lost on this, but a good question to be asking folks back at the ranch).
Tuning network channels - it is possible to get a different QoS (Quality of Service) on the same platform.
Tuning WebLogic file store - it is usually faster than JDBC store since there is no network traffic! Good to know!
Tuning data sources - set Initial Capacity to Maximum Capacity, cache JNDI lookups
Tuning WebLogic JMS
Tuning Class and Resource Loading - using class caching and filter loading
Plan for server capacity
Admin Console -> Monitoring -> Threads -> Core Dump instead of doing OS level core dumps.
JRockit Mission Control - out of box, no price attached!
Node Manager helps manage uptime with monitoring and automated restarts
WLDF - Diagnostic Framework
12:00 - 12:30 PM - Bobby Curtis (@dbasolved) - Exadata Exachk and Oracle Enterprise Manager 12c: Keeping up with Exadata
Check out these MOS notes 1070954.1, 757552.1, 1110675.1
Environment changes
Start Exachk as a daemon with ./Exachk -d start and then call it with ./Exachk -daemon -a
You must "force" the agent to collect Exadata metrics!
12:45 PM - 1:45 PM - Sandra Vucinica and many others - OAUG E-Business Applications Technology Stack SIG
ebsatssig.oaug.org - Visit the SIG home page and sign up!
EBS patching - Last year with one update there were 37 Java updates and 4 of them had 10.0 CVSS scores!
403537.1 - Security MOS note
Security AMP plugins for EBS will check these automatically for you.
AD and ADTXK delta 6 really just delivers new features for online patching so you should not need to redo your business process testing!
2:00 PM - 3:00 PM - Dan Norris (@dannorris) - Oracle Exadata Technical Deep Dive: Architecture and Internals
MAA team integrates the different Oracle technologies so each team can focus on doing what they do best, and this group tests the intersection of technologies in their labs under real situations! Pretty cool!
X5-2 overview since it is new, and I thought with a 50/50 mix of people that had Exadata and that did not that this was a good review presentation but it was not the "deep dive" I was looking for even if I did find it interesting.
New Extreme Flash Storage Server, replaces high performance drives for no actual price increase.
X4-8 has some built in support for In Memory.
ZDP RDSv3 is a network transport protocol that has low network overhead and is used in the InfiniBand switching SOFTWARE Oracle provides so buying your own InfiniBand HARDWARE will not get you the same benefits without that other piece of the puzzle. Important to know!
Can expand existing racks with newer technology nodes (X2-2 having an X5-2 added along side it).
When he got to the slide about the software upgrades with Exadata, it felt like what I saw in Denver.
I am also wondering if we need to have Exadata in our DR, and he was not sure if Platinum Support customers need to have it in DR so he will follow up on that for us.
Oracle VM is an option for Exadata but you need to reinstall so it is very involved and risky!
12.1.0.2 supports a PDB snapshot with a sparse diskgroup.
IM Fault Tolerance with X5, memory is mirrored to other nodes which in the long run just means that Oracle can keep selling you more nodes to get a little more cash. :}
DBMCLI is a new feature for monitoring on DB nodes!
DBMCLI is a new feature for monitoring on DB nodes!
FIPS 140-2 security compliant w/smart scans. What is FIPS 140-2? That is what I want to know now!
The MAA group now has posted their information up on docs.oracle.com -> Engineered Systems
You can also visit www.oracle.com/goto/MAA
If you want to be part of the Exadata SIG then visit this site too: is.gd/0doKdG
3:15 PM - 4:15 PM - Jim Czuprynski (@jczuprynski) - A Smart Optimizer Gets Even Smarter: New Histograms in Oracle 12cR1
In 12.1.0.1 and before, you could only have 254 histograms, but after 12.1.0.2 you can have 2048 histogram buckets!
Dba_histograms and dba_tab_col_statistics shows the system generated buckets from gather stats - another good reminder to be looking at (proactively alerting on) these tables for creation and/or drift!
12.1 top-frequency and hybrid are 2 new types of histograms.
Height-balanced histograms is a legacy histogram now!
Passing in anything for sample_size in DBMS_GATHER_STATS will make the DB generate a height-balanced histogram!
4:30 PM - 5:30 PM - David Gilpin - Oracle Linux and Oracle VM Strategy, Update, and Roadmap
I wanted to go to this one, but instead Jim and I got chatting about some things so I did miss out on this but I will try to find the slides online this week!
No comments:
Post a Comment