les10 mon db20 tell me





Monitoring Performance Issues









The interactions in this eCourse require Javascript to be enabled.



 

Monitoring Performance Issues


previous|next





Oracle Database XE enables you to monitor the following performance statistics.


Session information: A session is the connection of a user to an Oracle database instance. A session lasts from the time the user connects until the time the user disconnects or exits the database application.



The System Statistics page displays statistics for:

Physical I/O
Logical I/O
Memory
Time
SQL cursor
Transaction




Top SQL: The "top" SQL statements represent the SQL statements that are executed most often, that use more system resources than other SQL statements, or that use system resources more frequently than other SQL statements.



Long operations
: The Long Operations page displays the status of various operations that run for longer than six seconds (in absolute time). These operations currently include many backup and recovery functions, statistics gathering, and query execution. More operations are added for every Oracle release.




 
 
 








Wyszukiwarka

Podobne podstrony:
les10 man mem20 tell me
les10 man tblspc10 tell me
les10 man mem10 tell me
les10 man usr10 tell me
les10 man usr21 tell me
les10 man usr20 tell me
les10 man set20 tell me
les10 man tblspc20 tell me
les10 man set10 tell me
les10 mon?10 tell me
les05 ins tab20 tell me
Geri Halliwell Don t?ll me?by
Bee Gees Tell Me Why
les05 sav chg20 tell me
les05 ins tab30 tell me
Blink2 Don t Tell Me That It s Over
les05 upd rows10 tell me

więcej podobnych podstron