Concurrent request receiving Could Not Lock Request when canceling
After submitting concurrent request, the phase of the request is RUNNING and never completing. When we search for the database session, it is not having…
Read MoreMobile First strategy with Oracle CX Mobile App
Enterprise are emphasizing on building a culture of proactive sales with responsibility of identifying leads,new account openings and agility in closing deals. To achieve this, organizations are looking towards recent…
Read MoreGlobal Temporary Table ( GTT) – key facts
The data in a GTT is written to the temporary tablespace, which is not directly protected by redo, so using a GTT improves performance by reducing redo generation. Unfortunately, prior…
Read MoreOracle 12c SQL Plan Directives – Disable | Enable | Use As Hint
What is it? In previous releases the database stored compilation and execution statistics in a shared sql area which is non persistent. Starting in 12c the database can use a…
Read MoreORA-20005: object statistics are locked (stattype = ALL) – Solution
During tuning a query, I found one table has stale statistics. While running gather stats for that table, got below error. Let me demonstrate with a demo table: SQL> execute…
Read MoreIgnore Duplicate Rows (ORA-00001) with the ignore_row_on_dupkey_index Hint
The simplest method is to add a hint to the query to overcome ORA-00001 Added in 11.2, the ignore_row_on_dupkey_index hint silently ignores duplicate values: insert /*+ ignore_row_on_dupkey_index ( acct (…
Read MoreCreate a Virtual Column:
A virtual column applies a function to a column in the table. The database only computes this at runtime. The value is not stored in the table. So instead of…
Read MoreHow to Fix ORA-01450: Maximum Key Length (6398) Exceeded Errors:
The smallest unit of data storage in Oracle Database is the block. This defaults to 8k (8,192 bytes). Each index entry must fit within one block. So the maximum size…
Read MoreProtecting Data using Oracle Maximum Availability Architecture
When considering the security, it is important to ensure the availability. Data High availability ensured by achieving below key architecture to preventing downtime. Data Availability: Ensure that we are not…
Read MoreOracle Data Safe
Data Safe is a control center for your Oracle Databases which helps understand the sensitivity of data, evaluate risks to data, mask sensitive data, implement and monitor security controls, assess…
Read More