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 MoreImpact: Unknown underscore parameters without proper advice from metalink, would impact the database. Solution: We need to ensure that we have proper advises from Oracle Support on those underscore parameters…
Read MoreIntroduction Need for want of lock statistics in a oracle table in some cases, for example 1. Don’t want a table to be analyzed by schedule statistics job but want…
Read MoreError: FRM-30087: Unable to create form file $ORACLE_HOME/forms/WOENTRY.fmx Cause: Non-oracle user cannot write in the “output” directory or the mentioned fmx exists but user cannot overwrite it. Workaround: 1. By…
Read MoreError: error while loading shared libraries: libXm.so.3: cannot open shared object file: No such file or directory Solution: 1. As a workaround, make sure the following 64 bits openmotif packages…
Read MoreError: =========== We came across below ORA error during import of Schema ORA-39083: Object type TYPE:”FMSDEV”.”SAMPLE_TYPE_TABLE” failed to create with error: ORA-02304: invalid object identifier literal Failing sql is: CREATE…
Read MoreWe have to check the below details before reorganize the table TABLE DETAILS SELECT OWNER, SEGMENT_NAME, SEGMENT_TYPE, TABLESPACE_NAME, BYTES/1024/1024/1024 FROM DBA_SEGMENTS WHERE SEGMENT_NAME IN (‘WF_ITEM_ACTIVITY_STATUSES_H’); OWNER …
Read MoreSQL Wise CPU Usage select ss.username, se.SID, VALUE/100 cpu_usage_seconds from v$session ss, v$sesstat se, v$statname sn where se.STATISTIC# = sn.STATISTIC# and NAME like ‘%CPU used by this session%’ and se.SID…
Read MoreASM files db wise to see all list of files in db column path format a70 column file_type format a15 select concat(‘+’||gname, sys_connect_by_path(aname, ‘/’)) path, system_created, alias_directory, file_type from (…
Read More