Re: performance views and dictionary views

Dino,
becoming an expert in anything takes experience not memorizing a bunch of stuff. The dictionary and v$views are loaded with a wealth of information, you will use different veiws in different situations on different configurations.
Thus the experience factor. The best advice I can give is to know where to look
for the information and how to use it. (IE metalink, news groups, technet, white papers.) Read as much as you can and rememberwhat you learn.

Stephen Ashmore
Brainbench MVP for Oracle
www.brainbench.com

"Dino Hsu" <dino1.nospam_at_ms1.hinet.net> wrote in message news:s84urtk4995vqalrdn27jhl2kh80dkrr6r_at_4ax.com...
> 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 - 10:39:10 CDT