SEARCHDATABASE.COM | Database Administrator Tips July 3, 2002 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= FROM OUR SPONSOR:
July Training Special: Oracle PL/SQL Series http://learn.serebra.com?s=33&I=7118&m=dbocl2701nl&p=c =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= IN THIS ISSUE | Table of Contents 1. DATABASE ADMINISTRATOR TIPS - SQL Server: Checking system drive space threshold - Oracle: Finding paths in a MS Project file using PL/SQL - Oracle: Removing duplicate tuples - Oracle: Determining database size - More recent tips from members 2. IMPORTANT ANNOUNCEMENTS AND LINKS - Ask the Experts: You tough database questions answered - Featured Topic: Data warehousing - DB2 tips wanted! ___________________________________________________________________ ********** July Training Special: Oracle PL/SQL Series ************ Get six CD-ROM training courses to develop your understanding of Oracle PL/SQL. This series is only $99 during July -- buy it now! Series includes: Intro to RDBMS and SQL *Plus; Functions, Tables, and Groups; Adv SQL, SQL *Plus & Data Dictionary; DML and DDL Statements; Database Objects and Security and Oracle PL/SQL Basic Operations. http://learn.serebra.com?s=33&I=7118&m=dbocl2701nl&p=c ********************************************************************* ___________________________________________________________________ THIS WEEK'S TIPS: =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= CHECKING THE SYSTEM DRIVE SPACE THRESHOLD | Satish Gopi 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. >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci834312,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= FINDING PATHS IN A MS PROJECT FILE USING PL/SQL | Eli Leiba 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. >> CLICK for the online version of this tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci820924,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= REMOVING DUPLICATE TUPLES | Ravi Gulati 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. >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci832441,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= SCRIPT TO RECOMMEND VALUES FOR THE SIZE CLAUSE OF THE TWO MAIN DATA DICTIONARY CLUSTERS | Shailesh Yagnik 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. >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci832443,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= TWO WAYS TO DETERMINE THE SIZE OF THE DATABASE | Mohsin Jamil Qureshi Two quick ways to determine the size of your Oracle database. >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci823238,00.html __________________________________________________________________ MORE RECENT TIPS FROM SEARCHDATABASE MEMBERS: =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= IN-LINE FUNCTIONS IN SQL SERVER 2000 | Mark Oldfield http://www.searchDatabase.com/tip/1,289483,sid13_gci834313,00.html Functions are one of the most under-appreciated new features of SQL Server 2000. It is definitely worthwhile creating a "tool-kit" of commonly used functions to use in each new project. This tip includes a couple of scalar functions that can save lots of unnecessary temp table creating and cursor usage. AVOIDING THE MOUSE IN ENTERPRISE MANAGER | Rac Coons http://www.searchDatabase.com/tip/1,289483,sid13_gci834311,00.html Quick tip: When you want to run a query in SQL Server Query Analyzer, you can press the "F5" key, but there is no equivalent in Enterprise Manager. However, you can press the Windows Popup Menu button and then press the "R" button to pop up the context menu and select "Run" (as well as the other functions offered). MONITORING DAILY ARCHIVE LOG SWITCHES | Guillaume Henon http://www.searchDatabase.com/tip/1,289483,sid13_gci824587,00.html Putting an Oracle database in archive log mode has a drawback: disk space usage. Moreover, the redolog switch is a costly action that causes additional disk and CPU overhead. The following script gives you in one shot the daily number of redolog switchse, archive log disk space needed, and average number of log switches per hour. HIDE A USER PASSWORD | "Database Person" http://www.searchDatabase.com/tip/1,289483,sid13_gci834317,00.html Many times when running jobs through cron (on Unix boxes) it is required that you hide the password of the Oracle user from showing up when the ps command is run at the operating system level. There are various methods to do this, but here is the foolproof method. TIP FOR INSTALLING ORACLE 8I ON SOLARIS | Mohsin Jamil Qureshi http://www.searchDatabase.com/tip/1,289483,sid13_gci834314,00.html Oracle 8i for Solaris is on two CDs, but the first CD does not eject unless you close the installer. Here is a quick work-around. 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 SQL: Oracle and Sybase outer joins http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid477411_tax285649,00.html Oracle: Script to check if row exists, then update specific field http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid477417_tax289341,00.html Oracle: Creating a user with all privileges http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid478302_tax285650,00.html SQL Server: Date format in SQL Server http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid478321_tax285648,00.html SQL Server: Differences between SQL server 7 and 2000 http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid478294_tax292506,00.html More expert answers here: http://searchdatabase.techtarget.com/ateExperts/0,289622,sid13,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= DATA WAREHOUSING | SearchDatabase Featured Topic Bill Inmon coined the term "data warehousing" almost 15 years ago and it remains popular, propelled by BI and CRM. Newbies and gurus alike will benefit from our DW tutorials, news, analysis, webcasts, and expert advice inside... >> CLICK for our current Featured Topic... http://searchdatabase.techtarget.com/featuredTopic/0,290042,sid13_gci836153,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."
