Re: performance views and dictionary views

On Sat, 6 Oct 2001 12:19:54 +0200, "Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote:

>
>v$fixed_table : v$ and x$(?) objects
>dict : v$ objects and dictionary views *on top of v$ objects and ...$
>objects*
>I think your mixing up two different concepts.
>As dict is a view, you may try to retrieve it's definition.
>

v$fixed_table = v$... and x$... objects = performance views)
dict = v$ ...$... and dba_..., all_..., user_... = performance views + dictionary views
The resulting difference is the dictionary views, which stands for about 851-641=210 views. Generally these objects are either views or synonyms to views, correct me if I am wrong.

My major problem is how to memorize the many views, their contents and usages. I found many test questions are about these views, especially the 'performance tuning'. Furthermore, I remember a post earlier about what a real Oracle DBA is like, which emphasizes an Oracle DBA should be able to manually collect information from these views, and takes actions accordingly, instead of resorting to automated GUI tools, which could be used without indepth knowledge. Those who knows these views very well probably have developed a systematic approach to retain the knowledge, and this is what I really need.

Dino Received on Sat Oct 06 2001 - 09:29:44 CDT