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

» Database Journal Home
» Database Articles
» Database Tutorials
MS SQL
Oracle
DB2
MS Access
MySQL
» RESOURCES
Database Tools
SQL Scripts & Samples
Links
» Database Forum
» Slideshows
» Sitemap
Free Newsletters:
DatabaseDaily  
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

Oracle

Re-thinking SQL Queries Using Sets in Oracle 04/28/2016

Sometimes it's good to re-think how to write a query; set operations can provide performance benefits over 'straight SQL'.  Read on to see an example of this in action.

Deletes In Oracle: More 'Costly' Than You Think 04/21/2016

Deletes may be more 'expensive' than the Oracle optimizer reports; read on to see why.

Oracle 12c Table Point-in-time Recovery 03/28/2016

There may be times when you need to recover a single table and flashback isn't configured and the recycle bin is turned off. Using RMAN in Oracle 12c it's possible to restore and recover a single table. Read on to see how it's done.

Partition Limits In Oracle 03/14/2016

Partitioning can be a real asset when used properly, as long as you don't run afoul of the maximum number of partitions Oracle will allow.  Read on to learn the maximum number of partitions and discover some of the errors you can see if you try to exceed the limit.

The One 'Security' Feature in Oracle You Probably Shouldn't Use 02/29/2016

Oracle offers a number of security-related settings, but one could definitely create more harm than good.  Read on to see which parameter that is, and why.

Unique Records In Oracle 02/11/2016

There are several ways to ensure unique records in an Oracle table, but are some better than others?  Read on to see how each method compares.

Oracle's ANSI Join Syntax Can Result In Wrong Results 01/21/2016

Oracle can still have issues with ANSI join syntax, producing sub-optimal translations and possibly wrong results.  Read on to see how Oracle processes ANSI join syntax and how that translation process can create some problems.

Memory Leak in 11.2.0.1 on AIX: Shared Cursors Are Not Behaving 01/11/2016

In Oracle 11.2.0.1 shared cursor memory in some subpools can increase dramatically over time, resulting in having to restart the database.  Read on to see how this was discovered and how to check the subpool memory allocations.

Function-based Index on LOB Columns and Oracle's SQL*Loader 12/28/2015

SQL*Loader can fail to load LOB data when function-based indexes are present on the LOB columns.  Read on to learn more and work around the issue.

Oracle's utlrp.sql Script and Edition-based Redefinition 12/17/2015

Using the utlrp.sql script when Edition-based Redefinition is enabled can cause the recompile process to terminate with an ORA-00600 error in 12.1.0.2.  Read on to see why this can happen.

Oracle Error When Importing An Interval Partitioned Table 11/30/2015

Oracle 12.1.0.2 can throw an ORA-01438 when importing an interval partitioned table. Read on to learn a work-around until Oracle patches the bug.

Is It Time to Move from Oracle Database Standard Edition 2 or Enterprise Edition? 11/19/2015

New licensing for Oracle’s SE family line significantly lowers value to the enterprise.

Tivoli and RMAN in Oracle 11.2.0.3 11/12/2015

RMAN in Oracle version 11.2.0.3 is sending incorrect information to the Tivoli MML process, resulting in backup files that are larger than expected, filling the storage pool and causing the backups to fail.

Extended Statistics and Oracle 12c 10/26/2015

Extended statistics can provide better plans by recognizing correlated columns in a table.  Oracle 12c makes those statistics easier by providing an automatic way to generate them.  Read on to see how this can provide better plans.

The Oracle PL/SQL Results Cache 10/08/2015

Oracle's PL/SQL provides a results cache, and it works fairly well.  Problems can arise when multiple sessions are using it.  Read on to see what those problems are.

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