Re: Serialization issue on Oracle 10g

From: Brian Peasland <dba_at_nospam.peasland.net>
Date: Mon, 21 Aug 2006 05:26:16 GMT
Message-ID: <J4C1rw.86G@igsrsparc2.er.usgs.gov>

DA Morgan wrote:

> 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. ;-)

Then I quickly unlock their account, tell them to try again, and blame it on an error between the keyboard and the chair. :)

Cheers,
Brian

-- 
===================================================================

Brian Peasland
dba_at_nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown

Received on Mon Aug 21 2006 - 00:26:16 CDT