OraFAQ Forum: Server Administration » Message found in alert log

Home » RDBMS Server » Server Administration » Message found in alert log (Oracle 11.2.0.4.1 , SunOS 5.10)

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

Message found in alert log [message #619471]

Tue, 22 July 2014 16:36

Database admin
Messages: 365
Registered: September 2006
Location: india

Senior Member

Hi,

I found following entry in alert log .Is this something very critical that we need to look into it.
If so could you tell me what is this all about ?

Tue Jul 22 23:10:25 2014
Process 0x0x575293858 appears to be hung in Auto SQL Tuning task
Current time = 1406059824, process death time = 1406059805
Attempting to kill process 0x0x575293858 with OS pid = 23660
OSD kill succeeded for process 0x575293858
Tue Jul 22 23:30:39 2014
Running KSFV I/O slave I602 os pid=29750
Tue Jul 22 23:31:11 2014

Regards,
Srini

[Updated on: Tue, 22 July 2014 16:39]

Report message to a moderator

Re: Message found in alert log [message #619488 is a reply to message #619471]

Tue, 22 July 2014 23:07

trantuananh24hg
Messages: 744
Registered: January 2007
Location: Ha Noi, Viet Nam

Senior Member

It look like your DBA used EM to invoke Auto SQL Tuning Task.

You or your DBA should use guide-line in 1344499.1 (Metalink)

or

drop this task:

SELECT  task_name, status 
FROM    DBA_ADVISOR_TASKS
WHERE   task_name LIKE '%SYS_AUTO_SQL_TUNING_TASK%';

exec DBMS_SQLTUNE.DROP_TUNING_TASK('SYS_AUTO_SQL_TUNING_TASK');

[Updated on: Tue, 22 July 2014 23:10]

Report message to a moderator

Re: Message found in alert log [message #619489 is a reply to message #619488]

Tue, 22 July 2014 23:17

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

who else but DBA has access & looks at alert_SID.log file?

We have met the enemy & they is us.

Please note the Handle of OP; who claims to be "Database_admin" (in name only)!

Report message to a moderator

Re: Message found in alert log [message #619573 is a reply to message #619489]

Wed, 23 July 2014 08:19

Database admin
Messages: 365
Registered: September 2006
Location: india

Senior Member

Hi trantuananh,

Thanks for your suggestion.
So if we drop that task we wont receive this message in the alert log again ?

Hi Blackswan,
Quote:

We have met the enemy & they is us.
Please note the Handle of OP; who claims to be "Database_admin" (in name only)!

Are you calling me enemy ? i don't understand your words.So what asking you to clarify what you have written?

Regards,
Srini

Report message to a moderator

Re: Message found in alert log [message #619575 is a reply to message #619573]

Wed, 23 July 2014 08:29

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

So if we drop that task we wont receive this message in the alert log again ?

What is your opinion about this?

Report message to a moderator

Re: Message found in alert log [message #619588 is a reply to message #619575]

Wed, 23 July 2014 12:00

Database admin
Messages: 365
Registered: September 2006
Location: india

Senior Member

Hi Michel,
Quote:

So if we drop that task we wont receive this message in the alert log again ?

My opinion is 'yes' if we drop the task we wont receive this message.
But is there any impact to database if i drop the task ?

Quote:

It look like your DBA used EM to invoke Auto SQL Tuning Task.

Is there a way to find out who has invoked it ?

Regards,
Srini

Report message to a moderator

Re: Message found in alert log [message #619589 is a reply to message #619588]

Wed, 23 July 2014 12:02

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

But is there any impact to database if i drop the task ?

What is the purpose of this task?

Report message to a moderator

Re: Message found in alert log [message #619606 is a reply to message #619588]

Wed, 23 July 2014 13:03

Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web

Senior Member

Database admin wrote on Wed, 23 July 2014 22:30

Quote:
It look like your DBA used EM to invoke Auto SQL Tuning Task.

Is there a way to find out who has invoked it ?

Most probably OP's DBA. Also, OEM is not meant for developers.

If your aim is to find the name behind the responsible person, I doubt if that would help resolving any issues other than a big time chance to blame that DBA.

Report message to a moderator

Re: Message found in alert log [message #619609 is a reply to message #619606]

Wed, 23 July 2014 13:15

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

Most probably OP's DBA.

But HE is the DBA.

Quote:

If your aim is to find the name behind the responsible person, I doubt if that would help resolving any issues other than a big time chance to blame that DBA.

That is himself. Laughing

Report message to a moderator

Re: Message found in alert log [message #619615 is a reply to message #619609]

Wed, 23 July 2014 13:40

Database admin
Messages: 365
Registered: September 2006
Location: india

Senior Member

nice joke

Report message to a moderator

Re: Message found in alert log [message #619650 is a reply to message #619615]

Wed, 23 July 2014 20:39

trantuananh24hg
Messages: 744
Registered: January 2007
Location: Ha Noi, Viet Nam

Senior Member

I feel I'm a dunkey when answer to you, hmm ...

Report message to a moderator

Re: Message found in alert log [message #619719 is a reply to message #619650]

Thu, 24 July 2014 13:15

Database admin
Messages: 365
Registered: September 2006
Location: india

Senior Member

trantuananh
what is dunkey ? or its donkey ?

Report message to a moderator

Re: Message found in alert log [message #619834 is a reply to message #619719]

Fri, 25 July 2014 07:17

trantuananh24hg
Messages: 744
Registered: January 2007
Location: Ha Noi, Viet Nam

Senior Member

Donkey, sorry, I wrote on smart fone, so it change word automaticaly.

You're the most strange spammer I've never ever seen.
In my forum (Oracle VN), there are many spammer or disruption man but all of them did not tease like you. Please polite or seeking a corresponding forum to work.

I wonder about IP firewall block, Michel (!?)

Sorry, I'm not an polite man here!

Report message to a moderator

Re: Message found in alert log [message #619857 is a reply to message #619834]

Fri, 25 July 2014 10:06

Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web

Senior Member

trantuananh24hg wrote on Fri, 25 July 2014 17:47

I wonder about IP firewall block, Michel (!?)

And how do you think Michel and others know about OP's different handles? See this :

Quote:

Balaji? Ajit? Jack? Mohan? Mathew? Suhas? Srini? william?

Report message to a moderator

Re: Message found in alert log [message #619860 is a reply to message #619857]

Fri, 25 July 2014 10:25

trantuananh24hg
Messages: 744
Registered: January 2007
Location: Ha Noi, Viet Nam

Senior Member

@Lalit: I knew, but my mind is: Why did Michel know but he seem is to be sage?

Report message to a moderator

Re: Message found in alert log [message #619862 is a reply to message #619857]

Fri, 25 July 2014 10:25

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Actually it is not from IP as OP has used (many) different IPs along the time (almost 8 years). Wink

It is most of the time by OP himself who confuses his accounts and answers to one question we asked him with another account or other blunders like that (and also comparing questions and accounts in different forum).

[Updated on: Fri, 25 July 2014 10:37]

Report message to a moderator

Re: Message found in alert log [message #619863 is a reply to message #619860]

Fri, 25 July 2014 10:27

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

trantuananh24hg wrote on Fri, 25 July 2014 17:25

@Lalit: I knew, but my mind is: Why did Michel know but he seem is to be sage?

I think, but this is just my opinion, "stupidity" is not a sufficient reason to be banned. Smile

Report message to a moderator

Re: Message found in alert log [message #619865 is a reply to message #619862]

Fri, 25 July 2014 10:34

Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web

Senior Member

http://en.m.wikipedia.org/wiki/Dissociative_identity_disorder

dissociative identity disorder, multiple personality disorder, split personality or whatever you call it... Wink

Report message to a moderator

Re: Message found in alert log [message #619871 is a reply to message #619865]

Fri, 25 July 2014 11:33

Database admin
Messages: 365
Registered: September 2006
Location: india

Senior Member

Moderators,

For your information.If you want to share any jokes,or want to discuss something about others my thread is not the right place to do so.
There is a forum called 'TEST' in orafaq where you could discuss whatever topic you want to ,crack jokes on others or shares some good jokes etc..

This is my humble request.

The purpose i open a thread is to clarify my doubts on issues i face in database .I hope i am clear for you all.

Regards,
Srini

[Updated on: Fri, 25 July 2014 11:33]

Report message to a moderator

Re: Message found in alert log [message #619873 is a reply to message #619871]

Fri, 25 July 2014 11:35

Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web

Senior Member

How about posting in "community hangout"?

Report message to a moderator

Re: Message found in alert log [message #619875 is a reply to message #619871]

Fri, 25 July 2014 11:45

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

What is not clear is who you are... Grin

Report message to a moderator

Re: Message found in alert log [message #619884 is a reply to message #619875]

Fri, 25 July 2014 13:26

Database admin
Messages: 365
Registered: September 2006
Location: india

Senior Member

Quote:

How about posting in "community hangout"?

Its up to you

Quote:

What is not clear is who you are...

I am a human being Wink

[Updated on: Fri, 25 July 2014 13:26]

Report message to a moderator

Re: Message found in alert log [message #619886 is a reply to message #619884]

Fri, 25 July 2014 13:37

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Are you sure? Can you prove it? Razz

Report message to a moderator

Re: Message found in alert log [message #619887 is a reply to message #619886]

Fri, 25 July 2014 13:56

Database admin
Messages: 365
Registered: September 2006
Location: india

Senior Member

Are you sure? Can you prove it?

yes i will .come to my hometown . Smile

Report message to a moderator

Re: Message found in alert log [message #619888 is a reply to message #619887]

Fri, 25 July 2014 14:08

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Which is?
And who will I meet? Balaji? Ajit? Jack? Mohan? Mathew? Suhas? Srini? william?

Report message to a moderator

Re: Message found in alert log [message #619907 is a reply to message #619888]

Fri, 25 July 2014 17:28

Database admin
Messages: 365
Registered: September 2006
Location: india

Senior Member

The one available in Hong kong. Very Happy

Report message to a moderator

Re: Message found in alert log [message #619916 is a reply to message #619907]

Sat, 26 July 2014 00:08

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

But from your profile I should not have to go to Hong-Kong... Grin

Report message to a moderator

Previous Topic:	ORA-01012: not logged on
Next Topic:	Archive log destination is generating more redo

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Feb 22 17:20:38 CST 2025