performance views and dictionary views 
Author Message
 performance views and dictionary views
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



Wed, 24 Mar 2004 15:24:15 GMT
 performance views and dictionary views


Quote:
> 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



Wed, 24 Mar 2004 18:19:54 GMT
 performance views and dictionary views
On Sat, 6 Oct 2001 12:19:54 +0200, "Sybrand Bakker"

Quote:

>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



Wed, 24 Mar 2004 22:29:44 GMT
 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


Quote:
> On Sat, 6 Oct 2001 12:19:54 +0200, "Sybrand Bakker"

> >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



Wed, 24 Mar 2004 23:39:10 GMT
 performance views and dictionary views
On Sat, 06 Oct 2001 15:24:15 +0800, Dino Hsu

Quote:

>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?

For quick lookup, you can use this page:

http://tahiti.oracle.com/pls/tahiti/tahiti.catalog_views

John
--
Got an Oracle database question?
Try the search engine for the database docs at:
http://tahiti.oracle.com/



Fri, 26 Mar 2004 18:35:59 GMT
 
 [ 5 post ] 

 Relevant Pages 

1. Performance of data dictionary views

2. Performance problem: views upon views

3. How are views on views on views executed ??

4. Urgent - Dictionary View

5. Static Data Dictionary Views

6. Mass Outer-joins with data dictionary views

7. unable to create data dictionary views

8. Data Dictionary View - Table

9. ? strange Data Dictionary results: views and column alias

10. dictionary view for primary keys

11. missing data dictionary views?

12. Analyze and Data Dictionary views on Oracle 7.3.4.0.1


 
Powered by phpBB® Forum Software