You have designed the model and implemented the dimensions and fact tables. Data is clean. You have implemented all the required PK-FK relationships, created required indexes, gathered statistics and built the required materialized views. The analytic design team have completed report and issues SQL query! Oops… You expected the response time of < 10 seconds,… Read More Why is Query Rewrite not happening on my Materialized Views?
In this post the we’ll walk through the steps for downloading ADF Faces Components Demo in Jdeveloper environment. I am using Jdeveloper version 188.8.131.52. You need OTN account (free account) for downloading the WAR file. Access the downloadable WAR file (rcf-dvt-demo.war) from OTN which can be accessed here. This is a WAR file containing a… Read More Installing ADF Faces Components Demo
Many applications define tables with primary key which is populated using values from database sequence. There are several posts on the net that describe these techniques with some links listed below as references. In ADF applications there are several approaches to implement assignment of primary key values. 1. Using Groovy Expression in Entity class. 2.… Read More Assigning primary key value using Oracle Sequence
This error in SQL Developer (4.0) appears when you execute an SQL in SQL Worksheet with some errors. Any further execution of the SQL results in same error. Once you correct the SQL and rerun the SQL you get the same error… Any further execution of the SQL gives the same error. However if you… Read More SQL Developer 4.0 – "Streams has already been closed"!
Oracle introduced Flashback Technology many years back (9i), and with version 11g TRANSACTION_BACKOUT capability was introduced. This is a very powerful feature, which allows a developer or DBA to BACKOUT specific committed transactions. This feature leverages UNDO and supplemental log data to identify the DML changes involved in a specific transaction and the other dependent… Read More Transaction Backout – Oracle Flashback Technology
Having worked with Oracle Database, APEX, ADF, and Amazon Cloud (AWS) for some time now, like many others I was waiting for arrival of Oracle Cloud. Finally in 2012, Oracle has started delivering its Cloud Offerings. As a not-so-early-adapters, I started a trial account to explore the Oracle Public Cloud (OPC). My expectation was that… Read More Oracle Cloud : Getting Started
In my previous post I completed creating an Oracle instance from public AMI on AWS. In a following post we configured OEM. In this post I’ll start APEX on this instance. This instance of Oracle comes preinstalled with APEX. First we have to reset the password of ADMIN and APEX_PUBLIC_USER and unlock the accounts. The… Read More Startup APEX with Oracle 11g on AWS