Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have a SELECT query using several WITH blocks. Sometimes it runs successfully. Very often it fails with the error "Lookup Error - Oracle Database Error: ORA-32696: HTI: No free slot". I Googled the error, but the only advice is to "Increase memory". There are several discussion boards where people metion this error and ask what memory needs to be increased. I am not a DBA and cannot increase any memory allotments. I contacted my DBA and she said my only option was to try to optimize my query. Does anyone know specifically what causes this error?

share|improve this question
Are there any other errors in the error stack? Are you using parallel query? – Justin Cave Apr 9 '12 at 4:10

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.