Printable View
Thanks Pando;
'4010 is related to PGA'.
I am connecting from the server directly and think it makes a dedicated server connection in this case. I have a plenty of memory unused but still get this error for only one query while the others with more number of record(and so sorts) go through well.
Will increasing the ram help or decreasing the Sort_area_size help. If decreasing sort_area_size can help then why?
Please clarify.
Badrinath
Windows OS? What is the memory usage of Oracle.exe?
Yes It's Windows: Oracle.exe is 572 MB.
One question: How can the Oracle.exe be 572 while the the SGA is ~800MB.
Badrinath
I guess that part of it is paged out.
I have 2GB of Physical memory and 4 GB of VM, even if it paged out, isn't the memory available?
Thanks,
Badrinath
Hi,
How did you fix your problem?
I am also getting same ORA error.
Pl. share...
Thanks,
Sorry! I didn't post back the reply.
I decreased the sort area size to 50M and the SGA size (as I had a lot of unused shared pool)( It's still high and will reduce it after few more testing). I also monitored the memory usage and was at time shocked to see the memory usage going as close as 2GB (the limit for oracle as I have not made any changes to the NT boot.ini file to extend the memory).
Badrinath