SEARCHDATABASE.COM | Database Administrator Tips September 4, 2002 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= FROM OUR SPONSOR:
Free Oracle Database Health Check http://searchDatabase.com/r/0,,5379,00.htm?databasehealthcheck =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= IN THIS ISSUE | Table of Contents 1. DATABASE ADMINISTRATOR TIPS - Oracle: Stupid check for proper instance - Oracle: Unix script to gather tablespace information - SQL Server: Find out when a stored procedure was last altered - DB2: Determine when a tablespace was last copied - More recent tips from members 2. IMPORTANT ANNOUNCEMENTS AND LINKS - Ask the Experts: Your tough database questions answered - Featured Topic: XML: Hit or hype? - True DBA Bloopers: Submit your horrifying tale to win! ___________________________________________________________________ ****************** Sponsored by Quest Software ******************** Are your end-users feverish about database response time? Increase performance and availability with a FREE health check from the database-tuning gurus at Quest Software! With Quest's renowned real-time and historical diagnostics - plus Quest's industry-leading resolution tools - Quest's FREE health check is good for what ails your Oracle database. Click here to register! http://searchDatabase.com/r/0,,5379,00.htm?databasehealthcheck ******************************************************************* ___________________________________________________________________ THIS WEEK'S TIPS: STUPID CHECK FOR PROPER INSTANCE | Patrick Sand When you are bouncing between instances as an Oracle DBA, what is a quick way to determine what instance you are in? Here is a quick and dirty trick to check the instance name. >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci845215,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= UNIX SCRIPT TO GATHER TABLESPACE INFORMATION | Robert Hanrahan This script is used to gather Oracle tablespace information, including space, used_space and fragmentation. >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci831500,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= FIND OUT WHEN A STORED PROCEDURE WAS LAST ALTERED | P. Mandayam Find when a SQL Server stored procedure or function was last altered with this short script. >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci836901,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= DETERMINE WHEN A TABLESPACE WAS LAST COPIED | Manuel Angel Mendez Here is how to determine which DB2 tablespaces have not been copied on the current day and how many days have transpired since the last Full Image Copy. The tip is very useful to determine when a tablespace has been loaded or reorged, but not copied. >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci840525,00.html ___________________________________________________________________ MORE RECENT TIPS FROM SEARCHDATABASE MEMBERS: =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= CRAIG MULLINS ANSWERS YOUR DATABASE ADMINISTRATION QUESTIONS http://www.searchDatabase.com/tip/1,289483,sid13_gci846889,00.html On August 16, data management expert and author Craig Mullins gave an excellent Webcast on SearchDatabase titled Database Administration 101. Here are answers to audience questions that Craig didn't have time to address. LOGIN WITHOUT KNOWING PASSWORD | Srini Madhamshetty http://www.searchDatabase.com/tip/1,289483,sid13_gci845037,00.html Here's how to log into a user's account to make a change without knowing password of that user. For Oracle DBAs only! LAST DDL TIME BY TABLESPACE | Database Person http://www.searchDatabase.com/tip/1,289483,sid13_gci820930,00.html There are times when one may need to know when the last DDL was performed on a particular Oracle tablespace. Here's how to find out. STORED PROCEDURE TO EXPORT/IMPORT IMAGES TO SQL SERVER | Eli Leiba http://www.searchDatabase.com/tip/1,289483,sid13_gci835742,00.html This stored procedure serves as an interface to the TextCopy utility that exports and imports images and documnets to SQL Server. GET RID OF DELETED RECORDS AND IMPROVE PERFORMANCE -- TAKE 2 http://www.searchDatabase.com/tip/1,289483,sid13_gci847122,00.html Here is a follow-up, with important clarifications and additions, to John Kohan's recent tip about how to remove deleted files to increase the performance of DB2 on AS/400. 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: =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= 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 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= ASK THE EXPERT | This week's tough database questions answered Oracle: What privileges are granted by a role? http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid488096_tax289342,00.html SQL Server: Getting definitions of stored procedures and triggers by querying system table http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid487556_tax285648,00.html Oracle: Doing a keyword search within contents of memo field http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid487549_tax285650,00.html DB2: DB2 personal edition http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid487066_tax285651,00.html Oracle: Getting information about execution times http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid488076_tax289342,00.html More expert answers here: http://searchdatabase.techtarget.com/ateExperts/0,289622,sid13,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= XML: HIT OR HYPE? | SearchDatabase Featured Topic XML began as a simple markup language for defining and sharing documents containing structured data. Then came query features and database integration. The resources inside will help you understand and use XML with your DBMS... >> CLICK for our current Featured Topic... http://searchdatabase.techtarget.com/featuredTopic/0,290042,sid13_gci847616,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************************ 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."