RE: Oracle 7.3.4 problem... SLOW Drop user

From: <Jared.Still_at_radisys.com>
Date: Wed, 4 Aug 2004 11:14:07 -0700
Message-ID: <OFC506B6EA.A174CCF5-ON88256EE6.00640DDC-88256EE6.00642BE0@radisys.com>

oracle-l-bounce_at_freelists.org wrote on 08/04/2004 11:07:45 AM:
>
> There is a thing called ACID property. If the transaction
> wasn't terminated by the proper "commit", the oracle behaves
> as it has never happened (let's disregard ora-1555 for now).
> You can still walk to the user and tell him: "You will be terminated",
> with strong Austrian accent. In my case, it usually scares living
> daylight out of the poor user.
>
> --

Past experiences with dropping users on 7x lead me to believe that dropping a user was not viewed as a single transaction.

Haven't tested it, ain't going to. :)

Jared

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

To unsubscribe send email to: oracle-l-request_at_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
-----------------------------------------------------------------

Received on Wed Aug 04 2004 - 13:10:20 CDT