The Dynamic Performance Views are very helpful in monitoring our database for real time performance. The dynamic performance views (we will call them the V$ views to shorten the name) are real-time or almost real time views into the guts of Oracle.
Scripts are now floating around which take advantage of these views to supply detailed information about what is going on in the SGA in near-real time. It is not uncommon to see scripts which join v$session to v$sqlarea to v$sqltext to get details of what SQL is being run by which user right now and how expensive that SQL is.
The V$ Views are like the speedometer and the tachometer in our car, they tell us how fast the car (or the database) is going (or not), or like the timing light that helps us to adjust the timing . They provide almost immediate feedback as to the condition of the database. Below are the stats which shows how rapidly oracle dynamic views are increasing.
Version V$ Views X$ Tables
--------- ----------- -----------
6 23 ? (35)
7 72 126
8.0 132 200
8.1 185 271
9.0 227 352
9.2 259 394
10.1.0.2 340 (+31%) 543 (+38%)
10.2.0.1 396 613
11.1.0.6 484 (+22%) 798 (+30%)
Enjoy :-)
No comments:
Post a Comment