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 dba_auto_index_config dba_sql_quarantine V$SQL_TESTCASES DBA_REGISTRY_BACKPORTS
Read MoreNew 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 MoreSQL> Startup upgrade ORACLE instance started. Total System Global Area 1.3262E+11 bytes Fixed Size 2304584 bytes Variable Size …
Read MoreOracle allows columns to be hidden from application. Columns can be made invisible in the CREATE TABLE statement or using an ALTER TABLE statement.By default columns are visible. Invisible columns…
Read MoreBelow script to find Oracle Application Modules are Licensed or Not. Script: SELECT fat.application_name ,fa.application_id ,fpi.patch_level ,decode(fpi.STATUS,’I’,’Licensed’, ‘N’,’Not Licensed’,’S’,’Shared’,’Undetermined’) STATUS ,fpi.* FROM fnd_product_installations fpi ,fnd_application fa ,fnd_application_tl fat WHERE fpi.application_id…
Read MoreBelow script to find the OPP log file location in oracle E-Business Suite. Script: SELECT fcpp.concurrent_request_id req_id, fcp.node_name, fcp.logfile_name FROM fnd_conc_pp_actions fcpp, fnd_concurrent_processes fcp WHERE fcpp.processor_id = fcp.concurrent_process_id AND fcpp.action_type…
Read MoreEdition Based Redefinition (EBR) is a new feature introduced from Oracle Software Version 11g R2.Edition-based redefinition allows multiple versions of PL/SQL objects, views and synonyms in a single schema.This feature…
Read MoreWe can find the weblogic URL and port from the CONTEXT_FILE by using the below variable. Steps: 1. Go to Application Tier 2. Set the RUN file system environment. 3.…
Read MoreSELECT e.owner, e.segment_type, e.segment_name, e.partition_name, c.file# , greatest(e.block_id, c.block#) corr_start_block# , least(e.block_id+e.blocks-1, c.block#+c.blocks-1) corr_end_block# , least(e.block_id+e.blocks-1, c.block#+c.blocks-1) – greatest(e.block_id, c.block#) + 1 blocks_corrupted , null description FROM dba_extents e, v$database_block_corruption…
Read More