Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How does Oracle Server Process get data block Information

Re: How does Oracle Server Process get data block Information

From: Tom Pall <TPall_at_webtv.net>
Date: Sun, 6 Dec 1998 10:00:32 -0600 (CST)
Message-ID: <21645-366AAA20-24@newsd-133.iap.bryant.webtv.net> 





Describe dba_segments.  You see there that Oracle lists the file and
block in which the segment starts.  Dba_segments is a number of levels
of data massaging above the internal tables the Oracle engine uses.  But
yes, the start of each segment and each extent which makes of the
segment is stored and available.

Received on Sun Dec 06 1998 - 10:00:32 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US