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 thatWindows 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!