Oracle Virtual Private Database (VPD) enables you to create security policies to control database access at the row and column level. Essentially, Oracle Virtual Private Database adds a dynamic WHERE clause to a SQL statement that is issued against the table, view, or synonym to which an Oracle Virtual Private Database security policy was applied. …
Oracle virtual Private database(VPD) Read More »
Adop (Ad online patching utility) is used in R12.2 to apply the patches online with out any downtime.it is the new utility which to apply patches in online patching mode .It is Perl script and call adpatch internally to apply the patch. It is not recommended to apply the patches directly using adpatch in R12.2 …
Adop(Ad online patching utility) explained R12.2 Read More »
Oracle uses a simple mechanism of a heartbeat to detect instance failure of a node in a Oracle RAC cluster. The cluster manager software detects if it cannot receive the heartbeat of the other instances and if it does not the recovery process begins. From what I can find, this heartbeat is provided by the …
How Oracle RAC handles instance failure and recovery Read More »
DISM usage is Oracle Oracle database uses shared memory segment to facitilate many things in the database. Shared memory segment consist of SGA which has buffer cache ,shared pool etcThe shared memory segments is managed either using ISM or DISM in Solaris and Linux ISM stands for Intimate Shared Memory DISM stands for Dynamic Intimate …
Session Persistence Session Persistence is the act of keeping a specific user’s traffic going to the same server that was initially hit when the site was contacted for the first HTTP transaction. This is especially important for E-Business Suite as various modules bundled with the suite need to maintain session state. Session persistence is sometimes …
What is Session Persistence,Web Entry Point and Server Load Balancer Read More »
Oracle Performance case study on sql_trace being set improperly My apps system was generating lot of trace files and mount was getting , resulting in I/O issues. we cleaned up the trace files and but again it came backUpon investigation we found that some body has by mistake set the init.ora parameter sql_trace to …
Oracle sql_trace parameter and its impact Read More »
