As organizations evaluate the benefits of moving legacy or non-standard databases to enterprise-grade platforms, one recurring challenge persists: how to quantify whether a migration is truly worth the effort. Subjective opinions and technical assumptions often cloud decision-making, leaving businesses uncertain…
I’ve been a long time fan of running containers to quickly spin up a developer environment unfortunately my preferred dev platform is MacOS on the new Apple Silicon based MacBooks (maybe you see where this is going…). In order to…
If you don’t care about being notified each and EVERY time a disk is ejected from MacOS, run the following command. sudo defaults write DADisableEjectNotification -bool YES;sudo pkill diskarbitrationd
I’ve had relative success running Docker x86-64 containers on my M2 MacBook with the following procedure: Run docker on Apple Silcon with hacks Prerequisite /bin/bash -c “$(curl -fsSL )” Install Steps Single Command brew install docker; brew install docker-compose; brew…
This!!! This is SOOOOO simple and easy I’m really surprised it’s not part of Finder’s default Services. To install, download the file from here and let Automator install the workflow. From that point you can highlight a file in Finder,…
I recently needed to dynamically set an environmental variable from reading the Oracle Inventory XML file. Typically you can find your Oracle Inventory location by looking here on Linux or here on Solaris. You should see the inventory_loc…
Database design is hard…seriously… If you need to modify a table after you’ve rolled it into production DBMS_REDEFINITION can really save you! Here’s a little example that shows taking a non-partitioned table and adding interval partitioning to it. Enjoy!
Here’s a quick and simple script to help migrate a database over to Automatic Storage Management (ASM). The script implements the Oracle Documentation found here: You can download the script from GitHub here:
This is one of those topics that EVERYONE has a different take on and here’s mine! Using the LS_TABLE external table that you can find here you’ll be able to loop through all the files in a directory and load them into…