IN ORACLE MILIEU …

Beyond Knowledge

Monthly Archives: November 2010

Analyze Index Vs. Gather_Index_Stats – Oracle Database 10gp

Leave a Comment Posted by on November 1, 2010

One of the difference I noticed about analyze index command and gather_index_stats procedure is that when we use analyze index command if updates the index statistics with number of leaf blocks equals the number of leaf blocks below HWM. However if we use gather_index_stats statistics shows number of leaf blocks equals number of leaf blocks [...]

Database 10g Performance Tuning, Oracle Database 10g , ,

Oracle E-Business Suite R12 – Profiles

1 Comment Posted by on November 1, 2010

Profile Options in Oracle Application Object Library This section lists each profile option in Oracle Application Object Library. These profile options are grouped into categories based on their functional area and are available to every product in Oracle Applications. For each profile option, we give a brief overview of how Oracle Application Object Library uses [...]

Oracle Application R12 ,

Oracle Apps 11i – Profiles

Leave a Comment Posted by on November 1, 2010

Profile Options in Oracle Application Object Library This section lists each profile option in Oracle Application Object Library. These profile options are available to every product in Oracle Applications. For each profile option, we give a brief overview of how Oracle Application Object Library uses the profile’s setting. Unless otherwise noted, a profile option uses [...]

Oracle Applications 11i

Row Chaining and Migeration

Leave a Comment Posted by on November 1, 2010

Overview If you notice poor performance in your Oracle database Row Chaining and Migration may be one of several reasons, but we can prevent some of them by properly designing and/or diagnosing the database. Row Migration & Row Chaining are two potential problems that can be prevented. By suitably diagnosing, we can improve database performance. [...]

Database 10g Performance Tuning, Oracle Database 10g ,

Understanding AutoConfig

1 Comment Posted by on November 1, 2010

Introduction: AutoConfig is the tool, which is used to configure oracle application systems. Its basically a perl script with a shell wrapper over it. At present there are more then 300 configuration files and environment files in application system. Whenever a change is made to any of the configuration parameter, the change needs to be [...]

Oracle Application R12, Oracle Applications 11i

Oracle Real Application Cluster 10g

1 Comment Posted by on November 1, 2010

Introduction Oracle Real Application Cluster (RAC) is a revolution in the database management system. It is an extension of Oracle single instance database. RAC is basically a cluster of instances working on the same database. As you know instance is nothing but the computer memory and some background processes, so in case of RAC we [...]

Oracle RAC , ,

Oracle Database Lite 10g (OLite 10g)

1 Comment Posted by on November 1, 2010

Introduction Oracle Database Lite 10g extends the power of grid computing to a mobile workforce with a complete, integrated, secure database for building, deploying, and managing mobile applications for a broad range of mobile devices. Oracle Database Lite 10g enables persistent access to critical information and applications without requiring continuous connectivity to back-end enterprise systems. [...]

Oracle Database 10g ,

Oracle Database 9i Interview Questions

4 Comments Posted by on November 1, 2010

Intention of this post is to get as much interview question for Oracle DBA as possible to help you get the idea about the type of questions you can expect in interviews and exams. This will help you in increasing the knowledge about oracle database 9i as some of the questions may be new to [...]

Interview Questions, Oracle Database 9i ,

Oracle Application Express – Installtion Guide

2 Comments Posted by on November 1, 2010

This article provides instructions for installing and configuring the Oracle Application Express (formerly HTML DB) software release 2.2. Please note that these instructions cover the standalone version only. Installing Oracle Application Express is a two step process: Configure an Oracle HTTP Server (Release 9.0.3 or higher) with mod_plsql which is used to connect to the [...]

Oracle Application Express, Oracle Middleware

Oracle – Stellent

2 Comments Posted by on November 1, 2010

Oracle – Stellent Oracle announced that it has agreed to acquire Stellent, Inc. (NASDAQ: STEL), a global provider of enterprise content management (ECM) software solutions, through a cash tender offer for $13.50 per share, or approximately $440 million. On December 14, 2006, Oracle completed its acquisition of Stellent Inc., a global provider of enterprise content [...]

Oracle Middleware ,

← Older posts

Follow

Get every new post delivered to your Inbox.

Join 156 other followers