OraFAQ Forum: Server Administration » Huge trace generated in udump

Home » RDBMS Server » Server Administration » Huge trace generated in udump (Oracle EE, 10.2.04, HP_UX 11.31)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Huge trace generated in udump [message #406999]

Mon, 08 June 2009 02:36

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.

Report message to a moderator

Re: Huge trace generated in udump [message #407002 is a reply to message #406999]

Mon, 08 June 2009 02:43

ThomasG
Messages: 3211
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.

Report message to a moderator

Re: Huge trace generated in udump [message #407003 is a reply to message #407002]

Mon, 08 June 2009 02:49

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.

Report message to a moderator

Re: Huge trace generated in udump [message #408045 is a reply to message #406999]

Sat, 13 June 2009 05:23

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

Report message to a moderator

Re: Huge trace generated in udump [message #410554 is a reply to message #407003]

Sun, 28 June 2009 10:04

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..

Report message to a moderator

Re: Huge trace generated in udump [message #411283 is a reply to message #406999]

Thu, 02 July 2009 23:30

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

Report message to a moderator

Previous Topic:	Equivalent Privilege in oracle 9i and 10g (merged)
Next Topic:	ORA-01034

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Jul 02 23:11:16 CDT 2024