Oracle database management, tutorials, scripts, coding, programming and tips for database administrators
Although documented, the ASCIISTR() function may return 'interesting' results depending on the characters translated. Read on to see what problems this can cause and a possible fix.
Using Oracle VM can be a fast and reliable way to create dev and test environments. Read on to see how this can be done and how it can help migrate databases from other operating systems.
Patching an Oracle installation can be interesting, especially if the patch needs to be backed out. Read on to see how to create a process that preserves the original home.
Since Solaris is soon to be unsupported the x86 platform may be a desirable choice. Read on to see how to make the transition easier.
There may be some still using conventional export (exp); with Oracle 12 that may not be a good idea. Read on to see why.
The GDPR offers pseudonymization as a protection technique for personal data. Read on to see what pseudonymization is and why it can be difficult to implement.
Tables with 255 or more columns are not uncommon but Oracle introduces some interesting performance changes when dealing with them. Read on to see what can happen for such tables.
It may no longer be true that an on-premises database is faster than one in the Cloud. Oracle Cloud offerings are varied, so read on to see the available options to migrate to the cloud.
With the explosion of cloud-based applications and database services, it might be wise to consider backing up local databases to the Oracle cloud. Read on to see how to configure and execute such backups.
When upgrading an Oracle database to version 220.127.116.11 you may find that scripts that scan the alert log stop working. Read on to see why and how to address the issue.
Troubleshooting and tuning PL/SQL packages, procedures and functions can be a daunting task. Read on to see how DBMS_PROFILER can make that job easier.
It may not be obvious, but some aspects of Unified Auditing only register audit trails for privileged users. Read on to see which areas won't generate audit trails for conventional users.
It may not be an easy switch to the 18.104.22.168 listener if you have static registration configured. Read on to see why.
Oracle's UNDO tablespace should be simple to manage but using Autoextend may not be the wisest choice. Read on to see why.
Using Bulk Collect with the Limit clause may not process all of the data in the result set. Read on to see why and how the problem can be avoided.