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
» Sitemap
Free Newsletters:
News Via RSS Feed

follow us on Twitter
Database Journal |DBA Support |SQLCourse |SQLCourse2

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


Does Your Oracle Table Really Need 255 or More Columns? 04/16/2018

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.

Put Your Oracle Database In the Oracle Cloud 03/26/2018

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.

Backup to the Oracle Cloud 03/12/2018

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.

Oracle 12cR2 Upgrade and the Alert Log 02/26/2018

When upgrading an Oracle database to version you may find that scripts that scan the alert log stop working.  Read on to see why and how to address the issue.

Using Oracle's DBMS_PROFILER to tune PL/SQL 02/12/2018

Troubleshooting and tuning PL/SQL packages, procedures and functions can be a daunting task.  Read on to see how DBMS_PROFILER can make that job easier.

Oracle's Unified Auditing, Part II 01/29/2018

It may not be obvious, but some aspects of Unified Auditing only register audit trails for privileged users.  Read on to see which areas won't generate audit trails for conventional users.

Static Registration and the Oracle 12.2 Listener 01/11/2018

It may not be an easy switch to the listener if you have static registration configured.  Read on to see why.

Oracle's UNDO Tablespace and Autoextend 12/26/2017

Oracle's UNDO tablespace should be simple to manage but using Autoextend may not be the wisest choice.  Read on to see why.

Oracle's Bulk Collect and Limit Can Be A Problem 12/14/2017

Using Bulk Collect with the Limit clause may not process all of the data in the result set.  Read on to see why and how the problem can be avoided.

Monitoring Oracle's Temp Usage 11/20/2017

It may be necessary to monitor the usage and storage of the TEMP tablespace.  Read on to see how to implement a monitoring strategy that makes sense.

Oracle Upgrades to 11/13/2017

Upgrades to the newest Oracle release can create problems depending upon the database configuration.  Read on to see what types of issues can arise and how to address them.

Oracle's Automatic Big Table Caching 10/30/2017

If in-memory isn't available to you there may be another option: automatic big table caching.  Read on to see how to configure this feature and what it can do for you.

Oracle's TEMP Tablespace 10/12/2017

Big tables can be cached automatically by Oracle as long as certain criteria are met.  Read on to see how to configure this feature and what might be standing in your way.

Tracking Rollback Progress in Oracle 09/25/2017

Large transactions can take considerable time to rollback once they are stopped.  Read on to see how to monitor rollback progress from another session.

Oracle's Newest PL/SQL Feature 'ACCESSIBLE BY' 09/14/2017

Running procedures and functions outside of the package context can cause issues, especially with dependencies.  Read on to see how ACCESSIBLE BY can prevent 'unauthorized' access to procedures and functions.

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