How to enable 10046 Trace (SQL_TRACE) to troubleshoot performance issues

Event 10046 is used to gather extended SQL_TRACE information for Oracle sessions. This article describes how to enable event 10046 to get extended information to troubleshoot a performance issue. To gather 10046 trace at the session level: alter session set tracefile_identifier=’10046′; alter session set timed_statistics = true;alter session set statistics_level=all;alter session set max_dump_file_size = unlimited;alter…

Advertisements

Oracle Listener Tracing & network troubleshooting

This article focuses on the Oracle Listener Tracing & Troubleshooting, in this article we would explore the parameters available to enable tracing on Oracle listener so that additional data is available to troubleshoot network related issues between client & server. To enable Listener tracing add following parameters to listener.ora:- TRACE_LEVEL_LISTENER=[0-16|USER|ADMIN|SUPPORT|OFF]#This parameter defines the level of…

ORA-12502 TNS-12502 TNS:listener received no CONNECT_DATA from client

TNS:listener received no CONNECT_DATA from clientCause: No CONNECT_DATA was passed to the listener.Action: Check that the service name resolved from TNSNAMES.ORA has the CONNECT_DATA component of the connect descriptor. Below is the sample entry of tnsnames.ora:- #When using SERVICE_NAME in CONNECT_DATA componentorcl.example.com = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = myserver.example.com)(PORT =…