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

Home -> Community -> Mailing Lists -> Oracle-L -> RE: performance question

RE: performance question

From: Alvaro Jose Fernandez <alvaro.fernandez_at_sivsa.com>
Date: Mon, 10 Sep 2007 16:59:36 +0200
Message-ID: <607D6181D9919041BE792D70EF2AEC48242BC3@LIMENS.sivsa.int> 






Hi Joan and all,



What it's puzzling me is the output of id=27, the iff on
PS0PERSONAL_DATA . On QA returns 31,967 , vs. 0 on TRN.



stats for PS_EMPLOYMENT are the same on both (including indexes)????



regards,



alvaro




(QA: 


STAT #1 id=27 cnt=0 pid=13 pos=2 obj=64184 op='INDEX FAST FULL SCAN 
PS0PERSONAL_DATA (cr=0 pr=0 pw=0 time=0 us)'
)

--
http://www.freelists.org/webpage/oracle-l


Received on Mon Sep 10 2007 - 09:59:36 CDT












Original text of this message













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