RE: Oracle 7.3.4 problem... SLOW Drop user

  • From: Jared.Still@xxxxxxxxxxx
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Wed, 4 Aug 2004 11:14:07 -0700

oracle-l-bounce@xxxxxxxxxxxxx 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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Other related posts: