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

Hi,

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;

Regards

Bala



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 http://download.oracle.com/docs/cd/E11882_01/server.112/e10713/glossary.htm#CNCPT2033
> "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 http://download.oracle.com/docs/cd/E11882_01/server.112/e10713/glossary.htm#CNCPT44459
> "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
>
>
> --
> http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l


Other related posts: