Return-Path: Delivered-To: 2-oracle-l@orafaq.com Received: (qmail 21870 invoked from network); 10 Oct 2008 11:38:03 -0500 Received: from freelists-180.iquest.net (HELO turing.freelists.org) (206.53.239.180) by air964.startdedicated.com with SMTP; 10 Oct 2008 11:37:59 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id A22CEA3639F; Fri, 10 Oct 2008 12:36:45 -0400 (EDT) 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 16947-03; Fri, 10 Oct 2008 12:36:45 -0400 (EDT) Received: from turing.freelists.org (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 0C918A362B8; Fri, 10 Oct 2008 12:36:45 -0400 (EDT) Received: with ECARTIS (v1.0.0; list oracle-l); Fri, 10 Oct 2008 12:34:40 -0400 (EDT) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 9086EA371B2; Fri, 10 Oct 2008 12:34:40 -0400 (EDT) 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 15951-02-9; Fri, 10 Oct 2008 12:34:40 -0400 (EDT) Received: from nhplws963.nwideweb.net (pierce.nationwide.com [155.188.168.12]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 58E1FA371A5; Fri, 10 Oct 2008 12:34:40 -0400 (EDT) Received: from [172.25.24.105] (victor.nwie.net [172.25.24.105]) by nhplws963.nwideweb.net (Switch-3.2.5/Switch-3.2.5) with ESMTP id m9AGYdMp021024; Fri, 10 Oct 2008 12:34:39 -0400 Received: from [172.25.24.105] ([172.25.24.105]) by [172.25.24.105] via smtpd (for [10.93.148.2] [10.93.148.2]) with ESMTP; Fri, 10 Oct 2008 12:34:39 -0400 Received: from EntDDCMail09.nwie.net (ohcollbp0004.nwie.net [172.24.119.20]) by victor.nwie.net (Switch-3.2.5/Switch-3.1.11) with ESMTP id m9AGYceq026484; Fri, 10 Oct 2008 12:34:38 -0400 (EDT) In-Reply-To: <3c5f7820810100910x3f386082id8d393d263c38555@mail.gmail.com> To: sbecker6925@gmail.com Cc: oracle-l , oracle-l-bounce@freelists.org Subject: Re: Executing wrong sql MIME-Version: 1.0 Message-ID: From: TESTAJ3@nationwide.com Date: Fri, 10 Oct 2008 12:38:04 -0400 X-MIMETrack: Serialize by Router on EntDDCMail09/SRV/NWIE(Release 8.0.1 HF372|July 14, 2008) at 10/10/2008 12:38:04 PM, Serialize complete at 10/10/2008 12:38:04 PM Content-Type: multipart/alternative; boundary="=_alternative 005B1604852574DE_=" X-Spam-Score: 0.00% X-Spam-Analysis: v=1.0 c=1 a=oAmXSAwjz-BmgPGqoasA:9 a=IOcwKnLKrqXLHh4Yh58A:7 a=GcZeKeFQZzCfoRAz3tnKMQVcZI4A:4 a=MSl-tDqOz04A:10 a=btyeseNR-KIA:10 a=Iz4Xhm-JjTwA:10 a=HKfyApL1AAAA:8 a=gfg9ZlWwqujrLfQhUDwA:9 a=Gn7GMDIpzhAz2Ot6KQYA:7 a=-MnsCeW04kZdCYXqm9uh5bRuXUQA:4 a=QMcbb0mtcKgA:10 a=BMUHMS3u0ToA:10% X-Clean-RefId: str=0001.0A090209.48EF841F.0288,ss=1,fgs=0 X-archive-position: 11560 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: TESTAJ3@nationwide.com Precedence: normal Reply-to: TESTAJ3@nationwide.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 X-Virus-Scanned: Debian amavisd-new at localhost.localdomain --=_alternative 005B1604852574DE_= Content-Type: text/plain; charset="US-ASCII" HOw can you tell what is being executed, via a trace? Is there a materialized view out there thats doing a query rewrite? Thanks, Joe --------------------------------------- Phineas says, "Where's Perry?" "Sandra Becker" Sent by: oracle-l-bounce@freelists.org 10/10/2008 12:10 PM Please respond to sbecker6925@gmail.com From "Sandra Becker" To oracle-l cc Subject Executing wrong sql I have a developer trying to run an SQL script against a test database that is picking up the wrong sql instead of what is really in my PL/SQL script. What's really strange to me is that if I set echo on, I can see the code it should be executing, not what it is really executing. Could this be due to a cursor left open? I've never seen this behavior before so I'm a bit lost on where to look. If I run the same script against another test database, it works like it's supposed to. The developer also tells me that this code worked on this database until we bounced it yesterday. Our environment for both databases: Oracle 10.2.0.3, SuSE10, IBM z9 VM Any suggestions will be appreciated. Sandy --=_alternative 005B1604852574DE_= Content-Type: text/html; charset="US-ASCII"
HOw can you tell what is being executed, via a trace?

Is there a materialized view out there thats doing a query rewrite?

Thanks,  Joe

---------------------------------------
Phineas says, "Where's Perry?"


"Sandra Becker" <sbecker6925@gmail.com>
 
Sent by: oracle-l-bounce@freelists.org




10/10/2008 12:10 PM
Please respond to sbecker6925@gmail.com
From
"Sandra Becker" <sbecker6925@gmail.com>
To
oracle-l <oracle-l@freelists.org>
cc
Subject
Executing wrong sql





I have a developer trying to run an SQL script against a test database that is picking up the wrong sql instead of what is really in my PL/SQL script.  What's really strange to me is that if I set echo on, I can see the code it should be executing, not what it is really executing.  Could this be due to a cursor left open?  I've never seen this behavior before so I'm a bit lost on where to look.  
 
If I run the same script against another test database, it works like it's supposed to.  The developer also tells me that this code worked on this database until we bounced it yesterday.
 
Our environment for both databases:  Oracle 10.2.0.3, SuSE10, IBM z9 VM
 
Any suggestions will be appreciated.
 
Sandy
 
 
--=_alternative 005B1604852574DE_=-- -- http://www.freelists.org/webpage/oracle-l