How to enable Oracle listener tracing

Category : Home > Databases > Oracle > SQL*Net

How to enable Oracle listener tracing

1. Enable tracing

LSNRCTL> set trc_level ADMIN

2. Disable tracing

LSNRCTL> set trc_level OFF

3. Format the trace file using trcasst utility. The command line options for trcasst may vary
from version to version, so check what options are supported by your installation.

trcasst [options] [filename]

Options


Start discussion or add comment to this tip

Details

Tip reference : #41 views : 5871	Added on : 11/02/05	Submited by : h8dk97

Send a message	Printer friendly output Display this member's tips (202)

	Most viewed tips
	Databases > Oracle > Security : How to unlock Oracle user account
	Databases > Oracle > Performance Tuning : How to enable trace in Oracle
	Operating Systems > Unix : How to kill Unix user session
	Databases > Oracle : Kill user session

	All categories Databases \| Programming \| Hardware \| Operating Systems \| Networking \| Internet \| ERP / CRM \| Games & Multimedia \| Graphics & Design \| Miscellaneous \| Mobile Phones / Tablets \| Office Software

Home | FAQ | Terms of Use | Privacy Policy