Re: SQL in onstat -g ses output

Josi Kyllerd wrote: > Dumb question time: What is the difference between "Current SQL statement" > and "Last Parsed SQL statement"? Usually the SQL is identical in both but > I've always wondered why sometimes this is not the case. And why might > only Last parsed SQL statement be displayed as in the output below? The "Last Parsed SQL statement" is the last statement sent to the database server for parsing (syntax checking etc.) The "Current SQL statement" is the one currently running. The "Current SQL statement" is more useful if you are tracking performance issues. If your code PREPAREs SQL statements at the top of your code and then reuses them, then the "Last Parsed SQL statement" probably has little meaning. Cheers, -- Mark. +----------------------------------------------------------+-----------+ | Mark D. Stock mailto:mdstock@MydasSolutions.com |//////// /| | Mydas Solutions Ltd http://MydasSolutions.com |///// / //| | +-----------------------------------+//// / ///| | |We value your comments, which have |/// / ////| | |been recorded and automatically |// / /////| | |emailed back to us for our records.|/ ////////| +----------------------+-----------------------------------+-----------+