According to the query output from V$RESOURCE_LIMIT, the PROCESSES parameter limit is not yet reached. RESOURCE_NAME processes CURRENT_UTILIZATION 102 MAX_UTILIZATION 559 INITIAL_ALLOCATION 2000 LIMIT_VALUE 2000 The maximum value it ever reached was 559, while the limit is set to 2000.
Ref ID: How To Resolve Stranded DBA_2PC_PENDING Entries [ID 401302.1] Issue: We had network outage and there were some distributed transactions with dblinks hangs. Causing issue when trying to update some rows of the base table. Problem Discription: ==================== As a result of a failed commit of a distributed transaction, some entries canbe left in…
Read More “How To Resolve Stranded DBA_2PC_PENDING Entries ID 401302.1 (Very Good prooven)” »
cat test1 | egrep ‘TNS-|Client address’ | sed -e ‘s/^.*HOST/HOST/’
fuser -cu /directory_name
Seeing kernel version (32/64 Bit) on Unix flavors. -isainfo -kv on Solaris -lsconf on AIX -uname -a on Linux to See configuration -prtdiag on Solaris -lsconf on AIX -dmidecode on Linux Other useful Unix commands: Disk usage. # df -al Memory information. # free Network information. # ifconfig -a Installed Modules information. #lsmod Currently mounted…
Oracle Recommended Patches — Oracle Database Target Configurations Patch Availability Current Recommended Patches 11.2.0.2 Current Recommended Patches 11.2.0.1 Current Recommended Patches 11.1.0.7 Current Recommended Patches 11.1.0.6 Current Recommended Patches 10.2.0.5 Current Recommended Patches 10.2.0.4 Current Recommended Patches 10.2.0.3 Current Recommended Patches Conflict Resolution On Request Known Issues References Beginning with release 10.2.0.3, Oracle releases Recommended…
Read More “Oracle Recommended Patches — Oracle Database ID 756671.1” »
Applies to: Oracle Server – Enterprise Edition – Version: 10.2.0.4 to 11.2.0.1 – Release: 10.2 to 11.2 Information in this document applies to any platform. Oracle Server Enterprise Edition – Version: 10.2.0.4 to 11.2.0.1 Goal 1.Do you still need to apply Patch Bundles for a certain patchset level when Patch Set Update (PSU) for that…
Read More “Is It Recommended To Apply Patch Bundles When PSU Is Available? -ID 743554.1” »
Applies to: Oracle Server – Enterprise Edition – Version: 8.1.7.4 to 11.2.0.2 – Release: 8.1.7 to 11.2 Oracle Server – Standard Edition – Version: 8.1.7.4 to 11.2.0.2 [Release: 8.1.7 to 11.2] Information in this document applies to any platform. Oracle Server Enterprise Edition – Version: 8.1.7.4 to 11.2.0.2 Purpose The purpose of this document is…
Applies to: Oracle Server – Enterprise Edition – Version: 10.2.0.1 to 11.1.0.7 Information in this document applies to any platform. Goal This article helps to plan oracle database patching sequence to the latest/required patchset version with in the same release (ex: 10.2.0.1 to 10.2.0.4) along with CPU/PSU/One-off-patch installations. Solution Basically there are two entities in…
Oracle Database (RDBMS) Releases Support Status Summary [ID 161818.1] Oracle Database (RDBMS) Releases Support Status Summary Information here was last updated on 14-Sep-2010 This note shows the current main Oracle Database releases along with information about the support status of each release and its Patch Sets. To see the main support alerts and Patch Set…
