Newsgroups: comp.databases.oracle.server Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!news.glorb.com!sws1!ornl!news.er.usgs.gov!news From: Brian Peasland Subject: Re: Serialization issue on Oracle 10g In-Reply-To: <1156017979.885692@bubbleator.drizzle.com> X-Nntp-Posting-Host: edc-cv-160-58.cr.usgs.gov Content-Type: text/plain; charset=ISO-8859-1; format=flowed Message-ID: User-Agent: Thunderbird 1.5.0.5 (Windows/20060719) Sender: news@igsrsparc2.er.usgs.gov (Janet Walz (GD) x6739) Content-Transfer-Encoding: 7bit Organization: U.S. Geological Survey, Reston VA References: <1155773099.520582.286420@i42g2000cwa.googlegroups.com> <1155833678.922996.13580@h48g2000cwc.googlegroups.com> <9xHFg.16429$o27.10763@newssvr21.news.prodigy.com> <1156017979.885692@bubbleator.drizzle.com> Mime-Version: 1.0 Date: Sun, 20 Aug 2006 16:31:25 GMT Lines: 52 Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:273224 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." > Fuzzy Greybeard > > > 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@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