Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Tips Database Forum

» Database Journal Home
» Database Articles
» Database Tutorials
MS Access
SQL Scripts & Samples
» Database Forum
» Slideshows
Free Newsletters:


News Via RSS Feed

Database Journal |DBA Support |SQLCourse |SQLCourse2

Oracle database management, tutorials, scripts, coding, programming and tips for database administrators


Handling Disaster Recovery When Using Oracle Managed Files 01/16/2019

Standby databases are used in most, if not all, Data Recovery configurations, and init.ora files and control file creation scripts are usually generated on the primary. Read on to see why, when using Oracle Managed Files, they need to be created on the standby.

Choosing Between Oracle's Bitmap and Function-based Indexes 12/26/2018

Oracle provides two ways to create an index that can reliably be used with nulls; a bitmap index and a function-based index. In this article, you will learn when each is applicable and see them in action!

Improvements in Oracle's Join Elimination 12/13/2018

Occasionally a join using primary key columns in a query can be eliminated because of the data involved.  In Oracle 12.2 and later, multi-column primary keys can be used to do this; however, there are cases where the join elimination is not complete . In this article, you'll see an example that illustrates these points.

A GUI Might Not Be An Oracle DBA's Best Friend 11/20/2018

Oracle DBAs should know how Oracle behaves and should also be able to address issues without the aid of a flashy graphical user interface (or GUI). Are you a DBAs who would be lost without applications interfaces to help you with tasks? 

Hybrid Histograms in Oracle 18 11/15/2018

iOracle version 12 introduced the hybrid histogram as a performance improvement. Learn about a change in Oracle 18 that can cause histograms to break. 

Oracle OEM Agent 13c and Perl 10/25/2018

Perl can sometimes 'misbehave' with the Oracle Enterprise Manager (OEM) agent for version 13c.  Read on to see what issues it can create and how to correct them.

Oracle Network Encryption 10/15/2018

Oracle provides a method of encrypting networked database connections, with a few caveats.  Read on to see how this  is configured and what settings will ensure encrypted communication.

Tuning Oracle Queries with an Optimizer Trace 09/24/2018

Sometimes the obvious isn't when it comes to query performance; that's when event 10053 can help.  Read on to see how to use this event to tune query performance.

Oracle's LOCAL_TEMP_TABLESPACE 09/13/2018

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.

Oracle's ddl_lock_timeout in Version 08/27/2018

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.

Oracle's Transparent Data Encryption 08/13/2018

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.

Oracle's 'cursor_sharing = force' May Not Behave as Expected 07/30/2018

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.

Steps to Migrate Oracle Database to Azure SQL Database 07/23/2018

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.

Oracle's ASCIISTR() and Unicode Characters 07/12/2018

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 to Create Dev and Test Environments 06/25/2018

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.

Oracle Archives

Latest Forum Threads
Oracle Forum
Topic By Replies Updated
Oracle Data Mining: Classification jan.hasller 0 July 5th, 07:19 AM
Find duplicates - Unique IDs Lava 5 July 2nd, 08:30 AM
no matching unique or primary key rcanter 1 April 25th, 12:32 PM
Update values of one table based on condition of values in other table using Trigger Gladiator 3 February 29th, 06:01 PM