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

Home -> Community -> Mailing Lists -> Oracle-L -> RE: REP: Locally Managed Tablespaces

RE: REP: Locally Managed Tablespaces

From: Henry Poras <Henry.Poras_at_ctp.com>
Date: Tue, 24 Apr 2001 14:21:54 -0700
Message-ID: <F001.002F1641.20010424134559@fatcity.com>

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: The Oracle DBA INET: theoracledba_at_lycos.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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Patricia Ashe INET: pashe_at_TRUELINK.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). -- 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).
Received on Tue Apr 24 2001 - 16:21:54 CDT

Original text of this message

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