Oracle Parameter SESSIONS, How and Why
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 »Oracle Parameter SESSIONS, How and Why
Initialization Parameter
How to Set NLS_LENGTH_SEMANTICS Temporarily
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 »How to Set NLS_LENGTH_SEMANTICS Temporarily
Complete Oracle 19c Initialization Parameters List in DBCA
The complete list is shown during creating a 19c RAC database by DBCA.
How to Resolve ORA-01000: maximum open cursors exceeded
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-01000: maximum open cursors exceeded
How to Resolve ORA-02085: database link SOURCE_LINK connects to SOURCE_DATABASE
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 »How to Resolve ORA-02085: database link SOURCE_LINK connects to SOURCE_DATABASE
UNDO_RETENTION, How and Why
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 »UNDO_RETENTION, How and Why
Timings to Set SESSIONS Explicitly
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 »Timings to Set SESSIONS Explicitly
How to Resolve ORA-00845: MEMORY_TARGET not supported on this system
If you are planning to install additional database by DBCA on a Linux server, you should notice not only the limitation of semaphores, but also… Read More »How to Resolve ORA-00845: MEMORY_TARGET not supported on this system
BYTE vs CHAR in NLS_LENGTH_SEMANTICS
BYTE vs CHAR in NLS_LENGTH_SEMANTICS Most of databases set NLS_LENGTH_SEMANTICS as BYTE by default, but there are some databases in Non-English country will take CHAR… Read More »BYTE vs CHAR in NLS_LENGTH_SEMANTICS
How to Resolve ORA-02097: Parameter Cannot be Modified Because Specified Value is Invalid
When you ALTER SYSTEM to modify an initialization parameter, it sometimes fails with ORA-02097 ORA-02097: parameter cannot be modified because specified value is invalid Reproduce… Read More »How to Resolve ORA-02097: Parameter Cannot be Modified Because Specified Value is Invalid