Statistics can become stale when the data in the table changes substantially. Up-to-date statistics are important to generate good execution plans How does Oracle decide if the stats have become stale Stats are considered stale when #(INSERTS + UPDATES + DELETES) >= 10% of NUM_ROWS from dba_tables: The parameter setting required to Track the table […]
How to check Stale statistics in Oracle Database Read More »
Constraints on a table in Oracle can be found using the below viewsuser_constraints: It provides information about constraints owned by the current user.all_constraints: shows information about constraints accessible to the current user, including those owned by other users.dba_constraints: provides information about all constraints in the database and requires DBA privileges.User_cons_columns: it provides information about columns
How to check all constraints on a table in Oracle Read More »
Triggers are an important construct in Oracle. These are the codes that are fired when a row is updated, inserted, or deleted in the Oracle table. Let’s find out how to check trigger status in Oracle, how to check trigger definition in Oracle, how to find all triggers in the table, and much more How
How to check trigger status in oracle Read More »
What is Temporary Tablespace A temporary tablespace is used for sorting operations in Oracle. It is also used in the join operations. Basically, it is temporary storage and temporary objects are created here. Global temporary tables are also created in this tablespace. This is quite a significant tablespace and can pose issues if not managed
How to check temp tablespace in Oracle: Size, resize, add, drop Read More »
In this post, we will see the important topic of histograms in Optimizer stats What is a histograms in Oracle A histogram is a special type of column statistic that provides more detailed information about the data distribution in a table column. By gathering histogram data, the CBO can make improved selectivity estimates in the
Histograms in Oracle Read More »
Oracle Database Packages are widely used in EBS R12. We have thousands of Packages in the Apps schema. These packages are loaded and modified in the Oracle database using adpatch or adop using the files in the $PRODUCT_TOP/patch/115/sql/*pls. In this article, we will see how to check the Package version in EBS R12 Sometimes, we
How to check Package version in EBS R12 Read More »
