In this post, we will be discussing Java web start implementation in R12/R12.1 and R12.2 versions of EBS. we will see why it is important to implement it What is Java Web start? Java Web Start provides a browser-independent architecture for deploying Java technology-based applications to the client desktop. With Java Web Start, users can […]
Java web start(JWS) in R12 Read More »
We often come across a situation where a sql statement is giving issues. SQL monitor report is a very useful tool to analyze the various operation done by the sql, wait events, bind variables, and memory details. The below statement can be used to monitor any active sql or done sql in the database SET
How to generate sql monitor report in Oracle Read More »
Many operations take time in the Database like full table scan, backup, full index scan, and joins. We can estimate the % completion or monitor the session using the v$session_longops view in Oracle. This is a very useful view and provides quite an accurate estimate. How to find the %completion for the long operation for
How to find the long running (longops session) in Oracle Read More »
We often come across a situation in EBS Database, where we want to know the Concurrent request id from the given SID or SPID. Here are some queries which can be helpful in this situation How to find the concurrent request id from Sid Non-RAC set lines 2000select a.request_id ,a.os_process_id,b.sid from apps.fnd_concurrent_requests a,v$session b whereb.audsid(+)=
How to find concurrent request id from Sid or spid Read More »
The Flash recovery area(FRA) is an important location in the Oracle database. It stores archivelog, flashback logs, backups etc. Here in this post, we will see how to check fra size in Oracle, flash recovery area usage query, and how to increase fra size in Oracle how to check fra size in oracle The above
how to check fra size in oracle: Location, usage, change size Read More »
We use Autoconfig to manage configuration files in EBS. We generally make changes in the context file and run the autoconfig. Now suppose we want to know what all files will be impacted by the particular variable in the context file. One way would be to search the INST_TOP and other tops for it, but
AutoConfig Search Utility Read More »
