Oracle Database: why do I see “Logon failed because the client is missing the KZTVOV_KPCLOG_O9L_LP capability flag.” in the alert.log?
Last week I got pinged with an interesting question by a user: why do I see kpolnb: Logon failed because […]
Oracle Database
PDB-modifiable Oracle Database Parameters
I got an interesting question the other day: “which Oracle Database Parameters are PDB-modifiable?”, i.e., which parameters can have different
Introducing Oracle Database 23c Free – Developer Release
Oracle Database 23c Free – Developer Release is a new, free offering of the industry-leading Oracle Database that enterprises worldwide rely on every
How to write an anonymous PL/SQL function and use it in your SQL statement
Have you ever encountered a situation when you were in the middle of writing a SQL query and thought, “if
How to cancel long-running queries in Oracle Database
This is a short blog post about a tiny little feature that you are probably unaware of but can make
Technology
Everything you always wanted to know about Oracle Database NLS_LANG and character sets
I have recently come across the Oracle Database Globalization Support again and the question of what character set is used
Technology
SOLVED: Oracle XE: ORA-00821: Specified value of sga_target is too small
tl;dr Open ${ORACLE_HOME}/assistants/dbca/templates/XE_Database.dbc with a text editor Find <InitParamAttributes><InitParams> Add the following XML tag under <InitParams>: <initParam name=”cpu_count” value=”2″/>
Introducing gvenzl/oracle-xe: Oracle Database XE Docker images
One of the things that kept me busy lately was experimenting with how much an Oracle XE database setup could
Technology
How to install Oracle Database 18c XE on Oracle Linux 8
It has been more than two and a half years since Oracle 18c XE has been released for Linux. Since