|
August, 2007
In
This Issue
|
|
All articles have been reprinted with the written consent of their respective authors. | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
Tracing Individual Users in Connection-pooled Environments with Oracle 10g Many of us have been using Oracle’s Extended SQL Trace, also known as a 10046 trace, for years. An Extended SQL Trace can provide the most detailed information about exactly what an Oracle session is doing, including which SQL statements the session is executing, how many logical and physical reads the session is performing for each of those statements, what the session is waiting on and how long it has to wait, and more. By performing a 10046 trace we learn what the individual Oracle session is encountering, as opposed to what the database as a whole is doing. So if we can trace a portion of application code which is having performance problems, we will be able to address the issues specific to that application code. This has worked well in two-tiered architectures where there is a one-to-one relation between a database session and an end-user session. Unfortunately the Extended SQL Trace facility never worked well in connection-pooled environments or architectures that use an application server to multiplex many end user sessions into a smaller number of database sessions. More and more systems use this model today, where one end-user session can bounce around between multiple database sessions, and many different end-user sessions use a given database session. Click here to read the article.
|
How to Recreate the Database Control Repository - (Oracle10g R2) This article provides steps-by-step details on how to create, drop and recreate the Database Control Repository and configuration files in a 10g R2 database. Click here to read the article.
An ODTUG Seriously Practical Conference for Oracle Developers and DBAs who rely on PL/SQL to get their jobs done.Click here to register!!
|
|
Licensing Distributed DB2 9 Data Servers in a High Availability Environment Are you trying to ensure you're licensing your IBM® DB2® Version 9 for Linux®, UNIX®, and Windows® (DB2 9) data servers correctly in a high availability environment? Don't have the time nor the will to read through the announcement letters, PLETs, or your licensing sheets? Customers choose the IBM DB2 data server because of its incredible time to value, its ability to scale and integrate across disparate environments, its robustness, and for the minimization of 'down-time' (both planned and unplanned). In this article, I focus on the high-availability aspects of DB2, not so much from a functionality point of view (of which much has been written), but from the point of view of licensing. I hear a lot of questions about licensing DB2 in a high availability (HA) environment -- configurations that are designed to address unplanned outages (and sometimes planned ones too). Usually the first level of confusion is caused by wide variations in how different vendors price their database products in high availability environments
Click here
to read the article.
|
Monitoring File Sizes in SQL Server - Part 3 | by Roy Carlson All right! So I am not a mind reader. But I do have a photographic memory. Unfortunately, I have no film. Because of this uniqueness, I need a mnemonic aid. Excel to the rescue. With the script in Part 3, we are going to read the size of the SQL instances, put the data in an Excel spreadsheet and produce a chart where the growth can be tracked over time. If you have one or two SQL Servers to monitor this article may not interest you. If your data is unchanging or not very dynamic again your interest my not be here. If you have to watch a large quantity of servers, highly dynamic this simple script may be of help. We have highly seasonal data, hitting our databases from faxes, online, employees, trading partners, mainframe input, scanners, etc. The volumes are somewhat predictable but if there is a special promotion or industry change the effects can be dramatic. Likewise database maintenance performed on a scheduled basis shows dramatic changes in the size of files. Historical monitoring showed us the need to change the cycles of maintenance or modify them entirely. 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.
|
| Views and Why We Love Them Views are like snapshots of queries. You can save any query as a view, even complex queries with joins and subqueries, and MySQL will save the results of that query in a format that can be searched (and in some cases, modified) just like a table. But unlike tables, you never have to worry about updating the data in your view; MySQL handles all of the details for you! For the purposes of an example, let's pretend you built a database for Wally's Widget Works. The good folks at Wally's decided that they needed to keep track of the different kinds of widget that they produce. To make it easier to sort the different widgets, they have decided to give each widget one or more 'tags' that describes some aspect of that widget's function or purpose. Click here to see this article.
|
|
Expected monetary value (EMV) is a risk management technique that can be used to help quantify and compare risks in many aspects of the project. EMV is a quantitative risk analysis technique since it relies on more specific numbers and quantifies to perform the calculations, rather than high-level approximations like high, medium and low. EMV relies on two basic numbers.
Click
here for more information using
the expected monetary value technique.
| 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: "Harry Potter"
|
|
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!
