Re: performance question
- From: Hemant K Chitale <hkchital@xxxxxxxxxxxxxx>
- To: joan.hsieh@xxxxxxxxx, oracle_l <ORACLE-L@xxxxxxxxxxxxx>
- Date: Mon, 10 Sep 2007 23:09:49 +0800
When you say " Why the returned rows are so different ..."
can you tell us the number of rows returned ? That isn't clear in
the STAT output.
I would start looking at tables PS_EMPLOYMENT, PS_TFTH_JOB and
PS0PERSONAL_DATA.
The number of Blocks Gets for a Full Scan or Index Full Scan is
significant in TRN but not in QA.
Have the tables been rebuilt using Export/Import ? Are the two
databases not cloned from the same
source , but built seperately ?
At 09:21 PM Monday, Joan Hsieh wrote:
Dear list,
Our peoplesoft HR system recently upgraded from 9i to 10.2.0.3. We
did some statistics adjustment to solve one major sql statement.
However, we had another performace issue last week for a newly sqr
statement. I am confused after I had 10046 trace. Here is the story.
QA and TRN two database, same release on same server.
Hemant K Chitale
http://hemantoracledba.blogspot.com
"First they ignore you, then they laugh at you, then they fight you,
then you win" !"
Mohandas Gandhi Quotes
: http://www.brainyquote.com/quotes/authors/m/mohandas_gandhi.html
--
//www.freelists.org/webpage/oracle-l
Other related posts:
