One minor caveat about setting timed_os_statistics. On Solaris, if you set timed_os_statistics to non-zero, microstate accounting at the OS level is enabled for the server process. Common practice is to leave it off for performance reason. But I've never seen experimental data proving the negative effect of turning it on.
Yong Huang Tanel Poder wrote: Hi! Statistics level ALL means TYPICAL + row source execution stats + timed_os_statistics. If you want to switch to ALL for performance reasons, you can switch only row source stats on with parameter setting _rowsource_execution_statistics to true (on session level). But I doubt it'll help in current case anyway. Tanel __________________________________ Do you Yahoo!? Find out what made the Top Yahoo! Searches of 2003 http://search.yahoo.com/top2003 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Yong Huang INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
