Search for a command to run...
Articles tagged with #oracle
One of the most interesting use cases for ASMFS seems to be the ability to list/read archivelogs on a remote (physical standby?) server as if they were normal local files. A quick mental image of how
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...
Today I learned that Oracle can disable the Flashback Database feature by itself automatically. Here's the reason - an excerpt from the alert log: ORA-38886: WARNING: Flashback database was disabled due to error when writing flashback database logs. ...
Here's what I've learned while trying to implement an ASMFS (which is an open-source GitHub project) and where my implementation fell short of my initial expectations. Initial Expectations I can access v$asm_file and v$asm_alias, which provide a comp...
