Re: <<< Internal database structure >>>

In article <4s2s4f$ta7_at_alpha.ftech.net> simon_at_pace-data.co.uk (Simon Denvers) writes:
>exbrayat_at_lisiflory.insa-lyon.fr (Matthieu Exbrayat) wrote:
>
>>Hello,
 

>>I'd like to know if internal database structure of oracle is document.
>>If it is, where can I find the information?
>>Our goal is to extract data direct from DB to gain time comparing to
>>using SELECT.
 

>>All explanations welcome.
>
>
>Hi Matthieu
>
>Yes it is documented, but Oracle won't let you have it - it's all
>proprietary stuff which they've spent years and millions of dollars
>developing and they won't just hand it to their competitors on a
>plate.
>
>Even the developers who write the code only specialise in certain
>parts of the database, like MTS or kernel, so even if you got hold of
>some documentation you probably couldn't make much sense of it.
>
>If you've got complex queries then you could run them overnight and
>either generate a text file or insert the data into another table.
>I'm afraid there really is no substitue for SELECT.
>

I've often thought it would be so cool to build a physical implementation of the Oracle7 innards. A real Rube Goldberg/Secret Life of Machines monster. And no, I don't mean a pile of black boxes! :)

>
>Simon Denvers
>DBA/Unix Admin
>Currently at English Heritage
>simon_at_pace-data.co.uk
>
>
>
>
>
>
>
>
>
>
>
>

-- 
Joel Garry               joelga_at_rossinc.com               Compuserve 70661,1534
These are my opinions, not necessarily those of Ross Systems, Inc.   <> <>
%DCL-W-SOFTONEDGEDONTPUSH, Software On Edge - Don't Push.            \ V /
panic: ifree: freeing free inodes...                                   O