ary manages tablespace to locally
> managed tablespace.Can any one experienced any issues with locally managed
> tablespace?
> Do any one experience what gain after changing to locally managed
> tablespace?
>
> Thx
> -Seema
>
>
>
>
>
Hi,
What is the group view if I will go with locally managed tablespaces?
thx
-seema
_
Tired of spam? Get advanced junk mail protection with MSN 8.
http://join.msn.com/?page=features/junkmail
--
Please see the official ORACLE-L FAQ
Hi all
I am getting this error while running a large query, I recently created
this locally managed temp tablespace...
Any advice on possible solutions, the tablespace is 5 gig
ORA-01652: unable to extend temp segment by 32 in tablespace TEMP_LOCAL
TIA
--
Saj Iqbal
--
Please see the off
!! Please do not post Off Topic to this List !!
Anyone here tried to use those locally managed
tablespace? Some DBA here persuade me to use the
locally managed TS for the
rollback segment,tables, indexes, temp tablespace
Can you tell me what are the benefits of using the
locally managed
Seema
Oracle version?
Have you studied the paper "How to Stop Defragmenting . . ." so you
understand how to configure your LMT?
Overall, my results with LMT have been great. Oracle says eventually we
will all be LMT.
Dennis Williams
DBA, 80%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
I will say, "welcome to the club."
-Original Message-
Sent: Tuesday, June 24, 2003 11:59 AM
To: Multiple recipients of list ORACLE-L
Hi,
What is the group view if I will go with locally managed tablespaces?
thx
-seema
_
T
"group view"?
if you mean, where can you find the information about the tablespace
and datafiles, that is in the same set of views as dictionary-managed
tablespaces:
dba_tablespaces
dba_data_files
if that's not what you meant... please clarify what it is that you are
looking for
--- Seema Sing
and that including the PEOPLESOFT guys too...
-Original Message-
Sent: Tuesday, June 24, 2003 5:45 PM
To: Multiple recipients of list ORACLE-L
Seema
Oracle version?
Have you studied the paper "How to Stop Defragmenting . . ." so you
understand how to configure your LMT?
Overall,
8.1.7.4 and 9i
From: DENNIS WILLIAMS <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Subject: RE: LOCALLY MANAGED TABLESPACE
Date: Tue, 24 Jun 2003 08:44:39 -0800
Seema
Oracle version?
Have you studied the paper
What is the group view on your going with the locally managed tablespaces?
Well, go ahead, make my data!
Mladen Gogala
Oracle DBA
Phone:(203) 459-6855
Email:[EMAIL PROTECTED]
-Original Message-
Sent: Tuesday, June 24, 2003 11:59 AM
To: Multiple recipients of list ORACLE-L
Hi,
What is
of list ORACLE-L <[EMAIL PROTECTED]>
Subject: RE: LOCALLY MANAGED TABLESPACE
Date: Tue, 24 Jun 2003 09:19:48 -0800
8.1.7.4 and 9i
From: DENNIS WILLIAMS <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Subject: RE: LOCALL
[EMAIL PROTECTED] Subject:
tablespace to locally
managed tablespace.Can any one experienced any issues with locally managed
tablespace?
Do any one experience what gain after changing to locally managed
tablespace?
Thx
-Seema
_
Unlimited Internet access for only
Title: RE: LOCALLY MANAGED TABLESPACE
Metalink Note: 93771.1
-Original Message-
From: Seema Singh [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 24, 2002 2:49 PM
To: Multiple recipients of list ORACLE-L
Subject: LOCALLY MANAGED TABLESPACE
Hi
I am thinking to change our few
Title: RE: LOCALLY MANAGED TABLESPACE
The only issue we faced was convincing the management that in LMT having 150 extents is not really a problem.
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot
Title: RE: LOCALLY MANAGED TABLESPACE
why did management care?
- Original Message -
From:
Jamadagni, Rajendra
To: Multiple recipients of list ORACLE-L
Sent: Friday, October 25, 2002 7:04
AM
Subject: RE: LOCALLY MANAGED
TABLESPACE
The only issue we faced
Title: RE: LOCALLY MANAGED TABLESPACE
Good question I don't know ...
Raj
__
Rajendra
Jamadagni
MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot
com
Any opinion expressed here is
personal and doesn't refle
Title: RE: LOCALLY MANAGED TABLESPACE
Same here
Getting management to first understand the
extent issue on Dictionary managed was a interesting exercise.
Now trying to break that understanding down when wanting to use LMT is like
double the work, painful.
Difficult thing trying to
Title: RE: LOCALLY MANAGED TABLESPACE
In a
'converted/migrated' LMT, tables/indexes can not take advantage
of UNIFORM or SYSTEM (autoallocate) policy of extent management. Those
objects still grow with their old 'next' extent sizes. For full benefits of
LMT, consi
Title: RE: LOCALLY MANAGED TABLESPACE
Pardon
the ignorance, I'm simply trying to understand... What is meant by "management"
in this context? I'm can't imagine a circumstance under which ANY business
manager would have a say on what goes on in the black box called O
Title: RE: LOCALLY MANAGED TABLESPACE
You
are lucky, very lucky...
-Original Message-From: Gary Weber
[mailto:[EMAIL PROTECTED]]Sent: Friday, October 25, 2002 9:59
AMTo: Multiple recipients of list ORACLE-LSubject: RE:
LOCALLY MANAGED TABLESPACE
Pardon the ignorance, I
Title: RE: LOCALLY MANAGED TABLESPACE
Some business managers migrate (pardon the pun) from being a techie to a
bean counter type. So they know.
Raj
__
Rajendra
Jamadagni
MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot
com
Title: RE: LOCALLY MANAGED TABLESPACE
Or am I simply lucky to not have that
level of bureaucracy - You are lucky
We are busy going into production for a
big project, during the rollout and data take on the managers wanted to know
all these things, it comes down to them not just
Title: RE: LOCALLY MANAGED TABLESPACE
It's a question of responsibilities, not
knowledge.
Knowing something does not mean that one should
continue to be involved. Most managers (or directors or VPs)
who continue to be concerned in this technical detail are not
paying attention t
The other thing I've encountered is where a consultant comes in and makes a
fuss about the number of extents. Usually privately to a manager, then
leaves, so you don't have an opportunity to discuss the issue. Or a GUI tool
is demonstrated that has a screen to "find problems", and usually one of th
Title: RE: LOCALLY MANAGED TABLESPACE
Tim,
That's not the case, these guys are techies .. now handling higher
duties. They just haven't kept up with 9i yet ... and yes they do their job very
well.
Raj
__
Rajendra
!
-Original Message-
Sent: Thursday, October 24, 2002 1:49 PM
To: Multiple recipients of list ORACLE-L
Hi
I am thinking to change our few dictinary manages tablespace to locally
managed tablespace.Can any one experienced any issues with locally managed
tablespace?
Do any one
Title: RE: LOCALLY MANAGED TABLESPACE
I think your boss's boss might be relating 'locally' in LMT with standby db location ... who knows ...
Raj
__
Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at E
esn't reflect that of ESPN
Inc.
QOTD: Any clod can have facts, but having an opinion is an art!
-Original Message-
Sent: Thursday, October 24, 2002 1:49 PM
To: Multiple recipients of list ORACLE-L
Hi
I am thinking to change our few dictinary manages tablespace to locally
ma
nking to change our few dictinary manages tablespace to locally
managed tablespace.Can any one experienced any issues with locally
managed
tablespace?
Do any one experience what gain after changing to locally managed
tablespace?
Thx
-Seema
--
Please see the official ORACLE-L FAQ: http://
an have facts, but having an opinion is an art!
-Original Message-
Sent: Thursday, October 24, 2002 1:49 PM
To: Multiple recipients of list ORACLE-L
Hi
I am thinking to change our few dictinary manages tablespace to locally
managed tablespace.Can any one experienced any issues with locally
m
ORACLE-L
Hi
I am thinking to change our few dictinary manages tablespace to locally
managed tablespace.Can any one experienced any issues with locally managed
tablespace?
Do any one experience what gain after changing to locally managed
tablespace?
Thx
-Seema
--
Please see the official
Hi Sajid,
Use ALTER TABLESPACE ADD DATAFILE statement to add one or more files to the
tablespace indicated. This should fix the problem.
Moses
-Original Message-
Sent: Tuesday, January 15, 2002 12:50 PM
To: Multiple recipients of list ORACLE-L
Hi all
I am getting this error while ru
januari 2002 10:50
Aan: Multiple recipients of list ORACLE-L
Onderwerp: Locally Managed Tablespace
Hi all
I am getting this error while running a large query, I recently created
this locally managed temp tablespace...
Any advice on possible solutions, the tablespace is 5 gig
ORA-01652: unable to
split the query, and make use of temporary tables (by using CTAS)
to save results of the first part ...
HTH, Remco
-Oorspronkelijk bericht-
Van: Sajid Iqbal [mailto:[EMAIL PROTECTED]]
Verzonden: dinsdag 15 januari 2002 10:50
Aan: Multiple recipients of list ORACLE-L
Onderwerp: Locall
Multiple recipients of list ORACLE-L
Onderwerp: Locally Managed Tablespace
Hi all
I am getting this error while running a large query, I recently created
this locally managed temp tablespace...
Any advice on possible solutions, the tablespace is 5 gig
ORA-01652: unable to extend temp segment
I am confused about locally managed tablespaces.
I created a locally managed tablespace called "INDEX01" using "UNIFORMED"
extents of 128K (131072bytes).
I then imported in the tables and indexes from an different database.
When I query DBA_TABLESPACES it shows that the
recipients of list ORACLE-L
!! Please do not post Off Topic to this List !!
Anyone here tried to use those locally managed
tablespace? Some DBA here persuade me to use the
locally managed TS for the
rollback segment,tables, indexes, temp tablespace
Can you tell me what are the benefits of using
!! Please do not post Off Topic to this List !!
Chris - As I understand it, locally managed tablespaces with uniform
extents, possibly autoextensible, is the future direction for Oracle. This
will allow Oracle to be more easily managed. Probably put us DBAs out of
work, but hey something always s
!! Please do not post Off Topic to this List !!
Making Oracle simpler to work with I don't fear would put dba's out of work.
A dba's role is far more involved than just the daily janitor work.
Planning is also a large part of our job as well.
But let's think about this, look at Windows, a monkey
PM
To: Multiple recipients of list ORACLE-L
!! Please do not post Off Topic to this List !!
Anyone here tried to use those locally managed
tablespace? Some DBA here persuade me to use the
locally managed TS for the
rollback segment,tables, indexes, temp tablespace
Can you tell me what are the be
do not post Off Topic to this List !!
Anyone here tried to use those locally managed
tablespace? Some DBA here persuade me to use the
locally managed TS for the
rollback segment,tables, indexes, temp tablespace
Can you tell me what are the benefits of using the
locally managed tablespace, any
!! Please do not post Off Topic to this List !!
Since you can't usually predict which rollback segment a particular transaction
is going to use anyway, generally accepted best practice is to create a
dedicated tablespace (or usually one per instance for OPS) for rollback
segments, "enough" rollba
!! Please do not post Off Topic to this List !!
So if I understand you correctly, I should have rollback segments and temp segments
different for each of the different extent sizes I choice. So if I have tablespaces
with 128K, 1M and 4M I should have private rollbacks segments set up for each
Please visit me on Mt. Sinai for the next 6 commandments.
> -Original Message-
> From: Kathy Duret [mailto:[EMAIL PROTECTED]]
> Sent: Friday, September 14, 2001 5:36 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Locally managed tablespace
>
>
Title: RE: Locally Managed Tablespace Confusion
I think it's because dba_segments (or dba_indexes) will show the initial/next specified at creation time, even though the extents were not created at that size. Look in dba_extents to see that all extents are the same size.
Example:
I have to move a 7.3.4 database to 8i and I want to use the uniform extent
size to reduce fragmentation. I read the article "stop defragmenting and
start living" and it indicates to have 3 extent sizes - 128K, 4M, 128M.
I also read an article on Steve Adams site that indicates to keep the number
The advice on Metalink is sound in the sense that
using a finite number of extent sizes is a good thing,
but (imho) the choice of sizes for extents is largely
up to you (a point that the article doesn't really
convey).
The key with the uniform extent is avoiding
fragmentation issues; combine that
My understanding was that the main reason to keep the number of extents down
was in case you needed to drop or truncate the table it would take Oracle a
long time to clean up the fet$ table.
I think, and I emphasize that I am not certain of this, that this is no
longer a problem with locally manag
Title: RE: Locally Managed Tablespace Uniform Extent
> -Original Message-
> From: Miller, Jay [mailto:[EMAIL PROTECTED]]
>
> My understanding was that the main reason to keep the number
> of extents down
> was in case you needed to drop or truncate the table it wo
sual, Steve Adams has some sage advice on the
> subject. Check out his
> article "Planning Extents"
> http://www.ixora.com.au (click on Tips then on
> Planning Extents)
> in which he mentions that there are reasons for
> keeping the number of
> extents down even in a
Jim,
I'm probably a bit extreme here, but, with all due respect
to Steve Adams (because I really do), I wouldn't worry
terribly much about numbers of extents.
Our 8.1.6 production db on Win2k has 8KB block size and
uniform extent size of 1MB in all tablespaces. Our largest
segment stores the ou
Hi gurus,
Could you explain that.
Working with tablespace in locally managed, with uniform extends size, we
want to create LOB but we must have the uniform extend size 3 times the
db_block_size, right?
Otherwise we got ORA-03237.
With dictionnary managed tablespace we don't have this problem.
Lu
Luc,
got this for u from metalink.
Solution Description
You need to ensure that the extent size specification in the tablespace is at least
four times the
db_block_size. i.e:
Extents in a Locally Managed Tablespace Cause a Performance
Overhead ?
We Convert the ALLOCATION_TYPE from SYTEM to USER to Allow us to Control the
NEXT_EXTENT Size Manually
This is Done by Running the Following 2 Commands on the respective Locally managed
Tablespace
execute
for Both Cases ?
>
> For Objects Existing in Locally managed Tablespaces
> having ALLOCATION_TYPE SYSTEM , NEXT_EXTENT has NO
> Value But EXTENTS has Values .
>
> Qs Can Large Numbers of Extents in a Locally
> Managed Tablespace Cause a Performance Overhead ?
>
> We Co
h is Better ,
> ALLOCATION_TYPE USER OR SYSTEM with
> EXTENT_MANAGEMENT being LOCAL for Both Cases ?
>
> For Objects Existing in Locally managed Tablespaces
> having ALLOCATION_TYPE SYSTEM , NEXT_EXTENT has NO
> Value But EXTENTS has Values .
>
> Qs Can Large Numbers o
EXTENT_MANAGEMENT being LOCAL for Both Cases ?
> >
> > For Objects Existing in Locally managed
> Tablespaces
> > having ALLOCATION_TYPE SYSTEM , NEXT_EXTENT has NO
> > Value But EXTENTS has Values .
> >
> > Qs Can Large Numbers of Extents in a Locally
>
58 matches
Mail list logo