Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Serialization issue on Oracle 10g

Re: Serialization issue on Oracle 10g

From: DA Morgan <damorgan_at_psoug.org>
Date: Sun, 20 Aug 2006 15:53:51 -0700
Message-ID: <1156114431.75617@bubbleator.drizzle.com>


Brian Peasland wrote:
> DA Morgan wrote:

>> HansF wrote:
>>> On Sat, 19 Aug 2006 17:05:09 +0000, Bob Jones wrote:
>>>
>>>> It is rather the collective intelligence of ineffciency with 
>>>> unnecessary complexity. People who drop tables without thinking are 
>>>> likely to purge without thinking.
>>>
>>> Of course.  But it allows pointing of fingers and laughing.  It's on the
>>> same level as those infamous warning signs such as "Do not use this
>>> electric hair dryer in the bathtub." or "Warning, hot coffee may scald."
>>> and "This child's toy contains small parts.  Keep out of reach of 
>>> children."
>>>
>>> One of my standard lines (when I teach Oracle courses) is that the new
>>> flashback capabilities compensate for the 'Britanney Spears user'
>>>    ... you know the one who comes up to the DBA 1/2 hour before lunch 
>>> and
>>>    says "Oops, I did it again.  I deleted all the data and committed. 
>>> I'm
>>>    going lunch now but the boss wants the report using that data right
>>>    after I'm back. It's your database - please fix it."      
>>> <copyleft Fuzzy Greybeard <g>>
>>
>> CREATE PROFILE bad_user LIMIT
>> CPU_PER_CALL 10
>> PRIVATE_SGA 25K
>> LOGICAL_READS_PER_CALL 10
>> CONNECT_TIME 15
>> IDLE_TIME 15;
>>
>> And have a nice day!  ;-)

>
> I prefer:
>
> ALTER USER bad_user ACCOUNT LOCK;
>
> Makes my job much easier!!!
>
> Cheers,
> Brian

I do too but then they know what you did and they complain and make a fuss about it to their manager. ;-)

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Sun Aug 20 2006 - 17:53:51 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US