Oracle

Index Skip Scan Hint Usage in Oracle Database

Index skip scans improve index scans against non-prefix columns since it is often faster to scan index blocks than …

On which quote or order line items can a promotion be applied? Bundle Promotions can be applied to root product line …

The TEST1 table will be the parent and therefore must be created as a partitioned table.And table TEST_TAB will be the …

Oracle ASM Configuration Assistant (ASMCA) was introduced in Oracle ASM version 11.2. ASMCA supports installing and …

Reference partitioning provides the ability to partition a table based on the partitioning scheme of the table …

Composite Data Types You learned that variables of the scalar data type can hold only one value, whereas variables of …

This post explains 11gR2 and 12cR1 Grid Infrastructure configuration framework config.sh(config.bat on Windows) which is …

Hint Usage Report is a new feature from 19c which helps to determine from the execution plan output which are all the …

Beginning with Oracle10G, when statistics are gathered for a table, the old statistics are retained so should there be …

Question: How to find the log files for OPatch and OUI ( Oracle Universal Installer)? OPatch (Common for Windows and …

This script shows which tables and indexes are either missing statistics or have stale statistics, and the statistics …