| ||
|
The Monthly Newsletter of the RevealNet Pipeline
Communities |
www.revealnet.com | October 2001 |
All articles have been reprinted with the written consent of their respective authors.
Tablespace Map Script
By Brian Peasland, Pipeline SYSOP
This script shows a "map" of database block allocations for a tablespace. This script can be used to examine free space fragmentation among other issues. Click Here for the Script.
Brian Peasland, our newest Pipeline SYSOP, 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.
Win a Free Cap! Donate useful code to the Pipeline Library, and we will mail you a "stylin" canvas/embroidered RevealNet baseball cap if your utility is published in the newsletter. Just submit your code archive to cwhite@revealnet.com.
Linux Maximus: Gladiator-Like Oracle
Performance, Part 1
By Bert Scalzo, Ph.D., Quest
Software
Like many people today, the Linux movement enthralls me. Not just because I'm more of a UNIX based DBA, but because of the amazing speed at which major vendors such as HP, Compaq, Dell, IBM and Oracle have embraced this open source operating system. But no matter how fashionable Linux may be, that popularity does not automatically translate into nor guarantee performance. Believe it or not, it's quite easy to get upwards of 1000% database improvement through proper Linux tuning and database configuration for Linux. In this issue, we'll review some very high ROI approaches.
Click Here for part 1 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.
Real-Life Recovery: Perspective, Preparation,
Performance
By: Daniel W. Fink, 7S Consulting
In light of the tragic events of September 11, many organizations have been forced to review or re-think their Disaster Recovery plans and procedures. We thought we would re-print an article we featured in the August 2000 issue of the Pipeline Newsletter.
Most sites focus on backups and other issues before addressing recovery. Single points of failure are shortcuts to disaster, both business and career. The only measure of a successful backup plan is how completely recovery can be performed. The time to practice a recovery is not when a production system is down and the Order Entry clerks are waiting. Personnel can be the single greatest weakness in recovering a database, but they can also be the greatest strength. Click Here for the paper.
 | Get
the "Oracle DBA Checklists" Pocket reference FREE! Here's
how:
|
This concise pocket reference, authored by RevealNet and published by O'Reilly & Associates (76 pages) contains a series of easy-to-use checklists providing helpful reminders of the procedures Oracle DBAs must follow when performing common database administration tasks. In this book, you will find checklists for database management, installation and configuration and network management responsibilities.
Point-In-Time Recovery for DB2 on OS/390
Sample Topic from the RevealNet
Knowledge Base for DB2
Point-In-Time (PIT) recovery can be to an image copy or a point of consistency. The point of consistency can be established by the QUIESCE utility by recording the RBA or log record sequence number (LRSN) in a sysplex data sharing environment in the START_RBA column of SYSCOPY. The older term RBA is often used rather than LRSN and is used in this section. Keep in mind that is actually the LRSN in a sysplex data sharing environment. The RECOVER utility parameter TOLOGPOINT should be used rather than TORBA. It has the same effect in a data sharing and non-data sharing environment. It is required in a data sharing environment and should be used in a non-data sharing environment if there is any possibility of using data sharing in the future. This avoids having to change TORBA to TOLOGPOINT if it is decided to use data sharing. The goal of recovery to an RBA is to eliminate updates made after the PIT recovery. Click Here for the article.
UTL_SMTP: E-Mail from PL/SQL
By Darryl Hurley, RevealNet Pipeline
SYSOP, Mobile Data Solutions, Inc.
Sending electronic mail from PL/SQL is a long awaited feature that finally arrived with version 8.1 of the database. Finally the outside world can be notified directly of events within the database using standard PL/SQL packages. Things like notifying users of important data changes or notifying the DBA of impending lack of storage space can now be performed within PL/SQL.
Granted that sending mail from the database has been available for quite some time using methods like creating text files of mail commands for CRON jobs to process later or similar interfaces but now it can be done directly from PL/SQL! Click Here for the paper.
Quest
Software Presents:"Oracle
PL/SQL Best Practices"
A one-day seminar by Steven Feuerstein
November 7, 2001 8:30 AM - 5:00 PM Quest Software - Chicago
Quest Software presents a special seminar, offered only once in the US this year. Join PL/SQL Expert and renowned author, Steven Feuerstein for tips and techniques that will improve the performance and maintainability of your PL/SQL programs. While there are a number of tools that help you tune the SQL side of your application, PL/SQL tuning has been largely ignored. This seminar will show you how to take advantage of high-performance PL/SQL features such as bulk array processing in dynamic SQL and data caching in packages. You will also learn how to define your variable data structures for top efficiency. In addition, this seminar will help you build thoroughly tested, error proof code. Register Now! Click Here for Details.
Testing for Performance
Topic from the new RevealNet for SQL
Server Development Knowledge Base
In general, code development or testing should never be done on the production server. The reason for this is simple - since there is no "bug-free" code your program might adversely affect all users currently connected to the production server. However, to get an idea of how your code will perform in the production environment, you might want to test it with some realistic data. Click Here for the article.
Download the Trial/Beta Version of the Knowledge Base for SQL Server today. General Availability is scheduled for Monday, December 3.
FORTUNE.com on Quest Software: "Antidote to the Downturn"
"Quest is a great antidote to the economic downturn. If you buy their products, it will save you money on your technology budget." This month, FORTUNE.com features Quest Software as an ideal company for these uncertain economic times. Click Here for the article.
Quest Software E-Seminar Series
Join Oracle PL/SQL expert and renowned author Steven Feuerstein for a series of PL/SQL Best Practices e-Seminars from the convenience of your desktop. Register Today!
PL/SQL Best
Practices: The Top Ten Dumbest PL/SQL Things I Have Ever Done
October 18, 2001, 11:00 a.m. PT:
This presentation focuses on what developers can learn by examining the
mistakes made by others. Covering both traditional "gotchas" in
the world of programming and development challenges specific to PL/SQL, Oracle
PL/SQL expert and renowned author Steven Feuerstein extracts best practices and
lessons which can save you many hours of agonizing debugging and recoding.
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 Executive Hero in Flight 93 Crash
"Are you guys ready? Let's roll."
Todd Beamer, an Oracle Inc. executive from Highstown, N.J., and others are being credited with foiling hijackers bent on crashing the Boeing 757 into what authorities say might have been a second target in Washington, D.C., possibly the Capitol or the White House. Click Here for the article.
 |
Oracle DBA Tip of the Month: | Verifying Database Memory Allocation |
|
PL/SQL Tip of the Month: | Bulk Collecting Multiple Rows |
|
DB2 Tip of the Month: | New Uses for UNION in DB2 V7 |
|
SQL Server Tip of the Month: | How to Reset the SA Password for SQL Server |
More Real Life "Dilbert-isms"
"Assumptions identify things that we are
considering and not taking into consideration!"
This month, we received Real Life "Dilbert-isms" from John Geisler
and Pipeline SYSOP Dan Clamage. Click Here
for more real life Dilbert-isms. Do you have a
Dilbert-ism you would like to share? Email it to cwhite@revealnet.com.
We will publish them in future issues of the Pipeline Newsletter.
"Rollback Segments"
- Oracle
DBA Pipeline
Conference: FAQ Area
How do you stop rollback segments from occasionally going offline? Pipelines SYSOPs Mike Ault, Brian Peasland and regular members of the Pipeline community discuss options for working with rollback segments. 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 23,000 readers.
RevealNet Labs Contact Info
Quest Software - RevealNet Labs
P.O. Box 5560
Rockville, MD 20855
Tel: 800-738-3254 Toll-Free US
Tel: 301-947-7744 International
Fax: 301-947-9610
Email: info@revealnet.com
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
|
|
|