ORA-00064: object is too large to allocate on this O/S (1,20005328,network connections) is encountered on database startup when open_links_per_instance parameter…
Below are the steps to apply apps patch using ADpatch in oracle EBS R12.1.3. But before applying the patch please…
This post describe about Oracle RAC Cluster startup sequence in detail and the step by step explanation which oracle follow…
You can use Oracle OPatch utility to check all the Oracle Patches applied in Oracle database. opatch utility is located…
Below are the steps for applying Oracle JVM patch in 12c Database. It can be used for container database PDB,…
Table lock is very common in Oracle database and v$lock is used to check the process and the blocking session.…
Below are the steps to apply PSU patch on Oracle 12c database using OPatch utility for Single instance. STEP 1:…
During any patching activity like PSU and OJVM it is good to take backup of Oracle home and oraInventory so…
Below are the steps to drop and recreate temp tablespace in Oracle. You can also assign default temporary tablespace to…
Below are the important query to check table size of partition and non partitioned tables in Oracle database. You can…