Oracle is an exceedingly complicated collection of software and there are more configuration options than you can shake a stick at. As I write this, my 10gR2 database shows 1442 different parameters. Assuming the parameters each had only 2 possible values (which they don’t), the number of possible combination would be 2 raised to the 1442 power. Being as I’m an Oracle guy, I tried to calculate this using SQL*Plus as follows:

SQL> select power(2,1442) from dual;
select power(2,1442) from dual
ERROR at line 1:
ORA-01426: numeric overflow

Hmmm, must be a really big number. So I google for a web based calculator (it’s easier than finding the windows one – and I hate windows anyway). Low and behold, google has a built in calculator. Try it yourself. Try googling for something like 2*(15**3). Those guys at google are always coming up with something.

So I try to use this to do my calculation and it’s too big for them too (you’d think something called “google” would be able to deal with big numbers, but oh well!).

So next I try Excel and I get this:

So now I’m getting bored trying to figure out a way to calculate it. I’m sure I could get my friend Cary to calculate it with his copy of Mathmatica, but you get the idea. There are basically an (almost) infinite number of variations, so please keep that in mind when trying to reproduce any results that I may spout off about. Your mileage may vary.

Leave a Reply