Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Alter session set events not creating trace file.

Status
Not open for further replies.

maddave

Technical User
Jan 3, 2002
72
GB
Hi, I am issueing the following command in sqlplus oracle client 9i on a windows XP PC which has the database on a linux Redhat 4 server.

alter session set events '10046 trace name context forever, level 12';

If I run this statement remotely through the client it doesn't produce a trace file. If this command is run locally on the database server it produces a trace file in the udump directory as expected.

Any idea why running this command through sqlplus on the client doesn't produce a file?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top