-
Oracle Tracing Issues..
Hello All,
I am running Oracle 10.1.0.4 on Win 2003 and over the past couple of weeks I have noticed that I have been generating trace files and I am not sure how it started or how to stop it. I am not sure if it was enabled after installing the October 2005 Security patch but I have turned off sql_trace, trace_enabled and timed_statistics. The questions I have are:
1) Does this has anything to do with the DBMS_MONITOR feature?
2) Is it alright to have this type of tracing files generated?
3) My servers performance has deteriorated. Would this be a part of the problem?
3) How do I stop it?
I have done the following:
SQL> select * from dba_enabled_traces;
TRACE_TYPE
---------------------
PRIMARY_ID
----------------------------------------------------------------
QUALIFIER_ID1
------------------------------------------------
QUALIFIER_ID2 WAITS BINDS INSTANCE_NAME
-------------------------------- ----- ----- ----------------
SERVICE
SYS$USERS
TRUE FALSE
The trace file generated has the follow information:
Dump file d:\oracle\product\10.1.0\admin\prod2\bdump\prod2_j000_3412.trc
Wed Nov 23 05:10:44 2005
ORACLE V10.1.0.4.0 - Production vsnsta=0
vsnsql=13 vsnxtr=3
Oracle Database 10g Enterprise Edition Release 10.1.0.4.0 - Production
With the Partitioning, OLAP and Data Mining options
Windows Server 2003 Version V5.2
CPU : 4 - type 586, 2 Physical Cores
Process Affinity: 0x00000000
Memory (A/P) : PH:2179M/3327M, PG:4061M/5220M, VA:1376M/2047M
Instance name: TEST
Redo thread mounted by this instance: 1
Oracle process number: 18
Windows thread id: 3412, image: ORACLE.EXE (J000)
*** SERVICE NAME:(SYS$USERS) 2005-11-23 05:10:44.623
*** SESSION ID:(161.5) 2005-11-23 05:10:44.623
=====================
PARSING IN CURSOR #1 len=198 dep=1 uid=0 oct=3 lid=0 tim=3187151212 hv=4125641360 ad='2df6eb4c'
select obj#,type#,ctime,mtime,stime,status,dataobj#,flags,oid$, spare1, spare2 from obj$ where owner#=:1 and name=:2 and namespace=:3 and remoteowner is null and linkname is null and subname is null
END OF STMT
PARSE #1:c=0,e=64,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=3187151208
EXEC #1:c=0,e=71,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=3187237853
FETCH #1:c=0,e=71,p=0,cr=3,cu=0,mis=0,r=1,dep=1,og=4,tim=3187243729
=====================
PARSING IN CURSOR #2 len=105 dep=1 uid=0 oct=3 lid=0 tim=3187250610 hv=2594543328 ad='2d276670'
select value, flags, modified_inst, additional_info from sys.scheduler$_global_attribute where obj# = :1
END OF STMT
PARSE #2:c=0,e=230,p=0,cr=0,cu=0,mis=1,r=0,dep=1,og=1,tim=3187250607
EXEC #2:c=0,e=643,p=0,cr=0,cu=0,mis=1,r=0,dep=1,og=4,tim=3187281747
FETCH #2:c=0,e=29,p=0,cr=2,cu=0,mis=0,r=1,dep=1,og=4,tim=3187288065
=====================
Thanks for your help,
Dee.
