The telnet client is used to connect to the MWA server in EBS. Windows has telnet installed by default but it is often disabled. If you use Start > Run > telnet and the program is not found, then telnet is disabled. In this post, we will check how we can enable it How to …
How to Enable Telnet For Windows for MSCA Read More »
How the histograms are generated in EBS Oracle product team decides about the column where histograms are needed and those columns are inserted into the table FND_HISTOGRAM_COLS. FND_STATS collects histogram information if a column is listed in FND_HISTOGRAM_COLS. we should not use DBMS_STATS to gather stats in the EBS database as then it will create …
In this post, we will be checking out the most commonly used oracle tde wallet queries. How to open a TDE wallet in Oracle 12c or 19c Here is how to open a wallet in Oracle 12c or 19c for both CDB and Non-CDB Databases With 12c Non-CDB ADMINISTER KEY MANAGEMENT SET KEYSTORE OPEN IDENTIFIED …
how to open a TDE wallet in Oracle : Status, Open, Close Read More »
In this post, we will discuss FND_FILE in oracle apps, how it works, troubleshooting the FND_FILE issues What is FND_FILE select cp.plsql_dir, cp.plsql_out, cp.plsql_log from fnd_concurrent_requests cr, fnd_concurrent_processes cp where cr.request_id =< running request id> and cp.concurrent_process_id = cr.controlling_manager; l<seq no>.req o<seq no>.req FND_FILE API Procedure FND_FILE.PUTSyntaxFND_FILE.PUT (which IN NUMBER, buff IN VARCHAR2);Arguments which: A …
Histograms are generated in Oracle by using the method_opt parameter in the dbms_stats procedure method_opt syntax FOR ALL [INDEXED | HIDDEN] COLUMNS [size_clause] FOR COLUMNS [column_clause] [size_clause] size_clause is defined as size_clause := SIZE {integer | REPEAT | AUTO | SKEWONLY} column_clause is defined as column_clause := column_name | extension name | extension – integer : …
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 »
