SQL Wise CPU Usage
SQL Wise CPU Usage select ss.username, se.SID, VALUE/100 cpu_usage_seconds from v$session ss, v$sesstat se, v$statname sn where se.STATISTIC# = sn.STATISTIC# and NAME like ‘%CPU used by this session%’ and se.SID…
Read MoreASM files db wise
ASM files db wise to see all list of files in db column path format a70 column file_type format a15 select concat(‘+’||gname, sys_connect_by_path(aname, ‘/’)) path, system_created, alias_directory, file_type from (…
Read MoreHow to resolve ERROR: FRM-18108 while compiling the form in R12
FRM-18108: Failed to load the following objects. Source Module:APPSTAND Source Object: STANDARD_PC_AND_VA Source Module:APPSTAND Source Object: STANDARD_TOOLBAR Source Module:APPSTAND Source Object: STANDARD_CALENDAR Compiling package specification APP_CUSTOM… No compilation errors. We…
Read MoreFetching particular concurrent request out file remotely
This script fetch & transfer the specific concurrent request log file to remote location. $ vi Connout.sh cat /dev/null > /usr/tmp/ftp.log cat /dev/null > /usr/tmp/ftp1.log echo “Enter Concurrent program Request…
Read MoreORA-12547: TNS :lost contact when try to connect to Oracle
ERROR: ORA-12547: TNS :lost contact when try to connect to Oracle There could be many reasons for the above error, but one of the common issue is due to incorrect…
Read MoreGet any Apps User Password from Backend
In this steps we can find any user name’s password in oracle apps. STEP 1: login to Database through Command Prompt #sqlplus / as sysdba STEP 2 : Create Function…
Read MoreORA-00245: control file backup failed in Rman backup
A snapshot controlfile is a read consistent copy of a database controlfile which RMAN creates because the controlfile is changed constantly. The snapshot controlfile must be on a location shared…
Read More11i: “APP-FND-01542” Error When Logging Directly Into Forms Via the f60cgi in 11.5.10
Applies to: Oracle E-Business Suite Technology Stack – Version 11.5.10.0 to 11.5.10.0 [Release 11.5] Information in this document applies to any platform. Checked for relevance on 25-SEP-2013 Goal How to…
Read MoreManually create database 12c -NON CDB
We are going to see about manual database creation on oracle 12c nonCDB When we get the request to create a database on a Linux server. The basic prerequisite we…
Read MoreAdcfgclone AppsTier Failing During Clone Into When Source And Target Are On Same Host
Applies to: Oracle Applications Manager – Version 12.2.4 and later Information in this document applies to any platform. Symptoms E-Business Suite 12.2 Applications Manager, Rapidclone related issues Cloning the applications…
Read More