Using Oracle Trace / Expert for Oracle Reports Tuning

I am attempting to use Oracle Trace (Oracle Enterprise Manager 1.2.0 for Windows 95) to collect workload data from a database in real time whilst I am running 4 Oracle Reports that have performance problems. I wish to then import the workload data into Expert and analyse the workload data.

According the the release notes for Oracle Trace, only users which are already connected to the database when the collection begins will be recorded. The reports in question are all fired asyncronously from an Oracle Forms application.

Hence, I queue all the reports (in the Oracle Reports Server) and then start the collection in Oracle Trace. More often then not, I receive an error starting the collection. The error in EPC_ERROR.LOG is:

	Pid:26665 06-DEC-96 09:33:20
	Error starting Oracle7 database collection.  See EPC_ERROR.LOG on server system.
	Pid:26665 06-DEC-96 09:33:20
	Error parsing BEGIN sys.dbms_oracle_trace_agent.set_oracle_trace_in_session(16,1
	0,TRUE,'/m/app/oracle/admin/msg/otrace/MSGapp1','/m/app/oracle/product/7.3.2/rdb
	ms/admin/oracle7a.fdf');END;
	Pid:26665 06-DEC-96 09:33:21
	ORA-03113: end-of-file on communication channel

Around the same time the following errors are reported in ALERT.LOG:

	Errors in file /m/app/oracle/admin/msg/udump/ora_26620.trc:
	ORA-07445: exception encountered: core dump [_m_c_regids+308] [SIGBUS] [hardware
	 alignment error] [7450688] [] []
	Fri Dec  6 09:32:48 1996
	Errors in file /m/app/oracle/admin/msg/bdump/snp0_24690.trc:
	ORA-07445: exception encountered: core dump [_m_c_regids+308] [SIGBUS] [hardware
	 alignment error] [7450688] [] []
	Fri Dec  6 09:32:50 1996
	Errors in file /m/app/oracle/admin/msg/udump/ora_26692.trc:
	ORA-07445: exception encountered: core dump [_m_c_regids+308] [SIGBUS] [hardware
	 alignment error] [7450688] [] []
	Fri Dec  6 09:33:17 1996
	Errors in file /m/app/oracle/admin/msg/udump/ora_26607.trc:
	ORA-07445: exception encountered: core dump [_m_c_regids+308] [SIGBUS] [hardware
	 alignment error] [7450688] [] []
	Fri Dec  6 09:33:25 1996
	Errors in file /m/app/oracle/admin/msg/udump/ora_26659.trc:
	ORA-07445: exception encountered: core dump [_m_c_regids+308] [SIGBUS] [hardware
	 alignment error] [7450688] [] []
	Fri Dec  6 09:33:34 1996
	Restarting dead background process SNP0

When this error occurs, all users appear to be disconnected with an ORA-3113 error. Could this have something to do with generic bug 390005 in Oracle 7.3.2.2 (where the workaround is to relink the database with the Spatial Data Option) ??

In any case, when the collection works (rarely), I wonder if I am actually recording all the necessary workload data, as I suspect that each report queued connects to the Server before execution, in which case the collection may only be recording data for the report executing first ??

Can anyone clue me in what is happening here, and whether there is a better method of recording the Oracle Reports Workload data ?? Any help would be greatly appreciated !!  

-- 
Rod Coleman, Analyst Programmer 
BHP Information Technology     
Newcastle, Australia.         

Phone: +61 49 401631
Email: coleman.rod.rf_at_bhp.com.au