Autotrace is a utility in Oracle that can be used to analyze the execution plan and performance of SQL statements. It is a command-line tool that provides detailed information about how a SQL statement is executed, including the number of rows returned, the amount of time it takes to execute, and the resources used during […]
Autotrace Utility in Oracle Read More »
How to check tablespace name in Oracle To list the names and various other parameters of all tablespace in a database, use the following query on the DBA_TABLESPACES view: SELECT TABLESPACE_NAME “TABLESPACE”, EXTENT_MANAGEMENT,FORCE_LOGGING,BLOCK_SIZE,SEGMENT_SPACE_MANAGEMENTFROM DBA_TABLESPACES; With CDB Databases, you must connect to individual PDB and execute the query to check the tablespace. If you want to
How to check Tablespace in Oracle – Size, Free space, datafiles , growth Read More »
We saw how to enable trace in Oracle in an earlier post. The trace files obtained from the method are in raw form which can be converted into a more readable format using the tkprof utility in Oracle (Transient Kernel PROFile utility) tkprof utility in Oracle The syntax is given below tkprofUsage: tkprof tracefile outputfile
Oracle tkprof utility : How to generate and read Read More »
Concurrent Programs can be submitted from the backend ie. database using fnd_request.submit_request.We will check in this post the various code on How to submit a concurrent program from the backend The snippet of the API FUNCTION fnd_request.submit_request ( application IN VARCHAR2 DEFAULT NULL, program IN VARCHAR2 DEFAULT NULL, description IN VARCHAR2 DEFAULT NULL, start_time IN
How to submit a concurrent program from the backend Read More »
Sometimes it is not possible to buy the expensive HSHSM-based solution for EBS Jar signing. You can use your own private CA for signing the jar files. This post gives an overview of creating private CA using OpenSSL command. One-Time CA Initialization Create CA Directory mkdir ~/ebsJarCAcd ~/ebsJarCA Create CA Directory Structure mkdir certs db
How to Create a Minimally Viable Private CA for Jar Signing using OpenSSL Read More »
Starting June 2023, the commercial CAs changed their policy and stopped issuing code signing certificates where your private key was kept in a disk file such as the Java KeyStore (JKS) file used by EBS JAR signing tools. In short, the private key used for code signing now needs to be kept in a Hardware
EBS Jar signing with HSM Based Certificate Read More »
