Query:
Select sid,serial#,program,module,status,username,schemaname from gv$session where status ='ACTIVE'
This query is very useful to see all the active processes even we can see the ODI sessions here.
Subscribe to:
Post Comments (Atom)
Featured Post
Types of encryption techniques
There are several types of encryption techniques used to secure data, each with its own use case and strengths: 1. Symmetric Encryption Us...
-
Please find the following links for OIC hands on and relevant information: Oracle Integration Cloud Introduction | Benefits | Services offer...
-
OIC interview Q & A: 1. FBDI approach with an example https://soalicious.blogspot.com/2022/02/oic-erp-supplier-bulk-import-and.html 2. ...
-
Stage or vfs or virtual file system is a temporary location in the oic local file system which stores temporary files required for processin... -
UseCase: Here, we will show you how to split an input, received as comma separated string values( here, emails) into array of values using c... -
Usecase: Here, we will extract the data from HCM and then download the data from UCM uaing Flow Actions Service and Generic Soap Service To... -
Usecase: Here, we will demonstrate the detailed implementation steps for AP Invoice FBD Import from polling the file from source >> cr...
-
In OIC Generation 2, we can also read file in segments or chunks using stage action but the chunk size is default limited to 200 records whi... -
UseCase: While mapping the elements in the mapper using XSD structure of the file contents, getting below 2 types of translation errors: Err... -
Usecase: Here, we will see how we can download the import Payables Invoices report. That is we will download report equivalent .xml file w... -
Usecase: Here using ess job tables - ESS_request_history and ESS_request_property, we will fetch the latest succeeded processstart data as l...
No comments:
Post a Comment