Long time Oracle geek DBA for Summit Racing NEOOUG officer To be covered NEOOUG history Get involved and get paid The San Francisco experience General impressions of recent OOW trips 2012 Oracle conference takeaways ID: 793131
Download The PPT/PDF document "OOW 2012: reflections John Hurley" is the property of its rightful owner. Permission is granted to download and print the materials on this web site for personal, non-commercial use only, and to display it on your personal computer provided you do not modify the materials and that you retain all copyright notices contained in the materials. By downloading content from our website, you accept the terms of this agreement.
Slide1
Slide2OOW 2012: reflections
John Hurley
Long time Oracle geek
DBA
for
Summit Racing
NEOOUG officer
Slide3To be covered:
NEOOUG history
Get involved and get paid!
The San Francisco experience
General impressions of recent OOW trips
2012 Oracle conference takeaways
2012 Oak Table World snapshot
Hotsos
2013
in Dallas!
Slide4NEOOUG History
Started in 1989 …
I
first started attending NEOOUG meetings in late 1990’s at the Independence Library
Meetings were monthly?
Rumpi
/Gary/Paul are still aroundOther area database groups still active include:NEODBUG (http://www.neodbug.org )ONSSUG ( http://ohionorthsqlserverug.org )
Slide5Slide6NEOOUG History
Our first breakout event was in 2003 at LCC
with
Gaja
Vaidyanatha
… damagers … compulsive tuning disorderLCC again 2004 with Steven FeuersteinCase Western Reserve days Tom Kyte / Cary Millsap / Jonathan LewisCrazy Rumpi wanted us to move to 2 day event conferences Cleveland State University and the recent conferences
Slide7Great Lakes Oracle Conference
Chris Date: godfather of
relational database theory
and design principles. Books
include “An Introduction to Database Systems
”,
“Database in Depth: Relational Theory for Practitioners”.Tom Kyte … Oracle employee and world class speaker.Optional extra cost sessions Monday Dates are Tuesday/WednedayWorking with OOUG ( Columbus based )
Slide8Get involved and get paid:
Friendly atmosphere and the support of our officers in getting ready to speak
Presentations done at work can be recycled/repurposed for NEOOUG ( and vice versa )
An opportunity to grow personally and professionally
Mad money for free!
Slide9San Francisco experience:
PS: the weather is not usually like this!
Slide10Slide11Slide12Slide13Slide14Oracle Music Festival 2012
Slide152012 conference
takeaways:
Really pushing the engineered systems marketing message
Hard to find quality technical sessions but still: Maria
Colgan
/ Tom
Kyte / Jonathan Lewis etc12c Database new features include VARCHAR2 up to 32767 (RAW/NVARCHAR2) size greater than 4000 stored out of line like LOB columns.Adaptive execution plans ( build on adaptive cursor sharing and bind variable peeking ). Limited on the fly changes in execution plans at first ( nested loops change to has joins ).
Slide1612c changes continued
Adaptive statistics … additional statistics including relationships between columns gathered/stored in memory used by optimizer until next instance recycle.
Dynamic sampling levels increase to 11and highest level makes dynamic statistics persistent
Data optimization or heat maps … database can monitor block usage frequency ( hot/medium/cold ) to help aid resolving access bottlenecks
New ILM clause to create/alter table commands allow compression/archival of data after a given periods of time ( might work really well for partitions ).
Slide17This is pretty much the atmosphere at Oak Table World … a conference within a conference!
Oak Table World 2012 ( at OOW 2012 )
Slide18Slide19Slide20