select se.event, sum(se.total_waits), sum(se.total_timeouts), sum(se.time_waited/100) time_waited from v$session_event se, v$session sess where sess.username = 'SAPR3' and sess.sid = se.sid group by se.event order by 2 DESC;
As for how to upgrade performance, well, that's a big question, and without enough details to answer here. For complete details, I would recommend the book Oracle Tuning: The Definitive Reference by Alexey Danchenkov and myself.
Dig Deeper on Oracle database performance problems and tuning
Related Q&A from Don Burleson
I have created a table, Party, and in it there are two main fields, party_code and party_name, and around 2,500 records are available in it. I passed... Continue Reading
Suppose you have a table which has only two columns, namely locid (not primary) and place. In Oracle, which query should I run to get the output as ... Continue Reading
I have a query that retrieves around 10 records. I have a task to concatenate the values separated with ','. I would like to know if Oracle has any ... Continue Reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.