In part 1 of the series I tried to explain (probably a bit too verbose when it came to session statistics) what the effect is of delayed block cleanout and buffered I/O. In the final example the “dirty” blocks on disk have been cleaned out in the buffer cache, greatly reducing the amount of work to be done when reading them.
Check out the video of US President talking about Data Science and the first Chief Data Scientist of the USA talks about his mission.
Hi, welcome to RDX! Nowadays, almost every company uses business intelligence tools. Whether measuring return on investment or identifying your most popular products, BI can be an integral part of your operation.
But how will the technology progress in 2015? For one thing, it’s likely that new iterations of relational databases will receive integrated analytics functions. SQL Server is one particular solution that has become more compatible with Power BI, Microsoft’s signature BI application.
As I headed to Denver to attend the Rocky Mountain Oracle Users Group’s (RMOUG) training days, I was pretty excited to get to warmer weather. Typically people don’t say that they are going to Denver to warm up but as I entered my car in the morning it was -22 C. This would be my first visit to RMOUG […]
Once upon a time I had a laugh on facebook when someone posted an image showing multiple groups dedicated to stopping duplicate groups, oh the irony.
Recently I've been trying to share my blog posts via LinkedIn but I'm always unsure which of the seven APEX groups I'm a member of I should post to.
Looks like the nice PL/SQL facility for returning a set of updated rows is restricted when it comes to database links
(This tested on 22.214.171.124)
"There are no wrong roads to anywhere."
- Norton Juster, The Phantom Tollbooth
Oracle can do some, well, strange things when fixing issues caused by the optimizer. For 10g releases up to 10.2.0.x Oracle chose to silently ignore a message and eliminate an outer join on the MERGE statement under certain conditions. Let’s examine this and see exactly what Oracle implements.
Occasionally in a 10046 trace file generated from 10g releases prior to 10.2.0.x and procesed by the tkprof utility you may see something similar to this: