Home

FND_FILE in oracle apps

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 …

FND_FILE in oracle apps Read More »

How are the histograms generated in Oracle

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 : …

How are the histograms generated in Oracle Read More »

Histograms in Oracle

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 »

How to check temp tablespace in Oracle: Size, resize, add, drop

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 »

Scroll to Top