Printable View
I agree with you one hundred percent. I have never tuned or seen a true Oracle Database running in the RealWorld. That's why I am a Rookie. (new to the field). But there doesn't seem to be too many Oracle DBA's that are willing to show new people to the field what Oracle truly looks like whereas MCSE's they talk and share stuff all the time.
So in the real world do you actually use Oracle Expert. From the books its looks like a pretty good tool to have around?
No, I do not use it. I have my own scripts and by now, I know what to check for. In the books, utlbstat/utlestat is also overrated.Quote:
So in the real world do you actually use Oracle Expert. From the books its looks like a pretty good tool to have around?
Dunno, used Oracle Expert once and I think it's really crap (specially the index wizard), I think nothing is better than customized scripts, statspack is pretty good as well, then ultbstat and utlestat.. Oracle Expert pffft I dont think peeps in Oracle Support use them neither
Customzied scripts simply takes too much time to do the reasearch on tuning... good but takes ages
And using Oracle Expert you wont be able to understand the tuning concepts, again my opinion :o
Never needed Oracle Expert, probably never will.
If you have a fundamental understanding of the database and how it works, you will not need a GUI for performance tuning. bstat/estat were good in 7, and statspack is pretty good for 8i.
Thought so -oracle expert tool reminds me of a lazy dba concept.
I did not read the entire chapter for Oracle Expert. i personally feel that it's a waste of time.
its a good thing only 1 question on Oracle Exams was included in the exam. of course i missed the answer. =)
I remember that the 1 question about Oracle Expert was very, very basic. Something like: If you wanna tune Oracle using a GUI, you would use:Quote:
Originally posted by D Maverick
I did not read the entire chapter for Oracle Expert. i personally feel that it's a waste of time.
its a good thing only 1 question on Oracle Exams was included in the exam. of course i missed the answer. =)
1. Oracle Expert
2. Oracle Wizard
3. Tuning Expert
4. Tuning Wizard
:-))
The question that i encountered for Oracle Expert goes something like:
What types of analysis can be performed on Oracle Expert, choose three (something like that)
A. Structure
B. User
C. Process
E. Instance
D. Schema
Tough luck, since its hard to guess 3 of 5. =)
Thats a pretty tough question even if you've studied the Oracle Expert. I automatically picked two but the third I really had to look at:
The answers are: Schema, Instance and Structure. I almost went for User as a distractor.
This is a tough, meaningless question .-)Quote:
Originally posted by Rookie
Thats a pretty tough question even if you've studied the Oracle Expert. I automatically picked two but the third I really had to look at:
The answers are: Schema, Instance and Structure. I almost went for User as a distractor.