This past year I joined up on the board of the Northern California Users Group (NoCOUG) and am excited to help the NoCOUG team bring great conferenes to the Bay Area. Our new conference director Ben Prusinski has scheduled a whole slew of NoSQL and Big Data presentations at Conference 105 on February 21. Has NoCOUG abandoned SQL? You can bet your bottom dollar it hasn’t! In fact, it was Oracle’s own idea to have so many NoSQL and Big Data presentations at Conference 105. Dave Rubin, Director of NoSQL Database Development at Oracle will explain why NoSQL Database and Oracle Database ...

Kyle Hailey
Uncategorized

Nicer formating at https://sites.google.com/site/oraclemonitor/r-slicing-and-dicing-data R data types Converting columns into vectors Extracting Rows and converting Rows to numeric vectors Entering data Vectorwise maximum/minimum Column Sums and Row Sums R can do some awesome data visualizations: http://gallery.r-enthusiasts.com/thumbs.php Instead of doing one off data visualizations like with Excel, R can automate the process allowing one to visualize many sets of data with the same visualizations. Installing R is pretty easy http://scs.math.yorku.ca/index.php/R:_Getting_started_with_R There are lots of blogs out there on getting started with R. The one thing that I didn't find explained well was slicing and dicing data. Lets take some data that I want to visualize.  The following data shows the performance of ...

Kyle Hailey
Uncategorized

  I wanted to plot a set of data by 3 dimensions. I wanted to plot I/O read latency by MB/s throughput by number of concurrent readers. Seemed simple. Well it turns out there is no good way to do it in Excel. Sure Excel has 3d charts but, attention, the z axis is treated like rows and not values. For example Note that the z axis, "users" had 3 values marked  on the axis. Those 3 values are 1,16 and 64. Notice that  16 is as far from 1 as 64 is from 16, ie the distance is not proportional to the ...

Kyle Hailey
Uncategorized

If one is seeing  'enq: TX - row lock contention' there could be a lot of reasons. One distinguishing factor is the lock mode. If the lock mode is exclusive (mode 6) then it's most likely a classic row lock where two sessions are trying to modify the same row. On the other hand if the lock mode is share (mode 4)  it's typically going to be inserting a unique key when  someone else has already inserted that key but not committed Inserting a foreign when then parent value has been inserted but not committed or deleted and not commited (not to ...

Kyle Hailey
Uncategorized

Here is a short video D3 Show Reel from Mike Bostock on Vimeo. Here is a longer tutorial video Data-driven Documents from London Web Standards on Vimeo. You can go through the actual presentation slides at http://lws.node3.org/#landing-slide NOTE: these"slides" are active pages. You can click on the pages and interact with them. They are in live d3. Try this page for example and click on one of the  points in the graph http://lws.node3.org/#transitions-2     This page is a fun one: http://lws.node3.org/#demo-3 Drag your mouse around the page - it eventually draws a picture

Kyle Hailey
Uncategorized

  The human brain works so well because it calculates outcomes as it takes actions feeding back the current results compared to the expected results  which allows immediate corrections if the two are not aligning. Such a immediate comparison between expected results and actual is an important functionality to include into software in order to have the best results especially when it comes to usability and user friendliness. Software that doesn't give any feedback until a job is supposedly finished is setting itself up for at worst failure or at least wasted time and effort. As  Cary Millsap recounts in one of his ...

Kyle Hailey
Uncategorized

Tom Kyte, Tim Gorman, Kellyn Pot'Vin, and Ben Prusinski are flying in to the Bay Area to present at NoCOUG Nov 15. I'll be presenting as well on how to make dozens of multi-terabyte database copies in seconds using various easily available technologies on the market now. http://www.technicalconferencesolutions.com/pls/caat/caat_abstract_reports.schedule?conference_id=116 NoCOUG is offering free admission to the first 25 people who answer the following SQL riddle: SQL comes in two distinct flavors—“relational calculus” and “relational algebra.” Without sweating the technical details, let’s just say that the relational calculus flavor is characterized by correlated subqueries—subqueries that refer to outside values—while the relational algebra flavor is characterized by ...

Kyle Hailey
Uncategorized

Oaktable world (aka Oracle Closed World) was an another amazing conference. We are already planning 2013 More videos will be posted as we have time to process the footage (help from video editors more than encouraged, email me Kyle.Hailey at  delphix.com ) Here are a few photos from this year: Oct 2012 photos photos from Karl Arao Thanks everyone for an awesome conference. Special thanks to conferences patrons Paul Vallee Tim Gorman Kerry Osborne Marco Gralike Jonathan Gennick Marcin Przepiorowski Without their help the conference wouldn’t have been the same. Thanks to all the speakers Jonathan Lewis – Pessimist view of Exadata, video  , presentation small, large Cary Millsap – Grand Unified Theory of “Tuning” Kyle Hailey – Database Virtualization and Instant Cloning Tanel Poder ...

Kyle Hailey
Uncategorized

From the article "Facebook shares some secrets on making MySql scale" "800 million users and handling more than 60 million queries per second" ..."4 million row changes per second." and that was almost a year ago. Think what it's like now! Ever wonder why Facebook limits your friends to 5000?  Does Facebook want to stop people from using it to promote themselves? Ever see this message "There are no more posts to show right now" on Facebook? Notice it says "There are no more posts to show right now." I got this message when scrolled back in "friends" status updates. After scrolling back a few days ...

Kyle Hailey
Uncategorized

The first 3 videos of talks at Oaktable World are up: Connor McDonald 11g RAC upgrade drama http://oaktableworld.com/video-connor-mcdonald-11g-rac-upgrade-drama/ Tanel Poder hacking session: http://oaktableworld.com/tanel-poder-hacking-session-video/ Tim Gorman on exchange partition http://oaktableworld.com/video-tim-gorman-on-exchange-partition/ We still have more video material to come but only limited resources to go through and edit them.  Comment here if you are interested in help out edit video. For a list of talks see: http://oaktableworld.com/    

Kyle Hailey
Uncategorized