The above is so cool.
The graphic shows the latency heatmap of “log file sync”. I was running a swingbench load and at the same time throttling I/O such that latencies started off good then got worse and then back to normal.
All I did was type
sqlplus / as (more...)
On Thursday I attended the UKOUG Database Server SIG in Leeds. All slides have been uploaded to the UKOUG website.
It’s the first SIG I’ve attended this year and after enjoying it so much I ought to try harder to get to other events. We had Oak (more...)
Here’s a quick and dirty script to create a procedure (in the SYS schema – so be careful) to check the Hakan Factor for an object. If you’re not familiar with the Hakan Factor, it’s the value that gets set when you use the command “alter table minimize records_per_block;”.
What is new in SQLT? A couple of new stand-alone utilities. Both can be used without having to install SQLT. And both are only for 11g+. Look for sqlt/utl/mon and sqlt/utl/spm. The former is to monitor executions taking longer than 5 seconds (requires Oracle Tuning Pack and it uses the (more...)
Cloud computing has brought a host of advantages for businesses that have become impossible to ignore, from decreased capital spending to enhanced collaboration. However, the true benefits of these technologies come with time, and therefore, a more extensive and strategic cloud plan, with remote database support, can potentially offer enterprises (more...)
This week again, the Log Buffer Edition covers the exciting and ever-evolving galaxies of Oracle, MySQL and SQL Server.
When does an Oracle process know it’s on Exadata?
MobaXterm 6.3 has been released. You can find the download and changelog in the usual place.
Business intelligence (BI) solutions have the potential to empower businesses in a multitude of ways by allowing professionals to mine extensive stores of information for enhanced insight. However, many firms still aren't fully leveraging these tools due to inadequate resources or expertise. However, by seeking the professional support of database experts (more...)
I’ve had my 13″ MacBook Pro since the Mid 2009 refresh and it’s been really reliable. Apart from one brief visit to Apple to replace a noisy fan, I’ve had no worries. A few years ago I upgraded from 4G to 8G RAM, so I’m not stranger to taking the (more...)
I just read this post about a new patch that will allow you to affect the way the optimizer calculates clustering factor and hence how likely it is to choose a particular index for a query plan.
Pretty cool. I haven’t tried it, but it looks (more...)
This is yet another blogpost on Oracle’s direct path read feature which was introduced for non-parallel query processes in Oracle version 11.
For full table scans, a direct path read is done (according to my tests and current knowledge) when:
- The segment is bigger than 5 * _small_table_threshold.
So, I checked (more...)
Cost Based Oracle – Fundamentals (November 2005)
But the most interesting function for our purposes is sys_op_countchg(). Judging from its name, this function is probably counting changes, and the first input parameter is the block ID portion (object_id, relative file number, and block number) of the table’s rowid, so the (more...)