OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » Wait events (Oracle 10g,11g)

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

Wait events [message #612814]

Fri, 25 April 2014 03:19

Jack14
Messages: 497
Registered: December 2011
Location: INDIA

Senior Member

Hi,

What are the frequent and most occurring wait events in oracle ?

Thanks,
Jack

Report message to a moderator

Re: Wait events [message #612815 is a reply to message #612814]

Fri, 25 April 2014 03:32

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

Senior Member
Account Moderator

There is a list of the main wait events in the documentation with their meaning, their origin and how to fix them, better than anything we could post in a forum.

Report message to a moderator

Re: Wait events [message #612816 is a reply to message #612814]

Fri, 25 April 2014 03:38

ThomasG
Messages: 3212
Registered: April 2005
Location: Heilbronn, Germany

Senior Member

"At this specific moment in time in your specific database" the answer would be something like

Code: [Select all] [Show/ hide]

select event, seconds_in_wait
  from v$session
 WHERE seconds_in_wait > 0

Report message to a moderator

Re: Wait events [message #612828 is a reply to message #612816]

Fri, 25 April 2014 08:23

Jack14
Messages: 497
Registered: December 2011
Location: INDIA

Senior Member

Thanks Thomas for the query.

Quote:

There is a list of the main wait events in the documentation with their meaning, their origin and how to fix them, better than anything we could post in a forum.

Michel,

I searched the lists in the documentation but could not find it.Could you help me to search for that link.

Thanks,
Jack

Report message to a moderator

Re: Wait events [message #612829 is a reply to message #612828]

Fri, 25 April 2014 08:25

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

http://www.oracle.com/pls/db121/search?remark=quick_search&word=wait+event&partno=

You seem to be unqualified to be within 2 meters of any keyboard.

Report message to a moderator

Re: Wait events [message #612837 is a reply to message #612829]

Fri, 25 April 2014 13:05

Jack14
Messages: 497
Registered: December 2011
Location: INDIA

Senior Member

Quote:

You seem to be unqualified to be within 2 meters of any keyboard

No actually looking for Michel to answer my question because nowadays he is not interested to answer any of our questions.
Anyways you provide the link im happy for that.

Report message to a moderator

Re: Wait events [message #612838 is a reply to message #612837]

Fri, 25 April 2014 13:11

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

Senior Member
Account Moderator

Balaji/Ajit/Jack...,

I do not answer to obvious questions from you that do not require more than typing keywords in search field of the documentation. All your questions belong to this type.
As BlackSwan said, "You seem to be unqualified to be within 2 meters of any keyboard."
More than 2 years that we constantly repeat to you where is the documentation and how to search in it.
Either you are lazy either you are definitively unqualified; in both cases you should leave any Oracle job and search for something you are able to do.

[Updated on: Fri, 25 April 2014 13:13]

Report message to a moderator

Re: Wait events [message #612839 is a reply to message #612837]

Fri, 25 April 2014 13:13

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>No actually looking for Michel to answer my question because nowadays he is not interested to answer any of our questions.
OUR?
BTW, nobody owes you an answer to any question.

>Anyways you provide the link im happy for that.
incapable or unwilling to use SEARCH & GOOGLE yourself?

Report message to a moderator

Re: Wait events [message #612861 is a reply to message #612838]

Sat, 26 April 2014 09:34

Jack14
Messages: 497
Registered: December 2011
Location: INDIA

Senior Member

I will try that Michel Smile

Report message to a moderator

Previous Topic:	Control files in ASM.
Next Topic:	need ahelp creating table

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri May 02 17:32:34 CDT 2025