|
July, 2007
In
This Issue
|
|
All articles have been reprinted with the written consent of their respective authors. | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
Advanced Workload Repository In Oracle Database 10g Oracle replaced statspack with the Advanced Workload Repository (AWR). The job of AWR is to collect database statistics (by default every hour) and this data is maintained for a week and then purged. You can then run reports against these statistics to performance tune your database. Other Oracle features such as ADDM and the database advisors use the database statistics to monitor and analyze the database looking for performance problems. When you create an Oracle database, AWR is automatically installed and enabled. Statistics collection is automated, and the statistics collected by AWR are stored in the database. In order to properly collect database statistics, the parameter STATISTICS_LEVEL should be set to TYPICAL (the default) or ALL. If STATISTICS_LEVEL is set to BASIC then the AWR will be disabled. The Oracle database uses AWR for problem detection and analysis as well as for self-tuning. A number of different statistics are collected by the AWR including wait events, time model statistics, active session history statistics, various system and session level statistics, object usage statistics and information on the most resource intensive SQL statements. Other Oracle Database 10g features use the AWR, including ADDM and the other advisors in Oracle Database 10g. Click here to see the rest of the topic.
|
|
Breaking DB2 Platform Barriers The popularity of DB2 UDB running on distributed platforms continues to grow. The sudden growth and popularity of DB2 on distributed platforms has resulted in a shortage of experienced non-mainframe DB2 DBAs. IT departments today have to deal with tightening budgets and shrinking staffs. The luxury of being a single platform DBA is becoming a thing of the past. Many DB2 mainframe DBAs find themselves supporting DB2 on these distributed platforms, resulting in a huge learning curve. It is essential for the DB2 DBA of the new millennium to be well versed on running DB2 on multiple platforms. This paper is geared toward any DB2 DBA responsible for having to support DB2 on multiple platforms, whether you’re an OS/390 DBA with little or no knowledge of UNIX/NT or a UNIX DBA with little or no knowledge of OS/390. It will cover some of the basic terminology for the different platforms and how they differ, as well as the key architectural differences and administrative issues.
Click here
for the paper.
|
The Humble IF Statement |
by John Russell If I have one piece of wisdom to impart, it's this: pay attention to your IF statements! Seems like the hardest part of knowing a dozen languages is keeping track of the different syntaxes for simple IF statements. (I took a tour of an Internet startup pre-dotcom crash, and saw my PL/SQL User's Guide open on a desk -- not to BULK COLLECT or the exception model, but to the page for the IF statement.) Click here for the article.
|
|
Monitoring File Sizes in SQL Server - Part 2 Last time we were able to read the file size of our mdf/ldf files. This time we need to watch the size of a folder be it the MS SQL data folder or a DTS import folder. Real example - we have main frame files imported from a remote location to a folder - the files are processed into the database - and are deleted from the import folder after being moved into a date coded folder on the same server. The reason for the date coding and storage is that new reports get created and the database will not be able to process them until the report parameters are defined. We can then reprocess the files and all is well. Shiver me timbers, these files can get very large. 20,000 page reports are not uncommon. We also might need to re-process older reports with different parameter settings to extract different data This third-party application is tied to an MS SQL database on the same server. We have to watch the size of this folder offloading the older folders to storage media. Click here to see the article.
In A Nutshell
Interested in learning more tips and techniques for SQL Server? "In A Nutshell"
is what you are looking for. Kevin Kline,
author of O'Reilly's "SQL in a Nutshell" and "Transact-SQL Programming" and President of The Professional Association for SQL Server,
offers tips, techniques and much more. Updated numerous times a week,
there is always valuable material to be had!
Click
here
to see what Kevin is up to in the SQL Server world.
|
| How to Find Slow MySQL Queries In terms of storage, both tables and indexes are stored within the user datafiles that are automatically created by the Falcon engine when the first Falcon table is created in a database. Falcon supports standard heap tables along with all datatypes available within MySQL. Tables can house up to four billion rows in the alpha release (this limit will be removed in the GA version). To support the auto-increment feature of tables, Falcon implements a subset of the standard SQL sequence feature. A sequence is a mechanism for generating unique ascending values that are not transactional. When a sequence is incremented, it remains incremented even if the action that causes the increment fails or the transaction rolls back. Falcon generates new sequences for concurrent inserts without requiring them to wait for each other. For users of Oracle and DB2, please note: Falcon sequences are not separate objects that can be addressed and manipulated as sequences in those RDBMS’s. Click here to see this article.
|
|
Morale problems don’t happen overnight, and they cannot be resolved overnight. Typically, the complete causes and remedies are out of your control. However, as the project manager, there are some things that are within your control. Regardless of how much you can do, if the group sees you trying to help, they will feel better as well. You need some feedback from the group to determine the cause of the morale problems. Once you understand the cause, there are usually multiple ways to help. Here are some examples. Click here for more information on improving team morale.
|
| Webcasts
Introducing Toad Project Watson
Toad Project Watson is currently in Beta and seeking additional testers. To join the beta program, go to the link below: http://www.toadworld.com/DevTeam/ProjectWatson/tabid/147/Default.aspx Get a Toad t-shirt for reporting a verifiable bug and a 4GB Apple iPod® Nano for reporting the most bugs during the beta program!
|
|
|
|
Interactive Crossword
Puzzle: "Famous Slogans"
|
|
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/
Do you know someone who would like to receive the Pipeline Newsletter? If so, click here!
Past Issues of the Pipeline Newsletter | |||||||||||||||||||||||||||||||||||||||||||||||||||||
Toad Project Watson empowers effective decision making by giving you insight into your business
data, enabling IT professionals to access and understand their data from any source with one tool.
It has the ability to define relationships; gather and understand where the data resides; and query,
export, publish and automate the reports for the business community.
Refer a Friend!
