Pages

▼
Monday, December 18, 2023

Change resource of a profile

›
Change resource of a profile by Example. Example: Change IDLE_TIME from 480 minutes to UNLIMITED SELECT profile, resource_name, limit    FRO...
Thursday, December 14, 2023

AWR "enq: TX - row lock contention" Wait Event

›
============================= General ============================= Checking AWR, Oracle is spending a lot of time in "enq: TX - row...

Golden gate - crontab to log golden gate processes stats

›
 59 * * * * /software/oracle/oracle/scripts/gg_stats_monitor/get_gg_stats.sh get_gg_stats.sh #!/bin/bash . /etc/sh/orash/oracle_login.sh igt...

Golden Gate - Crontab to log INFO ALL

›
crontab */10 * * * * /software/oracle/oracle/scripts/gg_stats_monitor/get_gg_info.sh get_gg_info.sh #!/bin/bash . /etc/sh/orash/oracle_login...
Wednesday, December 6, 2023

ORA-32001: write to SPFILE requested but no SPFILE is in use

›
========================== Error Details ========================== ALTER SYSTEM SET MEMORY_MAX_TARGET=24576M scope=spfile; ERROR at line 1:...
Tuesday, December 5, 2023

Archive logs is pointing to non exiting location

›
=============================== The Problem: =============================== Archive destination is not available. Oracle is running in ARCH...
Sunday, November 26, 2023

crontab to delete old dmp files

›
crontab 11 11 * * * /software/oracle/oracle/scripts/del_old_dmp_files/del_old_dmp.sh del_old_dmp.sh #!/bin/bash WORK_DIR=/software/oracle/or...