Oracle Database Administration

Hello Guys, Here we are going to see the steps to add new disk to ACFS file system disk group or How to extend/increase the size of ACFS file system diskgroup (ACFS - Oracle Automatic Storage Management Cluster File System). This is also real time scenario of my environment. We received critical alert on ACFS file system mount point /prodtop which is having only 10GB free space and 90% of disk group space has been used. So customer requested us to increase size of /prodtop to another 10GB. Before extending the diskgroup [root@node1: ~]# df -Th /prodtop/ Filesystem                    Type      Size  Used Avail Use% Mounted on /dev/asm/prodtop-153  ACFS    95G   85G   11G  90%    /prodtop So here we go. 1) Ask OS team to provide a new partitioned disk size of 10GB which should be shareable across all nodes if it is a clustered environment. For example *********** We got the below partitioned disk. Disk /dev/xvdj: 10.7 GB, 10737418240 bytes     Device Boot   

Hello Guys, Here is an another post related to Cloud Control EM13c - Real-time Scenario. Suddenly We were receiving the following warning and critical alerts from EM13c Cloud Control during the time slot between 12 AM and 04:00 AM daily. 1)  Message= Loader Throughput (rows per second) for Loader_D crossed the critical threshold (xx). Current value: xx.xx 2)  Message= Total Loader Runtime in the Last Hour (seconds) for Loader_D crossed the critical threshold (x,xxx). Current value: xxxx.xx 3)  ORA-error stack (3,136) and ORA-error stack (609) were also logged in alert log 4)  Message= Incident (BEA-310003 [LowMemory]) detected in $OMS_HOME/gc_inst/user_projects/domains/GCDomain/servers/EMGC_OMS1/adr/diag/ofm/GCDomain/EMGC_OMS1/alert/log.xml at time/line number: When we analyzed the AWR reports of EM PDB repository database, we found there were few PL/SQL statements given below causing this issue with wait event  SQL*Net Break/reset To Client Waits. SQL statement wit