Re: DBA_SEGMENT query question

From: Vijay Vardhineni <vardhineni_at_worldnet.att.net>
Date: 1997/01/16
Message-ID: <01bc0407$45d991e0$376893cf@default>#1/1

Some time back, I found the similar type of segment in our database. This segment was created by SYS in the tablespace TEMP. As this segment was created by SYS, I thought Oracle created this segment for its internal processing.

Vijaya Kumar Vardhineni
Certified Oracle DBA, EDS
Plano, TX

Unknown <zgeist_at_ee.ee.net> wrote in article <5blc73$pv_at_news1.ee.net>...
>
>
> 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