SEARCHDATABASE.COM | Database Administrator Tips October 9, 2002 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= FROM OUR SPONSOR:
FREE White Paper - VERITAS Clustering for Availability http://searchDatabase.com/r/0,,6438,00.htm?veritas =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= IN THIS ISSUE | Table of Contents 1. DATABASE ADMINISTRATOR TIPS - Oracle: Query for mulitple Oracle processes and transactions - Oracle: Simple query formatter - SQL Server: Back up transaction logs - DB2: Date conversion from Sybase to DB2 - More recent tips from members 2. IMPORTANT ANNOUNCEMENTS AND LINKS - Free webcast: Tom Kyte answers your Oracle9i questions - Ask the Experts: Your tough database questions answered - Featured Topic: Spotlight on SQL Server - True DBA Bloopers: Submit your horrifying tale to win! ___________________________________________________________________ ********************** Sponsored by Veritas *********************** Does downtime negatively impact your organization? Do you want to increase uptime but face IT budgetary pressure and unprecedented data growth? Would you like clarity on the roles that clustering, high availability, and data replication should play in your environment? Click here for a FREE white paper to learn why people trust VERITAS Software for their high availability needs: http://searchDatabase.com/r/0,,6438,00.htm?veritas ******************************************************************* ___________________________________________________________________ THIS WEEK'S TIPS: QUERY FOR MULITPLE ORACLE PROCESSES AND TRANSACTIONS | Pratik Chakraborty Ever wanted a handy way to find out how long an UPDATE update statement has been running, how much rollback space it has used, etc? Or who are all the people connected to the database? And exactly what are they doing right now? Here is a query that shows all. >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci852246,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= SIMPLE QUERY FORMATTER | Andrew Wall This script is useful for ad-hoc queries with numerous select list items within SQL*Plus. It formats the output as one column_name = column_value per line. Normally, the display would show many heading lines and then some data, making it difficult to line up columns with their values. >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci846683,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= BACK UP TRANSACTION LOGS | Barrie Sosinsky A few quick tips about SQL Server's transaction log, the key to being able to recover from a variety of system and software problems. >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci849849,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= DATE CONVERSION FROM SYBASE TO DB2 | Parminder Singh The format in which Sybase stores data is often different than DB2, which becomes a problem when manually porting from one to the other. For example, Sybase and DB2 DATE formats are entirely different. If a Sybase data column is loaded into DB2, it will give an error. Use this script to overcome the problem... >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci854963,00.html ___________________________________________________________________ MORE RECENT TIPS FROM SEARCHDATABASE MEMBERS: AUTONUMBER AND IDENTITY FUNCTIONALITY IN ORACLE | Murali Krishna http://www.searchDatabase.com/tip/1,289483,sid13_gci850770,00.html Developers accustomed to AutoNumber columns in MS Access or Identity columns in SQL Server often complain when they have to manually populate primary key columns using sequences in Oracle. This type of functionality is easily implemented in Oracle using triggers. Here's how. COMPRESSING ORACLE EXPORTS ON THE FLY | Chuck Hamilton http://www.searchDatabase.com/tip/1,289483,sid13_gci852577,00.html Here is how to create compressed Oracle export files on the fly even though the export utility does not support writing to the Unix standard output stream. SQL SERVER STRING PARSER | Alena Willis This stored procedure takes a delimited string, parses it and puts it into a table. It can be used to filter sets of data with lists (strings) from any kind of application. http://www.searchDatabase.com/tip/1,289483,sid13_gci851250,00.html WATCH YOUR DB2 CONNECTIONS | Stephen Swoyer http://www.searchDatabase.com/tip/1,289483,sid13_gci838025,00.html Watch out for this problem connecting Websphere Application Server to DB2... 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 prize: http://searchdatabase.techtarget.com/tipsSubmit/1,289485,sid13,00.html ___________________________________________________________________ IMPORTANT MESSAGES AND LINKS: =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= TOM KYTE ANSWERS YOUR ORACLE9I QUESTIONS | SearchDatabase webcast Who: Tom Kyte, Author of "Expert one-on-one: Oracle" When: Oct. 23, 2002 at 01:00 PM EDT (17:00 GMT) Take advantage of this exclusive opportunity to interact with one of the premier Oracle gurus on the planet. During this webcast, Tom Kyte will answer your burning questions about Oracle 9i. Send your questions now to [EMAIL PROTECTED]! >> CLICK for more details... http://searchdatabase.techtarget.com/webcasts/0,289675,sid13,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= YOUR TOUGH DATABASE QUESTIONS ANSWERED | Ask the Experts Oracle: Passing query in stored procedure to cursor variable http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid494712_tax285650,00.html DB2: Primary key versus unique key http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid494696_tax285651,00.html SQL: Max within a subset http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid494653_tax289340,00.html Oracle: 8i versus 9i with respect to code changes in applications http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid494702_tax285650,00.html DB2: Adding months to a date using built-in functions http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid494684_tax285651,00.html More expert answers here: http://searchdatabase.techtarget.com/ateExperts/0,289622,sid13,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= SPOTLIGHT ON SQL SERVER | SearchDatabase.com Featured Topic Attention SQL Server administrators and developers! Scads of free tips, tutorials, news and advice about SQL Server performance tuning, design, stored procedures, XML integration, and much more are inside... >> CLICK for our current Featured Topic... http://www.searchDatabase.com/featuredTopic/0,290042,sid13_gci769983,00.html >> CLICK for previous Featured Topics... http://searchdatabase.techtarget.com/featuredTopics/0,290043,sid13,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= TRUE DBA BLOOPERS | Submit your horrifying tale to win Attention DBAs: SearchDatabase.com wants your bloopers! Submit your backup/recovery snafus, tuning disasters and ugly upgrades. Stories of good intentions gone bad, over-ambitious and under-trained newbies, clueless consultants, and even more clueless managers will all be accepted. The submitter of the most amusing or wince-inducing blooper of the month will receive a free copy of Craig Mullins' new book "Database administration: The complete guide to practices and procedures." Send your bloopers to [EMAIL PROTECTED] today! >> More details about Mullins' "Database Administration"... http://www.digitalguru.com/DigitalGuru/product_detail.asp?catalog_name=Books&product_id=0201741296&partner_id=77 ___________________________________________________________________ *********************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."
