AW: Strange: sql.log file

From: Schoen Volker <v.schoen_at_inplan.de>
Date: Sat, 9 Sep 2000 08:54:48 +0200
Message-Id: <10614.116576@fatcity.com>

SQL.LOG is the ODBC trace-file. Diable ODBC tracing in ODBC Manager.

regards

Volker Sch=F6n
E-Mail: mailto:v.schoen_at_inplan.de
http://www.inplan.de
=20

-----Urspr=FCngliche Nachricht-----
Von: Helmut Daiminger [mailto:hdaiminger_at_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_at_quickdoc.co.uk
to subscribe send a blank email to oracledba-subscribe_at_quickdoc.co.uk Received on Sat Sep 09 2000 - 01:54:48 CDT