1 / 20

OOW 2012: reflections

OOW 2012: reflections. John Hurley 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 2012 Oak Table World snapshot

luka
Download Presentation

OOW 2012: reflections

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. OOW 2012: reflections John Hurley Long time Oracle geek DBA for Summit Racing NEOOUG officer

  2. To 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!

  3. NEOOUG 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 around Other area database groups still active include: NEODBUG (http://www.neodbug.org ) ONSSUG (http://ohionorthsqlserverug.org )

  4. NEOOUG History Our first breakout event was in 2003 at LCC with GajaVaidyanatha … damagers … compulsive tuning disorder LCC again 2004 with Steven Feuerstein Case Western Reserve days Tom Kyte / Cary Millsap / Jonathan Lewis Crazy Rumpi wanted us to move to 2 day event conferences Cleveland State University and the recent conferences

  5. Great 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/Wedneday Working with OOUG ( Columbus based )

  6. Get 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!

  7. San Francisco experience: PS: the weather is not usually like this!

  8. Oracle Music Festival 2012

  9. 2012 conference takeaways: Really pushing the engineered systems marketing message Hard to find quality technical sessions but still: Maria Colgan / Tom Kyte / Jonathan Lewis etc 12c 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 ).

  10. 12c 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 ).

  11. Oak Table World 2012 ( at OOW 2012 ) This is pretty much the atmosphere at Oak Table World … a conference within a conference!

More Related