Home » RDBMS Server » Server Administration » Huge trace generated in udump (Oracle EE, 10.2.04, HP_UX 11.31)
Huge trace generated in udump [message #406999] Mon, 08 June 2009 02:36 Go to next message
IBNHUSSAIN
Messages: 39
Registered: December 2007
Location: INDIA
Member
Hi,

I have a problem on my production database. I appreciate, if you could guide me to get details and cause of this problem in order to solve it.

From last 3 days my database server is generating huge trace files in udump. The normal trace files generation is 2000 on my database but from last 3 days it is generating 8600, 9000 and 10000 trace files in udump.

Kindly let me know why it has increased.
Re: Huge trace generated in udump [message #407002 is a reply to message #406999] Mon, 08 June 2009 02:43 Go to previous messageGo to next message
ThomasG
Messages: 3212
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
Because someone or something did activate them.

The first step would be to look inside those files to find out which user did it, and then ask that user.
Re: Huge trace generated in udump [message #407003 is a reply to message #407002] Mon, 08 June 2009 02:49 Go to previous messageGo to next message
IBNHUSSAIN
Messages: 39
Registered: December 2007
Location: INDIA
Member
This is what i have found in one of the files.

Ioctl ASYNC_CONFIG error, errno = 1
Dump file /10.2.0/admin/PROD_prod2/udump/prod_ora_140.trc
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORACLE_HOME = /PROD/db/tech_st/10.2.0
System name:    HP-UX
Node name:      prod2
Release:        B.11.31
Version:        U
Machine:        ia64
Instance name: PROD
Redo thread mounted by this instance: 1
Oracle process number: 0
Unix process pid: 140, image: oracle@prod2

Ioctl ASYNC_CONFIG error, errno = 1


I have found Doc: 302801.1 for this issue.
But i do not know the consequenses of setting these parameters on other area( server or database)

......
....Since the Oracle 10.2 version, these settings stop the tracing:
disk_asynch_io=FALSE
filesystemio_options=none .....
......

Thanks in advance.
Re: Huge trace generated in udump [message #408045 is a reply to message #406999] Sat, 13 June 2009 05:23 Go to previous messageGo to next message
Kamran Agayev
Messages: 145
Registered: February 2009
Location: Azerbaijan, Baku
Senior Member

May be someone (or DBA) set parameter SQL_TRACE to true? Could you please verify value of SQL_TRACE parameter?
SQL>show parameter SQL_TRACE
Re: Huge trace generated in udump [message #410554 is a reply to message #407003] Sun, 28 June 2009 10:04 Go to previous messageGo to next message
selvakumarmvs
Messages: 12
Registered: February 2009
Junior Member
refer this

http://forums11.itrc.hp.com/service/forums/questionanswer.do?admit=109447626+1246201317067+28353475&threadId=227687


regards
selva..
Re: Huge trace generated in udump [message #411283 is a reply to message #406999] Thu, 02 July 2009 23:30 Go to previous message
animesh_nz19
Messages: 7
Registered: July 2009
Junior Member
Ioctl ASYNC_CONFIG error, errno = 1
The above message indicates problem with teh asynch IO.

I agree with IBN HUSSAIN that setting below parameter stop the tracing:
disk_asynch_io=FALSE
filesystemio_options=none

BUt you need to check if this can cause any affect to your database because this will disable asynch IO.

Best is to verify with system admin that asynch IO is configured properly.

Regards,
Animesh
Previous Topic: Equivalent Privilege in oracle 9i and 10g (merged)
Next Topic: ORA-01034
Goto Forum:
  


Current Time: Tue Dec 10 02:03:41 CST 2024