To 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 MoreNew tables/views in Oracle 19c Database
New tables/views in Oracle 19c Database dba_auto_index_config dba_sql_quarantine V$SQL_TESTCASES DBA_REGISTRY_BACKPORTS
Read MoreNew initialization parameters in Oracle Database 19c
New initialization parameters in Oracle Database 19c “_optimizer_gather_stats_on_conventional_dml” and “_optimizer_use_stats_on_conventional_dml” which are true by default _optimizer_stats_on_conventional_dml_sample_rate (at 100%) DATA_GUARD_MAX_IO_TIME DATA_GUARD_MAX_LONGIO_TIME ADG_REDIRECT_DML (TRUE or FALSE) MAX_DATAPUMP_JOBS_PER_PDB aws_pdb_autoflush_enabled (TRUE or FALSE)
Read More