set pagesize 10000 set linesize 133 column tablespace format a20 heading ‘Tablespace Name’ column segfile# format 9,999 heading ‘File|ID’ column spid format 9,999 heading ‘Unix|ID’ column segblk# format 999,999,999 heading…
Read Moreset head on column module format a20 set lines 1000 pages 1000 prompt SQL Ordered by Elapsed time /*FIND THE SNAP ID*/ set pages 0 col begin_interval_time for a30 col…
Read MoreDescription: This Document for configuring oracle Statspack, schedule auto snapshot and report generation. The Statspack tool is instead of AWR report because AWR is licensed Statspack is non licensed. Steps:…
Read MoreDescription: After Clone the Oracle Application R12.1.3 and login the application this error occurs. Solution: Check the Server ID in fnd_node table . Select server_id from fnd_node; Take a backup…
Read MoreDescription: Oracle have lot of printing option to configuring in Solaris 10, this is also one method will follow to setup printer on EBSR12 in Solaris Sparc 10 Steps: Login…
Read MoreDescription: Oracles have lot of trace utility the oradebug is one the utility to trace particular running concurrent request using oracle spid. Steps: Check Request ID from Find Concurrent request…
Read MoreDescription: The user was running RDF report and concurrent completed with error That issue occur on the prefs.ora file is missing or non-accessible owner Solution: copy the prefs.ora file from…
Read MoreDescription: Customers run the Oracle Report are Failing with APPS.FND_CP_OPP_IPC ORA-00600: internal error code. This issue made low level business impact Solution: Check the Concurrent Log file to detail…
Read MoreError: ORA-28040: No matching authentication protocol Cause: 1. This problem was encountered on database instance version 12.2 and above and clients with version 9g/10g/11g. Example: In my case the development…
Read MoreQuery 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 More