James Koopmann

Let’s zero in on the most important variable for implementing a global database in Oracle and some lessons learned. Firstly I need to thank the professionals at Oracle for their help in assisting me in getting the facts straight on these globalization articles. If you haven’t noticed, the facts and methods to setting the NLS_LANG […]

How does Oracle compare and sort data. There is more to it than meets the eye. Ever since I was a newbie to databases I never questioned how sorting occurred in a database. I just knew that there was a predefined order to the character set (English) and I never thought much more of it. […]

In the previous article, we looked at the terminology around globalization, mostly from outside Oracle. This article will take a look at the internal parameters available within Oracle that we will need to become familiar with. It is very important when talking about the globalization of language to understand the settings that you currently have […]

With today’s exploding world economy, multi-national communication is essential. Databases must not only store different character sets but also present information in a comfortable format and order for individuals from every locale. This series explores how to globalize your databases and communicate effectively across the globe. Let’s begin learning about how sorting and character comparisons […]

Part VI in our series will show you how to access and generate reports off of the trace files we generated in Part V through the use of the TKPROF and trcsess utilities. In the last part of this series, we re-visited methods on how to generate trace files. These trace files that were generated […]

Part five in our series will get closer to what we have, for years, experienced as Oracle’s tracing mechanism. Read On and get re-acquainted with creating trace files for TKPROF. For many years, DBAs have been getting low level tracing information about sessions through the creating and reading of Oracle generated trace files. These trace […]

Part IV in our series will focus on determining which internal Oracle views hold the information to our enabled statistical gathering. In Part I, we learned how to set the CLIENT_IDENTIFIER session variable to more accurately pinpoint resource consumption for an individual user or group of users. In Part II, we learned how to set […]

Explore how to enable and disable Oracle tracing with DBMS_MONITOR package in 10g. In Part I, we learned how to set the CLIENT_IDENTIFIER session variable to more accurately pinpoint resource consumption for an individual user or group of users. We did this through queries to real-time activity views such as V$SESSION and V$ACTIVE_SESSION_HISTORY. In Part […]

Here is how to make a connection from Oracle to SQL Server using Oracles heterogeneous Services ODBC agent. Many database shops that have more than just Oracle. In fact, SQL Server is gaining popularity and there are many shops that I know of that have this database system within their walls. Oracle has a generic […]

This part of the series is an extension to Part I and shows how to set two more very important session environment variables to make tracing more effective. Read on and learn how to set the module and action names. In Part I of the Session Tracing Series we learned how to set the CLIENT_IDENTIFIER […]

This is the first in a series introducing some of the new tracing concepts and options within Oracle. This installment focuses on the new CLIENT_IDENTIFIER environment variable that can be assigned to sessions. The goal of this series is to inform DBAs on how to track and trace connected sessions so that they can properly […]

There is nothing spectacular about using indexes per se. However, on many occasions I have come across a variety of SQL coders that never consider validating that the index they think they are using is efficient or even being used at all. We can all put indexes on the columns that we think will be […]