The SQL*Plus command ORADEBUG is very useful for diagnosing performance and hanging issues. Among other things, it may be used to verify that the correct IP addresses are used for Real Application Clusters inter-instance communication. In releases prior to Oracle11g, ORADEBUG TRACEFILE_NAME is the only way to determine the name of the trace file a process is writing to.1
Unable to display preview. Download preview PDF.