 Profiling filters out well performing light weight SQL and collects information on heavy weight SQL. SQL that is heavy weight are either long running queries or queries that are short but run so often that they put load on the database Profiler takes snapshots of user/session activity once a second and builds up a statistical model of the load on the database. The sampled data displayed in 3 ways 1. Load on the database measured in average number of sessions active 2. Top Activity - top SQL, Event and Session 3. Details - detail on a SQL , Session or Event The idea is to look at the load on the database, the top graph on the screen. The graph on the top of the screen the shows the load on the database and can quickly indicate how the database is functioning. The database could be
Problems can come from 4 areas 1 Machine cpu, slow disks (network) Reference: Wait Events Defined DB Optimizer 2.0 Editor Detail Drilldown For statements
For Session:
|