Oracle database management, tutorials, scripts, coding, programming and tips for database administrators
Database tables are not static entities and sometimes changes can wreak havoc on packages and procedures. Read on to see how Oracle's expand_sql_text can help solve such issues.
Learn of possible scenarios to monitor changes when replicating Oracle. Read on to discover the best course of action for moving forward!
If you are wanting to manipulate numeric data with mathematically, then you will wan tot read on to get an overview of the core SQL numeric functions
The Streams pool is used by more than just Streams. Read on to see what else uses it and what you could expect when streams_pool_size is set to 0.
LogMiner can be used to find data changes based on time or SCN and can be used to find only the most recent changes. Read on to see how this can be accomplished.
Referential constraints ensure data integrity, but in at least one case can cause occasional problems. Read on to see what can happen and why it can occur...
If there is a reasonable chance that parallel execution can occur, then you'll want to read on about the latch event!
Timestamp with Oracle Time Zone columns exhibits 'interesting' behavior with respect to unique indexes and primary keys. Read on to see the issue and one possibly confusing way to handle it!
Recently Oracle has updated its JSON functionality in the database and that may present unexpected issues. Read on to see what changed and how it could affect results.
Transactions using NOLOGGING can make a database unusable if recovery is necessary. Read on to see why and how to protect the database from unrecoverable transactions.
Does a single-column primary key need a histogram? That may not be as silly of a question as might appear. Read on to find out why.
Changes in the way Oracle sets the flag value for the UNDO tablespace in version 12.x make the output from DBA_TABLESPACE_USAGE_METRICS either incomplete (12.1) or missing (12.2). Read on for more information.
With Oracle's Automatic Memory Management the spfile is updated with some interesting settings. Read on to see what the settings are and what they do.
IBM’s machine learning is being used to improve the performance of analytical queries as well as operational queries and their associated applications. This requires management attention, as you must verify that your business is prepared to consume these ML and AI conclusions. Learn more…
Whether it's a bug or by design Oracle's 1000-element in-list restriction isn't always enforced. Read on to see what conditions can bypass this limitation.