Home » RDBMS Server » Performance Tuning » How to solve latch Promble?
How to solve latch Promble? [message #64789] Fri, 30 January 2004 21:09 Go to next message
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 #64790 is a reply to message #64789] Sun, 01 February 2004 05:06 Go to previous messageGo to next message
Thiru
Messages: 1089
Registered: May 2002
Senior Member
why do you think that there is a latch problem ?
Re: How to solve latch Promble? [message #64791 is a reply to message #64790] Sun, 01 February 2004 23:18 Go to previous messageGo to next message
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
Re: How to solve latch Promble? [message #64793 is a reply to message #64791] Mon, 02 February 2004 08:16 Go to previous message
Thiru
Messages: 1089
Registered: May 2002
Senior Member
I dont see any latch contention problem here.
Previous Topic: How can I Improve Performance
Next Topic: Query Temp Tablespace allocation problem
Goto Forum:
  


Current Time: Fri Mar 29 00:59:16 CDT 2024