SEARCHDATABASE.COM | Database Administrator Tips December 11, 2002 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= CHECK IT OUT:
FREE WEBCAST: Oracle expert tuning secrets http://searchDatabase.com/r/0,,8272,00.htm =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= IN THIS ISSUE | Table of Contents 1. DATABASE ADMINISTRATOR TIPS - DB2: Connect to an SQL Server from the iSeries - SQL Server: Tablespace usage view - Oracle: Control users' access to Oracle objects from SQL*Plus - More recent tips from members 2. IMPORTANT ANNOUNCEMENTS AND LINKS - Featured Topic: Rudy Limeback's SQL tips ___________________________________________________________________ ************************** CLICKWORTHY **************************** FREE WEBCAST: Oracle expert tuning secrets with author and guru Don Burleson. Oracle tuning is a phenomenal challenge for any professional. This presentation shares tuning secrets that Don has accumulated over his 20+ years as a database administrator consultant. He explores some of the most common causes of poor performance, looks at "silver bullets" and shows techniques for reducing disk I/O, tuning the SGA, and tuning SQL statements. Fun, informative and entertaining, this presentation is indispensable for anyone who must ensure that their Oracle database is optimally configured. http://searchDatabase.com/r/0,,8272,00.htm ******************************************************************* ___________________________________________________________________ THIS WEEK'S TIPS: CONNECT TO AN SQL SERVER FROM THE ISERIES | Santosh Prasad A quick tip about how to connect to a SQL Server database from DB2 on AS400/iSeries using Java Tool Box. >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci868252,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= TABLESPACE USAGE VIEW | Andrew Barringer This SQL Server view allows you to easily see the top 10% by Row Count, Space Used, etc. This is useful for answering the question "what's taking up all the space in my database?" >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci867509,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= CONTROL ACCESS TO ORACLE OBJECTS FROM SQL*PLUS | Murali Krishna The PRODUCT_USER_PROFILE table can be used to control users' access to various Oracle objects from SQL*Plus. Here is how to implement it. >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci867728,00.html ___________________________________________________________________ MORE RECENT TIPS FROM SEARCHDATABASE MEMBERS: GENERATING REORG STATEMENTS FOR ALL TABLES | Prashant Dahalkar http://www.searchDatabase.com/tip/1,289483,sid13_gci860001,00.html The author's production tables often need to be reorganized because they have been modified so many times that the data is fragmented and access performance is slow. In order to generate the reorg statements for all the tables at once -- as a batch process that will execute at night -- this command for DB2 UDB 7.1 is very useful. REMOVING DUPLICATE RECORDS FROM A TABLE THAT HAS NO PRIMARY KEY http://www.searchDatabase.com/tip/1,289483,sid13_gci862833,00.html By Prashant Dahalkar. Here is a SQL Server SELECT query that fetches only those records where the combination of two composite keys is unique. EMBEDDED SQL AND DB2 V5R1 FOR ISERIES | Sudhakar Kunji http://www.searchDatabase.com/tip/1,289483,sid13_gci838014,00.html In V5R1, a change was made to DB2 UDB for iSeries so that it returns the proper SQLCODE warning on certain types of FETCH and SELECT INTO statements. If an application wasn't coded properly to check the SQLCODE value, then it will start failing on V5R1 systems. Click below for more details... USE THE NAME OF CURRENT DATABASE IN QUERIES | Sushil Srivastava http://www.searchDatabase.com/tip/1,289483,sid13_gci858631,00.html Sometimes its quite essential to know and use the Oracle database name on which your SQL is being executed. You can do it simply by querying the GLOBAL_NAMES view in Oracle, like this: SELECT * FROM GLOBAL_NAMES. Simple! TABLESPACE MONITOR FOR AUTOEXTEND | Perry White http://www.searchDatabase.com/tip/1,289483,sid13_gci850776,00.html This Oracle code provides a way to proactively indicate how much total logical disk space is available for tablespaces using the autoextend feature of Oracle on its datafiles. SECURE IMPORT/EXPORT USER | Ed Schalk http://www.searchDatabase.com/tip/1,289483,sid13_gci841580,00.html Avoid the security problem of putting Oracle passwords in script files for privileged users. TRIMMING A STRING IN VERSIONS BEFORE 8I | Keshav Chennakeshav http://www.searchDatabase.com/tip/1,289483,sid13_gci859899,00.html To trim a string in Oracle, LTRIM and RTRIM are available. Here is a utility function that combines the two. Note: this function is a standard feature of Oracle 8i and higher so it will be of use for those who use Oracle versions less than 8i. 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: =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= RUDY LIMEBACK'S SQL TIPS | SearchDatabase.com Featured Topic Rudy is a SearchDatabase.com site expert and has been hacking away in the database field for 25 years. He *knows* his SQL! Browse his 200+ answers to tough SQL questions or submit your own. >> CLICK for our current Featured Topic... http://searchdatabase.techtarget.com/featuredTopic/0,290042,sid13_gci867561,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 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."
