SEARCHDATABASE.COM | Database Administrator Tips September 18, 2002 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= FROM OUR SPONSORS:
Free Oracle Database Health Check http://searchDatabase.com/r/0,,5799,00.htm?databasehealthcheck FREE Webcast: Comprehensive Oracle Management http://searchDatabase.com/r/0,,5798,00.htm?computerassociates =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= IN THIS ISSUE | Table of Contents 1. DATABASE ADMINISTRATOR TIPS - Oracle: Reference information about V$ and more - Oracle: Querying external tables - SQL Server: Turn off services, hike performance - DB2: Seven steps to a Java Web database application - More recent tips from members 2. IMPORTANT ANNOUNCEMENTS AND LINKS - Ask the Experts: Your tough database questions answered - Featured Topic: Oracle report card - 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,,5799,00.htm?databasehealthcheck ___________________________________________________________________ THIS WEEK'S TIPS: REFERENCE INFORMATION ABOUT V$ AND MORE | Paresh Yadav 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. >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci835733,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= QUERYING EXTERNAL TABLES | Srinivas Chittimalla Without loading data into your Oracle database, use this method to query data directly from external flat files. >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci837901,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= TURN OFF SERVICES, HIKE PERFORMANCE | Barrie Sosinsky 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. >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci849847,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= SEVEN STEPS TO A JAVA WEB DATABASE APPLICATION 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. >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci838016,00.html ___________________________________________________________________ MORE RECENT TIPS FROM SEARCHDATABASE MEMBERS: =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= PREPARING TO USE ORACLE9I RMAN | David Anderson http://www.searchDatabase.com/tip/1,289483,sid13_gci845085,00.html Recovery Manager is a great tool for backup, restore and recovery operations. Here is a practical setup procedure to get you started. PL/SQL SCRIPT TO GET PLAN OF RUNNING SQL | Dilbagh Singh http://www.searchDatabase.com/tip/1,289483,sid13_gci841566,00.html This Oracle PL/SQL script provides the PLAN for SQL currently running by providing the SID and serial number for a session. ADJUST SQL SERVER FILL FACTORS | Barrie Sosinsky http://www.searchDatabase.com/tip/1,289483,sid13_gci849845,00.html One parameter you should always be aware of is SQL Server's fill factor. The fill factor determines how much of an extent is written to, and how many pages it can accommodate. Here's a quick tip showing that you can trade space for performance by adjusting the fill factor. JDBC: SETTING YOUR AS/400 LIBRARY LIST | Jim Mason and Dave Slater http://www.searchDatabase.com/tip/1,289483,sid13_gci838013,00.html 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. TRUE DBA BLOOPER #1: SCRIPT DERAILS THE TRAINS | SearchDatabase.com http://www.searchDatabase.com/originalContent/0,289142,sid13_gci849503,00.html What does a modern enterprise DBA do? In today's challenging multi-DBMS environments, the answer is "just about everything." The job description apparently also includes keeping the trains running on time. Well, that's the theory at least. This costly blooper was submitted by Oracle DBA Scott Benitez, who reports that he did indeed find another job after derailing the entire American Midwest. 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 ___________________________________________________________________ ******* Sponsored by Computer Associates International, Inc. ****** Finally, secrets of a well-managed Oracle environment revealed! FREE Webcast: "Comprehensive Oracle Management -- From Infrastructure to Application" on September 23, 2002 at 2:00 p.m. ET. Join Computer Associates International, Inc. (CA) and learn how to achieve a high-performance, optimized Oracle environment your end users will notice and appreciate! To register, visit http://searchDatabase.com/r/0,,5798,00.htm?computerassociates ___________________________________________________________________ ___________________________________________________________________ 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 SQL: Multiple unique NULLs, revisited http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid489718_tax285649,00.html DB2: Using TO_DATE function with partial dates http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid489714_tax285651,00.html Oracle: Learning Oracle: 8i or 9i on Windows XP Pro? http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid489708_tax289342,00.html SQL Server: Problem attaching DBs because of different sort orders http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid489162_tax292506,00.html SQL: Mixing ANDs and ORs http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid489719_tax285649,00.html More expert answers here: http://searchdatabase.techtarget.com/ateExperts/0,289622,sid13,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= ORACLE REPORT CARD | SearchDatabase.com Featured Topic The survey results are in. You love Oracle's reliability and performance but question its premium cost. One-third are hesitant about upgrading to 9i. And tech support and sales tactics are among your biggest gripes. Read on for more results from our exclusive survey... >> CLICK for our current Featured Topic... http://www.searchDatabase.com/featuredTopic/0,290042,sid13_gci850316,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."
