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: Multi Threaded server not working for many inserts?

Re: Multi Threaded server not working for many inserts?

From: Michael Austin <maustin_at_firstdbasource.com>
Date: Sat, 29 May 2004 18:42:11 GMT
Message-ID: <7Q4uc.1312$Pm4.331@newssvr23.news.prodigy.com>


Sybrand Bakker wrote:

> Actually it isn't. It is a predictable reply to too many posters here
> who don't research anything, and just start to blame something,
> preferable a feature they don't understand (or are too lazy to read
> about).
> If there is anything personal in it, it is frustration, because he,
> and many other long-time professionals in this group suffer from
> people who only learned to hit a button in any GUI driven product, and
> as soon as anything goes wrong, don't do anything to resolve their own
> problems, don't search Google, but immediately post it, without
> providing any clues.
> That type of poster also preferably crossposts to every group he can
> spell, even if they have been abolished 8 years ago, and are not
> carried anymore by most providers.
> I am afraid, the ability to crosspost is his main thing he learned
> when he 'learned' Oracle.

and yet he gets hired because he took some test he paid for, but did not understand and has OCP behind his name and his rates reflect his true talent -shafting those of us who do know what we are doing. But yet companies still can't tell the difference between someone who can quote every verse in the docs and someone who knows how to find it in the docs then knows how to troubleshoot and actually understands the ramifications of making any changes.

Bottom line: most "DBA's" shouldn't be....

Frustrated to no end...

M. Austin

> 
> --
> Sybrand Bakker, Senior Oracle DBA
> 
> 
> On Fri, 28 May 2004 19:12:04 GMT, "Yosua" <leemorethomas_at_msn.com>
> wrote:
> 
> 

>>This response seems ego driven
>>"Billy Verreynne" <vslabs_at_onwe.co.za> wrote in message
>>news:1a75df45.0403161049.201206fb_at_posting.google.com...
>>
>>>"Royco" <bla_at_bla.nl> wrote
>>>
>>><snipped>
>>>
>>>>Are there any known bugs and workarounds in Multi Threaded Server
>>>>configurations which indicate problems with large inserts????
>>>
>>>This posting reminds me of a young scientist who caught a fly. He
>>>placed the fly on the lab table. He clapped his hands. The fly flew
>>>away. "Hearing. Excellent!" he wrote. He caught the fly again. Torn
>>>the fly's wings off and placed it on the table. He clapped his hands.
>>>The fly did not move. So he wrote in his lab notes "A fly without
>>>wings looses its ability to hear! Amazing!!".
>>>
>>>I.e. blaming your problems on MTS without providing a single shred of
>>>evidence or offering any kind of analysis results does not cut it.
>>>
>>>Processes do not hang. They do not get stuck at a machince code
>>>instruction and "hang" at that instuction.
>>>
>>>So even if it appears the car does not seem to be moving, the engine
>>>is still running. So you need to roll up your sleeves, pop the hood,
>>>and see what is happening inside. Is the car in gear? Is the car not
>>>maybe upside down? Did someone replace the fan with a Cessna 152 prop
>>>in an attempt to turn it into a plane?
>>>
>>>And yeah, this analogy is very apt when it comes to how some people
>>>insist on using Oracle.
>>>
>>>I.e. what does the wait events for that process say? What does the
>>>rows gotten, i/o reads/writes and other session stats say for that
>>>process? Have you enabled SQL tracing for that session when it appears
>>>to be hung? Have you had a look at operating system wait events?
>>>
>>>Or is this kneejerk re-action that MTS must be to blame typical of the
>>>investigative and troubleshooting skills of today's IT/Oracle
>>>professional?
>>>
>>>And yes dammit, I can do with anther mug of coffee. Or two...
>>>
>>>--
>>>Billy
>>

> Received on Sat May 29 2004 - 13:42:11 CDT

Original text of this message

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