How to Change MTU Size in Exadata Environment
How to Change MTU Size in Exadata Environment Issue: Having a larger value for MTU such as 65520 bytes = 64kb will require more memory pages to support IPoIB, the…
Read MoreOEM13.4 not monitoring all Disks
INTRODUCTION: OEM13.4 is not monitoring all the Disks so we are unable to monitor the Disk alerts. SOLUTION: To fix this issue we need to change a parameter called EM_MONITOR_ALL_DISKS…
Read MoreTo find the SQL query history which was executed yesterday in oracle
The below query is used to find the history of sql statement which has been executed earlier. Below query has been used for finding the yesterday data. eg: set colsep…
Read MoreBLOCK CHANGE TRACKING
BLOCK CHANGE TRACKING Block changing tracking improves the performance of incremental backups by recording changed blocks in the block change tracking file. During an incremental backup, instead of scanning all…
Read MoreHow to increase the report server engine in 12c reports
Increase the report server engine to run multiple reports in parallel. Take a backup of rwsever.conf file cd $DOMAIN_HOME/config/fmwconfig/components/ReportsServerComponent/repserv1 cp -rp rwserver.conf rwserver.conf_bck Change the maxEngine value from 1 to…
Read More21c New Feature – Result Cache for Standby Database
Oracle 21c introduces the ability to improve the performance of queries executed on the read-only active Standby Database by enabling the use of the Result Cache feature to store query…
Read MoreCollecting OSWatcher Logs for a Particular Period of Time
1. As <ROOT_USER>, log in to Node 1 and cd to the “/tmp” directory. # cd /tmp 2. Use “vi” or editor of your choice, to create the “osw_capture” script…
Read MoreManually Generating Segment Advisor Advice
Manually Generating Segment Advisor Advice ========================================== Step 1 – Create a task. dbms_advisor.create_task ( advisor_name => ‘Segment Advisor’, task_id => my_task_id, task_name => test123, task_desc => my_task_desc); Step 2 – Assign an object…
Read MoreThe Store Record X Could Not Be Found
Shutdown manage servers and Admin server, clear below extension file on under domain home. Clear temp and cache of manage and admin servers find . -name “*.DAT” -print find…
Read MoreNew Data Guard Oracle 19c Database
Data Guard Oracle 19c Database Replicate Restore Points from Primary to Standby Dynamically change Fast-Start Failover (FSFO) target standby database to another standby database in the target list without disabling…
Read More