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 …
Oracle Wait Events That Everyone Should Know Read More »
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 …
We can use RMAN to backup all the parts of the oracle database. RMAN backup commands can be used backs up Oracle database files, copies of database files, archived logs, or backup sets. Here is the general syntax for RMAN backup command Syntax: BACKUP FULL Options BACKUP FULL AS (COPY | BACKUPSET) Options BACKUP INCREMENTAL …
RMAN Backup commands Read More »
