RE: Strange: sql.log file

Helmut,

I believe if you're using odbc that is its default tracing file. You should have an odbcad32.exe (windows 95) or its equivalent which would let you check that and turn tracing off if desired.

Iain Nicoll

-----Original Message-----
From: Helmut Daiminger [mailto:hdaiminger_at_vivonet.com] Sent: 06 September 2000 20:01
To: Multiple recipients of list ORACLE-L Subject: 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

-- 
Author: Helmut Daiminger
  INET: hdaiminger_at_vivonet.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L


(or the name of mailing list you want to be removed from).  You may

also send the HELP command for other information (like subscribing).