A rant for today...
I am a new in the DBA field. Please let me know how to take dbms stats and how to analyze the same.
Here was my response:
Way too broad of a question to be able to answer in a paragraph. I suggest you get this book: Cost Based Oracle Fundamentals to understand how the CBO works, how statistics fit into it, and start from there.
So, what we have is someone just starting out – new to the field, doesn’t know what to do or why they might be doing it.
Here was their response:
Didn’t help me: I want faster replies rather than scanning through books
I don’t get it. I really don’t get it. The only reply I could come up with was this:
You have a lot to learn my friend, a lot to learn.
If you don't want to spend the time to get the knowledge, your employer doesn't
really need you - they can get a piece of automated software to do it.
For example, in 10g – We don't need someone like you. The "rule of thumb" for
gathering statistics is a job burned into the database. You are not needed. The gathering of stats with the level of knowledge you apparently want to achieve (eg: no real knowledge, just to be told what to do). Everything works with AUTO.
However, if you actually know how it works, understand it, take the time to
learn it, you might actually be able to add some value.
Seriously disappointed - that describes me right now.
I really don’t get it. When I started out – I remember spending much time in the bookstore, tons of time reading what I bought there. Many hours exploring and testing the information I was getting. I would buy technical manuals I couldn’t get at work. I spent so much money here over time.
I really don’t get it. “Make me smart right now”. We don’t need that, if we could distill the knowledge down to a paragraph, we would encode it in software and let it do it for us.
Oh wait, we do that…
Just a thought for the people that want “instant knowledge”, that provides no value add over what the software already automates – therefore, it won’t do you very well. A little knowledge is a dangerous thing.
My day is off to a bad start…
Added a couple of hours later....
I liked what Lisa had to say. And the day is much better now - 2nd day of a three day seminar. A room full of people that actually want to increase their understanding, makes me feel much better.