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 Access
Database Tools
SQL Scripts & Samples
» Database Forum
» 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


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

Skipping Schema DML in an Oracle 11.2 Logical Standby Database 10/13/2014

Skipping DML for one or more schemas isn't as simple as you might think.  Read on to see what steps are necessary to avoid ORA-02149 errors and keep the logical standby synchronized.

Oracle: Can a NULL sql_id Use CPU? 09/29/2014

Oracle can exhibit 'strange' behavior with the sql_id values in V$SESSION, but just because the sql_id is NULL that doesn't mean Oracle isn't processing a long-running statement.

Oracle Bloom Filters 09/11/2014

In Oracle releases 10.2.0.x and later join processing can be made more efficient by the use of Bloom filters, primarily to reduce traffic between parallel query slaves. Read on to learn more.

Oracle: Is Parallel Really Necessary? 08/25/2014

You're running processes in parallel; is it really faster?  Sometimes it may not be; read on to see why parallel processing may be creating more work than you'd expect.

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