To manage histograms in an Oracle database, use the DBMS_STATS package. You can generate histograms by setting the method_opt parameter in GATHER_TABLE_STATS (e.g., size auto). To check existing histogram types—such as Frequency, Top-Frequency, or Hybrid—query the HISTOGRAM column in the DBA_TAB_COL_STATISTICS data dictionary view. The Cost-Based Optimizer (CBO) uses Histograms to understand data skew. These […]
Top Histograms queries in Oracle Read More »
“To resolve the ‘no functions available’ error when accessing the User Management responsibility in Oracle EBS, the user must inherit the Security Administrator role. Log in as SYSADMIN, navigate to User Management > Users, search for the target user, and assign the ‘Security Administrator’ and ‘Customer Administrator’ roles.” You may need sometimes to assign User
Troubleshooting User Management Navigation Errors in Current Oracle EBS Read More »
I will be posting the step by step Oracle 19c Database Installation on Linux. First we will performing the binaries installation and then creating the database using DBCA Package and OS requirements We can install the Oracle Provided 19c preinstall package to meet the Package and OS requirementRunning the below yum command (as root): yum install -y oracle-database-preinstall-19c
Step by Step Oracle 19c Database Installation on Linux Read More »
To make an index invisible in Oracle, use the command: ALTER INDEX index_name INVISIBLE;. This hides the index from the optimizer while maintaining it during DML operations. To test its impact before dropping, set OPTIMIZER_USE_INVISIBLE_INDEXES = TRUE at the session level. This ensures a risk-free performance evaluation in production environments. What are Invisible Indexes? Beginning with Oracle
How to make index invisible in oracle Read More »
This post is part of Oracle SQL tutorial and we would be discussing Analytic functions in oracle(Over by partition) with examples, detailed explanation . Analytic functions in oracle We have already studied about Oracle Aggregate function like avg ,sum ,count. Lets take an example First lets create the sample data CREATE TABLE “DEPT” ( “DEPTNO”
How to use Analytic functions in oracle (Over Partition by Keyword) Read More »
In this post, we will learn about sql loader in oracle, SQL loader syntax in oracle, SQL loader direct path load, SQL loader examples SQL Loader in Oracle How Sql loader works Two types of input have to be provided to SQL*Loader. SQL Loader generates three files Sql loader Syntax Syntax sqlldr keyword=value Example SQLLDR
SQL loader in oracle Read More »
