A user’s process will occasionally hang or spin and lock out other sessions. If the DBA still has access to the database, she can usually just issue the following query. (R)

(Greg Robidoux and Jeremy Kadlec) One last item, keep in mind that once the DTS Package is developed it can be scheduled to execute on a regular basis via a SQL Server Agent Job. For more information visit How to schedule a DTS package using the Schedule Package option (Enterprise Manager). (R)

(Toji Mammen George) This article will present a brief overview of the usage of Pipelined Table Functions, introduced in Oracle 9i, which enables accepting and returning multiple rows using Table Functions in PL/SQL.

A subquery answers multiple-part questions. For example, to determine who works in Taylor’s department, you can first use a subquery to determine the department in which Taylor works. You can then answer the original question with the parent SELECT statement. A subquery in the FROM clause of a S

(Kimberly Floss) Once you know all the things that can be tuned, within the database, where do you start? The answer is, with the code. You can double check all the init.ora parameters to start, monitor hit ratios and use operating system monitoring tools, but most often, the issue is in the cod

(Greg Robidoux and Jeremy Kadlec) I’m quite newbie in exploring the database technologies whether Oracle or MS SQL Server. I want to export Oracle 9i database to text file, then import it to MS SQL Server 2000. Is there any solution that will work for me? Do you have any suggestions? (R)

Today’s businesses, whether e-business or traditional brick-and-mortar, all rely on Information Technology to produce, communicate, store and retrieve business-critical information. Having a highly reliable and highly available IT system becomes key, if not synonymous, to business success. IT organi

The following procedure describes how to manually setup master-slave replication with materialized view (materialized log) in Oracle 9i. I found using OEM tool to configure a Read-only Materialized View Replication with only one mater site created some unwanted objects and jobs. The Oracle Repli

(James Koopmann) Finally, Oracle 10g has given us the ability to execute external programs from within Oracle. Let’s take a look at what we need to do to expose this new feature.

When designing a database table structure, it’s important to choose an efficient strategy for storing a logical Boolean that you can use in many programming environments. (Although Oracle doesn’t come with a Boolean datatype for database columns, it does have a Boolean datatype in PL/SQL.) (R)