Re: Insufficient memory to parse request during Optimizer phase.
ifact one of our developr faced the same error. it has got something to do with maxparsetreeseg. what is the current value that is set in your system? i suggest you ask ur dba to increase it to 4000 and then give it a shot. if u still find the error then u may have to revisit your SQL statement. IMP: when ever you are trying to use a join avoid using sel * from.... . i mean it is better to restrict the col's.