Many times in Oracle Apps env,user complain there request get stuck or takes time to start processing. Majority of time Support team can’t do anything, unless waiting or asking Oracle DBA to check the server performance. There is couple of option you can try , if you know a demanding user and there request name( …
How to change Priority for Concurrent Program Read More »
Here are some of the Common Oracle wait events that everyone should Know. Wait eventsYou can find which event session is waiting for it by following query select event from V$session_wait where sid=&1 I am trying to explain few common Oracle wait events ,there causes and resolutions enqueue The process is waiting on an oracle …
This article is part of EBS tutorials and provides different JDBC connection scripts for Oracle Applications R12 Oracle OC4J connect to Oracle database using JDBC connection. Here is the list of some good scripts on JDBC connection The OC4J JVM process id can be found using the below opmnctl command opmnctl status -l A) To …
JDBC connection scripts for Oracle Applications R12 Read More »
High Water Mark of Oracle table High water mark in oracle is a term used in oracle table to show the blocks which has been ever used in the life cycle of the oracle table. So basically if the oracle table block is flat structure, it is right most block in the structure. This is …
With R12 ,Oracle EBS has introduced a new Top call INST_TOP. Features on this R12 INST_TOP -All the logs files have been moved from APPL_TOP,ORACLE_HOME to this to top All configuration files have been moved to INST_TOP like DBc file All the http related config files appsweb.cfg All the start or stop scripts all the …
We often come across the error ORA-28000 the account is locked in day-to-day activities. This can happen with developers and DBA. Reasons This can happen due to multiple reasons a. Oracle DBA has purposely locked the account alter user <username> account lock; select status from dba_users where username=’&1′; b. The wrong password has been attempted …
How to solve ORA-28000 the account is locked Read More »
