11g

Category

Views

Patrick Barel on 05 June 2013 with 1 comments

Success always occurs in private and failure in full public view. – Unknown When working with views you have several options to hide some of the data. Of course there is the possibility not to select certain columns of data in the view. This way, the user of the view doesn’t even have to know this column even exists. You… Continue Reading →

10g, 11g, 12c, 8i, 9i, All Things Oracle Full Articles, Oracle Database, PL/SQL

RAC One Node

Aman Sharma on 25 April 2013 with 31 comments

In the past few years, technology has become a very important aspect of our lives. There isn’t any moment when we are not connected to or using technology and this is not to do some core geeky stuff but for the tasks which have become a part of our lives. Can you imagine a day when you are unable to connect to… Continue Reading →

11g, All Things Oracle Full Articles, Database Administration, Oracle Database, RAC

In the first three parts (Part 1: Basic Table Compression, Part 2: Read-Only Data, Part 3: OLTP Compression) of this series we examined table compression – both basic and the separately licensed OLTP compression. In this article we move on to index compression which, as we shall see, uses the same “deduplication” techniques as table compression but includes a couple… Continue Reading →

11g, All Things Oracle Full Articles, Database Administration, Database Development, Oracle Database, Performance Tuning

In part two of this series we examined the effect of updates on compressed data when using basic compression, and saw how Oracle will do some “decompression” of a row before updating it with the effect that highly compressed rows might easily become so much larger that even a small amount of change could lead to a large number of… Continue Reading →

11g, All Things Oracle Full Articles, Database Development, Oracle Database, Performance Tuning

In part one of this series we saw that the mechanics of basic table compression came in to play only for direct path inserts, CTAS, and “alter table move”. We also saw that Oracle would, by default, set the free space percentage (pctfree) for a table to zero if the table were defined as compressed – giving us a hint… Continue Reading →

11g, All Things Oracle Full Articles, Database Development, Oracle Database, Performance Tuning

In this short series on compression in Oracle, we will be looking at the various types of compression used by traditional Oracle systems, this means: (i) basic table compression, (ii) OLTP table compression, and (iii) index compression. I won’t be discussing the hybrid columnar compression (HCC) that appeared with Exadata (though I may write up a mini-series on that topic… Continue Reading →

11g, All Things Oracle Full Articles, Database Development, Oracle Database, Performance Tuning

Extract, Transform, and Load (ETL) scenarios sometimes are perceived as mundane and, dare I say it, even boring. Yet I find them fascinating opportunities to apply out-of-the box thinking. Data rarely presents in just the format expected by SQL*Loader or external table syntax. On a good day one builds a straightforward external table and job done. Or is that on… Continue Reading →

11g, All Things Oracle Full Articles, Database Administration, Database Development, Oracle Database

I have recently published an article about SQL Plan Management and some of its capabilities in 11g version of the database. SQL plan management helps preserving efficient execution plans and evaluates every changed plan. Plan changes can be due to the system change (Database upgrade, changes in database parameters, changes in optimizer parameters, changes in optimizer statistics, system configuration, etc… Continue Reading →

11g, Database Administration, Oracle Database

A process cannot be understood by stopping it. Understanding must move with the flow of the process, must join it and flow with it. – Frank Herbert, Dune (First Law of Mentat) One of the ‘killer’ features of the Oracle Database version 11g Release 2 is probably Edition Based Redefinition. This functionality allows for near zero downtime when performing an… Continue Reading →

11g, All Things Oracle Full Articles, Database Development, Oracle Database, PL/SQL

In part 1 I explained how to duplicate a single instance database using RMAN. This article will focus on converting the single instance to RAC. 2. Convert Single instance to RAC We have migrated the database successfully from Non-ASM to ASM using RMAN; the database is still running as single instance.  Now we need to convert the single instance database… Continue Reading →

10g, 11g, All Things Oracle Full Articles, Application Development, Database Administration, Oracle Database, Uncategorized