| How to solve latch Promble? [message #64789] |
Fri, 30 January 2004 21:09  |
kothari Alpesh
Messages: 27
Registered: December 2001
|
Junior Member |
|
|
I have run the following query and it gove the below result.
can anybody give me suggetion or figure out where is the problem???
Thanks
Alpesh Kothari
select SUBSTR(NAME,1,25) NM,
GETS,
MISSES,
((GETS-MISSES)*100) / GETS PRCNT,
IMMEDIATE_GETS IG,
IMMEDIATE_MISSES IM
from sys.v_$latch
where GETS != 0
or IMMEDIATE_MISSES > 0
order by ((GETS-MISSES) / GETS) desc;
Name GEES PRCNT IG IM
------------------------- ---------- ------ ---------- ---------
session switching 80126 100 0 0
event group latch 790411 100 0 0
file number translation t 18351 100 0 0
message pool operations p 3 100 0 0
mostly latch-free SCN 1 100 0 0
archive control 24542 100 0 0
redo copy 56 100 31630520 10892
begin backup scn array 23766 100 0 0
transaction branch alloca 80002 100 0 0
job_queue_processes param 80002 100 0 0
ncodef allocation latch 80002 100 0 0
address list 1 100 0 0
Direct I/O Adaptor 2 100 0 0
library cache load lock 276852 100 0 0
dictionary lookup 1030 100 0 0
ktm global data 16484 100 0 0
sort extent pool 45574 100 0 0
archive process latch 24547 100 0 0
active checkpoint queue l 2352008 99.9999 0 0
channel operations parent 1580892 99.9998 790353 179658
channel handle pool latch 790421 99.9998 790353 3277729
dml lock allocation 15579036 99.9997 0 0
list of block allocation 15328700 99.9997 0 0
process group creation 1580763 99.999 0 0
process allocation 790411 99.9994 790407 4
longop free list 171693 99.9994 0 0
transaction allocation 23956996 99.9994 0 0
undo global data 30058288 99.9987 0 0
Token Manager 570183 99.9987 76394 0
cache buffers chains 2294149457 99.9986 303321952 10891
session idle bit 220116969 99.9984 0 0
enqueues 54640169 99.9983 0 0
sequence cache 16246935 99.9982 0 0
cache buffer handles 2482045 99.9971 0 0
enqueue hash chains 35317572 99.9971 0 0
process queue reference 3961274 99.9940 280995 583
redo allocation 47679169 99.9907 0 0
checkpoint queue latch 20091496 99.987 0 0
multiblock read objects 49149522 99.9845 66 0
row cache objects 388177536 99.983 128079 91
query server process 3803 99.9737 3803 0
library cache 424674779 99.9688 15116434 17056
shared pool 247208289 99.9530 0 0
session allocation 35271778 99.9284 0 0
user lock 3153824 99.9271 0 0
loader state object freel 242652 99.9151 0 0
query server freelists 42280 99.8888 0 0
process queue 40234 99.8856 0 0
messages 51323498 99.8544 0 0
error message lists 16230 99.7905 0 0
parallel query alloc buff 72656 99.6091 0 0
redo writing 43902823 99.401 0 0
latch wait list 14223 99.3601 14150 1
cache buffers lru chain 317200462 99.1880 168919 138
parallel query stats 12682 97.7054 0 0
|
|
|
|
|
|
| Re: How to solve latch Promble? [message #64791 is a reply to message #64790] |
Sun, 01 February 2004 23:18  |
kothari Alpesh
Messages: 27
Registered: December 2001
|
Junior Member |
|
|
This is written in he hurry?? But I mean to say that There is a problem with Performance and this is the proactive action as far as concern right now there is no probs with the performance but ratio is decreasing
if u have any solution except buffer , Library and data cache then give me a solution
Thanking u
Alpesh
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
