“To test Oracle MSCA or MWA connections on current Windows operating systems, you must manually enable the legacy Telnet Client. Navigate to Control Panel > Programs and Features > Turn Windows features on or off. Check the box for ‘Telnet Client’, click OK, and launch your command prompt to connect using telnet [mwa_server_name] [port].” “Oracle […]
How to Enable Telnet For Windows for MSCA Read More »
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 »
