Skip to Main Content

Data Science & Machine Learning

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to solve the Error in ORE: always the allocate a vector of the size of ***

不了峰Dec 1 2014 — edited Dec 5 2014
I  create an  object DF_403_TABLE for class ore.frame , I want to run dist(DF_403_TABLE) in ORE, but I encountered in ore runtime
"Error : cannot allocate vector of size***"


I read "I can" t analyze the or mine all of my data, it has to be the javax.media.sound.sampled "and
Oracle R Enterprise Documentation.

I thought ORE can deal with the problem of insufficient memory.

But why would still meet the  error above, how should I solve it, (through  sampled or additional memory)
Would you please tell me another way to get the result.

The environment that
Windows 2008, Oracle 11.2.0.4, ORE 1.4.1 64 bits
4 GBof OS memory

sql > EXEC sys.rqconfigset('MAX_VSIZE', '20G')
SQL> SELECT * FROM sys.rq_config;

NAME                 VALUE
-------------------- -------------------------------------------------
R_HOME               C:\PROGRA~1\R\R-30~1.1
R_LIBS_USER          C:\app\product\11.2.0\dbhome_1\R\library
VERSION              1.4.1
MIN_VSIZE            32M
MAX_VSIZE            20G
MIN_NSIZE            2M
MAX_NSIZE                                                                       

7 rows selected

for example:

> dim(DF_403_TABLE)
[1] 71062    24

head(DF_403_TABLE,2)
X0 X1 X2 X3 X4 X5 X6 X7  X8 X9 X10 X11 X12 X13 X14 X15 X16 X17  X18 X19 X20 X21 X22 X23
0  0  0  0  0  0  0  0  24 50  61  79 149   0   0   0   0   0   0   0   0   0   0   0
6  0  0  0  0  0  0 76 141 49  66 103 250 365 272   8  90  46   124 162   4 127 149  16


begin
sys.rqScriptdrop('rqs_dist');
end;
/


begin
  sys.rqScriptCreate('rqs_dist',
  'function(dat) {
     dist(dat)
    }');
end;
/


select *
from table(rqTableEval(
   cursor(SELECT X0,X1,X2 FROM DF_403_TABLE  ),
   null,
   null,
   'rqs_dist'))

ORA-20000: RQuery error
Error : cannot allocate vector of size 18.8 Gb
ORA-06512: 在 "RQSYS.RQTABLEEVALIMPL", line 112
ORA-06512: 在 "RQSYS.RQTABLEEVALIMPL", line 109

在ORE中

> DF_403_dict <- ore.tableApply(
+   DF_403_TABLE[,c(-1,-26)],
+   function(dat) {
+     dist(dat)
+   })
Error in .oci.GetQuery(conn, statement, data = data, prefetch = prefetch,  :
  ORA-20000: RQuery error
Error : cannot allocate vector of size 18.8 Gb
ORA-06512: 在 "RQSYS.RQTABLEEVALIMPL", line 112
ORA-06512: 在 "RQSYS.RQTABLEEVALIMPL", line 109

~~~~~~~~~~~~
Thanks!
This post has been answered by Sherry Lamonica-Oracle on Dec 3 2014
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 2 2015
Added on Dec 1 2014
2 comments
1,346 views