[Sqlrelay-discussion] ORA Error : ORA-04030

[Huve L. <l....@fo...>]

Hi David,

I have check my "ulimit -m" and all are unlimited and when errors appear
I have no memory leaks (ram used and process don't use memory 
more than usually). 
On oracle alert log I never see these error (in general ORA-XXX are log
in).
I have check a little more and It's only errors on "SELECT DISTINCT".
Is it possible, at one time, to many "SELECT DISTINCT" use all the "sort
memory" of sqlrelay ?

I let run sqlrelay all the week and ratio is good but on the total
errors 95% are SELECT-DISTINCT.
  Total  Queries:             79484886
  Total  Errors:                677

I Try to do something, I just put a new sqlrelay server and a keepalived
so with more connections open that maybe limit the numbers of errors.

Thank's 
Loic