=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= SEARCHDATABASE.COM | Database Administrator Tips March 20, 2002
Essential tools and advice for the enterprise DBA: http://searchDatabase.techtarget.com/tips/ =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= IN THIS ISSUE | Table of Contents 1. DATABASE ADMINISTRATOR TIPS - Oracle: Dynamic strings in Java - SQL Server: Creating standby databases - SQL Server: Statistics and query performance - Oracle: Generate a bar graph for tablespace utilization - More recent tips from members 2. IMPORTANT ANNOUNCEMENTS AND LINKS - Ask the Expert: Your SQL questions answered - Online Event Archive: Bill Inmon on the sorry state of metadata - Featured Topic: The database top ten ___________________________________________________________________ ******* STORAGE MAGAZINE EDITORIAL HIGHLIGHTS: March issue ******** Here's a preview of our March topics: ** Strategies to manage the explosion of customer data ** Why storage professionals are hot ** How to make NAS work with Microsoft Exchange ** A guide to secure SANS ** How September 11 changed disaster recovery FREE 42-page storage networking special report with your FREE subscription. Subscribe today at: http://ad.doubleclick.net/clk;3802184;5058249;k?http://www.storagemagazine.com ___________________________________________________________________ ___________________________________________________________________ THIS WEEK'S TIPS: =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= ORACLE JAVA APPLICATION PERFORMANCE, PART 1: CREATING DYNAMIC STRINGS | by John Carnell, et al. Since String objects are immutable, the creators of Java included the StringBuffer class in the core Java API. The StringBuffer class is a class that acts as a buffer for the creation and manipulation of dynamic strings. Learn how to properly use the StringBuffer class and how it will dramatically improve the performance of your Oracle Java apps. >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci811232,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= CREATING STANDBY DATABASES IN SQL SERVER | by Krishnan Ramakrishnan It is a common practice to create a replica database for server testing but this can also be done for backup purposes. Using DTS with the option to transfer all objects can be very time-consuming. Generating insert scripts would require a special utility so that the dependencies are managed. The easier way is to do the steps in this tip. >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci809859,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= MANUALLY UPDATING STATISTICS TO IMPROVE QUERY PERFORMANCE by Jyoti Bhatia Do you have a large number of rows being added to or deleted from a table? Do your users report that their initial queries are very slow but then response time improves for subsequent queries? If so, here's a quick way to handle this situation. >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci809880,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= GENERATE A BAR GRAPH FOR TABLESPACE UTILIZATION | by Shishir Dani Almost all DBAs need to continually check the status of various tablespaces in the Oracle database. Here is a SQL script that will generate a bar graph showing the status of tablespaces in the database. >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci809865,00.html __________________________________________________________________ MORE RECENT TIPS FROM SEARCHDATABASE MEMBERS: =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= AN ALTERNATIVE TO SQL INSERT STATEMENTS | Peter Robson http://www.searchDatabase.com/tip/1,289483,sid13_gci803717,00.html Here is a simple suite of (hidden) Oracle SQL scripts that enable the user to insert the odd few rows into any table in the users schema without the labor of having to construct the usual SQL insert statement. The script automatically constructs the full syntax for a SQL insert statement for the table name provided by the user, by repeated reference to the Oracle data dictinary. APPLICATION INVENTORY SCRIPT | by Dixie Hill http://www.searchDatabase.com/tip/1,289483,sid13_gci804488,00.html This Oracle script will dynamically get the number of rows, objects and their definitions, and descriptions of schema objects. Good to review after a database refresh. The script is run in a Windows/NT environment from SQL*Plus. DYNAMIC SQL IN PL/SQL | by Prashant Gijare http://www.searchDatabase.com/tip/1,289483,sid13_gci809890,00.html Here's an example PL/SQL script showing you how to use dynamic SQL. 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 CENDYNE CD-RW DRIVE http://searchdatabase.techtarget.com/tipsPrize/0,289492,sid13_prz805991_cts805990,00.html ___________________________________________________________________ IMPORTANT MESSAGES AND LINKS: =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= ASK THE EXPERT | This week's tough database questions answered SQL: Displaying time ranges based on login, logout http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid456510_tax289340,00.html SQL: Showing results as a percentage http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid456507_tax289340,00.html SQL: Populating one name column from three http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid456512_tax285649,00.html SQL: Finding and deleting duplicate records in a table http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid456326_tax289340,00.html SQL: Selecting fractions of a penny http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid456529_tax285649,00.html Hundreds more expert answers here: http://searchdatabase.techtarget.com/ateExperts/0,289622,sid13,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= LIVE EXPERT Q&A ARCHIVE | Metadata: No longer a second-class citizen Did you miss Bill Inmon's excellent presentation last week? Fear not, you can listen to the archived version any time. The father of the data warehouse discusses how the world of metadata has arrived in such a sorry state and why your organization must develop a metadata strategy to succeed. >> CLICK: http://searchdatabase.techtarget.com/onlineEventsTranscriptSecurity/1,289693,sid13_gci803032,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= THE DATABASE TOP TEN | SearchDatabase Featured Topic We analyzed traffic stats, ratings, and feedback and came up with a list of your favorite SearchDatabase content so far this year. Here you'll find the best of the best tech tips, news analysis, and Ask the Expert advice. >> CLICK for our current Featured Topic... http://searchdatabase.techtarget.com/featuredTopic/0,290042,sid13_gci810618,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. ED PARRY, 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. If you no longer wish to receive this newsletter simply reply to this message with "REMOVE" in the subject line. Or, visit http://searchDatabase.techtarget.com/register and adjust your subscriptions accordingly. If you choose to unsubscribe using our automated processing, you must send the "REMOVE" request from the email account to which this newsletter was delivered. Please allow 24 hours for your "REMOVE" request to be processed.
