Blog Aggregator - Amardeep Sidhu

I recently had an opportunity to do a deeper dive into a performance issue related to the performance of a PIPELINED function. The results weren’t quite what I had expected, so I thought they may be of general interest. As with many performance issues, the issues encountered here are likely data- and database-specific. This was […]

Last week I read a post in Andy C’s blog about the service called Disqus. It is a service to keep track of comments in blogs. Later he made another post about it.

I have been looking for a solution to keep track of blog comments, both mine and other people’s. Not all blogs have the option to subscribe to the comments, when you comment on a post you need to check later if someone commented

Welcome, readers, to the 92nd Log Buffer, the weekly review of database blogs.
Brian “Krow” Aker started an interesting blog-thread with his post, The Death of Read Replication, the crux of which is that object caches, such as memcached, make the DBMS itself a little less central, particularly in “Web 2.0″ scenarios. “What does this […]

I use a couple of venues to generate new material, new talking material every year.  Hotsos symposium has always been one, Oracle University Seminars have been another.  Oracle OpenWorld is definitely one as well.

Well, believe it or not, it is time for me to submit my abstract for Oracle OpenWorld already - even though it is not until September.  So, it is time to come up with yet another topic.  I’ve been known to do a “top ten” style presentation for a while at OpenWorld - the last few years have been top tens on 9i Release 2, 10g Releases 1 and 2 and most recently - 11g Release 1.  Intermixed with that was a database ‘worst practices’ presentation as well.

So, now - I’m looking for some fresh ideas.  A topic that can be well covered in an hour and would have broad general appeal.  In reality - if I get a couple of good ideas, I’ll probably generate the material for all of them but just pick one (maybe two) for presentation at OpenWorld. 

So, I invite you to submit an idea - doesn’t have to be fully fleshed out - just a concept, something you would find useful at a venue such as OpenWorld (or a presentation to a user group - as this is where this material will be used time and time again…)

Thanks in advance for any ideas!

Wordpress has released the version 2.5 of its blog. My public domain blogs are already upgraded as being managed by Wordpress itself. But I had to upgrade my private domain blog to the current release myself. I tried it yesterday but some how it didn’t work well. Today I tried with Wordpress Automatic Upgrade plugin and […]

Just a little note to say you can now register for some of my upcoming events.
The Puget Sound OracleDays 2008 Conference in Seattle, USA is now open to registrations:
July 14-18: OracleDays 2008 Conference
This looks like being a huge conference with heaps of really interesting training events and speakers.
You can also register for all dates on the Oracle University Celebrity Series European Spring Tour:
June […]

I’m running two of my Oracle BI Masterclass events in the USA later in 2008, in Denver on June 23rd and 24th and Minneapolis on June 26th and 27th. The format is the same as the Oracle BI Masterclasses I’ve been running through Oracle University, but this time they’re arranged through Speak Tech Seminars, who […]

This time next week I should be back in the UK (but probably still trying to find my baggage at the airport!) after presenting my first conference talk in the USA.
I have been through the slides, made a few adjustments and and cut a CD copy as a backup to my laptop version (and it […]

Collections can be a great help in speeding up the PL/SQL programs. By using bulk collect operations it is possible to get great performance improvements.

In 9.2 we needed to use the bulk collect clause to fetch rows into a collection. 10G brings a new function called COLLECT, which takes a column as a parameter and returns a nested table containing the column values. Using this we can get the

There’s no video for Jacob Nikom’s December 2007 Boston MySQL User Group meeting, but the slides for “Measuring MySQL Server Performance” can be downloaded (2.33 MB) at http://technocation.org/files/doc/Measuring_MySQL_server_performance_03.ppt
And with that, this is (I believe) post #10,000 at Planet MySQL!