Windows/Oracle 9i takes 4 mins
DECLARE
LIM NUMBER;
BEGIN
LIM := 100000000;
FIBONACCI ( LIM );
COMMIT;
END;

call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.01 0.00 0 0 0 0
Execute 1 260.09 268.77 0 0 0 1
Fetch 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 2 260.10 268.77 0 0 0 1

Misses in library cache during parse: 1
Optimizer mode: RULE
Parsing user id: 47

Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
SQL*Net message to client 1 0.00 0.00
SQL*Net message from client 1 183.55 183.55



Oracle9i/Solaris 10 take 20 mins+


DECLARE
LIM NUMBER;
BEGIN
LIM := 100000000;
FIBONACCI ( LIM );
COMMIT;
END;

call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 2 0.01 0.01 0 0 0 0
Execute 2 1592.53 1555.19 0 0 0 1Fetch 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 4 1592.54 1555.20 0 0 0 1

Misses in library cache during parse: 1
Optimizer goal: RULE
Parsing user id: 61

I'm convinced there is some sort of capping on cpu going on Solaris10.
Windows goes to 100% when the sql is run. Solaris 10 sits there at 4% CPU.