| avnish |
Posted: Apr 16, 2008 02:03:30 AM |
Total Post: 50
Joined: Dec, 2007
|
Hi Experts,
i need full list of oracle events that can be dumped for tuning purpose. or
i need full list of events that are used with this command
alter system set event " ";
thanks
Avnish |
|
|
 Murtuja |
| Posted: Apr 16, 2008 03:54:27 AM |  |
|
Total Post: 814
Joined: Jan, 2006
|
List of diagnostic events
http://www.adp-gmbh.ch/ora/tuning/diagnostic_events/list.html
If you want to know more about all events then below sites will be useful
http://www.dba-oracle.com/t_10046_tracing_events.htm
http://www.adp-gmbh.ch/ora/tuning/event.html
http://www.adp-gmbh.ch/ora/tuning/diagnostic_events/index.html
|
|
|
|
|
| Gitesh |
| Posted: Apr 17, 2008 12:11:34 AM | |
|
Total Post: 322
Joined: May, 2005
|
As you said...
i need full list of oracle events that can be dumped for tuning purpose. or
i need full list of events that are used with this command
alter system set event " ";
Dear friend,
Oracle wait event is different then event which can set systemwide or session.
Wait event you can't set with "alter system set event" command. It will automatically stored in the data dictionary views or volatile views (v$).
Both are different.
|
|
|
|
|
| avnish |
| Posted: Apr 17, 2008 04:50:55 AM | |
|
Total Post: 50
Joined: Dec, 2007
|
Mr. gitesh,
We are not here for arguments...we are here for solutions...
in my query where did you see that i am asking about "an oracle event"?????
Pleas tell me?
|
|
|
|
|
| avnish |
| Posted: Apr 17, 2008 04:52:21 AM | |
|
Total Post: 50
Joined: Dec, 2007
|
in my previous post i m asking you where did you see an oracle wait event in my query?
|
|
|
|
|
| Ratnaker |
| Posted: Apr 18, 2008 12:21:54 AM | |
|
Total Post: 136
Joined: Apr, 2007
|
The following SQL statement displays an alphabetical list of all Oracle wait events and the wait class to which they belong:
SQL> SELECT name, wait_class FROM V$EVENT_NAME ORDER BY name;
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
