Oracle 23c is the latest Release of the Oracle Database. This is also a Long term release. It is also called Oracle 23ai given the focus on AI in it. Oracle has introduced a lot of new features in it. Here are the Top Features Augmenting a new generation of AI models Asking questions naturally …
Oracle 23c/23ai Database New Features 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 and read 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 …
EBS R12 is supported in Multitenant mode for Oracle Database 19c. If you try to generate a tkprof to report explain plan generation on the Database, you will receive errors for the Invalid username /password in the trace file generated tkprof test.trc test.txt sys=no explain=apps/apps sort=prsela,exeela,fchela The reason for this is that the apps is …
Concurrent Programs can be submitted from the backend ie. database using fnd_request.submit_request.We will check in this post the various code on How to submit a concurrent program from the backend The snippet of the API FUNCTION fnd_request.submit_request ( application IN VARCHAR2 DEFAULT NULL, program IN VARCHAR2 DEFAULT NULL, description IN VARCHAR2 DEFAULT NULL, start_time IN …
How to submit a concurrent program from the backend Read More »
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 »
