| November, 2002 |
|
|||||||||||||
|
All articles have been reprinted with the written consent of their respective authors.
| |||||||||||||
|
|||||||||||||
|
Calculating the Buffer Cache Hit
Ratio for Accurate Results This month Click
Here for the script. |
|||||||||||||
|
|||||||||||||
|
Oracle9i New Features for Oracle8i
DBAs This paper offers a brief overview of the new features in the Oracle9i database of most interest to database administrators. It is written for DBAs experienced with Oracle8i who are looking for a quick-read roadmap to what has changed and what is new in Oracle9i. For each item we'll just look at a few of the highlights so that we can keep this paper short. This should be enough to whet your appetite and give you an idea of which features and areas you want to learn more about. Click Here for the paper. Offensive Runaways: Defensive DBA Oracle Application concurrent programs normally run for long hours and it becomes difficult to identify and monitor periodically which processes are actually running and which are run away processes. If a runaway process is identified as a forms executable then it is easy to check for the runaway and kill the process. Most Oracle sites will have scripts that either checks the dynamic view V$Session for forms programs or sniped processes and kills them. Some sites also check the CPU time of the shadow process and in cases where the shadow process exceeds a threshold set say 30 minutes, then it is a bad process and consumes CPU time more than it is supposed too. In this paper we would talk about how a runaway brought the database to its knees and derailed our Auto Invoice program run and what we put in place to check and identify that a process is captured periodically and monitored by both the DBA’s and the developers. Click Here for the paper.
|
|||||||||||||
|
|||||||||||||
|
Choosing to Use Dynamic SQL In several cases, a specific variation of dynamic SQL may be only one of several alternatives available. These alternatives include the use of static SQL with various BIND parameters as well as the deployment of stored procedures. This topic explores these possibilities and introduces some of the issues that must be considered before the appropriate choice is made. Click
Here for the topic. |
|||||||||||||
|
|||||||||||||
|
Alert Log Scanner The following Unix shell script was written for HP/UX to scan the alert log, checking if Oracle and the SQL*Net listener are up in an effort to be proactive regarding system errors. It's based on a script from www.dba-oracle.com but it has been enhanced to be submitted once and run every minute and end at a predefined time. It also doesn't resend the same error all day. It only sends messages since the last scan. Click Here
for the script.
|
|||||||||||||
|
|||||||||||||
|
Microsoft T-SQL
Performance Tuning - Part 3 This article is the third in a series that describes a variety of performance tuning techniques that you can apply to your Microsoft SQL Server Transact-SQL programs. In many cases, you could use the graphic user interface provided in the Microsoft tools to achieve the same or similar results to those described here. For example, the graphic showplan feature of SQL Query Analyzer will show you the query plan for a query. However, this series focuses on using Transact-SQL commands as the basis for our solutions. All examples and syntax are verified for Microsoft SQL Server 2000. These articles illustrate, through examples and explain plans, useful techniques for improving queries in Microsoft SQL Server 2000. There are a number of small tips and techniques applicable in narrow classes of programming tasks. Knowing them expands your resources in performance optimization. We have chosen to use Microsoft SHOWPLAN_ALL output in all examples in this section, because they are more compact and still show all the critical information. Click
Here for the paper. |
|||||||||||||
|
|||||||||||||
Just as the Project Manager may face scheduling difficulties, you may also find yourself trending over budget. If you monitor costs regularly, you should know very quickly if you are trending over your budget. This control process is somewhat more difficult than managing the schedule, because there could be a variety of reasons why your financial information is not as good or as accurate. With scheduling, you know right away if you missed an end date. With the budget, you may not always know. There are a number of reasons for this. Click Here for tips and techniques on
managing risk. |
|||||||||||||
|
|||||||||||||
| Free
e-Seminars For detailed information on these free e-Seminars, please visit our News and Events page.
|
|||||||||||||
|
|||||||||||||
|
|||||||||||||
|
|||||||||||||
|
Interactive Crossword
Puzzle: "Days of Celebration"
|
|||||||||||||
|
|||||||||||||
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, we will mail you a FREE gift from Quest 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 28,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 unsubscribe@quest-pipelines.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 |
|||||||||||||
