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 6AF4010032C467 for ; Sun, 19 Nov 2017 11:48:35 +0100 (CET) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id F277721A1F; Sun, 19 Nov 2017 05:48:33 -0500 (EST) DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=freelists.org; s=turing; t=1511088514; bh=xvEZdZKPbt5r1jmehJS/vat9EuYiSFASrtJ2tP1XqKM=; h=Date:From:To:In-Reply-To:References:Subject:Reply-To:List-help: List-unsubscribe:List-Id:List-subscribe:List-owner:List-post: List-archive; b=uaEd+0dsnEWH4Iye6R3oy1VB9uBsuQtylAdfbAILEk2ye3eEJxvH2ZtaQaeKZEw0B SN+Idk/PfZFTAj1wrp2rCiu0I8QrP/n+jvp+uf+Odx0VkhHBnvt995BJ70Zjl6T/n5 JE6Xw2J4QlhQlZHeI/2Y90QHeHdrIVW6sJhM9Lns= 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 WWMgnuDjoTRQ; Sun, 19 Nov 2017 05:48:33 -0500 (EST) Received: from turing.freelists.org (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 0397C21A30; Sun, 19 Nov 2017 05:48:20 -0500 (EST) DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=freelists.org; s=turing; t=1511088513; bh=xvEZdZKPbt5r1jmehJS/vat9EuYiSFASrtJ2tP1XqKM=; h=Date:From:To:In-Reply-To:References:Subject:Reply-To:List-help: List-unsubscribe:List-Id:List-subscribe:List-owner:List-post: List-archive; b=HG55m70BQ12lo/ZSXaqgswFLjDVzO8UgvO85ljo5IDYtYQ67TlJZf1T2XNKt5E4G9 gN0/IFLFHJHGqvD688SJLQMsve5gRpV1hfqmIMIprEJssjfYQqys1ST1GbTNWeWvM6 DgsnCSnlzkn8efhpgX/i4gvYfLuVFjnQ4Tf9iNSk= Received: with ECARTIS (v1.0.0; list oracle-l); Sun, 19 Nov 2017 05:46:59 -0500 (EST) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id F2A0121534 for ; Sun, 19 Nov 2017 05:46:58 -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 2gL1UqdHY3Qg for ; Sun, 19 Nov 2017 05:46:58 -0500 (EST) Received: from wp021.webpack.hosteurope.de (wp021.webpack.hosteurope.de [80.237.132.28]) (using TLSv1 with cipher ECDHE-RSA-AES128-SHA (128/128 bits)) (No client certificate requested) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTPS id 63D0521510 for ; Sun, 19 Nov 2017 05:46:58 -0500 (EST) Received: from app01-neu.ox.hosteurope.de ([92.51.170.135] helo=null); authenticated by wp021.webpack.hosteurope.de running ExIM with esmtpsa (TLS1.0:ECDHE_RSA_AES_256_CBC_SHA1:256) id 1eGN7o-0005wD-IB; Sun, 19 Nov 2017 11:46:56 +0100 Date: Sun, 19 Nov 2017 11:46:56 +0100 (CET) From: Stefan Koehler To: Amir.Hameed@xerox.com, ORACLE-L Message-ID: <1829681872.185955.1511088416453@ox.hosteurope.de> In-Reply-To: References: Subject: Re: UPDATE statement - cpu and elapsed time almost the same MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable X-Originating-Client: open-xchange-appsuite X-bounce-key: webpack.hosteurope.de;contact@soocs.de;1511088418;91f90960; X-HE-SMSGID: 1eGN7o-0005wD-IB X-archive-position: 69807 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: contact@soocs.de Precedence: normal Reply-To: contact@soocs.de 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 Hey Amir, not quite sure what you have traced but the data between parsed extended SQ= L trace output and execution plan does not fit. You have 4 EXEC OPI calls with 646/261 logical I/Os and 30 rows but your po= sted execution plan already has 2335 logical I/Os by 4 starts. The problem is that Oracle does not provide any CPU break-down information = in OPI call tracing or the execution plan - so basically you have to check = session statistics (if there is any hint) or profile the shadow process. I had a talk about this and you might find this interesting: http://www.soo= cs.de/public/talk/160616_DOAG_Regio_NUE_Identifying_Performance_Issues_Beyo= nd_The_Oracle_Wait_Interface_PPT.pdf Page 5 describes the general approach (you are basically at point 3 from no= w on) and the other slides include various tools for profiling. Best Regards Stefan Koehler Independent Oracle performance consultant and researcher Website: http://www.soocs.de Twitter: @OracleSK >"Hameed, Amir" hat am 18. November 2017 um 02:50 g= eschrieben: >=20 > Hi, >=20 > We traced an Oracle EBS Order Import form which was taking time to import= orders. The trace file showed multiple UPDATE statements that were consumi= ng time. What was common in all those statements was that their cpu time wa= s almost the same as their elapsed time. I am pasting one of the statements= , its statistics and explain plan. The explain plan seems to indicate that = operation 1, which was executed 4 times, took most of the time. Was the tim= e spent in this operation was due to the number of buffers processed which = is memory operation and that is the reason cpu statistic was high? The colu= mns being updated is indexed via a single-column index. >=20 > UPDATE OE_ORDER_LINES OEOPT SET ATO_LINE_ID =3D ( SELECT LINE_ID FROM >=20 > =C2=A0 OE_ORDER_LINES OEATO >=20 > WHERE >=20 > OEOPT.TOP_MODEL_LINE_ID =3D OEATO.TOP_MODEL_LINE_ID AND OEATO.CONFIGURATI= ON_ID >=20 > =C2=A0 =3D (SELECT ATO_CONFIG_ITEM_ID FROM CZ_CONFIG_DETAILS_V WHERE CONF= IG_HDR_ID =3D >=20 > =C2=A0 OEOPT.CONFIG_HEADER_ID AND CONFIG_REV_NBR =3D OEOPT.CONFIG_REV_NBR= AND >=20 > =C2=A0 CONFIG_ITEM_ID =3D OEOPT.CONFIGURATION_ID) AND OEATO.OPEN_FLAG =3D= 'Y' ) WHERE >=20 > =C2=A0 TOP_MODEL_LINE_ID =3D :B1 AND NOT (ITEM_TYPE_CODE =3D 'OPTION' AND= ATO_LINE_ID =3D >=20 > =C2=A0=C2=A0 LINE_ID AND ATO_LINE_ID IS NOT NULL) AND NOT (ITEM_TYPE_CODE= =3D 'INCLUDED' >=20 > =C2=A0 AND ATO_LINE_ID =3D LINE_ID AND ATO_LINE_ID IS NOT NULL) AND ITEM_= TYPE_CODE >=20 > =C2=A0 <> 'CONFIG' AND (NVL(MODEL_REMNANT_FLAG, 'N') =3D 'N' OR LINE_CATE= GORY_CODE =3D >=20 > =C2=A0 'RETURN') AND ORDERED_QUANTITY > 0 >=20 > call=C2=A0=C2=A0=C2=A0=C2=A0 count=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 cp= u=C2=A0=C2=A0=C2=A0 elapsed=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 disk=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0 query=C2=A0=C2=A0=C2=A0 current=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0 rows >=20 > ------- ------=C2=A0 -------- ---------- ---------- ---------- ----------= =C2=A0 ---------- >=20 > Parse=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 1=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0 0.00=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 0.00=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0 0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 0= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 0 >=20 > Execute=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 4=C2=A0=C2=A0=C2=A0 174.74=C2=A0=C2= =A0=C2=A0=C2=A0 174.86=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0 0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 646=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0 261=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0 30 >=20 > Fetch=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0 0.00=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 0.00=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0 0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 0= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 0 >=20 > ------- ------=C2=A0 -------- ---------- ---------- ---------- ----------= =C2=A0 ---------- >=20 > total=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 5=C2=A0=C2=A0=C2=A0 174.7= 4=C2=A0=C2=A0=C2=A0=C2=A0 174.86=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0 0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 646=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0=C2=A0=C2=A0 261=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0 30 >=20 > -------------------------------------------------------------------------= ---------------------------------------------------------------------------= - >=20 > | Id=C2=A0 | Operation=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 | Name=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 | Starts | E-Rows |E= -Bytes| Cost (%CPU)| E-Time=C2=A0=C2=A0 | A-Rows |=C2=A0=C2=A0 A-Time=C2=A0= =C2=A0 | Buffers | >=20 > -------------------------------------------------------------------------= ---------------------------------------------------------------------------= - >=20 > |=C2=A0=C2=A0 0 | UPDATE STATEMENT=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=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 0 |=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 12 (100)|=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 0 |00:00:00.01 |= =C2=A0 =C2=A0=C2=A0=C2=A0=C2=A0=C2=A00 | >=20 > |=C2=A0=C2=A0 1 |=C2=A0 UPDATE=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 | OE_ORDER_LINES_ALL=C2=A0=C2=A0=C2=A0=C2=A0=C2= =A0 |=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 4 |=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=A0=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0=C2=A0 |=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 0 |00:02:54.91 |=C2= =A0=C2=A0=C2=A0 2335 | >=20 > |*=C2=A0 2 |=C2=A0=C2=A0 TABLE ACCESS BY INDEX ROWID=C2=A0=C2=A0 | OE_ORD= ER_LINES_ALL=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 |=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 = 4 |=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 1 |=C2=A0=C2=A0 454 |=C2=A0=C2=A0=C2=A0= =C2=A0 5=C2=A0=C2=A0 (0)| 00:00:01 |=C2=A0=C2=A0=C2=A0=C2=A0 30 |00:00:00.0= 1 |=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 60 | >=20 > |*=C2=A0 3 |=C2=A0=C2=A0=C2=A0 INDEX RANGE SCAN=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 | OE_ORDER_LINES_N10=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0 |=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 4 |=C2=A0=C2=A0=C2= =A0=C2=A0=C2=A0 9 |=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 |=C2=A0=C2=A0=C2=A0= =C2=A0 1=C2=A0=C2=A0 (0)| 00:00:01 |=C2=A0=C2=A0=C2=A0=C2=A0 30 |00:00:00.0= 1 |=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 8 | >=20 > |*=C2=A0 4 |=C2=A0=C2=A0 FILTER=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=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 30 |=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=A0=C2= =A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 |=C2=A0=C2=A0=C2=A0=C2=A0 26 |00:00:00.01= |=C2=A0=C2=A0=C2=A0=C2=A0 584 | >=20 > |*=C2=A0 5 |=C2=A0=C2=A0=C2=A0 TABLE ACCESS BY INDEX ROWID=C2=A0 | OE_ORD= ER_LINES_ALL=C2=A0 =C2=A0=C2=A0=C2=A0=C2=A0|=C2=A0=C2=A0=C2=A0=C2=A0 30 |= =C2=A0=C2=A0=C2=A0 229 |=C2=A0 3664 |=C2=A0=C2=A0=C2=A0=C2=A0 6=C2=A0=C2=A0= (0)| 00:00:01 |=C2=A0=C2=A0=C2=A0 226 |00:00:00.01 |=C2=A0=C2=A0=C2=A0=C2= =A0 382 | >=20 > |*=C2=A0 6 |=C2=A0=C2=A0=C2=A0=C2=A0 INDEX RANGE SCAN=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 | OE_ORDER_LINES_N10=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0 |=C2=A0=C2=A0=C2=A0=C2=A0 30 |=C2=A0=C2=A0=C2=A0= =C2=A0 11 |=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 |=C2=A0=C2=A0=C2=A0=C2=A0 1= =C2=A0=C2=A0 (0)| 00:00:01 |=C2=A0=C2=A0=C2=A0 226 |00:00:00.01 |=C2=A0=C2= =A0=C2=A0=C2=A0=C2=A0 50 | >=20 > |=C2=A0=C2=A0 7 |=C2=A0=C2=A0=C2=A0 NESTED LOOPS OUTER=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=A0=C2= =A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 |=C2=A0=C2=A0=C2=A0=C2=A0 30 |=C2= =A0=C2=A0=C2=A0=C2=A0=C2=A0 1 |=C2=A0=C2=A0 310 |=C2=A0=C2=A0=C2=A0=C2=A0 0= =C2=A0=C2=A0 (0)|=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 30 |00:00:00.01 |=C2=A0=C2=A0=C2=A0=C2=A0 202 | >=20 > |=C2=A0=C2=A0 8 |=C2=A0=C2=A0=C2=A0=C2=A0 NESTED LOOPS=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=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 30 |=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 1 |=C2=A0=C2=A0 14= 9 |=C2=A0=C2=A0=C2=A0=C2=A0 0=C2=A0=C2=A0 (0)|=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 30 |00:00:00.01 |=C2= =A0=C2=A0=C2=A0=C2=A0 172 | >=20 > |*=C2=A0 9 |=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 TABLE ACCESS BY INDEX ROWID| C= Z_CONFIG_ITEMS=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 |=C2=A0=C2= =A0=C2=A0=C2=A0 30 |=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 1 |=C2=A0=C2=A0 108 |=C2= =A0=C2=A0=C2=A0=C2=A0 0=C2=A0=C2=A0 (0)|=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 30 |00:00:00.01 |=C2=A0=C2= =A0=C2=A0=C2=A0 112 | >=20 > |* 10 |=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 INDEX RANGE SCAN=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 | CZ_CONFIG_ITEMS_N1=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0 |=C2=A0=C2=A0=C2=A0=C2=A0 30 |=C2=A0=C2=A0=C2=A0 =C2=A0= =C2=A01 |=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 |=C2=A0=C2=A0=C2=A0=C2=A0 0= =C2=A0=C2=A0 (0)|=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 |= =C2=A0=C2=A0=C2=A0 256 |00:00:00.01 |=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 50 | >=20 > |* 11 |=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 TABLE ACCESS BY INDEX ROWID| CZ_CON= FIG_HDRS=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 30 |=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 1 |=C2=A0=C2=A0=C2=A0 41= |=C2=A0=C2=A0=C2=A0=C2=A0 0=C2=A0=C2=A0 (0)|=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 30 |00:00:00.01 |=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0 60 | >=20 > |* 12 |=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 INDEX UNIQUE SCAN=C2=A0=C2=A0= =C2=A0=C2=A0 =C2=A0=C2=A0=C2=A0=C2=A0| CZ_CONFIG_HDRS_PK=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0 |=C2=A0=C2=A0=C2=A0=C2=A0 30 |=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0 1 |=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 |=C2=A0=C2=A0=C2=A0=C2=A0 0= =C2=A0=C2=A0 (0)|=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 30 |00:00:00.01 |=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 30= | >=20 > |* 13 |=C2=A0=C2=A0=C2=A0=C2=A0 INDEX UNIQUE SCAN=C2=A0=C2=A0=C2=A0=C2=A0= =C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 | CZ_CONFIG_ATTRIBUTES_PK |=C2=A0=C2= =A0=C2=A0=C2=A0 30 |=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 1 |=C2=A0=C2=A0 161 |=C2= =A0=C2=A0=C2=A0=C2=A0 0=C2=A0=C2=A0 (0)|=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 0 |00:00:00.01 |=C2= =A0=C2=A0 =C2=A0=C2=A0=C2=A030 | > -- http://www.freelists.org/webpage/oracle-l