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
» 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

Bulk Exceptions in Oracle 05/14/2015

When using BULK COLLECT it's possible to see all of the exceptions thrown for the bulk collection by coding the exception handler properly.  Read on to see how to implement such an exception handler.

Cartesian Joins in Oracle: The Nullable Column Problem 04/27/2015

NULL values in a table can cause Oracle to decide to use a Cartesian join with large data sets.  Read on to see one way this can be addressed.

More Than Oracle Knows What To Do With 04/13/2015

In Oracle 12c an interesting problem arises with ANSI joins, star expansion and tables with 500 columns or more.  Read on to find out what happens and how you can work around the problem.

Hitting The Oracle Target 03/30/2015

SGA and PGA management can be confusing.  Oracle can make it easier with two views that provide advice on how to set the associated parameters.  Read on to see what those views are and how to read the data.

CBO, Analytic functions and Cardinalities in Oracle 11.2 03/12/2015

In Oracle 11.2 using analytic functions can generate 'interesting' cardinality values that are far larger than they should be.  Read on to see just how far off those values can be.

My Oracle Cup Overflows 02/23/2015

Overflow data in an index-organized table is usually put in its own tablespace.  Sometimes it isn't; read on to see what overflow data is and how to change where it's located.

Oracle: MERGE 'Monkey-business' 02/12/2015

Odd errors can result in odd 'solutions', and Oracle has one for the MERGE statement.  Read on to see what it is and what it fixes.

Oracle: The Nuts And Bolts Of Basic Compression 01/26/2015

Oracle provides several levels of compression, with BASIC compression requiring no additional license cost. Read on to find out how this level of compression works and what you may expect when using it.

Oracle: Too Much Time On Your Hands? 01/15/2015

Using parallel query can improve performance in some cases but AWR reports can report too much elapsed time when they are used.  Read on to see why and how you can get the actual elapsed time in those cases.

Problem Solving, Oracle-Style 12/29/2014

Some problems can appear to be more difficult than they are.  Read on to see how changing how you think about a problem can open up new ways to solve it.

Do You Really Need Oracle Optimizer_index_cost_adj Set? 12/11/2014

Performance is the watchword with a database and indexes can be a major part of that performance equation.  Oracle provides the optimizer_index_cost_adj parameter but do you REALLY need to set it differently than the default?  Read on to see what may happen when you do.

How to Maintain Enterprise-Level Service with Oracle Standard Edition 11/26/2014

For business executives looking to save on information technology costs, it may seem like a win-win scenario in Oracle database environments to transition from Oracle Enterprise to Standard Edition. However, executives making this decision may not always be aware of or truly understand how transitioning from Enterprise to Standard Edition will affect the delivery of critical IT services, ultimately creating the potential to impact end user efficiency and revenue.

Oracle: Can Adaptive Cursor Sharing Plans Depend On Execution Order? 11/24/2014

Adaptive cursor sharing is a great feature that can tailor execution plans to bind variable values.  Read on to see how it behaves when query order is reversed and if it chooses 'bad' execution plans.

Oracle: Deferred Segment Creation And Tablespace Restrictions 11/13/2014

Oracle offers Deferred Segment Creation for tables and indexes, which allows users with no access to a tablespace to create tables and indexes successfully.  Read on to see why this is a problem.

Oracle In-Memory Database: The Bloom Filter Example Re-visited 10/27/2014

Bloom filters can improve performance in recent Oracle releases, but Oracle 12.1.0.2 provides the In-Memory Database option and using that configuration can improve performance even further.  Read on to see how the in-memory option is configured and the performance it provides.

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













Thanks for your registration, follow us on our social networks to keep up-to-date