SEARCHDATABASE.COM | Database Administrator Tips July 16, 2003 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= FROM OUR SPONSOR:
Attention Oracle DBAs - Free Data Dictionary http://searchDatabase.com/r/0,,16157,00.htm?questsoftware =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= IN THIS ISSUE | Table of Contents 1. DATABASE ADMINISTRATOR TIPS - SQL Server: Generating a database population routine - Oracle: Check all active processes and the SQL hit ratio - DB2: Creating serial number columns - More recent tips from members 2. IMPORTANT ANNOUNCEMENTS AND LINKS - Ask the experts: Your database questions answered - Featured Topic: Database design - Introducing SearchOracle.com ___________________________________________________________________ ***************** Sponsored by Quest Software ********************* Is your Oracle database running at full speed? Can you identify bottlenecks and code that needs tuning? Start down the path to Oracle database healthtoday with a free, online Oracle data dictionary compliments of Quest Software. Download your free data dictionary now: http://searchDatabase.com/r/0,,16157,00.htm?questsoftware ******************************************************************* ___________________________________________________________________ THIS WEEK'S TIPS: =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= GENERATING A DATABASE POPULATION ROUTINE | Baya Pavliashvili Here is a SQL Server script that will populate your data model with data and stress test it prior to making it available to users. >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci913717,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= CHECK ALL ACTIVE PROCESSES, THE LATEST SQL, AND THE SQL HIT RATIO This quick script from member Rajesh George is useful for Oracle DBAs in the process of tuning and identifying slow SQL. It will provide information about the currently active sessions, the latest SQL, as well as the hit ratio. >> CLICK for the full tip... http://www.searchOracle.com/tip/1,289483,sid41_gci913363,00.html >> NOTE: All Oracle-related tech tips have moved! Click here: http://www.SearchOracle.com/ =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= CREATING SERIAL NUMBER COLUMNS | Barrie Sosinsky Auto-incrementing columns are important when you need serial numbers or key fields for joins. In DB2 for versions 7 and later you can add the IDENTITY clause to the CREATE TABLE statement to create such a column. Here's how. >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci914811,00.html ___________________________________________________________________ MORE RECENT TIPS FROM SEARCHDATABASE MEMBERS: SPLIT DELIMITER-SEPARATED LISTS | Andrew Novick http://www.searchDatabase.com/tip/1,289483,sid13_gci911718,00.html Creating and parsing lists of items in a string is a frequent request. Here's a SQL Server UDF that shows you how to do it. TOP 20 DB2 PERFORMANCE MYTHS | Richard A. Yevich & Susan Lawson http://www.searchDatabase.com/tip/1,289483,sid13_gci910646,00.html Think you know DB2 performance tuning? Think again! Yevich and Lawson debunk some commonly-held beliefs about DB2 performance. FIND OUT ABOUT TEMP/SORT AREA USAGE | Rajesh George http://www.searchOracle.com/tip/1,289483,sid41_gci913360,00.html This Oracle script will give you an idea about the existing usage of the TEMP/SORT area. If you are frequently getting outputs for the SQL in this tip, you have a shortage of sort area in memory or you need to fine tune application SQL. BUILD A SERVLET-BASED APP THAT EXECUTES SQL AGAINST A DATABASE http://searchoracle.techtarget.com/tip/1,289483,sid41_gci913448,00.htm This tutorial by Joel Murach will show you how to use a Java servlet, JSP, and a static Java class to interactively execute any standard SQL statement against any database, including Oracle. BACKUP AND RECOVERY UNDER WINDOWS NT | Rajendra Gutta http://searchoracle.techtarget.com/tip/1,289483,sid41_gci912782,00.html The third installment of Rajendra Gutta's series of hot and cold backup and recovery script for Oracle, this time for the Windows NT platform. Includes scripts, checklists, and troubleshooting. ORACLE BACKUP AND RECOVERY SCRIPTS, PART II: HOT BACKUP UNDER UNIX http://searchoracle.techtarget.com/tip/1,289483,sid41_gci911798,00.html Rajendra Gutta continues his series of quality backup and recovery script for Oracle on Unix. Includes scripts, checklists, and troubleshooting. 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 LINKS: =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= YOUR TOUGH DATABASE QUESTIONS ANSWERED | Ask the Expert DB2: Query runs on Windows, not on mainframe http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid537046_tax285651,00.html DB2: Selecting and displaying columns in subselect query http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid537043_tax285651,00.html Oracle: Problems loading data with SQL*Loader http://www.searchOracle.com/ateQuestionNResponse/0,289625,sid41_cid540954_tax294550,00.html Oracle: Resolving the ORA-04031 error http://www.searchOracle.com/ateQuestionNResponse/0,289625,sid41_cid540947_tax294550,00.html Oracle: Resolving the ORA-06508 error http://www.searchOracle.com/ateQuestionNResponse/0,289625,sid41_cid540946_tax294550,00.html Oracle: Splitting duties between system and application DBAs http://www.searchOracle.com/ateQuestionNResponse/0,289625,sid41_cid540951_tax294550,00.html More database expert answers here: http://searchdatabase.techtarget.com/ateExperts/0,289622,sid13,00.html More Oracle database answers here: http://searchoracle.techtarget.com/ateExperts/0,289622,sid41,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= DATABASE DESIGN | SearchDatabase.com Featured Topic Taking the time to design stable, fast and secure databases is critical for avoiding future administration headaches. Our tips and expert advice inside will surely help... >> CLICK for our current Featured Topic... http://searchdatabase.techtarget.com/featuredTopic/0,290042,sid13_gci811735,00.html >> CLICK for previous Featured Topics... http://searchdatabase.techtarget.com/featuredTopics/0,290043,sid13,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= INTRODUCING SEARCHORACLE.COM We're happy to introduce the newest independent voice for the Oracle user, SearchOracle.com! Check out our huge selection of tech tips, expert advice, webcasts, links from around the web, white papers, and much more: http://www.SearchOracle.com =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= ___________________________________________________________________ *********************SEARCHDATABASE CONTACTS*********************** TIM DICHIARA, Senior Site Editor (mailto:[EMAIL PROTECTED]) ROBYN LORUSSO, Site Editor (mailto:[EMAIL PROTECTED]) SARA CUSHMAN, Assistant Editor (mailto:[EMAIL PROTECTED]) ELLEN O'BRIEN, News Editor (mailto:[EMAIL PROTECTED]) ROB WESTERVELT, News Writer (mailto:[EMAIL PROTECTED]) TOM CLICK, Sales (mailto:[EMAIL PROTECTED]) CLARK MORLEY, Sales (mailto:[EMAIL PROTECTED]) ___________________________________________________________________ **********************ABOUT THIS NEWSLETTER************************ Created by TechTarget (http://www.techtarget.com) TechTarget - The Most Targeted IT Media Copyright 2003, All Rights Reserved. ___________________________________________________________________ ::::::::::::::::::::: ABOUT THIS NEWSLETTER :::::::::::::::::::::: This newsletter is published by TechTarget, the most targeted IT media. http://www.techtarget.com Copyright 2003 TechTarget. 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."