Find the Max file size: [applmgr@xxxxx out]$ ls -lSr -rwxrwxrwx 1 applmgr oinstall 3703635 Jun 6 15:45 o5829172.out-rwxrwxrwx 1 applmgr oinstall 3703635 Jun 6 15:04 o5829155.out-rwxrwxrwx 1 applmgr oinstall 3703635…
Read MorePL/SQL package RCAT.DBMS_RCVCAT version 11.02.00.02 in RCVCAT database is not current. when we are trying to connect the Rman catalog database we are getting the error it is cause because…
Read More# +===========================================================================+ # | FILENAME # | R12_Instance_Version_Information.sh # | # | DESCRIPTION # | This script can be used to collect Apache, Jserv, Forms, Jinitiator and # | Perl…
Read MoreParallel Backup of the Same Data files in Oracle 11g RMAN In Oracle Database 11g RMAN, the channels can break the datafiles into chunks known as “sections.” we can…
Read MoreTo Determine which processes have listening ports on AIX The open source “lsof” tool is great for determining what process has a port open. Unfortunately lsof isn’t included with AIX…
Read MoreIn Oracle 11g, there is a new SGA component called result cache, which is used cache SQL query and PL/SQL function results. The database serves the results for the executed…
Read MoreIntelligent Data Placement enables you to specify disk regions on Oracle ASM disks for best performance. Using the disk region settings, you can ensure that frequently accessed data is placed…
Read Moreset lines 130 alter session set nls_date_format=’DD-MON-YY HH24:MI:SS’; select APPS_SYSTEM_NAME,DRIVER_FILE_NAME,start_date,end_date from AD_PATCH_RUNS a,AD_PATCH_DRIVERS b where a.PATCH_DRIVER_ID = b.PATCH_DRIVER_ID and DRIVER_FILE_NAME like ‘%&Patch_number%’;
Read MoreScenario: When are working in the inventory module and when we tried to do some transactions, We faced the following issue. Error : You must allow access to at least…
Read MoreAfter the Upgradation from 11.1.0.7 to 11.2.0.3 we started facing performance issue in execution of the custom concurrent program. The program which was running within 5 minutes was not completing…
Read More