Blog Aggregator - Amardeep Sidhu

I wrote this post because I feel there is a great need for it. The number of people struggling with unstable query plans due to bind peeking in Oracle 10G is enormous, to say the least. More than that, solutions like disabling bind variable peeking are driving us away from understanding the root cause of […]

I’ve often wondered why companies really want to own their computers. HP has voiced the same rhetorical question by launching AIaaS.
Why Do They Put Those Data Centers There?
But Atlanta? Is power really that cheap in Atlanta? It must be all that cheap hydroelectric power down there.
What’s This Have To Do With Oracle?
This is an Oracle-related […]

RDA 4.11 is out, with a couple of new features. “Oracle Database Diagnostics Collector” (ORADDC) is one of those. It allows you to easily activate all kinds of traces, dumps, or stack collections.
Once RDA 4.11 installed, run ./rda.pl -T oraddc to collect whatever you need. The tool will guide you. To learn more about its […]

At the moment I am in Cairo delivering a number of 11g New Features trainings.
I have a completely packed class with 21 students.
 Most of the students are Oracle Trainers, Support Agents and Consultants.

One of the great myths surrounding the use of differing block sizes is that storing indexes in larger block sizes somehow dramatically improves the performance of index related multiblock reads.
Oracle performs index multiblock reads when performing an Index Fast Full Scan, when it basically treats the index structure as a skinny version of the table. It […]

It started at 5pm, because all interesting production issues start at 5pm. As the on-call DBA, I recieved an alert about over used undo tablespace on one of our databases. First thing to do in such case is check v$transaction for transactions that have been running for a while. Turned out that v$transaction is […]

Windows Vista SP1 direct update slips to next month

Microsoft is doing a really bad job announcing dates for releasing Windows Vista Service pack 1 (SP1) and then delaying it further. I have been waiting since last December to update my windows Vista ultimate. It’s worth mentioning here that my desktop is HP a6150e with dual core AMD processor and 4 GB ram it’s running like a 486. I hate windows vista but i was stuck with Windows vista because it came pre installed on my HP desktop and that time i didn’t have option to choose windows XP.

Last month i heard that Microsoft is going to release Windows vista SP1 in March , so i started counting days and when 2 weeks gone by just waiting and waiting i came to know on Tech dispenser that Windows Vista SP1 will be officially available for downloads on March 18 on Microsoft’s download site. The SP1 will be available through Windows Update only by April.

I wouldn’t be downloading the Windows Vista service pack 1 (SP1) but prefer updating it through windows update i have to wait little bit longer till next month April

How to display HP-UX Itanium server information:

On Itanium systems running HP-UX 11v2/v3 for displaying system information HP introduced a new command called machinfo. Running machinfo command on Itanium HP-UX systems (servers) not only displays CPU information, memory information, firmware version, HP-UX system model but it also displays system serial number

In the example above running machinfo on HP-UX Itanium system displays number of CPU, CPU speed and CPU family as Itanium processor. However machinfo doesn’t shows information on CPU core type, to find out if CPU is single/dual or quad core see my earlier articles on How to find HP-UX CPU is dual or quad core. Also machifo command displays Itanium HP-UX system’s memory size and firmware information.

If you want to find out the Itanium HP-UX system model and system serial information you would need to run machinfo .In the example above HP-UX system mode type is rx6600 and also displays system serial number.

We’ve been running into a problem with one client
SELECT COUNT(*) FROM tbl;
Takes 0.25 seconds on one db, and 0.06 seconds on another.
Consistently. That’s a fourfold difference.
There aren’t any significant configuration differences (like query cache, etc.), the software versions are the same, and the table fits into memory. This has been […]

In the final part of my series on migrating an OBIEE installation from direct application access to a data warehouse, I’m finally going to plug my new data warehouse into my OBIEE logical model. Previous to this, in the first posting I created a single logical model over three different application data sources, and in […]