Re: DBA_SEGMENT query question

From: AWILSON <awilson_at_rci.rogers.com>
Date: 1997/01/17
Message-ID: <32DFE76F.6D21@rci.rogers.com>#1/1

Unknown wrote:
>
> 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

I don't know the answer but...
It may help to display the Owner and Tablespace of the Segment?

---

The above reflect my personal views and in no way are connected with whomsoever I may be working for at this particular point in time.  

Alan Wilson                              Help fight continental drift.
======================================================================

Received on Fri Jan 17 1997 - 00:00:00 CST