RE: REP: Locally Managed Tablespaces

Isn't it also in sys.uet$? Oops, that's for dictionary managed, not locally managed. You're right. But isn't there a way to see locally managed extents?

Henry

-----Original Message-----
Sent: Tuesday, April 24, 2001 5:19 PM
To: ORACLE-L_at_fatcity.com; Henry Poras

Henry,

The extent info does not come from the DD, it is in the datafile header.

Jared

On Tuesday 24 April 2001 14:45, Henry Poras wrote:
> I haven't tried it, but I recall hearing that all extents really are 1M,
it
> is just the data dictionary displays that are confusing. If you create a
> table with initial=next=1.5M, I believe dba_tables will show the create
> parameters, while dba_extents will show the actual extent sizes. I don't
> have a good test database right now to try this. Maybe I have the
> dictionary tables wrong (I guess I could check their sources).
>
> Henry
>
> -----Original Message-----
> Sent: Tuesday, April 24, 2001 4:47 PM
> To: Multiple recipients of list ORACLE-L
>
>
> I am doing some research on locally managed tablespaces prior to using
> them. Looking for problems, etc. This is the first negative response I
> have heard about them. Perhaps, storage parameters were specified on the
> create table?
>
> Patricia
> -----Original Message-----
> Sent: Tuesday, April 24, 2001 12:52 PM
> To: Multiple recipients of list ORACLE-L
>
>
> A couple of threads here and in other lists have mentioned this. A person
> puts LMTSs up and sets uniform extents on and sets it to, say 1M. Later
> they notice that not all extents are 1M.
>
> Thanks,
>
> Earl
>
> ---
>
> TheOracleDBA
> theoracledba_at_lycos.com
>
>
>
> On Mon, 23 Apr 2001 11:01:37
>
> Jared Still wrote:
> >On Monday 23 April 2001 11:40, The Oracle DBA wrote:
> >> Are you using uniform extents? We are told they are not really = and
> >> actually are not the same at all over time.
> >
> >Do you have a source for this information? A number of us have been
> >using LMT's with uniform extents, and have not seen that.
> >
> >Jared
> >--
> >Please see the official ORACLE-L FAQ: http://www.orafaq.com
> >--
> >Author: Jared Still
> > INET: jkstill_at_cybcon.com
> >
> >Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> >San Diego, California -- Public Internet access / Mailing Lists
> >--------------------------------------------------------------------
> >To REMOVE yourself from this mailing list, send an E-Mail message
> >to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> >the message BODY, include a line containing: UNSUB ORACLE-L
> >(or the name of mailing list you want to be removed from). You may
> >also send the HELP command for other information (like subscribing).
>
> Get 250 color business cards for FREE!
> http://businesscards.lycos.com/vp/fastpath/

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Henry Poras
  INET: Henry.Poras_at_ctp.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).