SEARCHDATABASE.COM | Database Administrator Tips July 10, 2002 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= FROM OUR SPONSOR:
***Get your free trial!*** http://searchDatabase.com/r/0,,4391,00.htm?BMC =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= IN THIS ISSUE | Table of Contents 1. DATABASE ADMINISTRATOR TIPS - SQL Server: Fast way to add a comment header - Oracle: An aggregate product function - Oracle: Archive log switch history - Oracle: Compile all invalid objects - More recent tips from members 2. IMPORTANT ANNOUNCEMENTS AND LINKS - Ask the Experts: You tough database questions answered - Featured Topic: Summertime database hits - DB2 tips wanted! ___________________________________________________________________ *********************** Sponsored by: BMC ************************* Want to look good and improve the performance of your database at the same time? With failure-point identification, proactive prevention of space management problems, and sophisticated analysis of your complete database environment, Space Expert for DB2 UDB from BMC Software has the features necessary for you to achieve peak database performance... and to make you look good. Click here now for a FREE trial of Space Expert for DB2 UDB. http://searchDatabase.com/r/0,,4391,00.htm?BMC ******************************************************************* ___________________________________________________________________ THIS WEEK'S TIPS: FAST WAY TO ADD A COMMENT HEADER | Michael Garstin For a rapid way to add a comment header to your SQL Server code from Query Analyzer, add a "comments.tql" file to the Query Analyzer Templates sub-directory. Here's how. >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci837813,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= AN AGGREGATE PRODUCT FUNCTION | Kanan Mamedli Here is a quick Oracle SQL select query demonstrating how to multiply aggregate values. >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci835735,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= ARCHIVE LOG SWITCH HISTORY | Jeremy Birkett Here is a script to track archive log switching by the day and by the hour. Since most of the work on our databases take place between the 1st and 7th of the month, the script is limited by that. It shows you the number of switches by the hour and by the day. It's very informative when deciding on log sizes and the number of logs. >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci835739,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= COMPILE ALL INVALID OBJECTS | Keshav Prasad In Oracle databases, if you change or alter the structure of objects such as tables, the status of dependent objects such as procedures, packages, functions, views, and triggers becomes invalid. So in order to compile all the invalid dependent objects at once, you can run this SQL script. >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci835731,00.html ___________________________________________________________________ MORE RECENT TIPS FROM SEARCHDATABASE MEMBERS: =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= CHECKING THE SYSTEM DRIVE SPACE THRESHOLD | Satish Gopi http://www.searchDatabase.com/tip/1,289483,sid13_gci834312,00.html Here is how to check the system drive space threshold in SQL Server. As the tip details, you first create a stored procedure called System_DriveSpace then execute it as a job with specified paramters. FINDING PATHS IN A MS PROJECT FILE USING PL/SQL | Eli Leiba http://www.searchDatabase.com/tip/1,289483,sid13_gci820924,00.html Microsoft Project 98 saves a network of defined activities, called a project, in an MPP file. You can save the whole project into an Oracle database and all 38 tables supporting the project definition will be created. Here's how. REMOVING DUPLICATE TUPLES | Ravi Gulati http://www.searchDatabase.com/tip/1,289483,sid13_gci832441,00.html The author presents a table that contains duplicate tuples, which is undesirable. This quick tip removes such duplicate tuples from the relation uing the DELETE command in Oracle SQL*PLUS. SCRIPT TO RECOMMEND VALUES FOR THE SIZE CLAUSE OF THE TWO MAIN DATA DICTIONARY CLUSTERS | Shailesh Yagnik http://www.searchDatabase.com/tip/1,289483,sid13_gci832443,00.html This large Oracle script recommends values for the SIZE clause of the two main data dictionary clusters. Unless this value is customized, there is a significant risk of cluster block chaining in these clusters. TWO WAYS TO DETERMINE THE SIZE OF THE DATABASE | Mohsin Jamil Qureshi http://www.searchDatabase.com/tip/1,289483,sid13_gci823238,00.html Two quick ways to determine the size of your Oracle database. 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 GARMIN ETREX GPS: http://searchdatabase.techtarget.com/tipsPrize/0,289492,sid13_prz836949_cts836948,00.html ___________________________________________________________________ IMPORTANT MESSAGES AND LINKS: =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= ASK THE EXPERT | This week's tough database questions answered DB2: What to look for when monitoring performance http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid479547_tax285651,00.html Oracle: Selecting from the results of a stored procedure in 8.1.7 http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid479567_tax285650,00.html Database/Relational fundamentals: Can data normalization be automated? http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid479534_tax292527,00.html SQL Server: Using a string list as a parameter in a stored procedure http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid479537_tax285648,00.html SQL: Select most recent with a condition http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid479570_tax285649,00.html More expert answers here: http://searchdatabase.techtarget.com/ateExperts/0,289622,sid13,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= SUMMERTIME DATABASE HITS | SearchDatabase Featured Topic Although it's the height of summer here in the northern hemisphere, data management still takes precedence over margaritas. We analyzed our stats and came up with a list of your favorite tips and advice so far this summer. Enjoy! >> CLICK for our current Featured Topic... http://searchdatabase.techtarget.com/featuredTopic/0,290042,sid13_gci836947,00.html >> CLICK for previous Featured Topics... http://searchdatabase.techtarget.com/featuredTopics/0,290043,sid13,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= DB2 TIPS NEEDED | SearchDatabase Tip of the Month Contest Attention DB2 DBAs and developers! Share your knowledge, help your peers -- submit a time-saving DB2 tech tip or script. The highest-rated tip in June will win a set of GARMIN ETREX GLOBAL POSITIONING SYSTEM, worth $115! >> CLICK for more info... http://searchdatabase.techtarget.com/tipsPrize/0,289492,sid13_prz836949_cts836948,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."