Oracle database management, tutorials, scripts, coding, programming and tips for database administrators
Over the years Oracle backup and recovery has changed significantly, from manual backups to the most recent version of RMAN. Read on to see where we were and where we are now.
Monitoring tablespace space is a constant, yet necessary, task. It's changed over the years and releases, so read on to see how it used to be done and what new views are available to make the task easier.
According to Jonathan Lewis: "Stoptimisation - the art of optimization by not doing the things you don't need to do." Read on to see what things you may be doing that you shouldn't be doing.
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.
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.
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.
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.
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.
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.
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 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.
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.
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.
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.
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.