Re: informations about physical file layout
From: Mark D Powell <Mark.Powell_at_eds.com>
Date: Mon, 27 Apr 2009 09:36:56 -0700 (PDT)
Message-ID: <46f783ea-a887-45fc-a3f2-099f6b8288ca_at_b7g2000pre.googlegroups.com>
On Apr 27, 3:52 am, tb <t.be..._at_web.de> wrote:
> Hello,
>
> i am looking for details about internal structure of the redolog
> files, tablespace files and controlfiles. Does anyone know a book or
> website to start.
>
> Best regards
> Thomas
Date: Mon, 27 Apr 2009 09:36:56 -0700 (PDT)
Message-ID: <46f783ea-a887-45fc-a3f2-099f6b8288ca_at_b7g2000pre.googlegroups.com>
On Apr 27, 3:52 am, tb <t.be..._at_web.de> wrote:
> Hello,
>
> i am looking for details about internal structure of the redolog
> files, tablespace files and controlfiles. Does anyone know a book or
> website to start.
>
> Best regards
> Thomas
For what purpose? Oracle provides visibility to many of the in-memory and stored in the control and spfile structures via V$ views. You can find these views documented in your Oracle version# Reference manual.
The log miner utility package can be used to look at the contents of the redo logs.
The use of the above will not give you byte for byte storeage layouts but will give you the gist of what the is stored where and means to access much of it.
HTH -- Mark D Powell -- Received on Mon Apr 27 2009 - 11:36:56 CDT