Return-Path: X-Original-To: oracle-l@orafaq.com Delivered-To: oracle-l@orafaq.com Received: from turing.freelists.org (turing.freelists.org [206.53.239.180]) by malta2546.startdedicated.com (Postfix) with ESMTPS id 2310D1002E6A79 for ; Wed, 29 Nov 2017 08:55:48 +0100 (CET) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id CC55523E9F; Wed, 29 Nov 2017 02:55:46 -0500 (EST) DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=freelists.org; s=turing; t=1511942146; bh=PEEYL+uxN2O9GRShL1FLqXiMmA9T4dSIvqtS/cXL7Hw=; h=In-Reply-To:References:From:Date:Subject:To:Cc:Reply-To:List-help: List-unsubscribe:List-Id:List-subscribe:List-owner:List-post: List-archive; b=ai8VY6XCxekbYwfK6AtWQkhpIbBFqYlQ5oEAsX6YBISM+AOjHi8jQwETIsUhD+oXj dP6bpF0nbQHuXGDts5qMcIu1ZEkuOxfkBAwc06igfU6Z3B98RPgsro/5XT4FtCVnJs 9/O3CVY8QryqwTcxEyvuUu9RfUsLdpIPGol78tmk= X-Virus-Scanned: Debian amavisd-new at turing.freelists.org Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 6npevxw1GKEq; Wed, 29 Nov 2017 02:55:46 -0500 (EST) Received: from turing.freelists.org (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id C8DBB23F55; Wed, 29 Nov 2017 02:55:33 -0500 (EST) DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=freelists.org; s=turing; t=1511942146; bh=PEEYL+uxN2O9GRShL1FLqXiMmA9T4dSIvqtS/cXL7Hw=; h=In-Reply-To:References:From:Date:Subject:To:Cc:Reply-To:List-help: List-unsubscribe:List-Id:List-subscribe:List-owner:List-post: List-archive; b=ai8VY6XCxekbYwfK6AtWQkhpIbBFqYlQ5oEAsX6YBISM+AOjHi8jQwETIsUhD+oXj dP6bpF0nbQHuXGDts5qMcIu1ZEkuOxfkBAwc06igfU6Z3B98RPgsro/5XT4FtCVnJs 9/O3CVY8QryqwTcxEyvuUu9RfUsLdpIPGol78tmk= Received: with ECARTIS (v1.0.0; list oracle-l); Wed, 29 Nov 2017 02:54:12 -0500 (EST) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 0755C23D97 for ; Wed, 29 Nov 2017 02:54:12 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 0AJODKT-viEl for ; Wed, 29 Nov 2017 02:54:11 -0500 (EST) Received: from mail-pl0-f48.google.com (mail-pl0-f48.google.com [209.85.160.48]) (using TLSv1.2 with cipher ECDHE-RSA-AES128-GCM-SHA256 (128/128 bits)) (No client certificate requested) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTPS id AE7B123D92 for ; Wed, 29 Nov 2017 02:54:11 -0500 (EST) Received: by mail-pl0-f48.google.com with SMTP id q7so1621650plk.0 for ; Tue, 28 Nov 2017 23:54:11 -0800 (PST) X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:in-reply-to:references:from:date :message-id:subject:to:cc; bh=JP1c9LDL1KNr4btp4580LGPghK0L1Rr4ujEOMMXs9aA=; b=U7x9z9Ou8h3lmaYLsVCwJfujfkyRldNTIkJupwwcbPcCPwFGuGnwyfdVoRn0+lqAx6 Qs4DY8hXYVWNiQHhVz+IKyLmZMZxmWoxT8fwL0brAX0a4qFvB0DD0VLLiFjv8gC9Hi6f 9Qr777jDL1gG4BZchkJQ1tgkpPn9tT4Q6YqUxGgmU/FVjc+Tyjhuaq7aKI3rne0I1UC3 aZxyXE8uIB0g9IbLkPUWF/vhzFzvVMXQFevTr6Vs/cdEr03lmNjh30cXwaunuor0x0LX 949P6WEfrDG3i2KO9BZjfhiPO8x1sbk3bVzS8yYswQRPVzEXwUNDWeEUafFoB7LjdtBb 0SRA== X-Gm-Message-State: AJaThX5gQiNzyRF5iyGyCm5g8vfZGkwZgHO1zphtjEQat33k0j/r3Qyt CdqcAWvhUCFL12EvoHOIjVEc+AHYE1gAH47IJwI= X-Google-Smtp-Source: AGs4zMaGNANfhPd6OpXpS8DpC+Tcfw38AKIyd2YsJ7kf02wyZve6Kp2FaydKZqIGsOOO3CUIri+QCII6RnCM7vqubmw= X-Received: by 10.84.238.193 with SMTP id l1mr2058001pln.106.1511942050722; Tue, 28 Nov 2017 23:54:10 -0800 (PST) MIME-Version: 1.0 Received: by 10.100.163.3 with HTTP; Tue, 28 Nov 2017 23:53:50 -0800 (PST) In-Reply-To: References: From: Ashish Lunawat Date: Wed, 29 Nov 2017 15:53:50 +0800 Message-ID: Subject: Re: Missing DB time and enq:TM question; To: Steven Heterogeneous Cc: oracle-l@freelists.org Content-Type: multipart/alternative; boundary="f403045fdf8edab676055f1a701e" X-archive-position: 69881 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: ashish.lunawat@gmail.com Precedence: normal Reply-To: ashish.lunawat@gmail.com List-help: List-unsubscribe: List-software: Ecartis version 1.0.0 List-Id: oracle-l X-List-ID: oracle-l List-subscribe: List-owner: List-post: List-archive: X-list: oracle-l --f403045fdf8edab676055f1a701e Content-Type: text/plain; charset="UTF-8" Steve, Thanks for your reply. 1. As you said, they are the top "5" events. And there are hundreds of other events. [A] I tried to count the time spent in those other events and it`s barely anything which makes me wonder why is it missing. 2. An "insert append" will also require a lock at object level. [A] In my case the insert query do not contain append hint. Thanks Regards, Ashish On Wed, Nov 29, 2017 at 11:55 AM, Steven Heterogeneous < steven.heterogeneous@gmail.com> wrote: > Hi Ashish, > > > 1. As you said, they are the top "5" events. And there are hundreds of > other events. > 2. An "insert append" will also require a lock at object level. > > > Steven > > > > On Wed, Nov 29, 2017 at 12:59 PM, Ashish Lunawat > wrote: > >> Hi, >> >> In this statspack report the top 5 event accounts only for about 55% of >> the DB time. Any clue where is the remaining time gone? >> >> Database DB Id Instance Inst Num Startup Time Release RAC >> ~~~~~~~~ ----------- ------------ -------- --------------- ----------- --- >> 1 12.1.0.2.0 NO >> >> Host Name Platform CPUs Cores Sockets Memory >> (G) >> ~~~~ ---------------- ---------------------- ----- ----- ------- >> ------------ >> Solaris Operating Syst 22 20 2 >> 128.0 >> >> Snapshot Snap Id Snap Time Sessions Curs/Sess Comment >> ~~~~~~~~ ---------- ------------------ -------- --------- >> ------------------ >> Begin Snap: 9083 20-Nov-17 10:00:03 159 8.1 >> End Snap: 9084 20-Nov-17 11:00:08 186 8.7 >> Elapsed: 60.08 (mins) Av Act Sess: 10.6 >> DB time: 635.94 (mins) DB CPU: 77.03 (mins) >> >> Cache Sizes Begin End >> ~~~~~~~~~~~ ---------- ---------- >> Buffer Cache: 7,552M 7,456M Std Block Size: 8K >> Shared Pool: 2,240M 2,336M Log Buffer: 29,768K >> >> Load Profile Per Second Per Transaction Per Exec >> Per Call >> ~~~~~~~~~~~~ ------------------ ----------------- ----------- >> ----------- >> DB time(s): 10.6 0.4 0.01 >> 0.01 >> DB CPU(s): 1.3 0.1 0.00 >> 0.00 >> Redo size: 482,697.7 18,323.1 >> Logical reads: 112,797.9 4,281.8 >> Block changes: 3,588.2 136.2 >> Physical reads: 1,654.0 62.8 >> Physical writes: 197.9 7.5 >> User calls: 1,845.5 70.1 >> Parses: 732.2 27.8 >> Hard parses: 8.0 0.3 >> W/A MB processed: 59.3 2.3 >> Logons: 0.2 0.0 >> Executes: 1,174.5 44.6 >> Rollbacks: 0.1 0.0 >> Transactions: 26.3 >> >> Instance Efficiency Indicators >> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ >> Buffer Nowait %: 99.74 Redo NoWait %: 100.00 >> Buffer Hit %: 98.88 Optimal W/A Exec %: 100.00 >> Library Hit %: 99.05 Soft Parse %: 98.91 >> Execute to Parse %: 37.66 Latch Hit %: 99.83 >> Parse CPU to Parse Elapsd %: 8.71 % Non-Parse CPU: 97.64 >> >> Shared Pool Statistics Begin End >> ------ ------ >> Memory Usage %: 81.35 81.99 >> % SQL with executions>1: 75.54 79.69 >> % Memory for SQL w/exec>1: 90.89 92.14 >> >> Top 5 Timed Events Avg >> %Total >> ~~~~~~~~~~~~~~~~~~ >> wait Call >> Event Waits Time (s) >> (ms) Time >> ----------------------------------------- ------------ ----------- >> ------ ------ >> db file sequential read 2,686,039 17,055 >> 6 27.4 >> log file sync 94,630 6,260 >> 66 10.1 >> CPU time 4,344 >> 7.0 >> LGWR worker group idle 83,645 4,190 >> 50 6.7 >> enq: TX - row lock contention 906 3,804 >> 4199 6.1 >> ------------------------------------------------------------- >> >> Host CPU (CPUs: 22 Cores: 20 Sockets: 2) >> ~~~~~~~~ Load Average >> Begin End User System Idle WIO >> WCPU >> ------- ------- ------- ------- ------- ------- >> -------- >> 2.79 2.12 6.02 1.68 92.30 0.00 >> 6.00 >> >> >> Second question, how is it possible for an insert on table with no >> foreign keys on it cause a enq: TM lock wait ? >> >> Thanks >> Regards, >> Ashish >> > > --f403045fdf8edab676055f1a701e Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Steve,

=C2=A0Thanks for your reply.

1. As you said, they are the top "5" e= vents. And there are hundreds of other events.
[A] I tried to cou= nt the time spent in those other events and it`s barely anything which make= s me wonder why is it missing.

2. An "insert = append" will also require a lock at object level.
[A] In my = case the insert query do not contain append hint.

= Thanks
Regards,
Ashish



On Wed, Nov 29, 2017 at 11:55 AM, Steven Heterogeneou= s <steven.heterogeneous@gmail.com> wrote:
Hi Ashish,=


1. As you said, they are the top "5= " events. And there are hundreds of other events.
2. An &quo= t;insert append" will also require a lock at object level.


Steven



On Wed, Nov 29, = 2017 at 12:59 PM, Ashish Lunawat <ashish.lunawat@gmail.com><= /span> wrote:
Hi,

=C2=A0In this statspack report the top 5 ev= ent accounts only for about 55% of the DB time. Any clue where is the remai= ning time gone?

Database=C2=A0 =C2=A0 DB Id=C2=A0 =C2=A0 Instance=C2=A0 =C2=A0 =C2= =A0Inst Num=C2=A0 Startup Time=C2=A0 =C2=A0Release=C2=A0 =C2=A0 =C2=A0RAC
~~~~~~~~ ----------- --= ---------- -------- --------------- ----------- ---
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A01 =C2=A0 =C2=A012.1.0.2.0=C2=A0 NO
<= div>
Host Name=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 = =C2=A0Platform=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 CPUs = Cores Sockets=C2=A0 =C2=A0Memory (G)
~~~~ ---------------- ---------------------- ----- ----- ---= ---- ------------
=C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 S= olaris Operating Syst=C2=A0 =C2=A0 22=C2=A0 =C2=A0 20=C2=A0 =C2=A0 =C2=A0 = =C2=A02=C2=A0 =C2=A0 =C2=A0 =C2=A0 128.0

~~~~~~~~=C2=A0 =C2=A0 ---------- ----------------= -- -------- --------- ------------------
Begin Snap:=C2=A0 =C2=A0 =C2=A0 =C2=A09083 20-Nov-17 10:= 00:03=C2=A0 =C2=A0 =C2=A0 159=C2=A0 =C2=A0 =C2=A0 =C2=A08.1
=C2=A0 End Snap:=C2=A0 =C2=A0 =C2=A0 = =C2=A09084 20-Nov-17 11:00:08=C2=A0 =C2=A0 =C2=A0 186=C2=A0 =C2=A0 =C2=A0 = =C2=A08.7
=C2=A0 =C2= =A0Elapsed:=C2=A0 =C2=A0 =C2=A0 60.08 (mins) Av Act Sess:=C2=A0 =C2=A0 =C2= =A0 10.6
=C2=A0 =C2=A0= DB time:=C2=A0 =C2=A0 =C2=A0635.94 (mins)=C2=A0 =C2=A0 =C2=A0 DB CPU:=C2=A0= =C2=A0 =C2=A0 77.03 (mins)

Cache Sizes= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 Begin=C2=A0 =C2=A0 =C2=A0 =C2=A0 = End
~~~~~~~~~~~=C2=A0 = =C2=A0 =C2=A0 =C2=A0---------- ----------
=C2=A0 =C2=A0 Buffer Cache:=C2=A0 =C2=A0 =C2=A07,552M= =C2=A0 =C2=A0 =C2=A07,456M=C2=A0 =C2=A0Std Block Size:=C2=A0 =C2=A0 =C2=A0 = =C2=A0 =C2=A08K
=C2=A0= =C2=A0 =C2=A0Shared Pool:=C2=A0 =C2=A0 =C2=A02,240M=C2=A0 =C2=A0 =C2=A02,3= 36M=C2=A0 =C2=A0 =C2=A0 =C2=A0Log Buffer:=C2=A0 =C2=A0 29,768K
=

Load Profile=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 = =C2=A0 =C2=A0 Per Second=C2=A0 =C2=A0 Per Transaction=C2=A0 =C2=A0 Per Exec= =C2=A0 =C2=A0 Per Call
~~~~~~~~~~~~=C2=A0 =C2=A0 =C2=A0 ------------------=C2=A0 ----------------= - ----------- -----------
=C2=A0 =C2=A0 =C2=A0 DB time(s):=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A010.6=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 0.4=C2=A0 =C2=A0 =C2=A0 =C2=A0 0.01=C2=A0 =C2=A0 =C2=A0 =C2=A0 0.01
=C2=A0 =C2=A0 =C2=A0 =C2= =A0DB CPU(s):=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 1.3=C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 0.1=C2=A0 =C2=A0 =C2= =A0 =C2=A0 0.00=C2=A0 =C2=A0 =C2=A0 =C2=A0 0.00
=C2=A0 =C2=A0 =C2=A0 =C2=A0Redo size:=C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 482,697.7=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= 18,323.1
=C2=A0 =C2=A0= Logical reads:=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 112,797.9=C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 4,281.8
=C2=A0 =C2=A0Block changes:=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 = =C2=A0 3,588.2=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 136.2=
=C2=A0 Physical reads:=C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 1,654.0=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A062.8
=C2=A0Physical writes:=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 197.9=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 7.5=
=C2=A0 =C2=A0 =C2=A0 User ca= lls:=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 1,845.5=C2=A0 =C2=A0 =C2=A0 = =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A070.1
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 Parses:=C2=A0 =C2=A0 = =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 732.2=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 = =C2=A0 =C2=A0 =C2=A027.8
=C2=A0 =C2=A0 =C2=A0Hard parses:=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 8.0=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 0.3
W/A MB process= ed:=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A059.3=C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 2.3
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 Logons:=C2=A0 = =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 0.2=C2=A0 =C2=A0 =C2=A0 = =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 0.0
=C2=A0 =C2=A0 =C2=A0 =C2=A0 Executes:=C2=A0 =C2=A0 =C2=A0 = =C2=A0 =C2=A0 =C2=A0 1,174.5=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A044.6
=C2=A0 = =C2=A0 =C2=A0 =C2=A0Rollbacks:=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 0.1=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 0.0
=C2=A0 =C2=A0 Transacti= ons:=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A026.3

Instance Efficiency Indicators
<= font face=3D"monospace, monospace">~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 Buffer Nowait %:=C2=A0 =C2=A099.74=C2=A0 =C2=A0 =C2=A0 =C2=A0Red= o NoWait %:=C2=A0 100.00
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 Buffer=C2=A0 Hit=C2=A0 =C2=A0%= :=C2=A0 =C2=A098.88=C2=A0 Optimal W/A Exec %:=C2=A0 100.00
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 Library Hit=C2=A0 =C2=A0%:=C2=A0 =C2=A099.05=C2=A0 =C2=A0 =C2=A0 =C2=A0= Soft Parse %:=C2=A0 =C2=A098.91
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0Execute to Parse %:=C2=A0 =C2= =A037.66=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0Latch Hit %:=C2=A0 =C2=A099.83
Parse CPU to Parse Elaps= d %:=C2=A0 =C2=A0 8.71=C2=A0 =C2=A0 =C2=A0% Non-Parse CPU:=C2=A0 =C2=A097.6= 4

=C2=A0Shared Pool Statistics=C2=A0 = =C2=A0 =C2=A0 =C2=A0 Begin=C2=A0 =C2=A0End
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0------=C2=A0 ---= ---
=C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0Memory Usage %:=C2=A0 =C2=A081.35=C2=A0 =C2= =A081.99
=C2=A0 =C2=A0= % SQL with executions>1:=C2=A0 =C2=A075.54=C2=A0 =C2=A079.69
=C2=A0 % Memory for SQL w/exec&g= t;1:=C2=A0 =C2=A090.89=C2=A0 =C2=A092.14

~~~~~~~~~~~~~~~~~~=C2=A0 =C2=A0 = =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 = =C2=A0 =C2=A0 =C2=A0wait=C2=A0 =C2=A0Call
Event=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 = =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 Waits=C2=A0 =C2=A0 Time (s)=C2=A0 =C2=A0(ms= )=C2=A0 =C2=A0Time
---= -------------------------------------- ------------ ----------- ------= ------
db file sequen= tial read=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 2,686,039=C2=A0 =C2=A0 =C2=A0 17,055=C2=A0 =C2=A0 =C2=A0 6=C2=A0= =C2=A027.4
log file s= ync=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 = =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A094,630=C2=A0 =C2=A0 = =C2=A0 =C2=A06,260=C2=A0 =C2=A0 =C2=A066=C2=A0 =C2=A010.1
= CPU time=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 = =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A04,344=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A07.0
LGWR worker group idle=C2=A0 =C2=A0 = =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 83,645=C2=A0 =C2=A0 =C2=A0 =C2=A04,190=C2=A0 =C2=A0 =C2=A050=C2=A0 =C2= =A0 6.7
enq: TX - row = lock contention=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A0 906=C2=A0 =C2=A0 =C2=A0 =C2=A03,804=C2=A0 =C2=A04199=C2= =A0 =C2=A0 6.1
=C2=A0 = =C2=A0 =C2=A0 =C2=A0 =C2=A0 ------------------------------------------= -------------------

=0CHost CPU=C2= =A0 (CPUs: 22=C2=A0 Cores: 20=C2=A0 Sockets: 2)
~~~~~~~~=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 Load Average
= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 Begin=C2=A0 =C2=A0 =C2=A0End=C2=A0 =C2=A0 =C2=A0 User=C2=A0 System=C2= =A0 =C2=A0 Idle=C2=A0 =C2=A0 =C2=A0WIO=C2=A0 =C2=A0 =C2=A0WCPU
=
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0= =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 ------- -------=C2=A0 =C2=A0------- ---= ---- ------- ------- --------
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2= =A0 =C2=A0 =C2=A02.79=C2=A0 =C2=A0 2.12=C2=A0 =C2=A0 =C2=A0 6.02=C2=A0 =C2= =A0 1.68=C2=A0 =C2=A092.30=C2=A0 =C2=A0 0.00=C2=A0 =C2=A0 6.00
=


Second question, how = is it possible for an insert on table with no foreign keys on it cause a en= q: TM lock wait ?

Thanks
Regards,
Ashish


--f403045fdf8edab676055f1a701e-- -- http://www.freelists.org/webpage/oracle-l