Message-Id: <10614.116576@fatcity.com> From: Schoen Volker Date: Sat, 9 Sep 2000 08:54:48 +0200 Subject: AW: Strange: sql.log file SQL.LOG is the ODBC trace-file. Diable ODBC tracing in ODBC Manager. regards Volker Sch=F6n E-Mail: mailto:v.schoen@inplan.de http://www.inplan.de =20 -----Urspr=FCngliche Nachricht----- Von: Helmut Daiminger [mailto:hdaiminger@vivonet.com] Gesendet: Mittwoch, 6. September 2000 19:58 An: Oracle List (Telelist); Oracle DBA List (Lazy DBA) Betreff: Strange: sql.log file Hi! This is 8.1.6 on Win2k Advanced Server. We have a strange thing occuring here: a file named sql.log shows up on = c:\ and I can't delete it because it is locked by some process. I looked in = the Oracle configuration and all Net8 tracing is done to c:\oracle\ora81\network\log. So this can't be an Oracle log file. We have no idea where it comes from. Size: 350 MB and growing. Is there a way to find out what process is generating and locking the = file? Here is a sample from the file: Processid:{3D14 318-6dc ENTER SQLAllocEnv HENV * 7318F510 Processid:{3D14 318-6dc EXIT SQLAllocEnv with return code 0 = (SQL_SUCCESS) HENV * 0x7318F510 ( 0x009d14f0) Processid:{9BE6 2d0-708 ENTER SQLSetConnectAttrW SQLHDBC 00991C60 SQLINTEGER 1 SQLPOINTER 0x00000000 SQLINTEGER -6 Processid:{9BE6 2d0-708 EXIT SQLSetConnectAttrW with return code 0 (SQL_SUCCESS) SQLHDBC 00991C60 SQLINTEGER 1 SQLPOINTER 0x00000000 SQLINTEGER -6 Thanks, Helmut -------- If you're bored, then visit the list's website: http://www.lazydba.com (updated daily) to unsubscribe, send a blank email to = oracledba-unsubscribe@quickdoc.co.uk to subscribe send a blank email to oracledba-subscribe@quickdoc.co.uk