| June, 2002 |
|
|||||||||||||
|
All articles have been reprinted with the written consent of their respective authors.
| ||||||||||||
|
|||||||||||||
|
PL/SQL Scan Function This PL/SQL scan function will return the nth word of a string using a delimiter of your choosing. Click
Here for the script. |
|||||||||||||
|
|||||||||||||
|
Oracle Database Block Size Rebuilds in
Oracle9i Oracle9i offers support for multiple database
block sizes in the same tablespace. DBAs can use this feature to support
rebuilding their databases to a higher database block size while the database
remains online. This article will provide a demonstration of the steps required
to increase the database block size for almost all tablespaces in an Oracle9i
environment. Topics covered include database quiescing, supporting multiple
block caches, using the Oracle-managed files feature, and online object
reorganization. Click Here for
the paper.
|
|||||||||||||
|
|||||||||||||
|
Application Performance Tuning for DB2 Today, databases are at the foundation of a business computing architecture that often includes Web servers, application servers, client workstations, application logic, networks, and other components. Since the database acts as the data server, it can quickly turn into an application bottleneck if a problem occurs. In many cases, newly developed applications pass quality assurance tests, but go on to fail in production because of scalability problems. Poorly written Structured Query Language (SQL)—the language used by the applications to retrieve and store data in a database—frequently causes this to happen. Like other databases, IBM DB2 UDB is
negatively affected by poor application SQL. Bad SQL—like bad grammar—will
still communicate the required message, but it does so much less efficiently.
Application SQL must be tuned in order to optimize performance and maximize the
return on an often-significant investment in business technology. Click Here for the paper. |
|||||||||||||
|
|||||||||||||
|
ALERT_LOG_MANAGER This PL/SQL package takes advantage of external tables in Oracle 9 to make Oracle alert logs and trace files available for display within the database itself as shown in the following demonstrations. The current version of alert_log_manager focuses on trace files. Specifically locating them in the alert log and displaying their contents.
Click
Here for the article. |
|||||||||||||
|
|||||||||||||
|
Is a Temporary Table Really
Necessary Most of the literature that advises against the
use of temporary tables correctly states that they may cause performance issues due to
the locking of the tempdb while the temporary table is being created, the
I/0 activity involved during the use of the temporary table, and the potential
locking of the tempdb if a transaction is used for the creation and the
subsequent operations against the temporary table, not to mention the numerous
problems SQL Server has with operations against temporary tables - see the list
of Knowledge Base articles below. While these issues are true, I'm going
to provide some reason to use a temporary table.
Click
Here for the article. |
|||||||||||||
|
|||||||||||||
|
Managing Scopes Scope
refers to the
way that we describe the boundaries of a project. In general, it defines what
the project will deliver and what it will not deliver. For larger projects, it
can also include the organizations affected (and not affected), the transactions
included (and not included), the data types included (and not included), the
business processes impacted (and not impacted), etc.
Click Here for this month's article. |
|||||||||||||
|
|||||||||||||
|
PASS Regional Seminars to Provide Intense, Interactive SQL Server Training With SQL Server chats, Webcasts and regional seminars just around the corner, it's going to be a busy summer for PASS! New educational opportunities are launching every month, so stay tuned to the PASS Web site, http://www.sqlpass.org, which will be updated with the latest detailed information. Next up - the PASS Regional Seminar Series with Mike Hotek and Kim Tripp kicks off June 17th in Chicago. Space is limited. Register today at http://sqlpass.org/events/seminars/. TOAD User Groups in 20 Cities -
Sign Up Today!
| |||||||||||||
|
|||||||||||||
|
|||||||||||||
|
|||||||||||||
|
Interactive Crossword Puzzle: "Spider-Man"
|
|||||||||||||
|
|||||||||||||
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 25,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
|
|||||||||||||
