Re: performance views and dictionary views

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Sat, 6 Oct 2001 12:19:54 +0200
Message-ID: <trtmo5bsb953a@news.demon.nl>

"Dino Hsu" <dino1.nospam_at_ms1.hinet.net> wrote in message news:bs9trtgfle334uiktkm44c4grejntbl5vo_at_4ax.com...
> Dear all,
>
> In the process of studying Oracle database, understanding the concepts
> is not difficult for me, it's performance views and dictionary views
> that often confuses me. I have trouble memorizing all these stuffs,
> and often mix up their functions. Anyone help me out?
>
> BTW, when I login a database with 'SYSTEM', I see 641 records in
> v$fixed_table while 851 records in dict. (don't quite know the
> difference though) Maybe you can show me the how to utilize these
> 'utility' views.
>
> Dino
>

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.

Regards,

Sybrand Bakker, Senior Oracle DBA Received on Sat Oct 06 2001 - 05:19:54 CDT