| ||
|
The Monthly Newsletter of the RevealNet Pipeline
Communities |
www.revealnet.com | November 2001 |
All articles have been reprinted with the written consent of their respective authors.
Oracle_SID "Switch" Script
By Gert de Boer
Real programmers are lazy, and typing in anything longer than two characters twice should be avoided. The same holds for DBAs.
So, I wrote a script to switch database instance on UNIX (works on bash and HP's Posix shell). I made a small adaptation for Oracle 8.1.7 on HP: the oratab entries did not end with ':Y' but with ':Y:'. I located it in /usr/local/bin. Click Here for the script.
Gert de Boer, a Pipeliner from Switzerland, posted this script to the "Script Exchange" conference on the DBA Pipeline. To access the "Script Exchange", just log on to "Pipe Talk" and click on the "Script Exchange" conference.
Linux Maximus: The RAW Facts on File Systems
By Bert Scalzo, Ph.D., Quest
Software
Welcome to the second white paper on maximizing the performance of Linux systems. The goal of these papers is to offer some relatively simple yet highly effective tuning ideas. Moreover, all such suggestions must adhere to the "KISS" ideal. All the tuning techniques must be both easily implemented and easily measured. Our ideal technique must fit the model of: perform a baseline benchmark, implement the proposed change, perform a comparative benchmark, followed by a big smile.
Click Here for part 2 of a series of papers aimed at maximizing performance on Linux systems. Statistical analysis and testing was performed with the aid of Quest's Benchmark Factory, a superior facility for database load testing and capacity planning.
Efficiency of Outer Joins
By: Dave Wotton
This paper discusses the usage of outer joins, the conditions under which they can be used and the efficiency implications of outer joins. This paper also points out performance issues associated with outer joins and views, as well as other potential problems. Click Here for the paper.
Java Security Issues
Sample Topic from the RevealNet
Knowledge Base for DB2
Java applications, applets and servlets exploit DB2 in the usual manner. Use of Java-based applications, regardless if the Java code executes as an application, applet or servlet, requires that a user ID or authorization ID be passed to DB2. This DB2 rule applies to Java code and execution environments as it would with any other DB2 application. Click Here for the topic.
Data Modeling: Common Mistakes and their
Impact
By Bert Scalzo, Ph.D., Quest
Software
Dew knot trussed yore spell chequer two fined awl yore mistakes.” – Brendan Hills
Although data modeling has been around for nearly 25 years, it ranks among the top areas from whence database application problems arise. Moreover, the severity of the problems ranges from totally incorrect functionality to freakishly miserable performance. How can such an established technique yield such terrible results? The answer is quite unnerving.
Click Here for part 1 of a series of papers that identify effective data modeling technics. Graphics and DDL examples are generated with the aid of QDesignerä, a superior data modeling tool available from Quest. Special competitive upgrade promotions are now available for QDesigner.
Sending Email from Within Your Oracle Database
By Bob Mycroft
Last month, we featured a popular article on UTL_SMTP, written by Darryl Hurley. This month, Bob Mycroft has submitted a paper that serves as a nice follow-up with excellent examples.
This article should be of interest to both the developer and the DBA. To try and shed some light on why this might be, I have thought of a couple of examples where the ability for the database itself to send emails would add value to an application or system.
Firstly, imagine a simple stock control system. With email functionality available from within the rdbms, you could code triggers that would email the supplier when stock of a particular item fell below a threshold level. This would be ideal for a 'just-in-time' warehouse system where the levels of stock must be tightly controlled. Click Here for the paper.
Error Checking with Transactions
Topic from the new RevealNet for SQL
Server Development Knowledge Base
Transactions follow the ALL or NOTHING rule; therefore, you need to make sure no errors are encountered during transaction execution. Error checking is accomplished by examining the value of the global variable @@error. If this variable has a value of anything other than zero, that means trouble. So, making sure that your transactions are atomic is fairly simple. Click Here for the topic.
Download the Trial/Beta Version of the Knowledge Base for SQL Server today. General Availability is scheduled for Monday, December 3.
|
Visit
Quest Software at Oracle OpenWorld 2001 December 3-5, San Francisco Booths 810 & 520 |  |
Visit the "Quest Beach House" (booth 520) and mingle with Quest experts including Steven Feuerstein, Dan Hotka, and others. Take a look at Knowledge Xpert, the future of RevealNet Knowledge Bases. Get your books signed. Meet fellow Pipeliners. The Quest Beach House is all about having fun and meeting with industry experts and colleagues.
At Booth 810, catch Quest's latest solutions for Oracle Development, Deployment, Administration, and Business Continuity. Grab yourself a bottle of water compliments of Quest Software. See you there!
Quest Software E-Seminar Series
PL/SQL
Best Practices: Making Reusable Code a Reality in PL/SQL
November 8, 2001, 11:00 a.m. PT:
What are the challenges to reusing code
in PL/SQL based applications? How do you go about building and deploying a
reusable library? When should you encapsulate and modularize, when you
should put your logic "in line"? Come explore these challenging
questions and more with Oracle PL/SQL expert and renowned author Steven
Feuerstein.
PL/SQL Best Practices:
No Room for Error -- Exception Handling in PL/SQL
December 13, 2001 11:00 a.m. PT:
Exception handling in PL/SQL can be difficult to understand and tricky to
implement consistently across one's application. This e-Seminar proposes a
set of standards and best practices for error handling and explores how you can
build an infrastructure package to implement those standards. Presented by
Oracle PL/SQL expert and renowned author Steven Feuerstein.
 |
Oracle DBA Tip of the Month: | Quick Script to Drop a Tablespace |
|
PL/SQL Tip of the Month: | Truncating a Table from a Remote Database |
|
DB2 Tip of the Month: | Deciding When to Index Columns |
|
SQL Server Tip of the Month: | Dropping a Corrupt SQL Server Table |
Symptoms of Age Activated Attention Deficit Disorder - AAADD
"More people have it than you think!"
Click Here for this month's humor. We
also received two more "Real Life Dilbert-isms". Click Here
for the Dilbert-isms. Send us your Dilbertisms to campbell.white@quest.com
for publication in a future issue of the Pipeline Newsletter.
"Sending Email When Oracle Errors Occur" (2 Scripts Included)
- Oracle
DBA Pipeline
Conference: Error Messages
Pipeliners discuss the steps to take to set up an Oracle server so that it will generate an email any time that an Oracle error message is generated or send an email if certain specified Oracle error messages are generated. Click Here for this month's discussion.
RevealNet Lab's Pipeline Communities are rich in technical discussions. Each month, we highlight particular discussions of interest. Log on to "Pipe Talk" and share your ideas with your colleagues around the world.
Win
a FREE CAP!
We love getting white papers, tips, articles, and code examples/archives from our readers around the world. Send your submission to cwhite@revealnet.com. If your article is published, we will mail you a "stylin'" canvas/embroidered RevealNet baseball cap as a gesture or our appreciation.
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. It is currently circulated to 24,000 readers.
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 info@revealnet.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
|
|
|