Q
Problem solve Get help with specific problems with your technologies, process and projects.

Which user is putting pressure on the database?

I would like to identify which user is putting pressure on an Oracle database. Which view(s) should I use for this and how do I upgrade the performance of the database?

Hi, Don. I would like to identify which user is putting pressure on an Oracle database. Which view(s) should I use for this and how do I upgrade the performance of the database?
The Oracle10g Automated Session History tables are perfect for this, and you can get information about the most active users in 10 OEM also. You can also look at v$session_event:

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

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close