Oracle Administration Support Tutorials - Database Journal

Sometimes the obvious isn't when it comes to query performance; that's when event 10053 …

Oracle has provided a new setting, local_temp_tablespace, for RAC installations. …

With some ports of Oracle 12.2, attempting to set ddl_lock_timeout at the session level …

Keeping data secure also means keeping it obscured should a breach occur. Read on …

The cursor_sharing=force setting is designed to substitute system-generated bind …

Many organizations are looking at the prospect of a technology migration, where …

Although documented, the ASCIISTR() function may return 'interesting' results …

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 …