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 -> DBA_SEGMENT query question

DBA_SEGMENT query question

From: Unknown <zgeist_at_ee.ee.net>
Date: 1997/01/16
Message-ID: <5blc73$pv@news1.ee.net>#1/1

Greetings all -

I am running Oracle 7.2.3 and receive the following output from a query against DBA_SEGMENTS:

SEGMENT_NAME SEGMENT_TYPE EXTENTS MAX_EXTENTS

------------------------- ----------------- ---------- -----------
1.377                     CACHE                      1           0

What the heck is a cache segment and how is the EXTENTS value larger than MAX_EXTENTS ?

Thanks in advance for any assistance !

Brett Cunningham
zgeist_at_ee.net Received on Thu Jan 16 1997 - 00:00:00 CST

Original text of this message

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