Re: [Sqlrelay-discussion] ORA Error : ORA-04030

[David M. <dav...@fi...>]

On Mon, 2007-07-16 at 11:42 +0200, Huve Loic wrote:
> 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 ?

All of the sorting is done in Oracle, SQL Relay doesn't do any
processing of the result set.  So, maybe Oracle is running out of
"sort-memory".  I know Oracle uses the global shared pool for that, but
I'm not exactly sure how.  It could be that certain queries are trying
to use more shared pool memory than Oracle is configured to allow them
to use.

Dave

> 
> 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
> 
> 
> 
> 
> -------------------------------------------------------------------------
> This SF.net email is sponsored by DB2 Express
> Download DB2 Express C - the FREE version of DB2 express and take
> control of your XML. No limits. Just data. Click to get it now.
> http://sourceforge.net/powerbar/db2/
> _______________________________________________ Sqlrelay-discussion mailing list Sql...@li... https://lists.sourceforge.net/lists/listinfo/sqlrelay-discussion