Initialization Parameter

DB_CREATE_ONLINE_LOG_DEST_n, How and Why

by Ed Chen
November 6, 2023November 16, 2023

DB_CREATE_ONLINE_LOG_DEST_n is a set of server parameters which specify the default destination where new Oracle-managed redo log files (OMF) should be placed. More precisely, DB_CREATE_ONLINE_LOG_DEST_n… Read More »

DB_CREATE_FILE_DEST, How and Why

by Ed Chen
November 2, 2023November 12, 2023

DB_CREATE_FILE_DEST is a server parameter which specifies the default destination where new Oracle-managed data files (OMF) should be placed. In this post, we'll talk about… Read More »

JOB_QUEUE_PROCESSES, How and Why

by Ed Chen
September 21, 2023November 12, 2023

JOB_QUEUE_PROCESSES is an initialization parameter which controls the maximum number of processes of scheduler jobs in an instance. In this post, we'll talk about the… Read More »

Oracle Parameter SESSIONS, How and Why

by Ed Chen
May 31, 2023November 12, 2023

In this post, we'd like to talk about the following topics for you to manage SESSIONS parameter better. Default Value of SESSIONS How to Check… Read More »

How to Set NLS_LENGTH_SEMANTICS Temporarily

by Ed Chen
May 19, 2021December 17, 2021

NLS_LENGTH_SEMANTICS Let's see what NLS_LENGTH_SEMANTICS of the database currently set. SQL> conn hr/hr@orclpdb Connected. SQL> show parameter semantics; NAME … Read More »

Complete Oracle 19c Initialization Parameters List in DBCA

by Ed Chen
October 31, 2020January 19, 2023

The complete list is shown during creating a 19c RAC database by DBCA.

How to Resolve ORA-01000: maximum open cursors exceeded

by Ed Chen
January 15, 2020December 10, 2022

ORA-01000 Saw an error ORA-01000 when executing a lot of statements. It seemed that the number of open cursors has reached the limitation. ORA-01000: maximum… Read More »

How to Resolve ORA-02085: database link SOURCE_LINK connects to SOURCE_DATABASE

by Ed Chen
December 19, 2016November 11, 2023
6 Comments

ORA-02085 I created a database link without any problem. But when I tried to test the link, I got ORA-02085. SQL> select sysdate from dual@source_link;… Read More »

UNDO_RETENTION, How and Why

by Ed Chen
April 7, 2016November 12, 2023

UNDO_RETENTION At times, you may find out or feel that UNDO_RETENTION is useless at all. Raising the number of seconds cannot resolve ORA-01555. This is… Read More »

Timings to Set SESSIONS Explicitly

by Ed Chen
July 5, 2014May 17, 2019

DBAs usually set PROCESSES when initializing a new database:SQL> alter system set processes=3000 scope=both;System altered.Another important parameter SESSIONS will be derived from PROCESSES automatically in this… Read More »

JavaScript is not enabled. Please enable it and reload the page.