Re: Locally managed tablespaces and migrated rows

What you have to appreciate is that we work in a little isolation room, as it were. We see the course notes, note the theory, test it out (some of us at any rate), and use our common sense as to whether a feature is any good or not. Unfortunately, we don't get to live in the real world where we find out whether X or Y is a life-saver, god-send, or a marketing feature, for real.

The best we can do is relate those experiences where we see the nonsense and the pitfalls (the one about a 55Mb application suddenly taking 600Mb+ is a true story that I witnessed).

There is a huge gulf between the training room and the real world, and nothing can eradicate that. A good trainer will point that out, but I agree that most don't, can't or won't. Personally, I crave for the anecdote and the personal cock-up, because it's through them that you work out when theory goes to pot. I have an 6-PC network in my spare bedroom for a reason: I use the product for real to try and get as realistic a grip on it as I can.

And you *learn* (any trainer that doesn't learn at least one thing per course is not doing the job properly, I reckon). And one of the things you ought to learn is that that which sounds like a good idea with no qualifiers turns out to be a disaster in the hands of the enthusiastic neophyte.

As for this particular one: I don't know who you work for Nuno, but since around May last year, until around January this year, there hasn't been anyone else in Sydney teaching Oracle DBA apart from yours truly, so I feel kind of guilty. I could *swear* that I ALWAYS point out that anything in Oracle requires the use of common sense, a due sense of testing before implementing, and the working out of whether something makes sense in a particular situation. But I see the rolling eyes in the head by Friday, and know that some of it doesn't go in.

With a due sense of humility, and a dawning sense of failure, I can report (but probably oughtn't) that Oracle have been good enough to take me back for the duration, and I take the comments I see in this thread to heart, and will do my best (as I thought I had been, but clearly haven't) to stamp out the overly simplistic approach in future.

This is a rich product we're working with, and I agree that we need to be richy-minded to deal with it all.

Regards
HJR "Nuno Souto" <nsouto_at_nsw.bigpond.net.au.nospam> wrote in message news:3af91311.4028559_at_news-server...
> On Wed, 9 May 2001 09:34:13 +0100, "Jonathan Lewis"
> <jonathan_at_jlcomp.demon.co.uk> wrote:
>
> >If you know exactly what you are doing
> >there is very little advantage to LMTs
> >over DMTs. But with a little care and
> >ingenuity it's quite easy to turn a safety
> >feature into a death trap, particularly if
> >you call it a shrink-wrapped, black-box,
> >3rd-party application.
>
> How true. And we have to live with them, they aren't gonna go away
> just because we think they're rubbish.
>
> BTW, to anyone listening who might be "concerned" that I'm having a go
> at Howard or at Oracle education in Australia:
>
> In the past, I've been accused of just that. In fact, it landed me in
> hot water with Oracle's top management. Because it was misinterpreted
> and distorted by a bunch of arseholes who don't work for Oracle
> anymore. I had the great joy a couple of years ago of meeting the
> person who got blasted then and hear him admit openly that I was
> absolutely right at the time with what I complained about.
>
> I'm not "roasting" anyone. Oracle education does not retain the
> "truth". Like any other education organization, it's a work in
> progress. New subjects come up and it takes a while to get the whole
> thing fine-tuned. It's in that spirit that I commented. As a
> "heads-up" that I'm noticing a problem with the output of their effort
> (the newbie DBAs). Not as an absolute attack on their practices.
>
> I hope that clears the air and I don't get another call from some crap
> USA VP at 2:00 am asking me "what the f... do you think you're doing"!
>
> And as far as Howard is concerned, I have a great deal of respect for
> the guy and it would be totally out of place for me to imply he was
> misleading anyone.
> If I ever had to say that about anyone I'd do so openly and directly,
> here or in any other open forum. Never been afraid of doing so in 26
> years in this industry. Wouldn't be starting now.
>
>
> Cheers
> Nuno Souto
> nsouto_at_bigpond.net.au.nospam
> http://www.users.bigpond.net.au/the_Den/index.html
Received on Wed May 09 2001 - 07:22:07 CDT