The following scripts are used to identify high-load and locked sessions. This posting is for responsing to the comment at http://oraclepoint.com/oralife/?attachment_id=105
High-Load Sessions:
1. Top CPU consumed sesstions: topcpu.sql
2. Display top UGA/PGA consumed sessions: monitor_memory_usage_by_databse_session.sql
Locked Sessions:
This script is used to check the locked sessions. Check_locked_session.sql
Popularity: 2% [?]
