|
March, 2003
In
This Issue
|
|
All articles have been reprinted with the written consent of their respective authors. | |||||||||||||
|
|||||||||||||
|
Creating a Hot Backup Script This PL/SQL code can be used to create the hot backup script for any windows database. This query asks for inputs for certain OS/Database related parameters. Click Here for the script. utPLSQL utPLSQL is a unit testing framework for programmers using Oracle's PL/SQL language. Developed by Steven Feuerstein, author of many books on the subject, it allows the automated testing of packages, functions and procedures. Click Here for more information. For background on the project and the reasons why this sort of unit testing is a good idea, visit the
utPLSQL site of the O'Reilly and Associates Oracle Resource Center. |
|||||||||||||
|
|||||||||||||
|
The Art & Science of Oracle
Performance Tuning (sample
chapters) Solving or planning for performance issues is a core part of the database professional's toolkit. The Oracle database is very flexible, making it suitable for a wide range of applications but presenting a bewildering set of tuning choices to the inexperienced. Tuning Oracle is as much about approach as understanding the technology. It is more than tweaking parameters, or following a set prescription - it involves matching application-specific knowledge with what's happening inside the database. Based on the author's long experience working with Oracle, the book uses a five-step model to help identify, isolate, and fix the causes of non-performance. This book shows you how to approach problems, get the information you need from Oracle, and follow the process through to success. Click Here
for chapter 1. |
|||||||||||||
|
|||||||||||||
|
Examining the Architectural
Differences of DB2 on OS/390 vs. UNIX/NT This presentation outlines some of the differences between DB2 on OS/390 vs. UNIX/NT. The areas covered in this presentation include basic concepts, terminology differences, storage management, object comparisons and administrative differences. Click
Here for the presentation. |
|||||||||||||
|
|||||||||||||
|
External Tables If all you need to do is read from a flat file, consider using external files instead of UTL_FILE. With UTL_FILE, you have to control file I/O yourself (open, get_line, close), plus write code to parse out the fields you want. Instead, using a SQL*Loader-like syntax, you can let Oracle handle all of that for you. Here is a very simple example. I've left out some error handling like bad record log files, etc. I ran this with Oracle 9.2 under NT 4.0, but it should work as well under UNIX. Click Here for the procedure.
|
|||||||||||||
|
|||||||||||||
|
Interact with SQL
Server's Data and Procedure Cache As you work with SQL Server you have probably heard of the terms data cache and procedure cache and may have wondered what exactly a cache was. SQL Server is configure to use a pool of memory of the server and it will allocate the majority of this memory pool to hold both data pages that have been read and the compiled execution plans for all Transact-SQL statements. It is this dynamic pool of memory that is being referred to and the data cache and procedure cache, keep in mind that in versions of SQL Server before SQL Server 7.0 the data cache and procedure cache were two separate pools of memory and could be controlled separately, today one pool of memory is used both for data and execution plans. Click
Here for the paper. |
|||||||||||||
|
|||||||||||||
On the surface, the role of a project manager should be easy to describe. In fact, from a textbook perspective it probably is. But the challenge to understanding roles and responsibilities is that they are different from company to company. In general, the project manager is responsible for the overall success of the project. In some companies, this person might be called a Project Coordinator, or a Team Leader, however, the key aspect is that the person is responsible for ensuring the success of the project. Click Here for tips and techniques on
The Role of a Project Manager. |
|||||||||||||
|
|||||||||||||
For detailed information on these free e-Seminars, please visit our News and Events page.
|
|||||||||||||
|
|||||||||||||
|
|||||||||||||
|
|||||||||||||
|
Interactive Crossword
Puzzle: "In the 'Spirit' of St. Patrick's Day"
|
|||||||||||||
|
|||||||||||||
|
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 |
|||||||||||||
