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 […]
How the histograms are generated in EBS Read More »
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
FND_FILE in oracle apps Read More »
Autotrace is a utility in Oracle that can be used to analyze the execution plan and performance of SQL statements. It is a command-line tool that provides detailed information about how a SQL statement is executed, including the number of rows returned, the amount of time it takes to execute, and the resources used during
Autotrace Utility in Oracle Read More »
How to check tablespace name in Oracle To list the names and various other parameters of all tablespace in a database, use the following query on the DBA_TABLESPACES view: SELECT TABLESPACE_NAME “TABLESPACE”, EXTENT_MANAGEMENT,FORCE_LOGGING,BLOCK_SIZE,SEGMENT_SPACE_MANAGEMENTFROM DBA_TABLESPACES; With CDB Databases, you must connect to individual PDB and execute the query to check the tablespace. If you want to
How to check Tablespace in Oracle – Size, Free space, datafiles , growth Read More »
We saw how to enable trace in Oracle in an earlier post. The trace files obtained from the method are in raw form which can be converted into a more readable format using the tkprof utility in Oracle (Transient Kernel PROFile utility) tkprof utility in Oracle The syntax is given below tkprofUsage: tkprof tracefile outputfile
Oracle tkprof utility : How to generate and read Read More »
