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
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
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