NLS_TIMESTAMP_FORMAT

NLS_SESSION_PARAMETERS, How and Why

by Ed Chen
July 18, 2023July 24, 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, 2023June 19, 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, 2023June 19, 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 »

How to Resolve ORA-13780: SQL statement does not exist

by Ed Chen
February 7, 2023February 8, 2023

ORA-13780 Tried to create a SQL tuning task for specific SQL ID, but it failed with ORA-13780. SQL> select DBMS_SQLTUNE.CREATE_TUNING_TASK ( sql_id => '21zq47mj49f7w', scope… Read More »

How to Check Oracle Database Startup Time

by Ed Chen
September 17, 2021April 15, 2023

Startup Time Varies To check Oracle database startup or restart time, we have to know the difference between instance startup time and database open time.… Read More »

NLS_LANG, How and Why

by Ed Chen
September 7, 2019April 26, 2023

In this post, I'll talk about 3 major topics about NLS_LANG. What is NLS_LANG? How to Set NLS_LANG in Oracle? What are Available Values of… Read More »

How to Move Oracle Database

by Ed Chen
January 23, 2019May 31, 2023

Actually, this topic "How to Move Oracle Database" follows my previous post: How to Move ORACLE HOME. But I think it can be used in… Read More »

How to Create a 9i Database by DBCA with Silent Mode

by Ed Chen
December 3, 2012February 8, 2023

In my experience, to create a new database by DBCA with silent mode in a 9i database on Linux, you must issue the dbca command… Read More »

How to Create a 11g Database by DBCA with Silent Mode

by Ed Chen
December 1, 2012September 7, 2023

Creating a database by DBCA is easier than scripts. But there will be less control over the database details, thus, some incompatible parameters with your… Read More »

Creating a 11g Database Manually by Scripts (2/3) - Create and check the new database

by Ed Chen
November 29, 2012February 8, 2023

Creating a 11g Database Manually by Scripts (1/3) - Prepare three files for creating the new databaseWhen the three files are ready, we can use… Read More »

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