|
October, 2003
In
This Issue
|
|
All articles have been reprinted with the written consent of their respective authors. | |||||||||||||
|
|||||||||||||
|
End Backup Script IF a hot backup script fails for some reason, the tablespaces will still be in hot backup mode until an ALTER TABLESACE END BACKUP command is issued. This script generates and runs an END BACKUP script based upon those database which are currently flagged as ACTIVE in the v$backup table. Click here
for the script. |
|||||||||||||
|
|||||||||||||
|
Helper Tables Helper tables remind me of Calculus
class. Remember Calculus (I applaud anyone who truly understood this stuff cause
I just didn't get it). But I do remember one thing vividly that I did get and
that I use all the time these days (even though it applied to a different venue). I
remember those Calculus problems that were either very difficult to solve or not
solvable at all. Then I remember the idea of transformation where in, the
professor did something seemingly useless that in turn changed the whole problem
into something way simple. For example, he would add 0 or divide by 1 (maybe
both), neither operation of which could possibly change the answer (hey the
identity matrix). But he would do it in two steps in order to introduce two canceling but very real and opposing
values to different parts of an equation. In the end he was just adding
"non-relevant" information to the process. But doing so let him play with the
pieces of the puzzle in order to solve his problem. Click here
for the article. |
|||||||||||||
|
|||||||||||||
|
Just the Stats, Ma'am Statistics reports can reveal surprising facts about the subsystem you thought you knew well. I wrote a column last year about the wealth of performance and tuning information available in DB2 monitor accounting reports. I promised to similarly cover statistics reports, which are chock full of performance information presented from a different perspective, in a future piece. As it turns out, I've got more to say about statistics reports than will fit in one article, so I'm delivering on my promise with two pieces. Tune in to November's newsletter for part two. Click
here for the article. |
|||||||||||||
|
|||||||||||||
|
Managing Exceptional Behavior,
Part 1 Many programmers don't take the time to properly bulletproof their programs. Most of us find it hard enough—and more than enough work—to simply write the code that implements the positive aspects of an application: maintaining customers, generating invoices, and so on. You write applications that often assume the best of all possible worlds, hoping that your programs are bug-free, that users will enter only the correct data in only the correct fashion, and that all systems (hardware and software) will always be a "go." No matter how hard you try, there will always be one more bug in your application. This article, the first of two parts, will explore a set of best practices you should follow to incorporate high-quality, comprehensive error handling in your PL/SQL-based applications. This article will start by considering some overall best practices for error handling and then focus on best practices relating to raising exceptions. The next article will move on to how best to handle exceptions. Click Here for the article. Announcing a new, three-day seminar by Steven Feuerstein on the PL/SQL language this Fall: Visit http://www.minmaxplsql.com for all the details... MIN-MAX PL/SQL ... on October 7-9 or November 11-13 or December 9-11, you can learn how to:
MIN-MAX PL/SQL is a best practices and optimization seminar unlike any you have attended before. Steven has carefully chosen from Oracle's many new PL/SQL features and his numerous recommended best practices to create a course that will radically change (for the better!) the way you design and implement PL/SQL-based applications. You can get lots more information (including a download for your manager that explains the instant ROI on this seminar) and register for MIN-MAX PL/SQL by visiting the Blast Off PL/SQL site: www.minmaxplsql.com. Seating is limited, so visit www.minmaxplsql.com and register right away! PS - Special discounts of 20% are available for customers of Quest Software and companies that register 3 or more students (across all the dates)!
|
|||||||||||||
|
|||||||||||||
|
Anti-Blocker Strategies No reasonable strategy for the resolution of concrete blocking problems can be
found until one has determined the precise nature of the scale block. The most
obvious criterion for distinguishing between different scale blocks is their
average duration. Four categories emerge as a result of this division. These four different types of scale blocks are discussed in terms of their
possible causes and in reference to appropriate strategies for resolving them. Click
here for the article. |
|||||||||||||
|
|||||||||||||
A project manager needs to update the project workplan on a regular basis. For a medium project, this is probably a weekly process. For larger projects the frequency might be every two weeks. You don’t want to wait any longer than two weeks to update your workplan. There is too much work taking place and if there are problems, too much time may pass before they are surfaced. Click here
for tips and techniques on how to Manage Your Project Workplan. |
|||||||||||||
|
|||||||||||||
Free Webcasts
|
|||||||||||||
|
|||||||||||||
|
|||||||||||||
|
|||||||||||||
|
Interactive Crossword
Puzzle: "Things that Go Bump in the Night"
|
|||||||||||||
|
|||||||||||||
|
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 visit http://qlist01.quest.com/UnsubMailingList/ 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 |
|||||||||||||
