(Sreeram Surapaneni) Another Oracle 10g feature that is interesting is a new type of tablespace called a Bigfile Tablespace. When you read the 10g New Features, you will find out that a DBA can create a terabyte-sized datafile using the Bigfile option. Oracle uses the term “Smallfile” to designate t

(Dratz) Ok, now we’re ready to talk about specific types of indexes. The first one we’re going to talk about is the basic, default, great-for-almost-anything B-tree index.

(Michael Milonov) The most popular instrument to access database data for .NET applications is ADO.NET. This set of components contains three main classes those are used to manipulate and store data: DataReader, DataSet and DataAdapter. DataReader is only able to read data and can’t work as data sou

(Casimir Saternos) Many platforms are available for Web development including Microsoft’s .NET, Java 2 Enterprise Edition, and PHP. Why, then, is there so much interest in a new platform using a relatively unfamiliar language?

(Bob Watkins) Recovery Manager (RMAN) was introduced in Oracle 8.0 and enabled true incremental backups for the first time. Prior to RMAN, database exports could be taken incrementally, but if any block in a table was changed, the entire table was written. RMAN incremental backups write only the cha

(David Baum) For years, when you needed more computing capacity, you bought more-expensive computers. Today, with the advent of grid computing, capacity is added on demand, one inexpensive PC server at a time—and off-the-shelf Linux blades are frequently the servers of choice, explains Monica Kumar,

(Fahd Mirza) We are going to discuss the UNION,UNION ALL, INTERSECT and MINUS operators in SQL of Oracle.

(K Gopalakrishnan) As defined in Chapter 1, a cluster is a group of interconnected nodes that acts like a single server. In other words, clustering can be viewed logically as a method for enabling multiple standalone servers to work together as a coordinated unit called a cluster. The servers partic

(Patrick Sinke) Although bitmap indexes are already available in Oracle 8i or even before (some sources even say 7.3!!!), they are still surrounded by many myths. Time for some clearing up. And believe it or not, every single myth mentioned here I heard many times in several projects.

(Paul F. Roberts) There’s a common nightmare haunting CISOs (computer information security officers) that features a glance at the morning paper, and 72-point banner headlines with the name of their employer and the words “LOST” and “CUSTOMER DATA.”