How and Why

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 »

DATABASE_PROPERTIES, How and Why

by Ed Chen
August 17, 2023November 12, 2023

DATABASE_PROPERTIES DATABASE_PROPERTIES is a data dictionary view which is able to describe the nature of a database by collecting its permanent properties Let's see standard… Read More »

PDB_PLUG_IN_VIOLATIONS, How and Why

by Ed Chen
August 3, 2023November 12, 2023

PDB_PLUG_IN_VIOLATIONS PDB_PLUG_IN_VIOLATIONS is a dictionary view for displaying incompatible information or violations about the PDB to the CDB which it plugs in. Usually, we use… Read More »

NLS_SESSION_PARAMETERS, How and Why

by Ed Chen
July 18, 2023November 12, 2023

What is NLS_SESSION_PARAMETERS ? NLS_SESSION_PARAMETERS is a dictionary view which shows all current NLS parameters of an user's session. Let's see their values. SQL> set… Read More »

NLS_INSTANCE_PARAMETERS, How and Why

by Ed Chen
July 17, 2023November 12, 2023

What is NLS_INSTANCE_PARAMETERS ? NLS_INSTANCE_PARAMETERS is a dictionary view which shows default NLS parameters of an instance. Let's see their values. SQL> set pagesize 1000;… Read More »

NLS_DATABASE_PARAMETERS, How and Why

by Ed Chen
July 14, 2023November 12, 2023

What is NLS_DATABASE_PARAMETERS ? NLS_DATABASE_PARAMETERS is a dictionary view which shows default NLS parameters of a database. Let's see their values. SQL> set pagesize 1000;… Read More »

TABLE_EXPORT_OBJECTS, How and Why

by Ed Chen
July 13, 2023November 12, 2023

TABLE_EXPORT_OBJECTS To INCLUDE or EXCLUDE specific object type in exporting or importing tables, you should know what name of object type should be used. To… Read More »

SCHEMA_EXPORT_OBJECTS, How and Why

by Ed Chen
July 12, 2023November 12, 2023

SCHEMA_EXPORT_OBJECTS To INCLUDE or EXCLUDE specific object type in exporting or importing schemas, you should know what name of object type should be used. To… Read More »

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