Re: what is the data dictionary?

From: Balakrishna Y <>
Date: Tue, 22 Sep 2009 08:49:58 +0530
Message-ID: <>


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

Received on Mon Sep 21 2009 - 22:19:58 CDT

Original text of this message