Re: Poor Performance on Oracle9i - 9.2.0.7

Hi, Volker.
In my development environment I am using the spfile but in my production environment I am using the init.ora. Are there differences between them, please?

Hi Beko.
The migration was one monthy ago.
The commands results are:

Buffer Hit Ratio = 94

NAME = MISS_RATIO = IMMEDIATE_MISS_RATIO archive process latch = 0,60059 = 0
cache buffers lru chain = 0,94907 = 1,4294896 enqueues = 0,29050 = 0
error message lists = 2,38805 = 0
hash table column usage latch = 1,635700 = 0,0028822 job workq parent latch = 99,975006 = 8,6155128 library cache = 1,770935 = 26,0725667
library cache pin = 0,425905 = 0
mostly latch-free SCN = 0,390845 = 0
multiblock read objects = 0,633379 = 0
NLS data objects = 8,3326389 = 0
parallel query alloc buffer = 22,4102894 = 0 parallel query stats = 37,3735486 = 0
process queue = 1,6352194 = 0
process queue reference = 0,0383967 = 0,20145200 query server freelists = 14,2420345 = 0
redo allocation = 0,6781498 = 0
row cache enqueue latch = 0,5896371 = 0
row cache objects = 1,2450116 = 0,50648546 session allocation = 0,7588896 = 0
shared pool = 1,54022427 = 0
sort extent pool = 0,94563953 = 0

Thank you. Received on Tue May 09 2006 - 07:31:55 CDT