Re: REP: Locally Managed Tablespaces

Alex, X$ tables are simply memory structures. In this case it is populated by data from the file headers. This stuff does not exist in the database. Jared On Wednesday 25 April 2001 07:49, Hillman, Alex wrote: And what is x$ktfbue and how it is maintained if there is no info in data

RE: REP: Locally Managed Tablespaces

Thanks Mark. -Original Message- Sent: Wednesday, April 25, 2001 12:56 PM To: Multiple recipients of list ORACLE-L I haven't got this back on the list yet - and haven't recieved a message from the list since about 9 this morning - so I thought I would resend this just in case.. --

RE: REP: Locally Managed Tablespaces

And what is x$ktfbue and how it is maintained if there is no info in data dictionary? Alex Hillman -Original Message- Sent: Tuesday, April 24, 2001 9:20 PM To: Multiple recipients of list ORACLE-L On Tuesday 24 April 2001 14:24, Henry Poras wrote: Isn't it also in sys.uet$? Oops,

RE: REP: Locally Managed Tablespaces

Right, I have done a little diggin in to this and the upshot is that if you create a LMT with UNIFORM extent sizes, then the tablespace will adere to those extent sizes no matter what you specifiy in the INITIAL storage parameter. I have a LMT already created with a UNIFORM extent size of 128k:

FW: REP: Locally Managed Tablespaces

I haven't got this back on the list yet - and haven't recieved a message from the list since about 9 this morning - so I thought I would resend this just in case.. -- Right, I have done a little diggin in to this and the upshot is that if you create a LMT with UNIFORM extent sizes, then the

Re: REP: Locally Managed Tablespaces

-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Re: REP: Locally Managed Tablespaces

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 [EMAIL PROTECTED] On Mon, 23 Apr 2001 11:01:37 Jared Still wrote:

RE: REP: Locally Managed Tablespaces

of list ORACLE-L Subject: RE: REP: Locally Managed Tablespaces 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

RE: REP: Locally Managed Tablespaces

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

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: [EMAIL PROTECTED]; Henry Poras Henry, The extent info does not

Re: REP: Locally Managed Tablespaces

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

Re: REP: Locally Managed Tablespaces

Sorry, I've been using LMT since they came out. I'll have to see hard evidence and a reproducible test case. Jared On Tuesday 24 April 2001 12:52, The Oracle DBA wrote: A couple of threads here and in other lists have mentioned this. A person puts LMTSs up and sets uniform extents on and

Re: REP: Locally Managed Tablespaces

On Tuesday 24 April 2001 14:24, Henry Poras wrote: 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? Yes, they show up in dba_extents, but it doesn't come from sys.uet$. Here's the view as

REP: Locally Managed Tablespaces

Are you using uniform extents? We are told they are not really = and actually are not the same at all over time. Thanks, --- TheOracleDBA [EMAIL PROTECTED] On Thu, 19 Apr 2001 15:25:31 Peter Barnett wrote: We are using LMTs with several of our databases. No problems. With these

Re: REP: Locally Managed Tablespaces

And just who is it that told you that? [EMAIL PROTECTED] 04/23/01 02:40PM Are you using uniform extents? We are told they are not really = and actually are not the same at all over time. Thanks, --- TheOracleDBA [EMAIL PROTECTED] On Thu, 19 Apr 2001 15:25:31 Peter Barnett wrote: