Read and monitor Oracle related blogs and news sources, all in one place.
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.
https://www.ukoug.org/events/ukoug-database-server-sig-meeting-may-2013/
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...)
In my forum discussion about free buffer waits I came across a term that I didn’t understand: “inode lock contention”. I’m pretty sure I had seen this same term years ago on one of Steve Adams’ pages on IO. But, I didn’t really understand what the term meant (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...)
It’s the only explanation!
Ace has dealt with problems before…
The post Changes (Ace Comic) appeared first on Steve Karam :: The Oracle Alchemist.
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.
- (more...)
Thanks to Norman Dunbar for pointing out that MobaXterm 6.3 has been released. You can find the download and changelog in the usual place.
I’ll be interested to see how the performance improvements to SFTP work out. I’ve seen some issues with this during transfers of large files before. (more...)
UltraEdit 4.0 has been released for Mac and Linux. The downloads are in the usual place. You can see the latest changelogs here (Mac, Linux).
Fun, fun, fun…
Cheers
Tim…
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...)
RSS