so_damn_insane (![[info]](http://klab.lv/img/userinfo.gif){kind=small} so_damn_insane) rakstīja,@ 2008-11-05 11:12:00 |
 |
 |
 |
|
|
|
|
|
|
 |
|
 |
ORA-04031 (produkcijā nemēģināt)
select count(*)
from (
SELECT ROWNUM,
(power((1 + sqrt(5)) / 2, ROWNUM) - power((1 - (1 + sqrt(5)) / 2), ROWNUM)) / sqrt(5)
FROM dual
CONNECT BY LEVEL <= 4000000);
ORA-04031: unable to allocate 48 bytes of shared memory ("shared pool","unknown object","cursor work he","cursor work heap")
select count(*)
from (
SELECT ROWNUM,
(power((1 + sqrt(5)) / 2, ROWNUM) - power((1 - (1 + sqrt(5)) / 2), ROWNUM)) / sqrt(5)
FROM dual
CONNECT BY LEVEL <= 4000000);
ORA-04031: unable to allocate 48 bytes of shared memory ("shared pool","unknown object","cursor work he","cursor work heap")
Nopūsties:
