Query to identify applications/workspace information of your Oracle apex Application COLUMN workspace FORMAT A20 COLUMN workspace_id FORMAT 99999999999999999999 COLUMN application_id FORMAT A14 COLUMN application_name FORMAT A20 — List applications. SELECT…
Read MoreThe default log files and logging levels are defined in logging.properties file under the below location /home/oracle/tomcat_09_Aug_2020/apache-tomcat-9.0.36/conf. The list is arranged in order by level of detail from the least…
Read MoreBelow script is for finding the Apex page hits ********************************************************************************************************** /home/oracle/backup/scripts/pagehits.sh . /home/oracle/db.env export SC_LOG=/Backup/pagehits/fms_`date +%d_%b_%H_%M_%Y`.log sqlplus -s <<EOF >>/usr/tmp/tmp1.log connect /as sysdba spool \$SC_LOG select flow_id,step_id,count(*) from FLOWS_030100.WWV_FLOW_ACTIVITY_LOG where…
Read MoreBelow script is for finding the Apex Page Time ********************************************************************************************************** /home/oracle/backup/scripts/pagetime.sh . /home/oracle/db.env export SC_LOG=/Backup/pagetime/fms_`date +%d_%b_%Y_%H_%M`.log sqlplus -s <<EOF >>/usr/tmp/tmp2.log connect /as sysdba spool \$SC_LOG select flow_id,step_id,sum(elap)/count(*) “Average” from FLOWS_030100.WWV_FLOW_ACTIVITY_LOG…
Read MoreQR Code Creator QR Code is defines that a machine-readable code consisting of an array of black and white squares, typically used for storing URLs or other information for reading…
Read MoreInstallation and Configuration of Oracle Application Express with Oracle REST Data Services and Apache Tomcat Installed Softwares (requirement may vary) Oracle Application Express 5.1.4 Apache Tomcat 7.0.96 Oracle Rest Data Service ORDS…
Read MoreIntroduction This Post is Explain About to Check Data type using JavaScrip. Use the below script to perform duplicate data validation along with numeric data type validation in Javascript.…
Read MoreDescription: Session State Protection is a built-in functionality that prevents hackers from tampering with the URLs within your application. URL tampering can adversely affect program logic, session state contents, and…
Read MoreDescription: Oracle BI Publisher is suitable for report output; it will give the output files like PDF, XLS, etc., Huge advantage in BI Publisher is that it can produce multiple…
Read MoreDescription: Fusion Applications provides web services that allow external systems to integrate with Fusion Applications. There are two types of services: ADF services and composite services. ADF services are created…
Read More