Re: process running slowly, lots of yield() calls ?
Date: Sat, 22 Nov 2008 08:48:46 -0000
"joel garry" <joel-garry_at_home.com> wrote in message news:e423a089-880e-446d-ba32-cb17024edcfa_at_a37g2000pre.googlegroups.com...
Would that be true of the PL/SQL lock timer sleep? In my ignorance of how it actually works I'm imagining silly code that hyperaggressively checks for time slept at a very fine grain. "I'm ready to run George, oh, ok, I'm yielding, now I'm ready to run George, is it time yet, huh George, huh George, huh?"
-- @home.com is bogus. Wentz, B. M. http://newsroom.mtv.com/2008/11/21/is-bronx-mowgli-wentz-the-best-celebrity-baby-name-ever/ Joel, I believe the pl/sql lock timer sets an alarm (pretty much as an ordinary enqueue wait) for the required interval. -- Regards Jonathan Lewis http://jonathanlewis.wordpress.com Author: Cost Based Oracle: Fundamentals http://www.jlcomp.demon.co.uk/cbo_book/ind_book.html The Co-operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.htmlReceived on Sat Nov 22 2008 - 02:48:46 CST