Posts tagged 'oracle 11g'

Ramandeep Singh Nanda

ADF Dynamic Query Performance Considerations

Recently, I noticed a poor implementation of dynamic query in our application environment.  As the query was complex and its where clauses were generated dynamically, the developer chose not to implement the bind variables.  Now, some of you will be aware of the disadvantages of not using bind variables, but ...

Ramandeep Singh Nanda

Tracing a J2EE application in Database

To trace an existing J2EE application (or a legacy application,legacy here means the ones still not using CDI) at database layer is not easy, especially if that application does not have any reference to the user whom you want to trace. A cumbersome way would be to pass the ...

Ramandeep Singh Nanda

oracle oui setup.exe crashes on windows 7

I recently faced an issue that after installing and configuring IDM domain, when i tried to run the config.bat for oim server the script was crashing on my windows 7 OS. The problems faced by me are mentioned below along with the causes and solutions.

  1. Problem: Setup.exe has ...

Ramandeep Singh Nanda

Oracle Database account unlocker

This is a simple procedure i created for unlocking user account and resetting the password to the original password, Although a very small utility it helps you with unlocking accounts that you tend to use after a long time which in my case were the SOA server and the BAM ...