Oracle-L: Re:DROP DEVELOPER not working

From: <dgoulet_at_vicr.com>
Date: Thu, 10 Oct 2002 07:38:52 -0800
Message-ID: <F001.004E5B06.20021010073852@fatcity.com>

Raj,

I'll take OTS's point of view on the subject, namely if the duhveloper can drop the table via SQL*Plus then he needs to call the vendor of the third party application. The database responds to a command the same way no matter where the command is issued from if it is complete and executed. More than likely there's either a bug in the third party code or else in his configuration thereof.

More than likely, and I've seen this before (actually did it myself), the application is doing something like a 'select count(*) from <tablename>;' and as long as count(*) > 0 it will wait, Well when the application leaves data laying around without cleaning up after itself guess what happens. DUH!!!

Dick Goulet

PS: I liked the "drop duhveloper off of third floor balcony" idea. But I still prefer the 12 gauge shotgun method. It's faster & leaves a more noticeable mark!! *-)

____________________Reply Separator____________________
Author: Rajesh.Rao_at_jpmchase.com
Date:       10/9/2002 1:28 PM

We have a developer here, installing a third party application, who claims one of his "delete campaign" process is hanging. I looked at the wait events, saw nothing, and asked him to politely to go look at the code. After much analysys, the developer now complains, that Oracle is not executing a drop table command at the end of the process, and hanging there. He claims he can drop the table from SQLPLUS.

I asked him to rerun the process. I noticed no wait events for that session in v$session_wait when he claims the process is hanging. I see no DROP statements in the v$sqlarea. I did a 10046 trace, and the last statement in the trace file is a select statement. I looked at the sql addresses from v$session, linked it to v$sqlarea and the sql_text shows the same select statement as is seen in the trace file. I see no exclusive locks on the said table. I conclude that the application is not sending a DROP statement to Oracle for execution. He claims that cannot be the case. They have done the same installation in a test environment and it worked fine. The jury seems to be taking sides. I scream SOS. What more should I be doing? And Does an Oracle 10046 trace write into the trace file after the statement has executed?

Thanks
Raj

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author:
INET: Rajesh.Rao_at_jpmchase.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author:
INET: dgoulet_at_vicr.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------