|
May, 2003
In
This Issue
|
|
All articles have been reprinted with the written consent of their respective authors. | |||||||||||||
|
|||||||||||||
|
Create DDL for all Profiles in a
Database This month's utility is a script to generate DDL for all profiles in a database as well as their underlying functions. This script uses the UTL_FILE feature of PL/SQL. To run this script, users should have the "UTL_FILE_DIR" parameter configured in the init.ora file. Click Here
for the script. |
|||||||||||||
|
|||||||||||||
|
Offensive Runaways - Defensive
DBAs - II In my first paper (you can find it in the November 2002 issue), I discussed what prompted me to write a script to track long running programs that were consuming CPU in an Oracle Application environment. In this paper we will look at what happens when a session process becomes a runaway in a Data warehouse environment and wrecks your parallel queries. Click Here
for the article. More Examples of Interpreting Wait
Events to Boost System Performance In early 2002 Roger Schrag published a paper entitled, "Interpreting Wait Events to Boost System Performance." That paper began with a definition of wait events and techniques for collecting wait event information, and then went on to discuss four examples of how wait event data had been used to solve real-life performance problems. The impetus for writing that paper had been that, while many resources were available that listed the wait event v$ views, we were not aware of any publication that actually explained how to use the wait event interface to solve problems or boost system performance. As we write this paper in early 2003, we still are not aware of any such publications. Now Roger Schrag has teamed up with fellow Oracle DBA Terry Sutton to document more examples of how Oracle's wait event interface can be used to solve real-world problems. In essence, this paper is a sequel to last year's paper. If you haven't read the first one, you may view it at http://www.dbspecialists.com/presentations.html. You can read the two papers in either order. In part one of this paper, we will define what wait events are. If you have read the previous paper or are already familiar with the wait event interface, we still encourage you to read this section as we've added some enhancements and new details regarding Oracle 9i. Click Here for the article. |
|||||||||||||
|
|||||||||||||
|
"DB2 for z/OS Version 8 -
What's New?" DB2 for z/OS Version 8 was released into the Early Support Program (ESP) January 31, 2003 and will likely be released to the general market soon. Version 8 includes a number of enhancements including increased SQL flexibility, enhanced compatibility with other DB2 products, increased scalability and performance, and a number of new features to improve availability and reliability. This IBM RedBook provides an overview of the enhancements that DB2 z/OS users can expect to see with Version 8. Click
Here for the paper. |
|||||||||||||
|
|||||||||||||
|
Dynamic Method Dispatch and Method
Overloading in a Subtype Oracle 9i has support for inheritance, method overriding and "dynamic method dispatch" (or "dynamic binding", or "virtual"). When we have inheritance and overriding, a process of selecting a method implementation is called "dynamic method dispatch" because it is done at run time, not at compile time. A method call is dispatched to the nearest implementation, working back up the inheritance hierarchy from the current or specified type. When child (type) overrides parent's method, dynamic method dispatch in PL/SQL works as expected. This simple example shows that after polymorphic assignment, child method is executed. Click Here for the procedure.
|
|||||||||||||
|
|||||||||||||
|
Who Needs Change
Management? Have you ever found yourself in this situation - something gets changed and you don’t know about it until there’s a problem. Or someone makes a change and says “Don’t worry it’s a small change. No one will even notice.” I think we have all found ourselves in these situations. The only way to fix things like this is to bolt down your servers and make the users sign their life away if they want to use your server. Not too likely, but it’ll work if you could get it implemented. I think we need to look for a solution in the middle of the road. Something that works for you as a DBA and something that works for the rest of the world. Click
Here for more on Change Management. |
|||||||||||||
|
|||||||||||||
There are some companies that have built reputations for being able to consistently manage projects effectively. Having good project management skills does not mean you have no problems. It does not mean that risks go away. It does not mean that there are no surprises. The value of good project management is that you have standard processes in place to deal with all contingencies. Click Here
for tips and techniques on the Value of Project Management. |
|||||||||||||
|
|||||||||||||
Free Webcasts
|
|||||||||||||
|
|||||||||||||
|
|||||||||||||
|
|||||||||||||
|
Interactive Crossword
Puzzle: "National Parks"
|
|||||||||||||
|
|||||||||||||
|
We love getting white papers, tips, articles, and code examples/archives from our readers around the world. Send your submission to newsletter@quest-pipelines.com. If your article is published, it will be mailed to over 28,000 subscribers. Our mission at Quest Software - RevealNet Labs is to anticipate the daily responsibilities and challenges faced by database professionals. Our products help thousands of people solve problems and implement solutions every day. This newsletter is designed to help facilitate the sharing of information among database professionals. About the Newsletter This newsletter is distributed to Quest Software - RevealNet Labs customers, prospects and friends who have subscribed to it from our website. If you would like to unsubscribe, please send a note to unsubscribe@quest-pipelines.com and we will make every effort to remove you from our list. Subscribe a Friend! Do you know someone who would like to receive the Pipeline Newsletter? If so, please enter their email address in the box below and click SUBMIT.
Past Issues of the Pipeline Newsletter |
|||||||||||||
