Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle function myth on Solaris machinie

Re: Oracle function myth on Solaris machinie

From: Sybrand Bakker <gooiditweg_at_sybrandb.nospam.demon.nl>
Date: Fri, 21 Nov 2003 20:15:51 +0100
Message-ID: <00psrvgs8c8vilkp2tilu5u5joqoo25fkr@4ax.com> 





On 21 Nov 2003 07:44:49 -0800, guo_at_andrews.edu (Limin Guo) wrote:



> WHY sql_trace or 10046 has impact on the insert, I

>don't understand.




Are you familiar with the buffer cache? If so, won't you think a
likely explanation is in your so-called 'fast-mode' everything is in
the buffer cache and in your so-called 'slow-mode' Oracle has to fetch
everything again?


So why are you making up myths?



--
Sybrand Bakker, Senior Oracle DBA


Received on Fri Nov 21 2003 - 13:15:51 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US