Message-Id: <10614.116576@fatcity.com>
From: Schoen Volker <v.schoen@inplan.de>
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 <SQL_ATTR_MAX_ROWS>
		SQLPOINTER          0x00000000
		SQLINTEGER                  -6

Processid:{9BE6 2d0-708	EXIT  SQLSetConnectAttrW  with return code 0
(SQL_SUCCESS)
		SQLHDBC             00991C60
		SQLINTEGER                   1 <SQL_ATTR_MAX_ROWS>
		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