SEARCHDATABASE.COM | Database Administrator Tips September 12, 2002 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= FROM OUR SPONSOR:
Qualify for FREE attendance to Networking Decisions Conference http://searchNetworking.com/r/0,,4344,00.htm?NetworkingDecisions =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= IN THIS ISSUE | Table of Contents 1. DATABASE ADMINISTRATOR TIPS - Oracle: Preparing to use Oracle9i RMAN - Oracle: PL/SQL script to get plan of running SQL - SQL Server: Adjust SQL Server fill factors - DB2: JDBC: Setting your AS/400 library list - More recent tips from members 2. IMPORTANT ANNOUNCEMENTS AND LINKS - Ask the Experts: Your tough database questions answered - Featured Topic: DBMS reviews and comparisons - True DBA Bloopers: Submit your horrifying tale to win! ___________________________________________________________________ *************** Sponsored by Networking Decisions ***************** Top speakers to present key networking, VoIP and wireless solutions at the FREE Networking Decisions conference that arrives in Chicago October 16-18. Speakers include: ** Cisco Systems' Chief Development Officer, Mario Mazzola ** Yankee Group VP, Zeus Kerravala ** Nortel Networks' CIO Richard Ricks ** Giga Information Group Senior Industry Analyst, Jim Slaby Qualify for FREE attendance at: http://searchNetworking.com/r/0,,4344,00.htm?NetworkingDecisions ******************************************************************* ___________________________________________________________________ THIS WEEK'S TIPS: PREPARING TO USE ORACLE9I RMAN | David Anderson Recovery Manager is a great tool for backup, restore and recovery operations. Here is a practical setup procedure to get you started. >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci845085,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= PL/SQL SCRIPT TO GET PLAN OF RUNNING SQL | Dilbagh Singh This PL/SQL script provides the PLAN for SQL currently running by providing the SID and serial number for a session. >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci841566,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= ADJUST SQL SERVER FILL FACTORS | Barrie Sosinsky 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. >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci849845,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= JDBC: SETTING YOUR AS/400 LIBRARY LIST | 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_gci838013,00.html ___________________________________________________________________ MORE RECENT TIPS FROM SEARCHDATABASE MEMBERS: =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= 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. GENERATE FLAT FILES FROM A DATA WAREHOUSE | Rama Balaji http://www.searchDatabase.com/tip/1,289483,sid13_gci847408,00.html This Oracle procedure takes in the schema name and directory path name, grabs all the tables owned by that schema and generates a tab-delimited flat file. GET THE WAIT TIME OF A SQL SESSION | Syed Ali http://www.searchDatabase.com/tip/1,289483,sid13_gci842561,00.html If you get a slow response from an Oracle database session, here is first step to finding what the session is waiting for. STUPID CHECK FOR PROPER INSTANCE | Patrick Sand http://www.searchDatabase.com/tip/1,289483,sid13_gci845215,00.html 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. UNIX SCRIPT TO GATHER TABLESPACE INFORMATION | Robert Hanrahan http://www.searchDatabase.com/tip/1,289483,sid13_gci831500,00.html This script is used to gather Oracle tablespace information, including space, used_space and fragmentation. FIND OUT WHEN A STORED PROCEDURE WAS LAST ALTERED | P. Mandayam http://www.searchDatabase.com/tip/1,289483,sid13_gci836901,00.html Find when a SQL Server stored procedure or function was last altered with this short script. DETERMINE WHEN A TABLESPACE WAS LAST COPIED | Manuel Angel Mendez http://www.searchDatabase.com/tip/1,289483,sid13_gci840525,00.html 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. 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: =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= 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 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= DBMS REVIEWS AND COMPARISONS | SearchDatabase.com Featured Topic One of the most common requests we at SearchDatabase.com receive is for independent product reviews. We aim to please, so here is a collection of 100+ Oracle, SQL Server, Sybase, MySQL, and DB2 reviews, comparisons, and analyses. >> CLICK for our current Featured Topic... http://searchdatabase.techtarget.com/featuredTopic/0,290042,sid13_gci801069,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."
