|
January, 2004
In
This Issue
|
|
All articles have been reprinted with the written consent of their respective authors. | |||||||||||||
|
|||||||||||||
|
Script to Show SGA Pools This script shows the different SGA POOLS, then sums up the UGAs & PGA. The percent of the shared_pool represents the percent of the allocations / total shared pool memory. For UGA & PGA pools, the latter column tries to evaluate the UGA & PGA sizes with the largest number of sessions on. Click Here
for the script. |
|||||||||||||
|
|||||||||||||
|
Optimizing Oracle 10g on Linux using Automated Storage Management I often react to new Oracle releases like Steve Martin acted in the movie "The Jerk" when the new phone books arrive. I cannot help but to get excited about all the new technology that Oracle routinely delivers. But with the release of Oracle 10g, that enthusiasm cannot be overstated. And while this Oracle version delivers numerous nifty new features, we’ll examine just one, Automated Storage Management (ASM), which makes Linux database disk space management a snap. Click Here
for the article. 9i RAC: Manual Backup and Recovery When we plan to move a large database
or a heavily used OLTP database to a cluster setup, to get enough mileage from the
horizontal scaling of 9i RAC, we normally have lots of questions about how we are
going to handle the various database maintenance issues that are traditionally done and how we
are going to set up the same as well as what changes or tools need to be in place to handle RAC.
In this paper we are going to look at one of the important administration jobs, the
backing up of a 9i RAC. We will also look at how we can recover from a simple data
file loss or from the other extreme, a disaster recovery. Click Here
for the article. |
|||||||||||||
|
|||||||||||||
|
More than Meets the Eye: Simplifying Catalog Publishing To tame the surprisingly complex challenges catalog publishers face,
A2i added its own unique technology on top of a solid DB2 UDB base.
Building on core DB2 Universal Database (UDB) functions, IBM partner A2i developed the xCat
system, an enterprise product content management and catalog publishing system for creating
and managing catalogs containing up to millions of products. The 10-year-old company's products
are used by some of the largest distributors and manufacturers in the United States, including
GE Appliances, Digi-Key, and NIBCO.
This paper explains how the company drew on DB2 UDB and added its own technical advances to accomplish
these advanced functions.
Click
here for the article. |
|||||||||||||
|
|||||||||||||
|
Logminer in Action The body of work that follows was born out of a desire to replicate data out of production. Of course we needed to do this while minimizing the effect on production. The best way to do this was to leverage APIs that Oracle made available in 8i. Some or all of the logic provided becomes unnecessary in 9i with the introduction of Oracle streams. However, I would contend that the procedures below provide a better level of control. Click Here for the paper.
|
|||||||||||||
|
|||||||||||||
Projects of different sizes have different ways and requirements on how the people are organized. In a small project, little organizational structure is needed. There might be a primary sponsor, project manager and a project team. However, for large projects, there are more and more people involved and it is important that people understand what they are expected to do, and what role people are expected to fill. It is important to understand roles so that the project manager knows who is acting in what capacity and who should be involved in various project situations. Click here
for more information on project roles. | |||||||||||||
|
|||||||||||||
|
Free Webcasts
|
|||||||||||||
|
|||||||||||||
|
|||||||||||||
|
|||||||||||||
|
Interactive Crossword
Puzzle: "A Look Back: News & Events"
|
|||||||||||||
|
|||||||||||||
|
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 |
|||||||||||||
