Oracle database management, tutorials, scripts, coding, programming and tips for database administrators
Troubleshooting and tuning PL/SQL packages, procedures and functions can be a daunting task. Read on to see how DBMS_PROFILER can make that job easier.
It may not be obvious, but some aspects of Unified Auditing only register audit trails for privileged users. Read on to see which areas won't generate audit trails for conventional users.
It may not be an easy switch to the 126.96.36.199 listener if you have static registration configured. Read on to see why.
Oracle's UNDO tablespace should be simple to manage but using Autoextend may not be the wisest choice. Read on to see why.
Using Bulk Collect with the Limit clause may not process all of the data in the result set. Read on to see why and how the problem can be avoided.
It may be necessary to monitor the usage and storage of the TEMP tablespace. Read on to see how to implement a monitoring strategy that makes sense.
Upgrades to the newest Oracle release can create problems depending upon the database configuration. Read on to see what types of issues can arise and how to address them.
If in-memory isn't available to you there may be another option: automatic big table caching. Read on to see how to configure this feature and what it can do for you.
Big tables can be cached automatically by Oracle as long as certain criteria are met. Read on to see how to configure this feature and what might be standing in your way.
Large transactions can take considerable time to rollback once they are stopped. Read on to see how to monitor rollback progress from another session.
Running procedures and functions outside of the package context can cause issues, especially with dependencies. Read on to see how ACCESSIBLE BY can prevent 'unauthorized' access to procedures and functions.
Parallel query buffers can be numerous and, as a result, may wait for an allocation latch. Read on to see why larger parallel degree settings are more likely to encounter this latch.
Execution plans can be very helpful when diagnosing problems but be careful how you generate them as autotrace can lie to you. Read on to see how to generate reliable execution plans.
Sometimes it's possible to track down an object causing an en-queue wait from an ASH report. Read on to see how such an investigation begins and what information may be available.
Mutexes differ from latches in a number of ways. Read on to see how they differ from latches, what modes they can be acquired in, and their relative efficiency compared to latches.