Determining the Optimal Undo Retention Period ============================================== You need to determine the optimal length of time for undo retention in your database. Solution You can specify the length of time…
Read MoreTo obtain the current patchset levels for each specific E-Business Suite functional product test the following steps: 1. Log into OAM. (Responsibility System Administrator,”Oracle Applications Manager”, menu “OAM Support Cart”)…
Read MoreTo find retention guarantee for undo tablespace select tablespace_name,status,contents,retention from dba_tablespaces where tablespace_name like ‘%UNDO%’; To find Undo Space Availability select a.tablespace_name, SIZEMB, USAGEMB, (SIZEMB – USAGEMB) FREEMB from (select…
Read MoreLocking and Disabling User Accounts in Linux 1. Locking the user account To lock a user account use the command usermod -L or passwd -l. Both the commands adds…
Read MoreWe can use ssh to connect between servers, but many times it is required to setup a password less connectivity between the servers. We can follow below steps to…
Read MoreError in `FNDLIBR’: double free or corruption (out) In some concurrent programs, I was seeing the error as FNDLIBR corrupted. Other programs were working fine. This was observed in EBS…
Read MorePROBLEM: After adding a datafile in primary database, recovery process in standby stopped with below error. — Error in alert log of standby database Fri Jan 15 09:56:46 2021 Errors…
Read MoreASMLIB is a storage management interface. ASMLIB is not required for ASM to function; it is like an add-on library that simplifies the tasks of managing and discovering the disks.…
Read MoreThe auditing mechanism for Oracle is extremely flexible. Oracle stores information that is relevant to auditing in its data dictionary. Every time when a user attempts anything in the database…
Read MoreBelow are some of the useful ASM commands which will be helpful all the time. ASMCMD > showversion ASMCMD > showversion –releasepatch –softwarepatch ASMCMD > showpatches ASMCMD > showclustermode ASMCMD…
Read More