Hi
I got a lot of time data stored.
When running too big range on data points I'm getting an error : ORA-04036: PGA memory used by the instance exceeds PGA_AGGREGATE_LIMIT for ..
Did anyone encountered that error before?
Is there a limit on number of rows that chart can display?
For SQL I'm using a pipeline function with parameters to and from as dates and fetch limit for cursor is 100k.
And there is not that many data points anyway its about 20k rows.
There are multiple graphs.
Here is a full error
Ajax call returned server error ORA-04036: PGA memory used by the instance exceeds PGA_AGGREGATE_LIMIT for .
And details from debug.
- ora_sqlerrm: ORA-04036: PGA memory used by the instance exceeds PGA_AGGREGATE_LIMIT
ORA-06512: at "APEX_210100.WWV_FLOW_JET_CHART", line 3485
ORA-06512: at "APEX_210100.WWV_FLOW_JET_CHART", line 3760
ORA-06512: at "APEX_210100.WWV_FLOW_JET_CHART", line 3785
- error_backtrace: ORA-06512: at "APEX_210100.WWV_FLOW_JET_CHART", line 3485
ORA-06512: at "APEX_210100.WWV_FLOW_JET_CHART", line 3760
ORA-06512: at "APEX_210100.WWV_FLOW_JET_CHART", line 3785
ORA-06512: at "APEX_210100.WWV_FLOW_JET_CHART", line 3929