ERROR 4305: Out of system WOS memory during catalog SELECT

Dear Friends,

I am getting the error- "vsql:/tmp/vrt_temp_exec.sql.4326:24: ERROR 4305:  Out of system WOS memory during catalog SELECT
HINT:  Increase sysdata.maxmemorysize, current value is 1048576 KB"

The error is because of the select query in my sql script:
select now();

When i checked the resources allocated to resource_pools, i get the below information-

SELECT NAME,MEMORYSIZE,maxmemorysize FROM RESOURCE_POOLS;

NAME          MEMORYSIZE    maxmemorysize
general                                   Special: 95%
sysquery            64M   
sysdata              100M                 1G
wosdata             0%                     2G
tm                      200M   
refresh               0%   
recovery            0%   
dbd                    0%   
jvm                    0%                     2G
svcacct_pool    0%   


#My sample script look like;

select now();

insert  /*+direct*/ INTO table1
select * from table1_bkp;

select now();

Update ...

select now();

.....

....
# End of script

Please help me out how to resolve the issue.

Note: I just wanted to have the select now(); query in my script to check how much time it takes for each load data from one table to other.

Regards,
Kushal