You query V$INSTANCE_RECOVERY view and consistently receive an OPTIMAL_LOGFILE_SIZE value that is greater than the size of your smallest online redo log file. The OPTIMAL_LOGFILE_SIZE column of the V$INSTANCE_RECOVERY view can be used to determine the appropriate size for all of the online redo log files in your database. If the value of the OPTIMAL_LOGFILE_SIZE […]
You use the DBMS_RESOURCE_MANAGER package to create a CDB resource plan and define the directives for the plan. Then, from the root container of your CDB connects as the SYS user. Then, create a pending area using the CREATE_PENDING_AREA procedure. After the pending area has been completed, you use the CREATE_CDB_PLAN procedure to create the […]
Starting in Oracle Database 12c, the multithreaded Oracle model enables specific Oracle processes to execute as operating system threads in separate address spaces. Setting up an Oracle database instance for using multi-process multi-thread architecture is done by starting up the Oracle database instance with the THREADED_EXECUTION initialization parameter set to TRUE. The multi-process multi-thread model […]
Today, 18th January 2022, The Database patch bundles were released. All the details on MOS in Doc ID 19202201.9 and Doc ID 21202201.9 are recommended to be installed on production systems.
In 19c or higher, it is no longer necessary to enable ‘Shared Servers’ on the catalog database, so Oracle recommends that (if you are using Oracle Native Encryption with sharding) you disable Shared Servers on the catalog database. This can be done by setting the database parameter shared_servers to “0” and restarting Oracle. Note that […]
Oracle Groundbreakers EMEA 2021 http://ogbemea.com/speakers-2021/#ARSALAN Michigan Oracle Users Summit 2021 – https://www.mous.us/MOUS_2021_Final_Agenda.htm
Oracle Machine Learning for R (OML4R) is an R API that makes the open-source R statistical programming language and environment ready for enterprise and big data. Designed for significant data problems, OML4R integrates R with Oracle Database. R users can run R commands and scripts for statistical and graphical analyses on data stored in the […]
There have been a few issues related to the grid inter-process communication(GIPC) daemon. Since this lets redundant interconnect usage, it would produce many networks interconnect messages. Previously, I carried out a cyclic cleanup of the ‘gipcd’ related trace/logs. You can purge these huge trace files if your Clusterware is well and has no issues. If […]
Oracle Sharding on Oracle Container Engine for Kubernetes (OKE) uses StatefulSet to provide stable, unique network identifiers and stable, persistent storage so you can create and manage your Oracle Sharding replica set natively in OKE with Oracle supported helm and chart templates. In addition, data is stored on persistent volume, so all the data is […]
The paper below describes an automated system that generates, selects, verifies, and maintains materialized views in the Oracle RDBMS; it presents a novel technique, called the extended covering subexpression algorithm, for the automated generation of materialized views. An extensive set of experiments is described that demonstrates the feasibility and efficiency of this approach. This system […]