SEARCHDATABASE.COM | Database Administrator Tips October 16, 2002 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= FROM OUR SPONSOR:
Take a survey about distributed systems database management & win! http://searchDatabase.com/r/0,,6603,00.htm?BMCSoftware =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= IN THIS ISSUE | Table of Contents 1. DATABASE ADMINISTRATOR TIPS - Optimizing database performance, part 1 - Oracle: Getting info about locked objects - SQL Server: Replicating data from SQL Server 2000 to Oracle - DB2: Inserting CLOB data into DB2 - More recent tips from members 2. IMPORTANT ANNOUNCEMENTS AND LINKS - Free webcast: Tom Kyte answers your Oracle9i questions - Ask the Experts: Your tough database questions answered - Featured Topic: Spotlight on Oracle ___________________________________________________________________ ******************* Sponsored by BMC Software ********************* If you are involved in the decision making process for DISTRIBUTED SYSTEMS DATABASE MANAGEMENT products you could win $500. A leading provider of DISTRIBUTED SYSTEMS DATABASE MANAGEMENT software is interested in your opinion! Your experience and knowledge can help them provide products that better meet your needs. Your answers will be kept completely confidential. To participate, click here http://searchDatabase.com/r/0,,6603,00.htm?BMCSoftware ******************************************************************* ___________________________________________________________________ THIS WEEK'S TIPS: OPTIMIZING DATABASE PERFORMANCE, PART 1: PARTITIONING AND INDEXING In this first part of a new series, author Craig Mullins introduces the techniques for optimizing the performance of any database. >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci850679,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= GETTING INFO ABOUT LOCKED OBJECTS IN ORACLE | Ranjit Kumar This short script takes the object name and gives the session ID and serial number for the session that has a lock. >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci854780,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= REPLICATING DATA FROM SQL SERVER 2000 TO ORACLE | Sravan Kasarla This tip is useful for understanding the replication options between SQL Server 2000 and Oracle 8i databases. It will help DBAs to enable sharing of data in a heterogeneous environment, which is a common challenge in most IT departments. >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci854771,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= INSERTING CLOB DATA INTO DB2 | Sujit Mishra These days, the CLOB data type is extensively used in many applications. However, our problem was inserting DB2 CLOB data from a Java application into a OS/390 database because the codepage settings are different for both client and server. This tip helps solve the problem of inserting the data into DB2 on OS/390. >> CLICK for the full tip... http://www.searchDatabase.com/tip/1,289483,sid13_gci854776,00.html ___________________________________________________________________ MORE RECENT TIPS FROM SEARCHDATABASE MEMBERS: QUERY FOR MULITPLE ORACLE PROCESSES AND TRANSACTIONS | Pratik Chakraborty http://www.searchDatabase.com/tip/1,289483,sid13_gci852246,00.html Ever wanted a handy way to find out how long an UPDATE update statement has been running, how much rollback space it has used, etc? Or who are all the people connected to the database? And exactly what are they doing right now? Here is a query that shows all. SIMPLE QUERY FORMATTER | Andrew Wall http://www.searchDatabase.com/tip/1,289483,sid13_gci846683,00.html This script is useful for ad-hoc queries with numerous select list items within SQL*Plus. It formats the output as one column_name = column_value per line. Normally, the display would show many heading lines and then some data, making it difficult to line up columns with their values. BACK UP TRANSACTION LOGS | Barrie Sosinsky http://www.searchDatabase.com/tip/1,289483,sid13_gci849849,00.html A few quick tips about SQL Server's transaction log, the key to being able to recover from a variety of system and software problems. DATE CONVERSION FROM SYBASE TO DB2 | Parminder Singh http://www.searchDatabase.com/tip/1,289483,sid13_gci854963,00.html The format in which Sybase stores data is often different than DB2, which becomes a problem when manually porting from one to the other. For example, Sybase and DB2 DATE formats are entirely different. If a Sybase data column is loaded into DB2, it will give an error. Use this script to overcome the problem... 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 MESSAGES AND LINKS: =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= YOUR TOUGH DATABASE QUESTIONS ANSWERED | Ask the Experts SQL Server: Porting nchar() data to Oracle http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid496353_tax285648,00.html Oracle: New or composite primary key for a composite table? http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid496385_tax289342,00.html SQL: Aggregate functions in a left outer join http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid494464_tax285649,00.html Oracle: Loading text files into Oracle tables http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid496317_tax285650,00.html SQL Server: Monitoring which databases take up most CPU time http://www.searchDatabase.com/ateQuestionNResponse/0,289625,sid13_cid496356_tax285648,00.html More expert answers here: http://searchdatabase.techtarget.com/ateExperts/0,289622,sid13,00.html =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= TOM KYTE ANSWERS YOUR ORACLE9I QUESTIONS | SearchDatabase.com Webcast Who: Tom Kyte, author of "Expert one-on-one: Oracle" When: Oct. 23, 2002 at 1:00 PM EDT (17:00 GMT) Take advantage of this exclusive opportunity to interact with one of the premier Oracle gurus on the planet. During this Webcast, Tom Kyte will answer your burning questions about Oracle 9i. >> If you have questions you'd like to ask, e-mail them today to Site Editor Tim DiChiara: mailto:[EMAIL PROTECTED] =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= SPOTLIGHT ON ORACLE | SearchDatabase.com Featured Topic Oracle is as technically complex as it is dominant in the DBMS market. Oracle DBAs know that all too well! Will 200+ free scripts and tips help? How about 600+ expert answers to tough Oracle questions? It's all below, and more... >> CLICK for our current Featured Topic... http://searchdatabase.techtarget.com/featuredTopic/0,290042,sid13_gci821160,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."
