Oracle has provided a procedure VERIFY_STATS in the FND_STATS package to verify stats for the table in EBS This procedure reports the statistics in the data dictionary tables for the tables, indexes, and histograms. Syntax FND_STATS.VERIFY_STATS ( schemaname VARCHAR2 DEFAULT NULL, tablelist VARCHAR2 DEFAULT NULL, days_old NUMBER DEFAULT NULL, column_stat BOOLEAN DEFAULT FALSE); To verify …
How to verify stats for the table in EBS Read More »
How to Gather schema statistics in oracle apps R12 In order to use Cost-Based Optimizer effectively, the schema statistics must be current. Fortunately, Oracle EBS has provided some scripts and concurrent programs(Gather Schema Statistics and Gather Table Statistics) to make this administrative task easier. FND_STATS is a PL/SQL package for the Applications that has numerous …
Gather Schema Statistics Using FND_STATS in EBS 11i and R12 Read More »
A SQL Tuning Set (STS) in Oracle is a database object that includes one or more SQL statements along with their execution statistics and context. It provides a means to store SQL statements for future use, such as input to the SQL Tuning Advisor or SQL Access Advisor, capturing workloads to move them from one …
Sometimes a SQL_ID might show a different plan because of a particular value of the bind variable. So we would like to find out the bind variable. Also, we might want to know the bind variable for the sql_id being executed by the session. In this post, we will check out How to find the …
What is DBMS_STATS The DBMS_STATS package was introduced in Oracle 8i and is Oracle’s preferred method of gathering object statistics. DBMS_STATS is a package in Oracle Database that provides procedures to manage statistics for database objects. Statistics are essential for the optimizer to make efficient execution plans for SQL statements. The package offers procedures to …
How to gather Statistics with DBMS_STATS Procedures Read More »
We often get questions on how to check physical RAM, swap space on Unix. Command varies as per the Operating system. Here are the commands for the common operating system How to check Physical RAM , Swap Space on Unix Operating System: HP Tru64 UNIXPhysical RAM: # /bin/vmstat -P grep “Total Physical Memory”Swap Space: # …
How to check physical RAM ,swap space on Unix Read More »
