Database Blog

Huges_Pages Setup for Host

    Find the memory on the host: [gg60@ut03 :+ASM] /home/dba/gg60 $ free -m total       used       free     shared    buffers     cached Mem:          3820       3773         47          0        396       2045 [gg60@ut03 :+ASM] /home/dba/gg60 $ cat /proc/meminfo  | grep Mem MemTotal:      3912580 kB MemFree:         64228 kB ********************************************************************************* Set the value for vm.nr_hugepages: 3820/1024 = 3.73 GB 1.5 GB is 40%     (this will be the sga_target value 1528 MB ) (1.50 * 1024 * 1024/2048) + 5 = 773 vm.nr_hugepages=773 A) Edit /etc/sysctl.conf Add line: vm.nr_hugepages=773 ********************************************************************************* Set the value for Soft memlock and Hard memlock: 3912580 * 2 = 7825160 B)  Edit: /etc/security/limits.conf Add lines: oracle soft memlock 7825160 oracle hard memlock 7825160 ************************************************************************************* .75 * 3264 * 1024 * 1024 = 3004170240 kernel.shmmax = 3004170240 C)  Edit /etc/sysctl.conf Add line:…

Read More

How to Format Corrupted Block Not Part of Any Segment

Step 1 – Identify corrupt datafile The corruption may be reported at the application level, such as DBV and RMAN, or the alert.log. Step 2 Run DBV/Rman validate on affected…

Read More

Tips to import the export and import datapump performance

1) Use parallel 2)While mentioning the dump file, use _%U.dmp (generates multiple dumps), which will be faster. 3)Increase the stream pool size alter system set streams_pool_size=2G; alter system set “_disable_streams_pool_auto_tuning”=TRUE;…

Read More

An Invalid redirect has been blocked error

Issue: As we all know, APEX page can be integrated into EBS as a function. After integrating Apex pages in EBS 12.2 when you access apex page from EBS, you…

Read More

Moving datapump dumpfiles In and Out of Autonomous data warehouse

Click here to Download

Read More

Performing Expdp/Impdp in Autonomous datawarehouse using SQLDEVELOPER

Click here to Download

Read More

Cloning Autonomous data warehouse using backup

Click here to Download  

Read More

Cloning Autonomous data warehouse from Live

Click here to Download as PDF

Read More

Script to check Long running 12c forms in Forms Application server

The below script is to check Long running 12c forms in Forms Application server   #!/bin/bash ############################################################################### # File Name : long_runn_forms.sh # Author : Vimal Raju # Date :…

Read More

Script to get metadata for all dblinks

The below script is to get metadata for all dblinks   # @(#) ==================================================================== # @(#) Reverse engineering all database links # @(#) # @(#) # @(#) Format: reverse_all_dblinks.sql #…

Read More