Re: what is the data dictionary?

  • From: Balakrishna Y <krishna000@xxxxxxxxx>
  • To: martin.a.berger@xxxxxxxxx
  • Date: Tue, 22 Sep 2009 08:49:58 +0530


Data Dictionary contains metadata and you know very well rest.

X$tables normally resides in memory itself and you can query all
x$tables using this query .

select kqftanam from x$kqfta;



On Tue, Sep 22, 2009 at 1:45 AM, Martin Berger
<martin.a.berger@xxxxxxxxx> wrote:
> Hi List,
> once again I stumble about two realy dumb (and related) questions:
> 1) what is the data dictionary (or how can I identify objects which belongs 
> to it)?
> 2) is there any spyhole to view into the row cache (like v$bh for the buffer 
> cache)?
> According to the documentation, the data dictionary 
> is
> "A read-only collection of database tables and views containing reference 
> information about the database, its structures, and its users."
> The row cache is  defined 
> with
> "A memory area in the shared pool that holds data dictionary information. The 
> data dictionary cache is also known as the row cache because it holds data as 
> rows instead of buffers, which hold entire data blocks."
> Even v$rowcache seems not as featured as I'd like it to be.
> This question is not based on any need,  just pure curiosity.
>  thank you for any hint,
>  Martin
> --

Other related posts: