<!--
@page { margin: 0.79in }
P { margin-bottom: 0.08in }
-->

2-
NODE RAC SETUP WITH OPENFILER

PART-A
Open-filer Set-up

• Install openfiler on a machine
  (Leave 60GB free space on the hdd)

• Login to root user

Hi All,

I am starting a blog for the Knowledge sharing about ASM (Automatic Storage Management). It may include New Features Installation,configuration,upgradation of ASM, Patching, Compatibility With RAC etc. Please avoid  repetion

Application Domain Indexes

Application domain index gives the user ability to supply new index technology.Most people will never make use of it his particular API to build a new index type. The inetMedia set of functionally ,implemented  using  the Application Domain indexing feature will  provide indexing on text,XML  documents and image.

Function-based Indexes

A function-based index includes columns that are either transformed by a function, such as the UPPER function, or included in an expression, such as col1 + col2.

Reverse Key index

There is an option to create index entries as reversed, which is called reverse key indexes. Oracle stores the index entries as their bytes reversed.

B tree index

A b-Tree index is a data structure in the form of a tree - no surprises there - but it is a tree of database blocks, not rows. Imagine the leaf blocks of the index as the pages of a phone book.
Each page in the book (leaf block in the index) contains many entries, which consist of a name (indexed column value) and an address (ROWID) that tells you the physical location of the telephone (row in the table).

Mapping Bitmaps to Rowids Efficiently
 

Use SQL statements with the ALTER TABLE syntax to optimize the mapping of bitmaps to rowids. The MINIMIZE RECORDS_PER_BLOCK clause enables this optimization, and the NOMINIMIZE RECORDS_PER_BLOCK clause disables it.

Maintenance Considerations for Bitmap Indexes

Index  Definition

An index  is a performance-tuning method of allowing faster retrieval of records. An index creates an entry for each value that appears in the indexed columns. By default, Oracle creates B-tree indexes.