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
>
>
> --
> //www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
