Oracle Administration Support Tutorials - Database Journal

Using Oracle VM can be a fast and reliable way to create dev and test environments. …

Patching an Oracle installation can be interesting, especially if the patch needs to be …

Since Solaris is soon to be unsupported the x86 platform may be a desirable …

There may be some still using conventional export (exp); with Oracle 12 that may not be …

The GDPR offers pseudonymization as a protection technique for personal data. …

Tables with 255 or more columns are not uncommon but Oracle introduces some interesting …

It may no longer be true that an on-premises database is faster than one in the …

With the explosion of cloud-based applications and database services, it might be wise …

When upgrading an Oracle database to version 12.2.0.1 you may find that scripts that …

Troubleshooting and tuning PL/SQL packages, procedures and functions can be a daunting …

It may not be obvious, but some aspects of Unified Auditing only register audit trails …

It may not be an easy switch to the 12.2.0.1 listener if you have static registration …

Oracle's UNDO tablespace should be simple to manage but using Autoextend may not be the …

Using Bulk Collect with the Limit clause may not process all of the data in the result …

It may be necessary to monitor the usage and storage of the TEMP tablespace. Read …