Getting current Session ID

Script to Monitor the Memory Usage on Server We can also schedule the script via cron to get regular notifications. This script is tested in...

In the previous post, we have seen an overview about ADOP . Now we will try to understand Various phases of ADOP in detail. Prepare Phase...

Query to find Responsibility for which Menu / Form Function is assigned To get responsibility based on Menu SELECT DISTINCT a.respon...

Query to find Form Function attached to which Responsibility Script: SELECT DISTINCT faa.application_name application, rtl.respon...

Query to get list of EBS users with responsibility and last login date (responsibility wise) Script: SELECT     usr.user_name,     rsp.respo...

 frmcmp Module=<pll name> Userid=<userid/password> [Parameters].  Optional parameters with default values given: Mo...

Error: FRM-40735: ON-ERROR trigger raised unhandled exception ORA-6508 Cause: This may be occur while opening forms after clone or if ...

The below query can be used for getting all the details for a scheduled concurrent program. select a.requested_by,a.status_code,a.phase...

STOP ORACLE RAC 1. emctl stop dbconsole 2. srvctl stop listener -n racnode1 3. srvctl stop database -d RACDB 4. srvctl stop ...

Query to find Concurrent Request Details from Concurrent Program Name Script SELECT    distinct user_concurrent_program...