Yesterday, Mark mentioned a new Oracle white paper on Cube Organized Materialized Views - now that is a bit of a mouthful and shouts out to be made COMV or something equally short and saving of typing. I say that because I have recently submitted the final version (in time so as to be included […]
I’ve got a bunch of half-finished aticles at the moment, but I’ve finally been able to close something off at last:
SQL Plan Management in Oracle Database 11g Release 1
Hopefully, I’ll get a couple of other things sorted soon.
Cheers
Tim…
While doing a standard audit for a new client, I recommended a few changes to get better performance. Because I had several changes, I used the documentation at
http://dev.mysql.com/doc/refman/5.0/en/server-system-variables.html
and found that innodb_flush_log_at_trx_commit is a dynamic variable. I was surprised, because most operations dealing with file sizes and operations are not dynamic. But […]
A common misconception with using a larger block tablespace specifically for indexes is that this will result in a reduction in the height of indexes and hence ”flatten” index structures.
However, this is only partly true.
A few little generalisations to begin with.
First, most databases out there have a default block size of 8K. I won’t go into a big […]
I’m just sitting in the departure lounge at Heathrow Terminal 2, waiting for my flight to Bucharest. I’m running the last of the Enterprise BI Masterclass seminars (at least in Europe) over the next couple of days, and this is a particularly interesting one for me as it’s my first time in Romania. Whilst I […]
I went round to a friends house last night and watched American Gangster on DVD. I didn’t bother to see it at the cinema because it really didn’t appeal to me, but it was a pretty good film. Denzel Washington always does the job well, although I don’t think he’s as good as the critics […]
Recently I acquired Sesame Street Volume 1, and on the third DVD in the set I came across one of my favorite Sesame Street songs: “Who are the people in your neighborhood?”
Here’s a sample of one such skit, if you are not familiar with it, or if you want a bit of nostalgia http://youtube.com/watch?v=B9lpUjQvToY […]
My name is Vasu Balla, and I’ve been with Pythian for about four months now. I have worked on Oracle E-Business Suite instances for over five years, and I’ve never had a moment where I felt bored.
I am constantly challenged with new technologies and new issues, and my Pythian team’s clients continue to […]
© 2008 Blog Aggregator - Amardeep Sidhu | Entries (RSS) and Comments (RSS)
Powered by Wordpress, design by Web4 Sudoku, based on Pinkline by GPS Gazette