| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Usenet -> comp.databases.theory -> Re: The IDS, the EDS and the DBMS
"Marshall Spight" <mspight_at_dnai.com> wrote in message
news:rgm0d.168571$mD.134957_at_attbi_s02...
> or in local parlance, there is logical structure and
> physical structure.
That parlance is even more local than you might think.
After you get done talking to the Oracle guru, and he finishes explaining to you that a "database block is phyisical", try going across the hall to the operating system guru. Here's what he says:
"If by 'database block' he means 'file block', then he's wrong. File blocks are virtual. They are mapped into logical blocks by the file mapping feature of the OS. Logical blocks are the same size as file blocks, but they have only a one dimensional address, at least on a single spindle.
Even logical blocks are not physical. Logical blocks are further translated into one or more disk sectors. Now that's physical!"
Now go down the hall to the guy who designs disk controllers. He says:
"I know the OS guy told you that 'sectors' are physical, but that's only an illusion!
Lemme tell you what's REALLY going on...." Received on Fri Sep 10 2004 - 14:01:18 CDT
![]() |
![]() |