Oracle Administration Support Tutorials - Database Journal

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 …

Upgrades to the newest Oracle release can create problems depending upon the database …

If in-memory isn't available to you there may be another option: automatic big table …

Big tables can be cached automatically by Oracle as long as certain criteria are met. …