SEARCHDATABASE.COM | Database Administrator Tips February 5, 2003 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= FROM OUR SPONSOR:
FREE WHITE PAPER: Oracle data access from .NET http://searchDatabase.com/r/0,,9924,00.htm?compuware =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= IN THIS ISSUE | Table of Contents 1. DATABASE ADMINISTRATOR TIPS - DB2: Find out what dynamic SQL is running - SQL Server: Automate documentation tasks - Oracle: Determining the hit ratio of Oracle databases - More recent tips from members 2. IMPORTANT ANNOUNCEMENTS AND LINKS - Ask the experts: Your database questions answered - Featured Topic: Web services: What? Why? How? ___________________________________________________________________ ***************** Sponsored by Compuware ********************** FREE WHITE PAPER: Oracle data access from .NET. LEARN how you can analyze and debug PL/SQL completely within the Visual Studio environment to save time in development. Get expert advice on accessing and manipulating database objects, without switching back and forth between two separate environments. Now that's a technique you'll want to learn. Read on. REGISTER FOR FREE WHITE PAPER DOWNLOAD HERE: http://searchDatabase.com/r/0,,9924,00.htm?compuware ******************************************************************* ___________________________________________________________________ THIS WEEK'S TIPS: FIND OUT WHAT DYNAMIC SQL IS RUNNING | David Quigley Have you wondered what SQL is being executed against your database as well as its frequency? Here's a quick command that will retrieve that info for you. >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci870147,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= AUTOMATE DOCUMENTATION TASKS | Garet Griffin Documentation is sorely lacking in many commercial development projects today. By automating some of the documentation tasks for your databases, you are doing yourself a big favor. Here are several simple documentation routines that can be stored in SQL Server's MODEL database and therefore propagated to all new databases. >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci878331,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= DETERMINING THE HIT RATIO OF ORACLE DATABASES | Peter Choi The hit ratio determines if Oracle is performing more physical reads to retrieve the data. A general rule of thumb for OLTP systems is that if the hit ratio falls below 70%-80%, the DBA should investigate the cause. Here's a quick script that will calculate the hit ratio. >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci878332,00.html ___________________________________________________________________ MORE RECENT TIPS FROM SEARCHDATABASE MEMBERS: DB2'S DATE DATA TYPE | Peter Gulutzan and Trudy Pelzer http://www.searchDatabase.com/tip/1,289483,sid13_gci876846,00.html This article describes how IBM implements the DATE data type for DB2 and discusses what calendar is used, what the JULIAN_DAY function really does, why date arithmetic is random, how to calculate birthdays, and how to find month ends using DB2. DETERMINE THE NUMBER OF ROWS IN A TABLE | Andrew Novick http://www.searchDatabase.com/tip/1,289483,sid13_gci876060,00.html If you don't require an exact answer, it isn't necessary use a SELECT count(*) query on the rows in a table to get the row count. SQL Server keeps the row count in sysindexes and it can be retrieved there. Here's how. UPDATED: HOT BACKUP AND RECOVERY WITH PERL | Frank Pantaleo http://www.searchDatabase.com/tip/1,289483,sid13_gci857677,00.html This extensive script is useful for Oracle DBAs who want to use Perl for doing hot backups. Now updated with bug fixes, code cleanup and add more verbose messages. 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 Experts Oracle: Storing video clips http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid514884_tax289342,00.html Object-oriented DBs: How does data mining work in ODBMSs? http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid513952_tax288550,00.html SQL Server: Equivalent of Oracle's DESC function http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid513982_tax285648,00.html DB2: Tool for SAP DB2 backups http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid514620_tax285651,00.html Oracle: Inserting the '&' symbol in a string http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid513988_tax285650,00.html More expert answers here: http://searchdatabase.techtarget.com/ateExperts/0,289622,sid13,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= WEB SERVICES: WHAT? WHY? HOW? | SearchDatabase.com Featured Topic Will 2003 be the year that Web services are translated from hype to reality? Wait -- what are Web services anyway and why do I need them? Fear not, we have the XML, .NET, & J2EE tips, tutorials, and analysis you need below... >> CLICK for our current Featured Topic... http://searchdatabase.techtarget.com/featuredTopic/0,290042,sid13_gci798776,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 ::::::::::::::::::::: Published by TechTarget (http://www.techtarget.com) TechTarget - The Most Targeted IT Media Copyright 2003, 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."