Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Latching / Oracle support problems

Latching / Oracle support problems

From: Terrian, Thomas <Thomas.Terrian_at_standardregister.com>
Date: Thu, 31 Aug 2000 08:05:40 -0400
Message-Id: <10605.115954@fatcity.com>


This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible.

------_=_NextPart_000_01C01343.C7DADD80

Content-Type: text/plain;

        charset="iso-8859-1"

AIX 4.3.2
Oracle 8.1.6
No OPS

Does anyone know what the following latches mean and more importantly how to fix them?

Latch                       Gets Misses %misses 
--------------------       ----- ------ ------- 
latch wait list              5754   368  6.39% 
parallel query alloc buffer 27083 10653 39.33% 
parallel query stats         1003   453 45.16% 
process queue                9979   113  1.13% 
process queue reference   4157244 61439  1.47% 
queryserver freelists       16348   522  3.19% 

Also for your enjoyment -- I log a TAR for this on Aug 18, 13 days ago. So far, no help from Oracle. I love it!!! - Gold support, production system, problem priority 2 -- and still no good answers from Oracle. Oh yea, baby.

Tom

Tom Terrian
Oracle DBA
(937) 221-1647
Thomas.Terrian_at_standardregister.com

------_=_NextPart_000_01C01343.C7DADD80

Content-Type: application/ms-tnef
Content-Transfer-Encoding: base64

eJ8+IioMAQaQCAAEAAAAAAABAAEAAQeQBgAIAAAA5AQAAAAAAADoAAEIgAcAGAAAAElQTS5NaWNy b3NvZnQgTWFpbC5Ob3RlADEIAQWAAwAOAAAA0AcIAB8ACAAFACgABAA3AQEggAMADgAAANAHCAAf AAgABQApAAQAOAEBCYABACEAAAAxNkUyMTgwMjFDN0ZENDExOUFCMjAwQTBDOUQ1RDdGQQAqBwEE gAEAIwAAAExhdGNoaW5nIC8gT3JhY2xlIHN1cHBvcnQgcHJvYmxlbXMAsAwBDYAEAAIAAAACAAIA AQOQBgAACQAAMQAAAAMAAIAIIAYAAAAAAMAAAAAAAABGAAAAAFKFAADwEwAAHgABgAggBgAAAAAA wAAAAAAAAEYAAAAAVIUAAAEAAAAEAAAAOC41AAsAAoAIIAYAAAAAAMAAAAAAAABGAAAAAAaFAAAA AAAAAwADgAggBgAAAAAAwAAAAAAAAEYAAAAAAYUAAAAAAAALAASACCAGAAAAAADAAAAAAAAARgAA AAADhQAAAAAAAAsABYAIIAYAAAAAAMAAAAAAAABGAAAAAA6FAAAAAAAAAwAGgAggBgAAAAAAwAAA AAAAAEYAAAAAEIUAAAAAAAADAAeACCAGAAAAAADAAAAAAAAARgAAAAARhQAAAAAAAAMACYAIIAYA AAAAAMAAAAAAAABGAAAAABiFAAAAAAAAHgAKgAggBgAAAAAAwAAAAAAAAEYAAAAANoUAAAEAAAAB AAAAAAAAAB4AC4AIIAYAAAAAAMAAAAAAAABGAAAAADeFAAABAAAAAQAAAAAAAAAeAAyACCAGAAAA AADAAAAAAAAARgAAAAA4hQAAAQAAAAEAAAAAAAAACwANgAsgBgAAAAAAwAAAAAAAAEYAAAAAAIgA AAAAAAALAA6ACyAGAAAAAADAAAAAAAAARgAAAAAFiAAAAAAAAAIBCRABAAAAFgMAABIDAACsBAAA TFpGdQIGRsoDAAoAcmNwZzEyNeIyA0N0ZXgFQQEDAff/CoACpAPkBxMCgA/zAFAEVj8IVQeyESUO UQMBAgBjaOEKwHNldDIGAAbDESX2MwRGE7cwEiwRMwjvCfe2OxgfDjA1ESIMYGMAULMLCQFkMzYW UAunYwEwARDASVggNC4zLicOUAqxCoBPcgDQbGVAIDguMS42HcROYG8gT1BTHcQdxEQ2bweRAHB5 AiAecGtumm8H4HcT4AVAdGgecI0CEGwXsAPwbmcgC2C+dBPQB5EHgAORAHBkIxA3BbAecAdwcBfB AHB0bCh5IGghQXQfUGZpUnghsm0/H6pMIrIg2ybfJzNHFCAEIE0EAQeR7CVtKKQdxC0p7yoQJzX/ KtQqxSq2HcQioyFgC3AFQA5sBAAFQCc7NTc1NCsnMRwgOCcwNh2AOSVfKXUKsQdAHmADIHEKUHKD JKAwwW9jIGJ1ASABEoEyNzA4MyAxuDA2NTKQL/AdgDMwH78xJC4QIZAEICc2MrAwMpDdJzA0MuE2 IB6gNjNnA2A+YweQBCAxIQpQJz45OfQ3OTWCMTXhHrA5gDa/vzfDGCAyEQnwN2A18jEvEMQyNC9A NjE0L/A5opw0NzNmMSMUEHJ2EoGfA1AJ4C3yNRY2kDM0L6F9LwAyFEAvcB6gMAcdxEG8bHMlEQWx INAIcCAJ8LxqbwbACfAFQCsBSSKQgm8igGEgVEFSQcNbIcAEACACIBDAdSKAMcw4LDKgMpBkYT4Q IKDoZ28uJzBTJREKwEUQ9yEwJLAw8HA+gQNwH2AeM89F4UMyPlAj8HQhSIArcccoMAbwI5BzdXAk IkUQpTcxZBrQdGlEgXM+EP0OsG1JswJgJZBJwUpABRD+dCSgFEArASNyLhADEAMg/0aRRcAEcCCh A+AEkAQgRxxaTybAeSMwRRBiAaB59i4fqh3EVANwUB1DoASQRwchC5Ad2kRCQR3EKBA5MzcpMkAy MS2fNpA9MFB1JMAAwHMuUgXeQDTRI4ALERggZy4BBJAWLgWgUPV9V7AAAB4AcAABAAAAIwAAAExh dGNoaW5nIC8gT3JhY2xlIHN1cHBvcnQgcHJvYmxlbXMAAAIBcQABAAAAFgAAAAHAE0RI82abJOJ/ DhHUndkAwE/yhfoAAAsAAgABAAAAAwDeP69vAABAADkAgN3ax0MTwAEDAPE/CQQAAB4AMUABAAAA CAAAAFRURVJSSUEAAwAaQAAAAAAeADBAAQAAAAgAAABUVEVSUklBAAMAGUAAAAAAAwD9P+QEAAAD ACYAAAAAAAMANgAAAAAAAwCAEP////8CAUcAAQAAADUAAABjPVVTO2E9IDtwPVN0ZFJlZztsPU9I X0RBWVROX1hDLTAwMDgzMTEyMDU0MFotMTMwMjQzAAAAAAIB+T8BAAAAYwAAAAAAAADcp0DIwEIQ GrS5CAArL+GCAQAAAAAAAAAvTz1TVEFOREFSRCBSRUdJU1RFUiBDT01QQU5ZL09VPVNSQ19DT1JQ T1JBVEUvQ049UkVDSVBJRU5UUy9DTj1UVEVSUklBAAAeAPg/AQAAABAAAABUZXJyaWFuLCBUaG9t YXMAHgA4QAEAAAAIAAAAVFRFUlJJQQACAfs/AQAAAGMAAAAAAAAA3KdAyMBCEBq0uQgAKy/hggEA AAAAAAAAL089U1RBTkRBUkQgUkVHSVNURVIgQ09NUEFOWS9PVT1TUkNfQ09SUE9SQVRFL0NOPVJF Q0lQSUVOVFMvQ049VFRFUlJJQQAAHgD6PwEAAAAQAAAAVGVycmlhbiwgVGhvbWFzAB4AOUABAAAA CAAAAFRURVJSSUEAQAAHMAIThOVCE8ABQAAIMLgKSMhDE8ABHgA9AAEAAAABAAAAAAAAAB4AHQ4B AAAAIwAAAExhdGNoaW5nIC8gT3JhY2xlIHN1cHBvcnQgcHJvYmxlbXMAAB4ANRABAAAARQAAADw3 NzgyQkU2Q0ZENjREMjExOUE3QjAwQTBDOUQ1RDdGQTA5NzUyM0REQG9oX2RheXRuX3hjaDAyLnN0 ZHJlZy5jb20+AAAAAAsAKQAAAAAACwAjAAAAAAADAAYQjPk5LwMABxBBAgAAAwAQEAAAAAADABEQ AAAAAB4ACBABAAAAZQAAAEFJWDQzMk9SQUNMRTgxNk5PT1BTRE9FU0FOWU9ORUtOT1dXSEFUVEhF Rk9MTE9XSU5HTEFUQ0hFU01FQU5BTkRNT1JFSU1QT1JUQU5UTFlIT1dUT0ZJWFRIRU0/TEFUQ0hH RVQAAAAAAgF/AAEAAABFAAAAPDc3ODJCRTZDRkQ2NEQyMTE5QTdCMDBBMEM5RDVEN0ZBMDk3NTIz RERAb2hfZGF5dG5feGNoMDIuc3RkcmVnLmNvbT4AAAAAevo= Received on Thu Aug 31 2000 - 07:05:40 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US