SEARCHDATABASE.COM | Database Administrator Tips September 25, 2002 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= FROM OUR SPONSORS:
Late for Dinner Again? Test Smarter. FREE White Paper. http://searchDatabase.com/r/0,,6072,00.htm?princetonsoftech =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= IN THIS ISSUE | Table of Contents 1. DATABASE ADMINISTRATOR TIPS - Oracle: Annoying DESCribe in 9i SQL*Plus - Oracle: Determining transactions per second - SQL Server: Avoid blocking - More recent tips from members 2. IMPORTANT ANNOUNCEMENTS AND LINKS - Free webcast: The latest and greatest in Oracle 9i - Ask the Experts: Your tough database questions answered - Featured Topic: Database-Web integration ___________________________________________________________________ ***************** Sponsored by Princeton Softech ****************** Managing complex relational databases across multiple platforms doesn't mean you have to work late. Princeton Softech's Relational Tools help streamline data management. Move, edit and compare related data with ease and accuracy. Support development and testing activities and still make it home for dinner. Get your complimentary Testing Strategies paper at http://searchDatabase.com/r/0,,6072,00.htm?princetonsoftech ___________________________________________________________________ THIS WEEK'S TIPS: ANNOYING DESCRIBE IN 9I SQL*PLUS | Jim Cox Ever use the DESC command in a SQL*Plus session, then have to scroll right to find some of the fields? The DESCribe command uses the LINESIZE value to control the display of fields. Here is a handy way around it. >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci852236,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= DETERMINING TRANSACTIONS PER SECOND | Cory Brooks This code can approximate the number of Oracle transactions per second by looking at the number of SCN changes per second. >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci852256,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= AVOID BLOCKING | Barrie Sosinsky Blocking is a classic database problem in which a transaction locks a first record and then a second record. Here's a quick intro to the topic and a way to avoid blocking in SQL Server. >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci849846,00.html ___________________________________________________________________ MORE RECENT TIPS FROM SEARCHDATABASE MEMBERS: =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= REFERENCE INFORMATION ABOUT V$ AND MORE | Paresh Yadav http://www.searchDatabase.com/tip/1,289483,sid13_gci835733,00.html Now you don't have to look in an Oracle reference manual to find descriptions about v$ and other dictionary tables and their columns -- you can use this SQL query. QUERYING EXTERNAL TABLES | Srinivas Chittimalla http://www.searchDatabase.com/tip/1,289483,sid13_gci837901,00.html Without loading data into your Oracle database, use this method to query data directly from external flat files. TURN OFF SERVICES, HIKE PERFORMANCE | Barrie Sosinsky http://www.searchDatabase.com/tip/1,289483,sid13_gci849847,00.html To squeeze more performance from a SQL Server application server, consider turning off operating system services unrelated to core OS functions and SQL Server itself. Here's how. SEVEN STEPS TO A JAVA WEB DATABASE APPLICATION http://www.searchDatabase.com/tip/1,289483,sid13_gci838016,00.html By Jim Mason and Dave Slater. Java Database Connectivity (JDBC) is one of the most important features of Java on any platform. You can use JDBC objects to define and run standard SQL statements to select and update AS/400 data files and call any RPG batch program easily. Here's how. 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 Laptop DC-AC inverter: http://searchdatabase.techtarget.com/tipsPrize/0,289492,sid13_prz848553_cts848282,00.html ___________________________________________________________________ IMPORTANT MESSAGES AND LINKS: =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= ORACLE 9I NEW FEATURES | Free Webcast TODAY, September 25 at 1 pm EST, join Andy Mendelsohn, a major force behind the past, present, and future development of Oracle, in this presentation and discussion about the latest and greatest manageability, data warehousing, and other features of Oracle 9i. >> CLICK for more details... http://searchdatabase.techtarget.com/webcasts/0,289675,sid13,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= ASK THE EXPERT | This week's tough database questions answered Data warehousing: The top BI vendors in the international market http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid491734_tax288369,00.html Oracle: Replicating data between SQL Server 2000 and Oracle http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid492464_tax285650,00.html DB2: Why the optimizer didn't choose an NPI http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid492166_tax285651,00.html SQL: Selecting every 100th of 1,000,000 rows http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid492167_tax285649,00.html Oracle: Tools for reverse engineering a database http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid491306_tax285650,00.html More expert answers here: http://searchdatabase.techtarget.com/ateExperts/0,289622,sid13,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= DATABASE-WEB INTEGRATION | SearchDatabase.com Featured Topic Integrating a DBMS with the Web and replacing static with database-driven Web pages continue to be top IT challenges. Our collection of tips and advice will help you understand & implement database-Web connectivity technologies. >> CLICK for our current Featured Topic... http://searchdatabase.techtarget.com/featuredTopic/0,290042,sid13_gci762529,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. Unsubscribe from 'Database Administrator Tips' - Simply Reply to this Email with REMOVE 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. - Uncheck the box next to the newsletter you wish to unsubscribe from. - When finished, click "Save Changes to My Profile."
