There are plenty of sql scripts out there publically available on internet.
You can use tools like toad for performance monitor, as well. The are quite handy.
Use AWR and ASH as well.
Salam sir I am new DBA in one company, so i needs some usefull script to check the Top consumer,top session and more,, so i have search in google but, does not find good one,, you may have to which u use daily basis...please send it on send it by email [hidden email] or other souce Regard If you reply to this email, your message will be added to the discussion below: http://erman-arslan-s-oracle-forum.2340467.n4.nabble.com/Check-the-performance-tp1525.html To start a new topic under Database, email [hidden email] To unsubscribe from Erman Arslan's Oracle Forum, click here. NAML