Wednesday, July 20, 2005
Oracle seem to employ smart people.
No, really. I know if you've engaged a support analyst in fruitless conversations this can occasionally seem hard to believe. Still.
Oh, what you wanted evidence as well? I'm afraid its that HTMLDB team again.not fit, shoelaces, tie. rearrange this into a well known phrase or saying and apply to me.
It so happens that HTMLDB engage a guy called Tyler Muth (this is either a made up name or he is American - who can tell). I've never met him, and likely never will. Anyway first up he contributed a hugely useful comment to Lisa's new oracle newbie blog. Here is what he has to say on learning Oracle
Now if you were following this blog earlier, then you'll know that, rather like many dbas I don't have the highest opinion of OEM there has ever been. (and EM10G needs to get the licensing bug sorted). But not content with the above advice, in the same post, Tyler adds
And finally, I refer you to this post on the HTMLDB forum showing just what can be achieved with cheap hardware and creative use of software features.
7 Comments
Oh, what you wanted evidence as well? I'm afraid its that HTMLDB team again.not fit, shoelaces, tie. rearrange this into a well known phrase or saying and apply to me.
It so happens that HTMLDB engage a guy called Tyler Muth (this is either a made up name or he is American - who can tell). I've never met him, and likely never will. Anyway first up he contributed a hugely useful comment to Lisa's new oracle newbie blog. Here is what he has to say on learning Oracle
VM Ware is sooooo key IMHO. You can create a base Linux or Windows image and save it off. Then install the database into it. If you make a major mistake, no problem, just grab the clean image you created and try again. As you start installing more "stuff", you can really make a mess of your machine. VM Ware contains the mess, makes it portable, and makes it easy to start over.. Now I happen to think, having installed Oracle 8,8i,9 and 10 on various boxes in various semi-competent ways, and then having had to clean up afterwards that that tip is worth the price of entrance alone.
Now if you were following this blog earlier, then you'll know that, rather like many dbas I don't have the highest opinion of OEM there has ever been. (and EM10G needs to get the licensing bug sorted). But not content with the above advice, in the same post, Tyler adds
I'm also a fan of the stand-alone version of Enterprise Manager (pre 10g) as a learning tool. Instead of digging for hours for the solution, do it in EM but press the "Show SQL" button. This way you learn what's going on under the covers. simple, straightforward and rather sneaky thinking in my book.
And finally, I refer you to this post on the HTMLDB forum showing just what can be achieved with cheap hardware and creative use of software features.
Then I turned on the resource manager and put a pretty restrictive policy in place. I believe any query that takes over 10 seconds gets dropped to 1% CPU, anything that takes over 30 min gets killed, anything estimated to take over 2 hours gets killed as soon as it's issued. This one of the most under-utilized db features I know.
7 Comments:
"This one of the most under-utilized db features I know"
and also one of the least documented ones, with an admin interface that positively "sucks" (at least in 9i)! It's a pity. I'm with you: it needs a lot more exposure.
and also one of the least documented ones, with an admin interface that positively "sucks" (at least in 9i)! It's a pity. I'm with you: it needs a lot more exposure.
I've been telling people to use VMware as their installation platforms for years! I've even had to fend off email accusing me of being a VMware salesman!
Disposable, repeatable, portable, cross-platformable and (since version 5) video-able. Training presentations knocked up so easily, it's not funny.
The snapshot and cloning features alone are worth the product's cost.
If only I had the bandwidth, I'd have put lots of RAC, ASM and Em video tutorials online by now.
I happen not to agree with the Enterprise Manager "Show SQL" idea, because I've seen people get sucked into the GUI, and who thus end up using it in its own right rather than remembering it's only a teaching tool. But I guess it's a place to start, if you're careful.
Disposable, repeatable, portable, cross-platformable and (since version 5) video-able. Training presentations knocked up so easily, it's not funny.
The snapshot and cloning features alone are worth the product's cost.
If only I had the bandwidth, I'd have put lots of RAC, ASM and Em video tutorials online by now.
I happen not to agree with the Enterprise Manager "Show SQL" idea, because I've seen people get sucked into the GUI, and who thus end up using it in its own right rather than remembering it's only a teaching tool. But I guess it's a place to start, if you're careful.
RE: Resource Manager
I've said before that it's the forgotten DBA tool:
http://www.oracle-base.com/articles/10g/ResourceManagerEnhancements10g.php
In 10g it's much simpler to use, but like all technologies you have to know what you're doing. Dropping the priority of a session that's holding locks can stall high priority sessions, defeating the object of your resource management. I learnt the hard way :)
Cheers
Tim...
I've said before that it's the forgotten DBA tool:
http://www.oracle-base.com/articles/10g/ResourceManagerEnhancements10g.php
In 10g it's much simpler to use, but like all technologies you have to know what you're doing. Dropping the priority of a session that's holding locks can stall high priority sessions, defeating the object of your resource management. I learnt the hard way :)
Cheers
Tim...
Tyler occasionally popped up on Mr Kyte's site (no, not the blog, the other one ;-) ) - I think he picked up some of the web questions for Tom, also did the Firefox search pluging for AskTom
I use the resource manager on an oltp system. I assign users (interactive) high priority and batch jobs low priority (90% CPU for users and 10% for batch). We are on 8i.
It works rather well. Most of the time there isn't a difference, but if some "batch user" runs something at the wrong time it doesn't piss off the users.
I also gave two of the administrators special seperate logins as "batch users" so they can run large updates under those logins. They don't need the updates to be super fast, but they don't want to wait until there are less users on the system.
You are correct the interface is UGH!
It works rather well. Most of the time there isn't a difference, but if some "batch user" runs something at the wrong time it doesn't piss off the users.
I also gave two of the administrators special seperate logins as "batch users" so they can run large updates under those logins. They don't need the updates to be super fast, but they don't want to wait until there are less users on the system.
You are correct the interface is UGH!
This is Tyler. I'm real, I promise, and yes, I am American. If someone made up a fictious character, I hope they would choose a better name than Muth.
Your comments are flattering, thank you. I think I ended up sounding a lot smarter than I really am ;)
I completely agree with the interface comments, though the one in 10g Grid Control is much improved.
Post a Comment
Your comments are flattering, thank you. I think I ended up sounding a lot smarter than I really am ;)
I completely agree with the interface comments, though the one in 10g Grid Control is much improved.
