Oracle database management, tutorials, scripts, coding, programming and tips for database administrators
Oracle has provided a new setting, local_temp_tablespace, for RAC installations. Read on to see what this does and how it can end up being set incorrectly.
With some ports of Oracle 12.2, attempting to set ddl_lock_timeout at the session level can throw an ORA-00068. Read on to see one way this can be fixed.
Keeping data secure also means keeping it obscured should a breach occur. Read on to see how Oracle's Transparent Data Encryption can keep that data from prying eyes.
The cursor_sharing=force setting is designed to substitute system-generated bind variables for literals, but there are cases where not all literals are replaced. Read on to see when this can occur.
Many organizations are looking at the prospect of a technology migration, where capabilities are moved to a new set of technologies, supporting and enabling the business of the future. Anoop Kumar lays out the steps that can be followed to migrate an on-premise Oracle database to the SQL Server cloud database, Azure SQL Database.
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 126.96.36.199 you may find that scripts that scan the alert log stop working. Read on to see why and how to address the issue.