Modern Oracle DBA

Recently we are facing this issue after login in to EBS navigation on home page very slow It was taking around 5 to 10 min to open the navigation page We enabled the Trace to user level to find the solution for it.   Enabling Trace in user Level: Step 1: Go to system administrator -> Profile ->system -> User Enter username and Profile Option “ Initialization SQL Statement – Custom ” and Enter the user name then search Step 2: Just replace the Username for below command and paste the command in profile values   Begin fnd_ctl.fnd_sess_ctl('','','TRUE','TRUE','LOG','ALTER SESSION SET TRACEFILE_IDENTIFIER='||'''' ||<Username> ||''''||' EVENTS='||''''||'10046 TRACE NAME CONTEXT FOREVER, LEVEL 12'||'''');End;   Step 3: Retest the issue and generate tkprof   How to generate Tkprof:   Once user retest the issue disable the

Server Steps: - Check OS version cat /etc/os-release   Check kernel version uname -r   RPM installation yum install gdbm-1.10-8.el7.i686 rpm -qa | grep -i                 Kernel Parameter Check /cat/sysctl.conf   Swap space check Recommended to set DB and apps swap space to on-perm server /proc/meminfo   Domain Name System (DNS) Resolver Parameters Check /etc/resolv.conf   Add etc/hosts entry Check the ulimit settings in limits.conf values /etc/security/limits.conf Ex:- * hard nofile 65536 * soft nofile 4096 * hard nproc 16384 * soft nproc 2047 * hard stack 16384   * soft stack 10240 Install the VPN server Setup firewall OS User and group creation Open Firewall port b/w on-perm to OCI   19C DB pre upgrade STEPS ·          Run ETCC on application nodes to check for missing patches ·          Validat