|
September, 2003
In
This Issue
|
|
All articles have been reprinted with the written consent of their respective authors. | |||||||||||||
|
|||||||||||||
|
Script to Query on Current
Transactions and Table Locks This script will query on current transactions and all table locks. The script is split into two parts: (1) A summary of all table locks and (2) the transactions (along with I/O stats) that are happening. Click Here
for the script. |
|||||||||||||
|
|||||||||||||
|
Microstate Response-time Performance Profiling,
Part 1 Getting optimum performance for mission-critical Oracle systems is an extremely complex task. For senior Oracle DBAs, measuring internal services waits within an Oracle database is a critical aspect of advanced response-time profiling. The accuracy of measurements is an important factor in all types of research. However, there are no 100-percent accurate measurements in Nature; there are always some distortions in the measurements. How can a method be accepted as an accurate method? The answer depends on the impact of measurement errors. The goal of this article is to adapt microstate accounting, which is a more accurate measurement technique provided by OS (operating system) vendors, to database management systems (DBMSs). Part 1 of the article outlines the current measurement techniques available and the errors that can occur with them. Part 2 will discuss how to correct these errors and introduces the theoretical approach of Microstate Response-time Performance Profiling. Click Here
for the article. Linux Maximus Part 3: Modern
Tablespace Paradigms This article, the third in a series, looks at adopting modern tablespace paradigms as yet another simple way to achieve optimal performance for Oracle on Linux. For although Oracle DBA's are good at optimizing their databases using time proven tuning tools and techniques, sometimes a very simple and quite effective answer lies just beneath the surface. Sometimes simply by embracing the newer tablespace management paradigms of more recent Oracle versions, DBA's can obtain 10-20% improvements in data loading throughput, index creations and sustainable transactions per second for little or no cost. Click Here
for the article. |
|||||||||||||
|
|||||||||||||
|
Plugging in to Faster Data Access As it matures with each release, DB2 provides faster distributed data access. Changes in version 8 take it to a whole new level. DB2 Universal Database's (UDB) evolution over the past few releases has made data access faster and more reliable through technology changes. Chief among these are a common data flow transmission protocol (new in DB2 UDB version 8.1 for Linux, Unix, and Windows), connection and transaction pooling, and enhanced sysplex exploitation. I'll explain each of these advances and show you how you can put them to use. Click
Here for the paper. |
|||||||||||||
|
|||||||||||||
|
ORACLE 9i MERGE Statement -
Decomposing SQL%ROWCOUNT The MERGE statement (AKA "UPSERT") released in Oracle 9i is possibly one of the most useful ETL-enabling technologies built into the Oracle kernel. For those who have missed Oracle's headlines for the last year and a half and are unaware of what the MERGE statement does, it simply enables us to either UPDATE or INSERT a row into a target table in one statement. You simply tell Oracle your rules for determining whether a target row should be UPDATEd or INSERTed from the source, and Oracle does the rest. Click Here for the paper. 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)!
|
|||||||||||||
|
|||||||||||||
|
Architecting
Replication with Identity Columns Time and again, I see posts to mailing lists or newsgroups stating that identity columns do not work with replication. Identity columns do in fact work with replication. There is simply some pre-planning that must occur along with setting an option that you normally don't use. This article contains the best practices that I've developed over the years to get replicated systems to work together with identity columns. Click
Here for the article. |
|||||||||||||
|
|||||||||||||
Typically, the more accurate the estimate, the more detail is needed, and perhaps the more time that is needed. If you are asked for a rough order of magnitude (ROM) estimate, you might be able to complete the work quickly, at a high-level, and with a minimum amount of detail. On the other hand, if you must provide an accurate estimate within 10%, you might need to spend quite a bit more time and understand the work at a low level of detail. Click Here
for tips and techniques on how to estimate effort. |
|||||||||||||
|
|||||||||||||
Free Webcasts
|
|||||||||||||
|
|||||||||||||
|
|||||||||||||
|
|||||||||||||
|
Interactive Crossword
Puzzle: "Famous Landmarks"
|
|||||||||||||
|
|||||||||||||
|
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 |
|||||||||||||
