Search for a command to run...
Articles tagged with #oracle-database
I was investigating the code that looked something like this: truncate table t1; for i in 1..300 loop insert /*+ append */ into t1 select 1 from dual connect by level <= p_connect_by_level;
LOBs can be stored as either BasicFiles or as SecureFiles. While both storage types are still supported in 19c, let me start by a quote from 12.1 documentation: SecureFiles is the default storage mec
I was investigating an issue where there were a lot of user logins to Oracle database via listener due to misconfigured connection pool. This post explains why many logins could be a problem. Most would first think of the cost of process creation, me...
In a previous post, I explored implementing asmfs using dbms_diskgroup.read(). Since then, asmfs (my open source GitHub project) has gained a new capability: reading files stored in Oracle ASM by directly accessing block devices. Rather than needing ...
When recompiling invalid objects—often after patches, upgrades, or invalid dependency chains—you might call utl_recomp.recomp_serial. Since it's a serial procedure, one could reasonably expect it to avoid any parallel or background job interaction. B...
We've just migrated one of the last databases to 19c. The main area of concern for the client was that they were using rather old embedded devices, which had 11g client libraries and connect strings baked into their firmware. Here's the list of the m...
