Some time user get performance issue during various pages in Oracle Apps application.We need to take the trace of the problem in order to identify the bottleneck We can execute below steps to generate the database level trace for the issue and find out the culprit sql or statement.Here is how to enable trace in […]
Supplemental Logging in Oracle
What is Supplemental Logging in Oracle Oracle Redo log file has the record of all the operation performed in the database by default or automatically.So Redo log files are generally used for instance recovery and media recovery. They are also used for Physical standby or physical replication. But by default Oracle redo logs files does […]
Useful Queries on oracle EBS password expiration/Policy/Settings
Here are some important question and queries for oracle EBS password expiration , password complexity, profiles options How to Stop the Force Password Reset on Creation of User Account in Oracle EBS When a new EBS user is created, User is supposed to change the password of the account upon first login. There are cases […]
Understanding IP Addresses, Subnets, and CIDR Notation
We need to have the basic knowledge of Networking concepts like IP Addresses, Subnets, and CIDR Notation before working on any Cloud infrastructure. Here I am giving the basic and to the my knowledge on few important concept like CIDR notation, Subnet Mask, Subnetting which will be useful for any cloud vendors What is IP […]
Aggregating Data Using Group Functions (group by oracle)
As part of learning Oracle SQL tutorial,Here is good detail on group by oracle Group Functions unlike single value functions operate on set of of rows and return one rows per group. The set of rows may be whole table or the table split into groups Types of Group Functions in Oracle include: AVG([Distinct/all] n) Numeric […]
How to Setup Oracle EBS Auditing
What is Audit Trail? Audit Trail (Oracle EBS Auditing) is a way of keeping track of changes made to important data in Oracle Application tables. Audit Trail keeps a history of the following three questions:1. What changed2. Who changed it3. When did the change take placeThis can be done on a row by row basis […]
