Archive | Database

Oracle Database Gateways 11g R2 (11.2) Installation and Configuration for heterogeneous connection from Oracle to Microsoft SQL database

Installation Install the Oracle Database Gateways 11g R2 (11.2). See the screen snapshots of the installation here. Configuration During the installation, the following+ default initialization parameter file is created: [ORACLE_DG_HOME]\dg4msql\admin\initdg4msql.ora dg4msql = Database gateway for Microsoft SQL Server. If you choose a different database option, use the appropriate path name. Copy initdg4msql.ora to a new […]

Continue Reading 1

How long did Oracle materialized view refresh run?

The LAST_REFRESH_DATE column of the DBA_MVIEWS or the LAST_REFRESH column of the DBA_MVIEW_REFRESH_TIMES indicates the start refresh time. But what if we’d like to find out how long the refresh of the materialized view really takes. Well, we can query the DBA_MVIEW_ANALYSIS. For Complete Refresh, the refresh duration will be in the FULLREFRESHTIM column of […]

Continue Reading 4

Customize/Personalize Oracle APEX Workspace Environment

When you have multiple Oracle APEX environments, e.g., development, test, UAT and production, and for multiple groups, one of the confusing things is that sometimes developers are lost on which environment they’re working on. Most of technically proficient developers can make a distinction easily from the URLs they’re currently using. However, most of less technically […]

Continue Reading 4

Book Review: Oracle 11g R1/R2 Real Application Clusters Essentials by Ben Prusinski and Syed Jaffer Hussain (Packt Publishing)

Oracle Real Application Cluster (RAC)  becomes the technology of choice for highly available and highly scalable deployment of enterprise Oracle database environment. With its innovative technology it comes with no surprise its complexity. The complexity is not only with the underlying database technology itself, but also how well you design and implement it to work […]

Continue Reading 0

Differences between Native and Interpreted Compilations in Oracle 11g? Why Performance Is Improved in the Native Compilation?

Quick bullet points from reading the Transparent Performance Improvement: Real Native Compilation from the PL/SQL Enhancements in Oracle Database 11g white paper: The PL/SQL is an interpreted language but it is not just like other interpreted languages , e.g. BASIC, where the code is processed statement by statement at the run time. The PL/SQL code […]

Continue Reading 4

Powered by WordPress. Designed by WooThemes