RE: DROP DEVELOPER not working - 10046 trace
The STAT lines are emitted into the trace file only when a cursor
closes. I wish the kernel would emit them right after the plan is
constructed, but it's just not the way it works.
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
Upcoming events:
- Hotsos Clinic, Oct 15-17 Dallas, Dec 9-11 Honolulu
- 2003 Hotsos Symposium on OracleR System Performance, Feb 9-12 Dallas
- Jonathan Lewis' Optimising Oracle, Nov 19-21 Dallas
-Original Message-
[EMAIL PROTECTED]
Sent: Thursday, October 10, 2002 11:49 AM
To: Multiple recipients of list ORACLE-L
And I Used oradebug at level 12 and set the file size to unlimited, and
I
am not running out of space in the udump destination. So, why dont I see
the execution plan?
- Forwarded by Rajesh Rao/CHASE on 10/10/02 11:22 AM -
Rajesh Rao
To: [EMAIL PROTECTED]
October 10, cc:
2002 10:14 AMSubject: RE: DROP DEVELOPER
not working - 10046 trace(Document link:
Rajesh Rao)
As I was investigating more on this issue, I took a close look at the
select statement which runs just before the drop. Isnt this select
statement supposed to have a STAT with the execution plan in the 10046
trace file. Why dont I see it here? The entries in the trace file are :
PARSING IN CURSOR #3 len=100 dep=0 uid=187 oct=3 lid=187 tim=339770733
hv=1446102633 ad='6890a490'
SELECT t.table_name FROM VANTAGE.pv_Tabs t WHERE t.Table_Name = 'SFI4'
AND
t.Table_Owner = 'VANTAGE'
END OF STMT
PARSE #3:c=2,e=2,p=0,cr=4,cu=0,mis=1,r=0,dep=0,og=4,tim=339770733
WAIT #3: nam='SQL*Net message to client' ela= 0 p1=1413697536 p2=1 p3=0
WAIT #3: nam='SQL*Net message from client' ela= 1 p1=1413697536 p2=1
p3=0
BINDS #3:
EXEC
#3:c=1,e=0,p=0,cr=0,cu=0,mis=0,r=9223372041149743104,dep=0,og=4,tim=3397
70734
WAIT #3: nam='SQL*Net message to client' ela= 0 p1=1413697536 p2=1 p3=0
FETCH
#3:c=0,e=0,p=0,cr=16,cu=0,mis=0,r=9223376430606319617,dep=0,og=4,tim=339
770734
WAIT #3: nam='SQL*Net message from client' ela= 0 p1=1413697536 p2=1
p3=0
FETCH
#3:c=0,e=0,p=0,cr=4,cu=0,mis=0,r=9223376430606319616,dep=0,og=4,tim=3397
70734
WAIT #3: nam='SQL*Net message to client' ela= 0 p1=1413697536 p2=1 p3=0
Rajesh Rao
To: [EMAIL PROTECTED]
October 10, cc:
2002 12:34 AMSubject: RE: DROP DEVELOPER
not working(Document link: Rajesh Rao)
Thats a nice idea. The problem here is that the owner of the table is
the
one executing the drop. And its not via SQLPlus. So, the
use of product_profile is also ruled out. The SQLNet tracing suggested
by
Robert also seems a good idea, worth trying out. They have been pointing
me
to their log file which shows the DROP statement, which is the last line
in
the log file. Maybe its writing to the logs first.
Now, when does a 10046 trace write to the tracefile? Does it wait for
the
statement to finish executing, before it writes to the files.
I dont think so. I remember the trace file showing me statements with
bind
variables even as a plsql block was running. Self doubt creeping in. In
need of an expert opinion.
Thanks
Raj
"Deshpande, Kirti"
rizon.com> cc:
Sent by: Subject: RE: DROP
DEVELOPER not working
[EMAIL PROTECTED]
October 09, 2002
10:58 PM
Please respond to
ORACLE-L
Revoke the drop/delete privilege from role/userid, and ask them to run
the
process. That would confirm if the code ever encounters the drop/delete
instruction.
The process could very well be data dependent...
- Kirti
-Original Message-
Sent: Wednesday, October 09, 2002 7:04 PM
To: Multiple recipients of list ORACLE-L
"It worked fine in development!"
I can't believe anyone would still say that.
Has your duhveloper traced the code in the current environment,
to ensure that the offending piece of code is actually being executed?
Jared
[EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
10/09/2002 02:28 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L
<[EMAIL PROTECTED]>
cc:
Subject:DROP DEVELOPER not working
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
RE: DROP DEVELOPER not working - 10046 trace
Raj, This reminds me of a similar situation I encountered several years ago, perhaps there will be something in it that will help... A 3rd party app was periodically committing only 2 of 3 changes that were required. The most likely explanation of the problem was that there was an unhandled exception and the app was issuing a commit regardless. This turned out to be the case. This also would explain your situation where the app fails, but the same command run manually works. If the debug mode of the app failed to reveal any new info, I was going to turn on events to dump out an error stack in case of an error on inserts. We put together a list of probable errors on an insert (privs, bad data, unable to extend, etc.) and could have placed these events in the init.ora. The syntax is "event = trace name errorstack level 3" where error is the error number (1555 for Snapshot too old). Dan -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Fink, Dan INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: DROP DEVELOPER not working
Whoa Stephane You might be onto something here. The developer confirmed that they do use Pro*C and cursors in the process. Will investigate. Thanks a ton Raj Stephane Faroult To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Subject: Re: DROP DEVELOPER not working Sent by: root@fatcity. com October 10, 2002 03:25 PM Please respond to ORACLE-L [EMAIL PROTECTED] wrote: > > 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 > DROP DEVELOPER, what a nice idea ... Anyway, it reminds me of a similar problem I had ca 1990 in a Pro*C program. I was checking something in a table, cleanly closing my cursor, and trying to drop the table and it timed out each time. The reason was that although my cursor was closed, Pro*C was keeping it open in the hope that somewhat later I would reuse it and it would save a parse. The lock which was preventing me from dropping my table was not an exclusive lock, but a share lock on the dictionary - as long as a cursor references a table, you can't drop it. It was solved by adding the relevant bit of code (kind of pragma) to the Pro*C code. Does your saying 'I see no exclusive locks on the said table' implicitly means that you are seeing other locks? I think that there is one of those obscure init.ora parameters instructing Oracle to cache or not to cache closed cursors. This may be the difference between your test and prod environments. -- Regards, Stephane Faroult Oriole Software -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB
RE: DROP DEVELOPER not working - 10046 trace
Sorry, I did not pay attention to what level trace you were generating... :( - Kirti -Original Message- Sent: Thursday, October 10, 2002 2:25 PM To: Multiple recipients of list ORACLE-L Thanks Kirti. While I cannot stop drops completely, I am thinking I could use dbms_system with the scripts, to write to the alert log whenever a drop statement is executed. And by the way, I did a level 12 trace, and for the statements it does put in the execution plan : PARSING IN CURSOR #3 len=72 dep=0 uid=187 oct=7 lid=187 tim=339770729 hv=592557958 ad='68ae6978' DELETE FROM VANTAGE.VANTAGE_DYN_TAB VDT WHERE VDT.VANTAGE_ALIAS = 'SFO4' END OF STMT PARSE #3:c=0,e=1,p=0,cr=0,cu=0,mis=1,r=0,dep=0,og=4,tim=339770729 WAIT #3: nam='SQL*Net message to client' ela= 0 p1=1413697536 p2=1 p3=0 WAIT #3: nam='SQL*Net message from client' ela= 0 p1=1413697536 p2=1 p3=0 BINDS #3: EXEC #3:c=0,e=0,p=0,cr=4,cu=7,mis=0,r=9223372041149743105,dep=0,og=4,tim=33977072 9 WAIT #3: nam='SQL*Net message to client' ela= 0 p1=1413697536 p2=1 p3=0 WAIT #3: nam='SQL*Net message from client' ela= 2 p1=1413697536 p2=1 p3=0 STAT #3 id=1 cnt=1 pid=0 pos=0 obj=0 op='DELETE VANTAGE_DYN_TAB ' STAT #3 id=2 cnt=2 pid=1 pos=1 obj=128620 op='TABLE ACCESS FULL VANTAGE_DYN_TAB ' Thanks Raj -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: DROP DEVELOPER not working - 10046 trace
Thanks Kirti. While I cannot stop drops completely, I am thinking I could
use dbms_system with the scripts, to write to the alert log whenever a
drop statement is executed.
And by the way, I did a level 12 trace, and for the statements it does put
in the execution plan :
PARSING IN CURSOR #3 len=72 dep=0 uid=187 oct=7 lid=187 tim=339770729
hv=592557958 ad='68ae6978'
DELETE FROM VANTAGE.VANTAGE_DYN_TAB VDT WHERE VDT.VANTAGE_ALIAS = 'SFO4'
END OF STMT
PARSE #3:c=0,e=1,p=0,cr=0,cu=0,mis=1,r=0,dep=0,og=4,tim=339770729
WAIT #3: nam='SQL*Net message to client' ela= 0 p1=1413697536 p2=1 p3=0
WAIT #3: nam='SQL*Net message from client' ela= 0 p1=1413697536 p2=1 p3=0
BINDS #3:
EXEC
#3:c=0,e=0,p=0,cr=4,cu=7,mis=0,r=9223372041149743105,dep=0,og=4,tim=339770729
WAIT #3: nam='SQL*Net message to client' ela= 0 p1=1413697536 p2=1 p3=0
WAIT #3: nam='SQL*Net message from client' ela= 2 p1=1413697536 p2=1 p3=0
STAT #3 id=1 cnt=1 pid=0 pos=0 obj=0 op='DELETE VANTAGE_DYN_TAB '
STAT #3 id=2 cnt=2 pid=1 pos=1 obj=128620 op='TABLE ACCESS FULL
VANTAGE_DYN_TAB '
Thanks
Raj
"Deshpande, Kirti"
rizon.com> cc:
Sent by: Subject: RE: DROP DEVELOPER not
working - 10046 trace
[EMAIL PROTECTED]
October 10, 2002
01:49 PM
Please respond to
ORACLE-L
Execution plan is not generated by using event 10046 for tracing.
If you using 8i+, there is a way to prevent owner of the table from
performing ddl.
Here's a post by Joe Testa quite some time ago.
And I have used this process successfully.
HTH,
- Kirti
On Thu, 6 Jan 2000, Joseph Testa wrote:
> Why would you want to do that, well, i'm at a place where the developers
> have the schema owner password but we DBAs(being retentitive as we
are)dont
> want them to make any ddl changes.
>
>
> here are the steps:
>
> Feel free to change the names to your liking
>
> create user schema_control identified by
> grant create any trigger to schema_control;
>
> edit the 3 following triggers, changing the to the schema
you
> want to put the control on:
>
> create or replace trigger create_control_trigger
> before create on .schema
>
> begin
> raise_application_error(-20001,'NO CREATE DDL ALLOWED');
> end;
> /
>
> create or replace trigger drop_control_trigger
> before drop on .schema
>
> begin
> raise_application_error(-20001,'NO DROP DDL ALLOWED');
> end;
> /
>
> create or replace trigger alter_control_trigger
> before alter on .schema
>
> begin
> raise_application_error(-20001,'NO ALTER DDL ALLOWED');
> end;
> /
>
>
> revoke alter any trigger from ;
>
> the previous line is needed so they dont alter the trigger to disable it
:)
>
> the next time they attempt to create, drop or alter anything in that
schema
> they get error msg.
>
> This all assumes they are not dba :)
>
> hht, joe
-Original Message-
Sent: Thursday, October 10, 2002 11:49 AM
To: Multiple recipients of list ORACLE-L
And I Used oradebug at level 12 and set the file size to unlimited, and I
am not running out of space in the udump destination. So, why dont I see
the execution plan?
----- Forwarded by Rajesh Rao/CHASE on 10/10/02 11:22 AM -
Rajesh Rao
To: [EMAIL PROTECTED]
October 10,
Re: DROP DEVELOPER not working
[EMAIL PROTECTED] wrote: > > 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 > DROP DEVELOPER, what a nice idea ... Anyway, it reminds me of a similar problem I had ca 1990 in a Pro*C program. I was checking something in a table, cleanly closing my cursor, and trying to drop the table and it timed out each time. The reason was that although my cursor was closed, Pro*C was keeping it open in the hope that somewhat later I would reuse it and it would save a parse. The lock which was preventing me from dropping my table was not an exclusive lock, but a share lock on the dictionary - as long as a cursor references a table, you can't drop it. It was solved by adding the relevant bit of code (kind of pragma) to the Pro*C code. Does your saying 'I see no exclusive locks on the said table' implicitly means that you are seeing other locks? I think that there is one of those obscure init.ora parameters instructing Oracle to cache or not to cache closed cursors. This may be the difference between your test and prod environments. -- Regards, Stephane Faroult Oriole Software -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: DROP DEVELOPER not working - 10046 trace
I am not talking of the execution plan for the drop table statement, but
for the select that's run prior to it? I opened a TAR for it, and Metalink
states: "sql trace messages are not in sync with the session. Some
messages will only dump to trace when the cursor is closed, or the program
normally exits. If you kill the program when it is hanging, very likely,
statistics information will not dump to trace."
Thanks
Raj
One attachment (0k)
"Jamadagni,
Rajendra" To: Multiple recipients of list
ORACLE-L <[EMAIL PROTECTED]>
Subject: RE: DROP DEVELOPER not
working - 10046 trace
Sent by:
[EMAIL PROTECTED]
October 10, 2002
12:59 PM
Please respond to
ORACLE-L
execution plan comes at the end ... that's why ...
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of ESPN
Inc.
QOTD: Any clod can have facts, but having an opinion is an art!
-Original Message-
Sent: Thursday, October 10, 2002 12:49 PM
To: Multiple recipients of list ORACLE-L
And I Used oradebug at level 12 and set the file size to unlimited, and I
am not running out of space in the udump destination. So, why dont I see
the execution plan?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
RE: DROP DEVELOPER not working - 10046 trace
Execution plan is not generated by using event 10046 for tracing.
If you using 8i+, there is a way to prevent owner of the table from
performing ddl.
Here's a post by Joe Testa quite some time ago.
And I have used this process successfully.
HTH,
- Kirti
On Thu, 6 Jan 2000, Joseph Testa wrote:
> Why would you want to do that, well, i'm at a place where the developers
> have the schema owner password but we DBAs(being retentitive as we
are)dont
> want them to make any ddl changes.
>
>
> here are the steps:
>
> Feel free to change the names to your liking
>
> create user schema_control identified by
> grant create any trigger to schema_control;
>
> edit the 3 following triggers, changing the to the schema
you
> want to put the control on:
>
> create or replace trigger create_control_trigger
> before create on .schema
>
> begin
> raise_application_error(-20001,'NO CREATE DDL ALLOWED');
> end;
> /
>
> create or replace trigger drop_control_trigger
> before drop on .schema
>
> begin
> raise_application_error(-20001,'NO DROP DDL ALLOWED');
> end;
> /
>
> create or replace trigger alter_control_trigger
> before alter on .schema
>
> begin
> raise_application_error(-20001,'NO ALTER DDL ALLOWED');
> end;
> /
>
>
> revoke alter any trigger from ;
>
> the previous line is needed so they dont alter the trigger to disable it
:)
>
> the next time they attempt to create, drop or alter anything in that
schema
> they get error msg.
>
> This all assumes they are not dba :)
>
> hht, joe
-Original Message-
Sent: Thursday, October 10, 2002 11:49 AM
To: Multiple recipients of list ORACLE-L
And I Used oradebug at level 12 and set the file size to unlimited, and I
am not running out of space in the udump destination. So, why dont I see
the execution plan?
- Forwarded by Rajesh Rao/CHASE on 10/10/02 11:22 AM -
Rajesh Rao
To: [EMAIL PROTECTED]
October 10, cc:
2002 10:14 AMSubject: RE: DROP DEVELOPER not
working - 10046 trace(Document link:
Rajesh Rao)
As I was investigating more on this issue, I took a close look at the
select statement which runs just before the drop. Isnt this select
statement supposed to have a STAT with the execution plan in the 10046
trace file. Why dont I see it here? The entries in the trace file are :
PARSING IN CURSOR #3 len=100 dep=0 uid=187 oct=3 lid=187 tim=339770733
hv=1446102633 ad='6890a490'
SELECT t.table_name FROM VANTAGE.pv_Tabs t WHERE t.Table_Name = 'SFI4' AND
t.Table_Owner = 'VANTAGE'
END OF STMT
PARSE #3:c=2,e=2,p=0,cr=4,cu=0,mis=1,r=0,dep=0,og=4,tim=339770733
WAIT #3: nam='SQL*Net message to client' ela= 0 p1=1413697536 p2=1 p3=0
WAIT #3: nam='SQL*Net message from client' ela= 1 p1=1413697536 p2=1 p3=0
BINDS #3:
EXEC
#3:c=1,e=0,p=0,cr=0,cu=0,mis=0,r=9223372041149743104,dep=0,og=4,tim=33977073
4
WAIT #3: nam='SQL*Net message to client' ela= 0 p1=1413697536 p2=1 p3=0
FETCH
#3:c=0,e=0,p=0,cr=16,cu=0,mis=0,r=9223376430606319617,dep=0,og=4,tim=3397707
34
WAIT #3: nam='SQL*Net message from client' ela= 0 p1=1413697536 p2=1 p3=0
FETCH
#3:c=0,e=0,p=0,cr=4,cu=0,mis=0,r=9223376430606319616,dep=0,og=4,tim=33977073
4
WAIT #3: nam='SQL*Net message to client' ela= 0 p1=1413697536 p2=1 p3=0
Rajesh Rao
To: [EMAIL PROTECTED]
October 10, cc:
2002 12:34 AMSubject: RE: DROP DEVELOPER not
working(Document link: Rajesh Rao)
Thats a nice idea. The problem here is that the owner of the table is the
one executing the drop. And its not via SQLPlus. So, the
use of product_profile is also ruled out. The SQLNet tracing suggested by
Robert also seems a good idea, worth trying out. They have been pointing me
to their log file which shows the DROP statement, which is the last line in
the log file. Maybe its writing to the logs first.
Now, when does a 10046 trace write to the tracefile? Does it wait for the
statement to finish executing, before it writes to the files.
I dont think so. I remember the trace file showing me statements with bind
variables even as a plsql block was running. Self doubt creeping in. In
need of an expert opinion.
Thanks
Raj
"Deshpande, Kirti"
rizon.com> cc:
Sent by: Subject: RE: DROP
DEVELOPER not working
[EMAIL PROTECTED]
RE: DROP DEVELOPER not working - 10046 trace
As I was investigating more on this issue, I took a close look at the
select statement which runs just before the drop. Isnt this select
statement supposed to have a STAT with the execution plan in the 10046
trace file. Why dont I see it here? The entries in the trace file are :
PARSING IN CURSOR #3 len=100 dep=0 uid=187 oct=3 lid=187 tim=339770733
hv=1446102633 ad='6890a490'
SELECT t.table_name FROM VANTAGE.pv_Tabs t WHERE t.Table_Name = 'SFI4' AND
t.Table_Owner = 'VANTAGE'
END OF STMT
PARSE #3:c=2,e=2,p=0,cr=4,cu=0,mis=1,r=0,dep=0,og=4,tim=339770733
WAIT #3: nam='SQL*Net message to client' ela= 0 p1=1413697536 p2=1 p3=0
WAIT #3: nam='SQL*Net message from client' ela= 1 p1=1413697536 p2=1 p3=0
BINDS #3:
EXEC
#3:c=1,e=0,p=0,cr=0,cu=0,mis=0,r=9223372041149743104,dep=0,og=4,tim=339770734
WAIT #3: nam='SQL*Net message to client' ela= 0 p1=1413697536 p2=1 p3=0
FETCH
#3:c=0,e=0,p=0,cr=16,cu=0,mis=0,r=9223376430606319617,dep=0,og=4,tim=339770734
WAIT #3: nam='SQL*Net message from client' ela= 0 p1=1413697536 p2=1 p3=0
FETCH
#3:c=0,e=0,p=0,cr=4,cu=0,mis=0,r=9223376430606319616,dep=0,og=4,tim=339770734
WAIT #3: nam='SQL*Net message to client' ela= 0 p1=1413697536 p2=1 p3=0
Rajesh Rao
To: [EMAIL PROTECTED]
October 10, cc:
2002 12:34 AMSubject: RE: DROP DEVELOPER not
working(Document link: Rajesh Rao)
Thats a nice idea. The problem here is that the owner of the table is the
one executing the drop. And its not via SQLPlus. So, the
use of product_profile is also ruled out. The SQLNet tracing suggested by
Robert also seems a good idea, worth trying out. They have been pointing me
to their log file which shows the DROP statement, which is the last line in
the log file. Maybe its writing to the logs first.
Now, when does a 10046 trace write to the tracefile? Does it wait for the
statement to finish executing, before it writes to the files.
I dont think so. I remember the trace file showing me statements with bind
variables even as a plsql block was running. Self doubt creeping in. In
need of an expert opinion.
Thanks
Raj
"Deshpande, Kirti"
rizon.com> cc:
Sent by: Subject: RE: DROP DEVELOPER not
working
[EMAIL PROTECTED]
October 09, 2002
10:58 PM
Please respond to
ORACLE-L
Revoke the drop/delete privilege from role/userid, and ask them to run the
process. That would confirm if the code ever encounters the drop/delete
instruction.
The process could very well be data dependent...
- Kirti
-Original Message-
Sent: Wednesday, October 09, 2002 7:04 PM
To: Multiple recipients of list ORACLE-L
"It worked fine in development!"
I can't believe anyone would still say that.
Has your duhveloper traced the code in the current environment,
to ensur
RE: DROP DEVELOPER not working - 10046 trace
Title: RE: DROP DEVELOPER not working - 10046 trace execution plan comes at the end ... that's why ... Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 10, 2002 12:49 PM To: Multiple recipients of list ORACLE-L Subject: RE: DROP DEVELOPER not working - 10046 trace And I Used oradebug at level 12 and set the file size to unlimited, and I am not running out of space in the udump destination. So, why dont I see the execution plan? *This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*1
RE: DROP DEVELOPER not working - 10046 trace
And I Used oradebug at level 12 and set the file size to unlimited, and I
am not running out of space in the udump destination. So, why dont I see
the execution plan?
- Forwarded by Rajesh Rao/CHASE on 10/10/02 11:22 AM -
Rajesh Rao
To: [EMAIL PROTECTED]
October 10, cc:
2002 10:14 AMSubject: RE: DROP DEVELOPER not working -
10046 trace(Document link:
Rajesh Rao)
As I was investigating more on this issue, I took a close look at the
select statement which runs just before the drop. Isnt this select
statement supposed to have a STAT with the execution plan in the 10046
trace file. Why dont I see it here? The entries in the trace file are :
PARSING IN CURSOR #3 len=100 dep=0 uid=187 oct=3 lid=187 tim=339770733
hv=1446102633 ad='6890a490'
SELECT t.table_name FROM VANTAGE.pv_Tabs t WHERE t.Table_Name = 'SFI4' AND
t.Table_Owner = 'VANTAGE'
END OF STMT
PARSE #3:c=2,e=2,p=0,cr=4,cu=0,mis=1,r=0,dep=0,og=4,tim=339770733
WAIT #3: nam='SQL*Net message to client' ela= 0 p1=1413697536 p2=1 p3=0
WAIT #3: nam='SQL*Net message from client' ela= 1 p1=1413697536 p2=1 p3=0
BINDS #3:
EXEC
#3:c=1,e=0,p=0,cr=0,cu=0,mis=0,r=9223372041149743104,dep=0,og=4,tim=339770734
WAIT #3: nam='SQL*Net message to client' ela= 0 p1=1413697536 p2=1 p3=0
FETCH
#3:c=0,e=0,p=0,cr=16,cu=0,mis=0,r=9223376430606319617,dep=0,og=4,tim=339770734
WAIT #3: nam='SQL*Net message from client' ela= 0 p1=1413697536 p2=1 p3=0
FETCH
#3:c=0,e=0,p=0,cr=4,cu=0,mis=0,r=9223376430606319616,dep=0,og=4,tim=339770734
WAIT #3: nam='SQL*Net message to client' ela= 0 p1=1413697536 p2=1 p3=0
Rajesh Rao
To: [EMAIL PROTECTED]
October 10, cc:
2002 12:34 AMSubject: RE: DROP DEVELOPER not
working(Document link: Rajesh Rao)
Thats a nice idea. The problem here is that the owner of the table is the
one executing the drop. And its not via SQLPlus. So, the
use of product_profile is also ruled out. The SQLNet tracing suggested by
Robert also seems a good idea, worth trying out. They have been pointing me
to their log file which shows the DROP statement, which is the last line in
the log file. Maybe its writing to the logs first.
Now, when does a 10046 trace write to the tracefile? Does it wait for the
statement to finish executing, before it writes to the files.
I dont think so. I remember the trace file showing me statements with bind
variables even as a plsql block was running. Self doubt creeping in. In
need of an expert opinion.
Thanks
Raj
"Deshpande, Kirti"
rizon.com> cc:
Sent by: Subject: RE: DROP DEVELOPER not
working
[EMAIL PROTECTED]
October 09, 2002
10:58 PM
RE: DROP DEVELOPER not working
"DROP COW-WORKER" only works here in the Dairy State... ;) Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- Sent: Thursday, October 10, 2002 11:09 AM To: Multiple recipients of list ORACLE-L I hear that they are enhancing that command in 10i. You know have the option of naming the employment position: drop manager drop user drop cow-worker etc... I recall that in Unix, the trace file is written right away, but NT waits for the process to complete. *Could be wrong on this one...only 1 cup of coffee this morning -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: DROP DEVELOPER not working
Title: RE: DROP DEVELOPER not working I hear that they are enhancing that command in 10i. You know have the option of naming the employment position: drop manager drop user drop cow-worker etc... I recall that in Unix, the trace file is written right away, but NT waits for the process to complete. *Could be wrong on this one...only 1 cup of coffee this morning -Original Message-From: Jamadagni, Rajendra [mailto:[EMAIL PROTECTED]]Sent: Thursday, October 10, 2002 5:39 AMTo: Multiple recipients of list ORACLE-LSubject: RE: DROP DEVELOPER not working (taking a cue from RMAN syntax) drop developer from third_floor position upside_down immediate / works for me all the time ... (sorry couldn't resist ... I have been a developer too for 8+ years) BTW 10046 will write the sql statement to trace file as soon as it is parsed ... it will have appropriate entry for execution as well ... Also, see if developer is doing all this inside a script ... take a closer look for a missing / or a semicolon ... Sometimes the best solution is an extra pair of eyes to see your code pick the person who hates you most, chances are he/she will find the most bugs in the least anount of time. It's human nature ... Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art!
RE: DROP DEVELOPER not working
Title: RE: DROP DEVELOPER not working (taking a cue from RMAN syntax) drop developer from third_floor position upside_down immediate / works for me all the time ... (sorry couldn't resist ... I have been a developer too for 8+ years) BTW 10046 will write the sql statement to trace file as soon as it is parsed ... it will have appropriate entry for execution as well ... Also, see if developer is doing all this inside a script ... take a closer look for a missing / or a semicolon ... Sometimes the best solution is an extra pair of eyes to see your code pick the person who hates you most, chances are he/she will find the most bugs in the least anount of time. It's human nature ... Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! *This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*1
RE: DROP DEVELOPER not working
Thats a nice idea. The problem here is that the owner of the table is the one executing the drop. And its not via SQLPlus. So, the use of product_profile is also ruled out. The SQLNet tracing suggested by Robert also seems a good idea, worth trying out. They have been pointing me to their log file which shows the DROP statement, which is the last line in the log file. Maybe its writing to the logs first. Now, when does a 10046 trace write to the tracefile? Does it wait for the statement to finish executing, before it writes to the files. I dont think so. I remember the trace file showing me statements with bind variables even as a plsql block was running. Self doubt creeping in. In need of an expert opinion. Thanks Raj "Deshpande, Kirti" rizon.com> cc: Sent by: Subject: RE: DROP DEVELOPER not working [EMAIL PROTECTED] October 09, 2002 10:58 PM Please respond to ORACLE-L Revoke the drop/delete privilege from role/userid, and ask them to run the process. That would confirm if the code ever encounters the drop/delete instruction. The process could very well be data dependent... - Kirti -Original Message- Sent: Wednesday, October 09, 2002 7:04 PM To: Multiple recipients of list ORACLE-L "It worked fine in development!" I can't believe anyone would still say that. Has your duhveloper traced the code in the current environment, to ensure that the offending piece of code is actually being executed? Jared [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 10/09/2002 02:28 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:DROP DEVELOPER not working 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of ma
RE: DROP DEVELOPER not working
Revoke the drop/delete privilege from role/userid, and ask them to run the process. That would confirm if the code ever encounters the drop/delete instruction. The process could very well be data dependent... - Kirti -Original Message- Sent: Wednesday, October 09, 2002 7:04 PM To: Multiple recipients of list ORACLE-L "It worked fine in development!" I can't believe anyone would still say that. Has your duhveloper traced the code in the current environment, to ensure that the offending piece of code is actually being executed? Jared [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 10/09/2002 02:28 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:DROP DEVELOPER not working 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: Deshpande, Kirti INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: DROP DEVELOPER not working
Privs obtained via roles (such as DROP TABLE) are NOT transferred (by default) when inside PL/SQL procedures. Rajesh.Rao@jpmcha se.com To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent by: cc: [EMAIL PROTECTED] Subject: DROP DEVELOPER not working 10/09/2002 02:28 PM Please respond to ORACLE-L 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: DROP DEVELOPER not working
"It worked fine in development!" I can't believe anyone would still say that. Has your duhveloper traced the code in the current environment, to ensure that the offending piece of code is actually being executed? Jared [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 10/09/2002 02:28 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:DROP DEVELOPER not working 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: DROP DEVELOPER not working
Raj - What about just a normal trace file? It should show a list of the commands sent, including the drop table. Maybe killing the session will cause the O.S. to flush the trace write buffer. Just a thought. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, October 09, 2002 4:28 PM To: Multiple recipients of list ORACLE-L 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: DENNIS WILLIAMS INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: DROP DEVELOPER not working
Is the application coming from a client? If so, sniff the packets and look for his DROP. That should be pretty conclusive. You can see the packets in a SQL*Net trace by setting TRACE_LEVEL_CLIENT=16 in sqlnet.ora. R> We have a developer here, installing a third party application, who claims R> one of his "delete campaign" process is hanging. I looked at the wait R> events, saw nothing, and asked him to politely to go look at the code. R> After much analysys, the developer now complains, that Oracle is not R> executing a drop table command at the end of the process, and hanging R> there. He claims he can drop the table from SQLPLUS. R> I asked him to rerun the process. I noticed no wait events for that session R> in v$session_wait when he claims the process is hanging. I see no DROP R> statements in the v$sqlarea. I did a 10046 trace, and the last statement in R> the trace file is a select statement. I looked at the sql addresses from R> v$session, linked it to v$sqlarea and the sql_text shows the same select R> statement as is seen in the trace file. I see no exclusive locks on the R> said table. I conclude that the application is not sending a DROP statement R> to Oracle for execution. He claims that cannot be the case. They have done R> the same installation in a test environment and it worked fine. The jury R> seems to be taking sides. I scream SOS. What more should I be doing? And R> Does an Oracle 10046 trace write into the trace file after the statement R> has executed? R> Thanks R> Raj R> -- R> Please see the official ORACLE-L FAQ: http://www.orafaq.com -rje -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robert Eskridge INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
