Home » RDBMS Server » Server Administration » Wait events (Oracle 10g,11g)
Wait events [message #612814] Fri, 25 April 2014 03:19 Go to next message
Jack14
Messages: 497
Registered: December 2011
Location: INDIA
Senior Member
Hi,

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


Thanks,
Jack
Re: Wait events [message #612815 is a reply to message #612814] Fri, 25 April 2014 03:32 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
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.

Re: Wait events [message #612816 is a reply to message #612814] Fri, 25 April 2014 03:38 Go to previous messageGo to next message
ThomasG
Messages: 3211
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
"At this specific moment in time in your specific database" the answer would be something like

select event, seconds_in_wait
  from v$session
 WHERE seconds_in_wait > 0 
Re: Wait events [message #612828 is a reply to message #612816] Fri, 25 April 2014 08:23 Go to previous messageGo to next message
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
Re: Wait events [message #612829 is a reply to message #612828] Fri, 25 April 2014 08:25 Go to previous messageGo to next message
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.
Re: Wait events [message #612837 is a reply to message #612829] Fri, 25 April 2014 13:05 Go to previous messageGo to next message
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.
Re: Wait events [message #612838 is a reply to message #612837] Fri, 25 April 2014 13:11 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
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 Go to previous messageGo to next message
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?
Re: Wait events [message #612861 is a reply to message #612838] Sat, 26 April 2014 09:34 Go to previous message
Jack14
Messages: 497
Registered: December 2011
Location: INDIA
Senior Member
I will try that Michel Smile
Previous Topic: Control files in ASM.
Next Topic: need ahelp creating table
Goto Forum:
  


Current Time: Thu Mar 28 16:06:16 CDT 2024