On 2008.04.16, Don Baccus <[EMAIL PROTECTED]> wrote: > Did you try speeding up the plan generation using Oracle's method of > giving hints?
Yes, we /*+HINTED*/. Oracle trace log showed parse times of 160ms +/- 10ms. Plan generation wasn't the killer. Parsing the SQL was the killer. It wasn't complex, but was large (~2K, before variables). Okay, maybe 2K of SQL is "complex" by many people's standards, but by size alone, it wasn't the largest SQL we had in this project. And, yes, we pushed to have no single query execution take longer than 60ms. (This was for an e-commerce implementation.) There was something about the query that was just expensive to parse. Rather than spend time trying to work through Oracle's parser, we just punted and pushed it into a stored procedure. -- Dossy Shiobara | [EMAIL PROTECTED] | http://dossy.org/ Panoptic Computer Network | http://panoptic.com/ "He realized the fastest way to change is to laugh at your own folly -- then you can let go and quickly move on." (p. 70) -- AOLserver - http://www.aolserver.com/ To Remove yourself from this list, simply send an email to <[EMAIL PROTECTED]> with the body of "SIGNOFF AOLSERVER" in the email message. You can leave the Subject: field of your email blank.
