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 -> Will setting timed_statistics=TRUE create much overhead?

Will setting timed_statistics=TRUE create much overhead?

From: <dmnwork_at_my-deja.com>
Date: Thu, 01 Feb 2001 13:00:19 GMT
Message-ID: <95bml0$g0j$1@nnrp1.deja.com> 








An Oracle DB monitoring product I'm using (Spotlight on Oracle) wants
to set timed_statistics=TRUE. The product docs claim this won't create
significant DB overhead (this is for an ORCL 8.0.5 database, which will
be upgraded to 8.1.6 eventually).



What's the real answer? I know ANALYZE TABLE COMPUTE STATISTICS
statements can be a real drag on performance. What will happen if
timed_statistics is turned on?




Thanks very much.






Sent via Deja.com


http://www.deja.com/
Received on Thu Feb 01 2001 - 07:00:19 CST












Original text of this message













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