Re: Serialization issue on Oracle 10g

From: Brian Peasland <dba_at_nospam.peasland.net>
Date: Sun, 20 Aug 2006 16:31:25 GMT
Message-ID: <J4B1wG.CEI@igsrsparc2.er.usgs.gov>

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

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

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 Sun Aug 20 2006 - 11:31:25 CDT