we can find this using the below query. You need to provide the username if you are looking for a particular user or just leave blank, it will show for all the users SELECT TO_CHAR(TIMESTAMP,’MM/DD HH24:MI’) TIMESTAMP, SUBSTR(OS_USERNAME,1,20) OS_USERNAME, SUBSTR(USERNAME,1,20) USERNAME, SUBSTR(TERMINAL,1,20) TERMINAL, ACTION_NAME, RETURNCODE, OS_USERNAME, USERNAME, USERHOST FROM SYS.DBA_AUDIT_SESSION WHERE USERNAME LIKE ‘%&1%’ AND […]
How to create spfile from pfile
In this post, we would check out various ways to create spfile from pfile in the Oracle database. First of all, let’s check out the description of both spfile and pfile What is pfile Pfile is a Traditional plain-text parameter file and it does not let you make persistent changes to parameter values. So any alter […]
How to rebuild WF_DEFERRED_TABLE_M Queue
Sometimes we need to rebuild the WF_DEFERRED_TABLE_M queue due to corruption. Here are the steps to perform it. (1) First, take a pre snapshot of all the objects related to that queue Login to server and source the EBS environment spool WF_DEFERRED_TABLE_M_objects_pre.lstselect object_name, object_type, status, ownerfrom dba_objectswhere object_name like ‘%WF_DEFERRED_TABLE_M%’;spool off (2) Now we will proceed […]
Oracle Cloud :Infrastructure-as-a-Service Concepts
Oracle Cloud: Infrastructure-as-a-Service Overview Oracle’s Infrastructure-as-a-Service (IaaS) provides a complete infrastructure for enterprise workloads, including compute services, storage services, and network services. It enables organizations to run any type of workload in the cloud and in particular run Oracle workloads in the most optimized way. This gives an excellent option to clients to not purchase […]
How Edition-Based Redefinition in Oracle Database 11gR2/12c/18c/19c works
Edition-based redefinition in Oracle Database 11gR2//12c/18c/19c allows multiple versions of PL/SQL objects, views, and synonyms in a single schema, which makes it possible to perform upgrades of database applications with zero downtime. It also means we can maintain multiple copies of the same object What is Edition in Oracle? An edition is effectively a version […]
Basic elements(Application,Forms,functions,menu) of Oracle EBS Application
Here in this post, I am trying to explain the Basic elements(Application, Forms, functions, menu) of the Oracle EBS Application Application An Application is a collection of Forms,Reports and PL/SQL objects to meet a particular business objectives Oracle Applications like 11.0,11i,R12 is a collection of predefined inter linked applications A custom application can be designed […]
