From oracle-l-bounce@freelists.org Thu Jun 10 15:28:16 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i5AKRpC09051 for ; Thu, 10 Jun 2004 15:28:01 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i5AKRS608988 for ; Thu, 10 Jun 2004 15:27:38 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 8343972C79B; Thu, 10 Jun 2004 15:11:52 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 19130-48; Thu, 10 Jun 2004 15:11:52 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 66B0572C7A1; Thu, 10 Jun 2004 15:11:36 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Thu, 10 Jun 2004 15:10:05 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 4BA0C72C490 for ; Thu, 10 Jun 2004 15:10:04 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 17379-83 for ; Thu, 10 Jun 2004 15:10:04 -0500 (EST) Received: from GEN-GTW-2.ppl.com (mscan1.pplweb.com [167.155.3.88]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 9A53E72C467 for ; Thu, 10 Jun 2004 15:10:03 -0500 (EST) Received: from GEN-GTW-1.ppl.com ([167.155.16.214]) by 167.155.3.88 with InterScan Messaging Security Suite; Thu, 10 Jun 2004 16:29:34 -0400 Received: from LEH-MBX-2.ppl.com ([167.155.1.31]) by GEN-GTW-1.ppl.com with Microsoft SMTPSVC(5.0.2195.6713); Thu, 10 Jun 2004 16:29:34 -0400 X-MimeOLE: Produced By Microsoft Exchange V6.0.6487.1 content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C44F29.A3B21731" Subject: advice for query cpu time difference on two servers Date: Thu, 10 Jun 2004 16:29:33 -0400 Message-ID: <32080FFBEEE7104BBDBF34FB8E53EF1404E1975D@leh-mbx-2.ppl.com> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: advice for query cpu time difference on two servers Thread-Index: AcRPKaMx6OpRiIclSzCqMJ8mMvFIKQ== From: "Singh, Alok" To: X-OriginalArrivalTime: 10 Jun 2004 20:29:34.0422 (UTC) FILETIME=[A46F2F60:01C44F29] X-Virus-Scanned: by amavisd-new at freelists.org X-archive-position: 2517 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: asingh@pplweb.com Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org ------_=_NextPart_001_01C44F29.A3B21731 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Hi! =0D I need some advice.=0D =0D HP-UX 11.00/Oracle v9205. SGA is larger on the server where it takes more time. =0D Can someone pl. explain whether it is normal to see stats like 35 more disk buffers reads and 200K more consistent reads with diff. SGA size for the same q.? =0D =0D SELECT DISTINCT LEVEL, QUAL_CODE AS S_QUAL_CODE, QUAL_QTYP_CODE AS S_QUAL_QTYP_CODE, EFFECTIVE_DATE FROM QUALIFICATION_EQUIVALENCES START WITH (QUAL_CODE, QUAL_QTYP_CODE) IN (SELECT WQ.QUAL_CODE, WQ.QUAL_QTYP_CODE FROM WORK_QUALIFICATIONS WQ , CURRENT_ASSIGNMENTS CA WHERE CA.PER_PER_DB_ID =3D 100005667 AND WQ.WASS_DB_ID =3D CA.WA_DB_ID AND (WQ.QUAL_CODE, WQ.QUAL_QTYP_CODE) IN ( SELECT DISTINCT QUAL_CODE, QUAL_QTYP_CODE FROM QUALIFICATION_EQUIVALENCES WHERE TRUNC(NVL(EFFECTIVE_DATE, '01-JAN-1900')) <=3D TRUNC(SYSDATE) START WITH QUAL_CODE_THE_SOURCE_OF =3D 'CH001R' AND QUAL_QTYP_CODE_THE_SOURCE_OF =3D 'TRN' CONNECT BY PRIOR QUAL_CODE =3D QUAL_CODE_THE_SOURCE_OF AND PRIOR QUAL_QTYP_CODE =3D QUAL_QTYP_CODE_THE_SOURCE_OF)) CONNECT BY PRIOR QUAL_CODE_THE_SOURCE_OF =3D QUAL_CODE AND PRIOR QUAL_QTYP_CODE_THE_SOURCE_OF =3D QUAL_QTYP_CODE ORDER BY LEVEL DESC =0D call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.11 0.11 0 0 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 271 13.61 13.36 0 225167 0 539 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 273 13.72 13.48 0 225167 0 539 =0D SELECT DISTINCT LEVEL, QUAL_CODE AS S_QUAL_CODE, QUAL_QTYP_CODE AS S_QUAL_QTYP_CODE, EFFECTIVE_DATE FROM QUALIFICATION_EQUIVALENCES START WITH (QUAL_CODE, QUAL_QTYP_CODE) IN (SELECT WQ.QUAL_CODE, WQ.QUAL_QTYP_CODE FROM WORK_QUALIFICATIONS WQ , CURRENT_ASSIGNMENTS CA WHERE CA.PER_PER_DB_ID =3D 100005667 AND WQ.WASS_DB_ID =3D CA.WA_DB_ID AND (WQ.QUAL_CODE, WQ.QUAL_QTYP_CODE) IN ( SELECT DISTINCT QUAL_CODE, QUAL_QTYP_CODE FROM QUALIFICATION_EQUIVALENCES WHERE TRUNC(NVL(EFFECTIVE_DATE, '01-JAN-1900')) <=3D TRUNC(SYSDATE) START WITH QUAL_CODE_THE_SOURCE_OF =3D 'CH001R' AND QUAL_QTYP_CODE_THE_SOURCE_OF =3D 'TRN' CONNECT BY PRIOR QUAL_CODE =3D QUAL_CODE_THE_SOURCE_OF AND PRIOR QUAL_QTYP_CODE =3D QUAL_QTYP_CODE_THE_SOURCE_OF)) CONNECT BY PRIOR QUAL_CODE_THE_SOURCE_OF =3D QUAL_CODE AND PRIOR QUAL_QTYP_CODE_THE_SOURCE_OF =3D QUAL_QTYP_CODE ORDER BY LEVEL DESC =0D call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.22 0.20 5 59 0 0 Execute 1 0.00 0.00 0 0 0 0 Fetch 268 28.54 28.25 35 433615 0 534 ------- ------ -------- ---------- ---------- ---------- ---------- ---------- total 270 28.76 28.45 40 433674 0 534 =0D Execution plan is exactly same on the two servers. # =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D =3D=3D=3D=3D=3D=3D=3D=3D Misses in library cache during parse: 1 Optimizer goal: CHOOSE Parsing user id: 36 (SUPERDATA) =0D Rows Execution Plan ------- --------------------------------------------------- 0 SELECT STATEMENT GOAL: CHOOSE 0 SORT (UNIQUE) 0 CONNECT BY (WITH FILTERING) 0 NESTED LOOPS 0 NESTED LOOPS 0 NESTED LOOPS 0 MERGE JOIN (CARTESIAN) 0 VIEW OF 'VW_NSO_1' 0 FILTER 0 CONNECT BY (WITH FILTERING) 0 NESTED LOOPS 0 INDEX GOAL: ANALYZED (RANGE SCAN) OF=0D 'QEQU_QUAL_SOURCE_REV_I' (NON-UNIQUE) 0 TABLE ACCESS GOAL: ANALYZED (BY USER ROWID) OF 'QUALIFICATION_EQUIVALENCES' 0 NESTED LOOPS 0 BUFFER (SORT) 0 CONNECT BY PUMP 0 TABLE ACCESS GOAL: ANALYZED (BY INDEX=0D ROWID) OF 'QUALIFICATION_EQUIVALENCES' 0 INDEX GOAL: ANALYZED (RANGE SCAN) OF=0D 'QEQU_QUAL_SOURCE_REV_I' (NON-UNIQUE) 0 BUFFER (SORT) 0 INDEX GOAL: ANALYZED (RANGE SCAN) OF 'CAS_PK'=0D (UNIQUE) 0 INDEX GOAL: ANALYZED (UNIQUE SCAN) OF 'QWQU_UC'=0D (UNIQUE) 0 INDEX GOAL: ANALYZED (RANGE SCAN) OF 'QEQU_PK' (UNIQUE) =0D 0 TABLE ACCESS GOAL: ANALYZED (BY USER ROWID) OF=0D 'QUALIFICATION_EQUIVALENCES' 0 NESTED LOOPS 0 BUFFER (SORT) 0 CONNECT BY PUMP 0 TABLE ACCESS GOAL: ANALYZED (BY INDEX ROWID) OF=0D 'QUALIFICATION_EQUIVALENCES' 0 INDEX GOAL: ANALYZED (RANGE SCAN) OF 'QEQU_PK' (UNIQUE) =0D 0 NESTED LOOPS 0 NESTED LOOPS 0 INDEX GOAL: ANALYZED (RANGE SCAN) OF 'QWQU_PK' (UNIQUE) =0D 0 VIEW OF 'VW_NSO_2' 0 FILTER 0 CONNECT BY (WITH FILTERING) 0 NESTED LOOPS 0 INDEX GOAL: ANALYZED (RANGE SCAN) OF=0D 'QEQU_QUAL_SOURCE_REV_I' (NON-UNIQUE) 0 TABLE ACCESS GOAL: ANALYZED (BY USER ROWID) OF=0D 'QUALIFICATION_EQUIVALENCES' 0 NESTED LOOPS 0 BUFFER (SORT) 0 CONNECT BY PUMP 0 TABLE ACCESS GOAL: ANALYZED (BY INDEX ROWID)=0D OF 'QUALIFICATION_EQUIVALENCES' 0 INDEX GOAL: ANALYZED (RANGE SCAN) OF=0D 'QEQU_QUAL_SOURCE_REV_I' (NON-UNIQUE) 0 INDEX GOAL: ANALYZED (UNIQUE SCAN) OF 'CAS_PK' (UNIQUE) # =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D =3D=3D=3D=3D=3D=3D=3D=3D Thanks,=0D Alok=0D =0D __________________________________________________ The information contained in this message is intended only for the personal= and confidential use of the recipient(s) named above. If the reader of= this message is not the intended recipient or an agent responsible for= delivering it to the intended recipient, you are hereby notified that you= have received this document in error and that any review, dissemination,= distribution, or copying of this message is strictly prohibited. If you= have received this communication in error, please notify us immediately,= and delete the original message. ------_=_NextPart_001_01C44F29.A3B21731 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Message
Hi!
 
I need some advice.
 
HP-UX 11.00/Oracle v9205. SGA is larger on the= server=0D where it takes more time.
 
Can someone pl. explain whether it= is normal=0D to see stats like 35 more disk buffers reads and 200K more=0D consistent reads with diff. SGA size for the same q.?
 
 
 SELECT= DISTINCT LEVEL,=0D QUAL_CODE AS S_QUAL_CODE, QUAL_QTYP_CODE AS
  S_QUAL_QTYP_CODE,=0D EFFECTIVE_DATE
FROM
 QUALIFICATION_EQUIVALENCES
 START= WITH=0D (QUAL_CODE, QUAL_QTYP_CODE)
 IN (SELECT
  WQ.QUAL_CODE,=0D WQ.QUAL_QTYP_CODE
  FROM WORK_QUALIFICATIONS WQ ,
  =0D CURRENT_ASSIGNMENTS CA
WHERE CA.PER_PER_DB_ID =3D 100005667
 = AND=0D WQ.WASS_DB_ID =3D CA.WA_DB_ID
  AND (WQ.QUAL_CODE,=0D WQ.QUAL_QTYP_CODE)
  IN ( SELECT DISTINCT
  =0D QUAL_CODE,
   QUAL_QTYP_CODE
 FROM=0D QUALIFICATION_EQUIVALENCES
 WHERE TRUNC(NVL(EFFECTIVE_DATE,=0D '01-JAN-1900')) <=3D TRUNC(SYSDATE)
 START WITH= QUAL_CODE_THE_SOURCE_OF=0D =3D 'CH001R'
   AND QUAL_QTYP_CODE_THE_SOURCE_OF =3D=0D 'TRN'
 CONNECT BY PRIOR QUAL_CODE =3D QUAL_CODE_THE_SOURCE_OF=0D AND
           = PRIOR=0D QUAL_QTYP_CODE =3D QUAL_QTYP_CODE_THE_SOURCE_OF))
CONNECT BY PRIOR = =0D QUAL_CODE_THE_SOURCE_OF =3D= QUAL_CODE
       AND=0D PRIOR QUAL_QTYP_CODE_THE_SOURCE_OF =3D  QUAL_QTYP_CODE
ORDER BY= LEVEL=0D DESC
 
call    =0D count       cpu   =0D elapsed      = disk     =0D query    current       =0D rows
------- ------  -------- ---------- ---------- ----------=0D ---------- = ----------
Parse       =0D 1      0.11      =0D 0.11         =0D 0         =0D 0         =0D 0          =0D 0
Execute      1     = =0D 0.00      =0D 0.00         =0D 0         =0D 0         =0D 0          =0D 0
Fetch      271    =0D 13.61     =0D 13.36         =0D 0    =0D 225167         =0D 0         539
-------= ------ =0D -------- ---------- ---------- ---------- ---------- =0D ----------
total     = 273    =0D 13.72     =0D 13.48         =0D 0    =0D 225167         =0D 0         539
 
 SELECT= DISTINCT LEVEL,=0D QUAL_CODE AS S_QUAL_CODE, QUAL_QTYP_CODE AS
  S_QUAL_QTYP_CODE,=0D EFFECTIVE_DATE
FROM
 QUALIFICATION_EQUIVALENCES
 START= WITH=0D (QUAL_CODE, QUAL_QTYP_CODE)
 IN (SELECT
  WQ.QUAL_CODE,=0D WQ.QUAL_QTYP_CODE
  FROM WORK_QUALIFICATIONS WQ ,
  =0D CURRENT_ASSIGNMENTS CA
WHERE CA.PER_PER_DB_ID =3D 100005667
 = AND=0D WQ.WASS_DB_ID =3D CA.WA_DB_ID
  AND (WQ.QUAL_CODE,=0D WQ.QUAL_QTYP_CODE)
  IN ( SELECT DISTINCT
  =0D QUAL_CODE,
   QUAL_QTYP_CODE
 FROM=0D QUALIFICATION_EQUIVALENCES
 WHERE TRUNC(NVL(EFFECTIVE_DATE,=0D '01-JAN-1900')) <=3D TRUNC(SYSDATE)
 START WITH= QUAL_CODE_THE_SOURCE_OF=0D =3D 'CH001R'
   AND QUAL_QTYP_CODE_THE_SOURCE_OF =3D=0D 'TRN'
 CONNECT BY PRIOR QUAL_CODE =3D QUAL_CODE_THE_SOURCE_OF=0D AND
           = PRIOR=0D QUAL_QTYP_CODE =3D QUAL_QTYP_CODE_THE_SOURCE_OF))
CONNECT BY PRIOR = =0D QUAL_CODE_THE_SOURCE_OF =3D= QUAL_CODE
       AND=0D PRIOR QUAL_QTYP_CODE_THE_SOURCE_OF =3D  QUAL_QTYP_CODE
ORDER BY= LEVEL=0D DESC
 
call    =0D count       cpu   =0D elapsed      = disk     =0D query    current       =0D rows
------- ------  -------- ---------- ---------- ----------=0D ---------- = ----------
Parse       =0D 1      0.22      =0D 0.20         =0D 5        =0D 59         =0D 0          =0D 0
Execute      1     = =0D 0.00      =0D 0.00         =0D 0         =0D 0         =0D 0          =0D 0
Fetch      268    =0D 28.54     =0D 28.25        = 35    =0D 433615         =0D 0         534
-------= ------ =0D -------- ---------- ---------- ---------- ---------- =0D ----------
total     = 270    =0D 28.76     =0D 28.45        = 40    =0D 433674         =0D 0         534
 
Execution plan is exactly same on the two=0D servers.
#=0D =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D
Misses in library= cache=0D during parse: 1
Optimizer goal: CHOOSE
Parsing user id: 36 =0D (SUPERDATA)
 
Rows    =0D Execution Plan
------- =0D ---------------------------------------------------
   &n= bsp; =0D 0  SELECT STATEMENT   GOAL:=0D CHOOSE
      0   SORT=0D (UNIQUE)
      0    CONNECT BY= (WITH=0D FILTERING)
      0    = NESTED=0D LOOPS
      0     = NESTED=0D LOOPS
     = 0      =0D NESTED LOOPS
     =0D 0        MERGE JOIN=0D (CARTESIAN)
     =0D 0         VIEW OF=0D 'VW_NSO_1'
     =0D 0         =0D FILTER
     =0D 0           CONNECT BY= (WITH=0D FILTERING)
     =0D 0            NESTED= =0D LOOPS
     =0D 0            =0D INDEX   GOAL: ANALYZED (RANGE SCAN) OF=0D
            = ;           =0D 'QEQU_QUAL_SOURCE_REV_I' (NON-UNIQUE)
     =0D 0            = TABLE=0D ACCESS   GOAL: ANALYZED (BY USER=0D ROWID)
           = ;            &n= bsp;=0D OF 'QUALIFICATION_EQUIVALENCES'
     =0D 0            NESTED= =0D LOOPS
     =0D 0            = BUFFER=0D (SORT)
     =0D 0            &n= bsp;=0D CONNECT BY PUMP
     =0D 0            = TABLE=0D ACCESS   GOAL: ANALYZED (BY INDEX=0D
            = ;           =0D ROWID) OF 'QUALIFICATION_EQUIVALENCES'
     =0D 0            &n= bsp;=0D INDEX   GOAL: ANALYZED (RANGE SCAN) OF=0D
            = ;            =0D 'QEQU_QUAL_SOURCE_REV_I' (NON-UNIQUE)
     =0D 0         BUFFER=0D (SORT)
     =0D 0          INDEX  = GOAL:=0D ANALYZED (RANGE SCAN) OF 'CAS_PK'=0D
            = ;        =0D (UNIQUE)
     =0D 0        INDEX   GOAL:= ANALYZED=0D (UNIQUE SCAN) OF 'QWQU_UC'=0D
            = ;      =0D (UNIQUE)
     = 0      =0D INDEX   GOAL: ANALYZED (RANGE SCAN) OF 'QEQU_PK'= (UNIQUE)
 
      0     = TABLE=0D ACCESS   GOAL: ANALYZED (BY USER ROWID) OF=0D
            = ;    =0D 'QUALIFICATION_EQUIVALENCES'
     =0D 0     NESTED LOOPS
     =0D 0      BUFFER= (SORT)
     =0D 0       CONNECT BY=0D PUMP
      0     = TABLE=0D ACCESS   GOAL: ANALYZED (BY INDEX ROWID) OF=0D
            = ;    =0D 'QUALIFICATION_EQUIVALENCES'
     =0D 0       INDEX   GOAL: ANALYZED= (RANGE=0D SCAN) OF 'QEQU_PK' (UNIQUE)
 
      0     NESTED=0D LOOPS
      0     = NESTED=0D LOOPS
     = 0      =0D INDEX   GOAL: ANALYZED (RANGE SCAN) OF 'QWQU_PK'= (UNIQUE)
 
     = 0       VIEW=0D OF 'VW_NSO_2'
     =0D 0       =0D FILTER
     =0D 0         CONNECT BY (WITH=0D FILTERING)
     =0D 0          NESTED=0D LOOPS
     =0D 0          = INDEX  =0D GOAL: ANALYZED (RANGE SCAN) OF=0D
            = ;         =0D 'QEQU_QUAL_SOURCE_REV_I' (NON-UNIQUE)
     =0D 0           TABLE=0D ACCESS   GOAL: ANALYZED (BY USER ROWID) OF=0D
            = ;         =0D 'QUALIFICATION_EQUIVALENCES'
     =0D 0          NESTED=0D LOOPS
     =0D 0           BUFFER=0D (SORT)
     =0D 0            CONNECT= BY=0D PUMP
     =0D 0           TABLE=0D ACCESS   GOAL: ANALYZED (BY INDEX ROWID)=0D
            = ;         =0D OF 'QUALIFICATION_EQUIVALENCES'
     =0D 0           =0D INDEX   GOAL: ANALYZED (RANGE SCAN) OF=0D
            = ;          =0D 'QEQU_QUAL_SOURCE_REV_I' (NON-UNIQUE)
     =0D 0      INDEX   GOAL: ANALYZED (UNIQUE= SCAN)=0D OF 'CAS_PK' (UNIQUE)
#=0D =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D

Thanks,=0D

Alok=0D

 
__________________________________________________ The information contained in this message is intended only for the personal= and confidential use of the recipient(s) named above. If the reader of= this message is not the intended recipient or an agent responsible for= delivering it to the intended recipient, you are hereby notified that you= have received this document in error and that any review, dissemination,= distribution, or copying of this message is strictly prohibited. If you= have received this communication in error, please notify us immediately,= and delete the original message.
------_=_NextPart_001_01C44F29.A3B21731-- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------