Oracle database management, tutorials, scripts, coding, programming and tips for database administrators
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 may be more 'expensive' than the Oracle optimizer reports; read on to see why.
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.
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.
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.
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 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.
In Oracle 184.108.40.206 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.
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.
Using the utlrp.sql script when Edition-based Redefinition is enabled can cause the recompile process to terminate with an ORA-00600 error in 220.127.116.11. Read on to see why this can happen.
Oracle 18.104.22.168 can throw an ORA-01438 when importing an interval partitioned table. Read on to learn a work-around until Oracle patches the bug.
New licensing for Oracle’s SE family line significantly lowers value to the enterprise.
RMAN in Oracle version 22.214.171.124 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 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.
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.