(Frits Hoogland) This post is about library cache SQL cursors, and how these are managed by the database instance.
Tag: Oracle
How to disable and enable archive log in Oracle RAC
(Anuradha Mudgal) After the core DBA, continue our journey towards RAC environment. Today we are going to explore the steps use for “How to disable and enable archive log in oracle RAC“
Oracle 19c Automatic Indexing: Mixing Manual and Automatic Indexes Part I (I Can’t Read)
(Richard Foote) In previous articles, I discussed how Automatic Indexing has the capability to add columns or reorder the column list of previously created Automatic Indexes. However, how does Automatic Indexing handle these types of scenarios with regard to existing manually created indexes?
Design Tips for Query Rewrite
(Dani Schnider) Although Query Rewrite on Materialized Views is a powerful feature which is available in Oracle databases for a long time, it is rarely used.
Dissecting 200414 BP, PSU, RU and RUR
(Rodrigo Jorge) I am quarterly writing a post dissecting the changes implemented by Oracle CPUs so we can understand better the modifications implemented by Oracle in our Databases.
Oracle WebLogic Server 14.1.1.0.0 Docker Image
(Dirk Nachbar) As since around 2 days the latest Oracle WebLogic Server 14.1.1.0.0 was released, I had some time to create Docker Images for the Oracle WebLogic Server 14.1.1.0.0
How to configure Shared server mode
(Anuradha Mudgal) Today we are going to explore the steps to use for configure Shared server mode. Let’s follow the steps. We need to set the init parameters
Mapping Azure and Oracle Cloud Infrastructure core concepts – Part One
(Lucas Jellema) All major public clouds are organized in similar ways. However, terms used for certain similar constructs can be (quite) different, or the same terms are used for quite different constructs.
Fixed issue with DBA_HIST_SQLSTAT script
(Bobby Durrett) I got rid of the old sqlstat.sql, sqlstat2.sql and sqlstat3.sql scripts in my GitHub repository and fixed an issue that was in sqlstat3.sql.
Far Sync, Redo routes and Priorities with alternates
(Pieter Van Puymbroeck) Far Sync is a great technology. When implementing a Disaster Recovery (DR) scenario, the first remark is usually “We want zero Data Loss”. This is exactly what Data Guard is meant for in Synchronous mode.