SEARCHDATABASE.COM | Database Administrator Tips May 28, 2002 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= FROM OUR SPONSOR:
Master today's most popular database and put yourself in demand! http://searchDatabase.com/r/0,,3586,00.htm?OracleProfLibrary =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= IN THIS ISSUE | Table of Contents 1. DATABASE ADMINISTRATOR TIPS - SQL Server: Sending email using CDONTS - Oracle: Optimal size of rollback segments - Oracle: Tuning the database cache hit ratio - More recent tips from members 2. IMPORTANT ANNOUNCEMENTS AND LINKS - Ask the Expert: Your toughest database questions answered - Featured Topic: Beyond the big three ___________________________________________________________________ ************** Sponsored by: Computer Books Direct **************** Master today's most popular database and put yourself in demand! The Oracle 9i Professional Library - a 3-volume, 1-CD-ROM set - a $169.97 value - can be yours for $9.99, with membership in Computer Books Direct! This insider's library will give you the most up-to-date security tips for your Oracle database as well as the latest information on the newest Oracle 9i tools! Click for details! http://searchDatabase.com/r/0,,3586,00.htm?OracleProfLibrary ___________________________________________________________________ ___________________________________________________________________ THIS WEEK'S TIPS: =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= SENDING MAIL USING CDONTS | Ashish Singal This SQL Server stored procedure can be used to send email through CDONTS. >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci826453,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= OPTIMAL SIZE OF ROLLBACK SEGMENTS | Marcelo Castanho Here is a simple Oracle script that displays the optimal size of rollback segments created in the database. >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci821261,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= TUNING THE DATABASE CACHE HIT RATIO | Gatot Rubianto When do you need to tune the Oracle cache hit ratio? Here is a quick list, plus a script that will measure it for you. >> CLICK for the online version of the tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci820946,00.html __________________________________________________________________ MORE RECENT TIPS FROM SEARCHDATABASE MEMBERS: =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= HOW TO MODIFY THE SNAPSHOT STRUCTURE WITHOUT DROPPING THE TABLE http://www.searchDatabase.com/tip/1,289483,sid13_gci824585,00.html This Oracle script by Riadh Amari modifies the structure of a snapshot for Oracle replication without dropping and recreating the snapshot. RETURNING A RESULT SET IN RANDOM ORDER | Baya Pavliashvili http://www.searchDatabase.com/tip/1,289483,sid13_gci823966,00.html At times, you might need to return the SQL Server data to the client in a random order. Unfortunately SQL Server doesn't provide built-in functionality for random sorting of the result set. The good news is that a bit of coding can help you get around this limitation. Here's how. FIND OUT WHICH DB2 VERSION YOU ARE USING ON MVS | David Davis http://www.searchDatabase.com/tip/1,289483,sid13_gci824586,00.html To determine the version of DB2 on MVS you can use this command... IDENTIFY AN OBJECT'S LOCKS IN THE DATABASE | Ofer Harel http://www.searchDatabase.com/tip/1,289483,sid13_gci824588,00.html Here are three simple Oracle scripts to identify an object's locks 1) for the database 2) for a specific session, and 3) for all sessions. MANAGE ARCHIVE REDO LOG FILES | Robert Dow http://www.searchDatabase.com/tip/1,289483,sid13_gci821259,00.html Here is a simple Oracle script that the author uses on AIX to manage archive redo log files. This will create a empty tar file, and loop through the available arch log files appending to the tar. Once complete, the tar is compressed. Hundreds more free tech tips submitted by members: http://searchdatabase.techtarget.com/tips/0,289484,sid13_tax281808,00.html Share your knowledge, submit a tip, win a SAMSUNG DVD/MP3 PLAYER: http://searchdatabase.techtarget.com/tipsPrize/0,289492,sid13_prz820755_cts820752,00.html ___________________________________________________________________ IMPORTANT MESSAGES AND LINKS: =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= ASK THE EXPERT | This week's tough database questions answered DB2: Altering VARCHAR columns http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid469272_tax285651,00.html DB2: Can a before insert trigger be used to prevent insertion? http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid469275_tax285651,00.html DB2: Plan versus package http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid469279_tax285651,00.html DB2: Function to return a comma-separated text string http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid470108_tax285651,00.html DB2: POSSTR function: use column name for second argument? (revised) http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid469278_tax285651,00.html More Oracle, DB2, and SQL Server expert answers here: http://searchdatabase.techtarget.com/ateExperts/0,289622,sid13,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= BEYOND THE BIG THREE | SearchDatabase Featured Topic There is life beyond the big three DBMS vendors! Sybase, MySQL, and others have found significant niches in enterprise IT. Our collection of news, tips, and expert advice has all the info you need about the "best of the rest." >> CLICK for our current Featured Topic... http://searchdatabase.techtarget.com/featuredTopic/0,290042,sid13_gci825686,00.html >> CLICK for previous Featured Topics... http://searchdatabase.techtarget.com/featuredTopics/0,290043,sid13,00.html ___________________________________________________________________ *********************SEARCHDATABASE CONTACTS*********************** TIP MAILBOX, (mailto:[EMAIL PROTECTED]) >> Submit your original tip here. TIM DICHIARA, Site Editor (mailto:[EMAIL PROTECTED]) >> Send your feedback and original articles. SARA CUSHMAN, Assistant Editor (mailto:[EMAIL PROTECTED]) >> Send your White Papers and favorite Web sites. ELLEN O'BRIEN, News Editor (mailto:[EMAIL PROTECTED]) >> Send your product announcements and poll ideas. TOM CLICK, Sales (mailto:[EMAIL PROTECTED]) >> Sponsor this or any other TechTarget newsletter. ___________________________________________________________________ **********************ABOUT THIS NEWSLETTER************************ Created by TechTarget (http://www.techtarget.com) TechTarget - The Most Targeted IT Media Copyright 2002, All Rights Reserved. To unsubscribe from 'DBA Tips,' simply reply to this e-mail with REMOVE (all caps) within the Body or Subject or go to http://searchDatabase.techtarget.com/register, log in to edit your profile, click on the link to Edit email subscriptions, and uncheck the box next to the newsletter you wish to unsubscribe from. When finished, click "Save Changes to My Profile."
