(James Koopmann) It is not a question as to whether or not hierarchical models are good or bad. We will all come across them no matter where we go. However, querying these structures has often baffled many practitioners. Not just in understanding the model behind them but in querying them properly.

(Scott Stephens) If you use the Windows Task Manager to kill the Oracle thread, it would bring down all users and background threads and crash the database. That’s why Oracle provides the command orakill.exe.

(Sailaja Pasupuleti) This script checks whether a column contains unique values.

A Linux GRID is currently one of the most popular data warehouse implementations. Based on the authors’ extensive experiences in the field of TPC-H and real-world customer benchmarks, this paper describes the top 5 performance tips for tuning a data warehouse on a GRID of Linux clusters: 1. How

(Jagadish Chaterjee) This article mainly concentrates on retrieving data from an Oracle database with ODP.NET using ASP.NET in several possible ways.

(Lewis R Cunningham) In part 1 of this series I covered Associative Arrays and Record types. Today I will be covering Varrays and Nested Tables.

(Mark A. Williams) There are many ways to access data from Oracle databases in .NET applications. In terms of features and performance, however, the Oracle Data Provider for .NET (ODP.NET) is your best choice for connecting .NET applications with Oracle Database.

(MS Sridhar) In Oracle, you can only control read/write capability for an entire tablespace, not for a single table within a tablespace. So, if you want all the tables in a tablespace to be read-only, you can use the following command.

(Charles Babcock) At Stride Rite Corp., Ray LeFebvre, database manager, finds that managing 50 Oracle database systems with a small staff is easier once a third party’s graphical-management tools are sitting on top of his Oracle 8i and 9i systems.

(Paolo Mariani) This PL/SQL script enables/disables foreign key constraints by referring to a specified table list.