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

Using Index-Organized Tables in Oracle 02/13/2017

Index-organized tables can provide great benefits if used properly.  Read on to see how to use them and what you might run into if conditions aren't ideal.

Calculating Elapsed Time For Queries In Oracle 01/30/2017

An AWR report isn't the only source for total elapsed time for a query.  Read on to see how to use the AWR data to compute these times on demand.

Oracle's pga_max_size and _pga_max_size Control Two Different Areas 01/12/2017

Oracle has two PGA size parameters that look the same but aren't.  Read on to see what areas each covers and why you can't get them confused.

Oracle’s Automatic Listener Registration 12/19/2016

Oracle databases auto-register with current listeners, but what if  you don’t want that to happen?  Read on to see how automatic listener registration can be stopped until you want it to happen.

Is Oracle’s SYS_GUID A Good Choice For A Primary Key? 12/12/2016

Using Oracle’s generated SYS_GUID() values is an option for creating unique primary key values.  Read on to see if it’s better than using a traditional sequence.

Storing Numbers As Strings In An Oracle Database 11/21/2016

It’s interesting to note that sometimes VARCHAR2 fields are used to store numbers.  Read on to see why this isn’t the best practice and how to get around the sorting issue if you can’t change the table.

Little-Known Exceptions in  Oracle’s PL/SQL 11/14/2016

It’s interesting to note that sometimes VARCHAR2 fields are used to store numbers.  Read on to see why this isn’t the best practice and how to get around the sorting issue if you can’t change the table.

Oracle 12c In-memory Column Store Has An Unexpected Surprise 10/31/2016

Oracle’s in-memory column store in 12.1 can provide better performance for large data sets.  Read on to see the added ‘bonus’ it can provide.

A New Way To Pattern Match In Oracle 12c 10/13/2016

Oracle 12c offers a new way to match patterns in your data, the MATCH_RECOGNIZE function.  Read on to see the syntax and the function in action.

Hybrid Histograms in Oracle 12c 09/26/2016

The right statistics and histograms can provide improved performance for queries and reports.  Read on to find out about Oracle’s new Hybrid histogram.

The Oracle Bug That Could Bite You Has No Teeth 09/12/2016

In a previous article Oracle declared bug 24390197 shouldn’t be; it’s the normal behavior for locally managed tablespaces with system-managed extents. Read on to see the details.

This Oracle Bug Could Bite You 08/29/2016

In Oracle 11.2.0.4 creating a table may fail even though space is available.  Read on to see the conditions that can make this happen.

Index Sanity in Oracle 08/11/2016

Careful testing and planning are crucial when deciding if an index is truly ‘unused’.  Read on to see what could happen if testing isn’t thorough.

Is Your Oracle Invisible Index REALLY Invisible? 07/25/2016

If you’re using invisible indexes, they may not be entirely ‘invisible’ to the optimizer. Read on to see why.

Returning The Actual DOP When Using Oracle’s Auto Degree Of Parallelism 07/14/2016

Without having an execution plan it’s difficult to know the degree of parallelism Oracle has selected.  Read on to see how that can be reported.

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