RE: wait events

--openmail-part-092ae953-00000001

Content-Type: text/plain; charset=US-ASCII; name="BDY.TXT"
Content-Disposition: inline; filename="BDY.TXT"
Content-Transfer-Encoding: 7bit

Deepak,

How many CPUs do you have? The value of db_block_lru_latches should depend on number of CPUs..
DB_BLOCK_LRU_LATCHES specifies the upper bound of the number of LRU latch
sets. Set this parameter to a value equal to the desired number of LRU latch sets.
Oracle decides whether to use this value or reduce it based on a number of internal
checks. If the parameter is not set, Oracle calculates a value for the number of sets.
The value calculated by Oracle is usually adequate. Increase this only if misses are
higher than 3% in V$LATCH.
Parameter type: integer
Parameter class: static
Default value: CPU_COUNT/2
Range of values: 1 - twice the number of CPUs

On the other hand, what does the output of V$WAITSTAT show?

How was Env A & B created? Was one the copy of the other? If so, one environment may be a well defragmentented copy of the other... What about indexes and age of statistics and the EXPLAIN PLANS for the SQLs in each of the environments? Reading these could clue you in on why this is happening... What about DB file locations (disk wise) between the two?

All the best in your search for the answer!

John Kanagaraj
Brunei Shell Petroleum
http://www.geocities.com/john_sharmila

God so loved the world that He didn't send a committee! (See John 3:16 for details)
** Opinions expressed here are solely mine and not necessarily those of Received on Sun May 21 2000 - 20:11:45 CDT