Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Tue 11/4/2003 6:49 PM
To: Multiple recipients of list ORACLE-L
Cc:
Subject: Who is using temp tablespace?
Hi All,
How can I determi
v$sort_usage and v$session should give you that.
Pawan
-Original Message-
Sent: Tuesday, November 04, 2003 6:49 PM
To: Multiple recipients of list ORACLE-L
Hi All,
How can I determine who is using temp tablespace? I have a 1 gb tablespace
and it is almost full. I want to know
Hi All,
How can I determine who is using temp tablespace? I have a 1 gb tablespace
and it is almost full. I want to know who and what sql is using most
of it.
Thanks
Rick
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author:
INET: [EMAIL PROTECTED]
Fat City
Hi!
How much free space you have in your file system,
you might be hitting the sparse files issue...
Tanel.
- Original Message -
From:
A Joshi
To: Multiple recipients of list ORACLE-L
Sent: Thursday, October 23, 2003 10:49
PM
Subject: ** temp tablespace
4GB isn't all that huge.
A couple of questions I can think of are:
1. How many users are simultaneously trying to sort stuff?
2. How often does some dufus fire up a Cartesian join?
-Original Message-
Hi,
I have a huge temp tablespace (4GB) and not much usage (current usage is
Hi,
I have a huge temp tablespace (4GB) and not much usage (current usage is 50MB from v$ tables) . However it keeps running out of space. It ran out of space yesterday and I was hoping it would release but it got an error again. The database is only 35GB mostly small tables. IT is temporary
Under the senario rely on v$sort_usage view.
Regards
Rafiq
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: Thu, 09 Oct 2003 09:24:24 -0800
I think you are right Jack. With a Temporary Temp tablespace, there is
nothing I can do to lower t
I think you are right Jack. With a Temporary Temp tablespace, there is
nothing I can do to lower the HWM. And I don;t really think it's full -
just the HWM shows it filled up.
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Thursday, October 09, 2003 11:19
he associated index to
a temporary segment and post smon to clear it up.
5. create a large table that will fail:
CREATE TABLE junk ( c1 varchar2(1) ) tablespace DATA storage ( initial 2000M
next 2000M) ;
Finally I had to bounce the instance, that cleared up the segment in temp
tablespace, so that i
point your user back to original temp tbs.
HTH
Regards
Rafiq
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: Thu, 09 Oct 2003 06:14:27 -0800
All,
Is there a way to clear a TEMP tablespace defined as Temporary? We had a
couple of long-runnin
see a TEMPORARY segment in DBA_SEGMENTS, though,
and the disk-space would
not be released till those users log out.
Hemant
At 06:14 AM 09-10-03 -0800, you wrote:
All,
Is there a way to clear a TEMP
tablespace defined as Temporary? We had a couple of long-running
jobs that have totally clogged
recipients of list ORACLE-L
All,
Is there a way to clear a TEMP tablespace defined as Temporary? We had a
couple of long-running jobs that have totally clogged up the TEMP
tablespace (54 Gig worth) and it doesn't seem to be releasing the space. I
know a db restart will clear it.
Any other
Title: RE: SAME and separating disk and index tablespaces
All,
Is
there a way to clear a TEMP tablespace defined as Temporary? We had a
couple of long-running jobs that have totally clogged up the TEMP
tablespace (54 Gig worth) and it doesn't seem to be releasing the space. I
know
I don't think that you can reduce temp datafile much below bytes_used value
in v$temp_space_header. I could reduce the file few kilobytes, but not much
compared to it's size. In order to reduce bytes_used, you need to bounce
instance (if there isn't any nifty tricks for releasing temp segment
other
Yes you can.
On Wed, 2003-10-01 at 11:29, Teresita Castro wrote:
> I have Oracle 9.2i
> I already run the query and the tablespace TEMP have
> CONTENTS=TEMPORARY AND EXTENT_MAN=LOCAL
> Can I run this line to fix the size of my tablespace?
>
> SQL> alter database tempfile '/data/oradata/system/te
I have Oracle 9.2i
I already run the query and the tablespace TEMP have
CONTENTS=TEMPORARY AND EXTENT_MAN=LOCAL
Can I run this line to fix the size of my
tablespace?
SQL> alter database tempfile
'/data/oradata/system/temp01.dbf' resize 128M;
I mean is the same or I have to change
someth
er 01, 2003 5:39
PM
Subject: Re: TEMP Tablespace
problem
This table do not have any file, how I understood this is
the table space that the queries uses.
They tell me that if I run a query that need mode that the
actual space it will be made that the TEMP tablespace grow.
>&
AdarMehish
- Original Message -
From:
Teresita Castro
To: Multiple recipients of list ORACLE-L
Sent: Wednesday, October 01, 2003 4:19
PM
Subject: Re: TEMP Tablespace
problem
9.2i>>> [EMAIL PROTECTED] 09/30/03
08:54PM >>>What is the Oracle versio
This table do not have any file, how I understood this is the
table space that the queries uses.
They tell me that if I run a query that need mode that the
actual space it will be made that the TEMP tablespace grow.
>>> [EMAIL PROTECTED] 09/30/03 10:09PM
>>>If the TE
9.2i>>> [EMAIL PROTECTED] 09/30/03 08:54PM
>>>What is the Oracle version?At 06:24 PM 9/30/2003 -0800,
you wrote:>Hi!!>I am trying to change the size of my tablespace
TEMP, I am not an >Administrator but we really need to make this
tablespace smaller.>Already the size is 13214 Mgs, and this ta
In 9i you could issue an "drop tablespace temp including contents and
datafiles".
(First make sure that this tablespace is not a default temporary
tablespace).
Tanel.
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, October 01, 2003 5
If the TEMP tablespace is a temporary tablespace, i.e. made of temp files
rather than datafiles, then you can't offline it. It would have to be
dropped and rebuilt.
At 07:34 PM 9/30/2003 -0800, you wrote:
Maybe you can create another temp tablespace (called temp_new) on another
disk, assig
Teresita, spelling the word "administrator" with the capital letter
is a good thing. Furthermore, if you have version 9i, you can do the
following, little known, thing:
SQL> alter database tempfile '/data/oradata/system/temp01.dbf' resize 128M;
Database altered.
If it's Oracle 8i, you can actual
Maybe you can create another temp tablespace (called temp_new) on another
disk, assign all users to temp_new, then offline the old temp tablespace,
drop the old temp tablespace, and finally remove the old temp datafiles
from OS.
HTH.
Guang
On Tue, 30 Sep 2003, Teresita Castro wrote:
> Hi!!
What is the Oracle version?
At 06:24 PM 9/30/2003 -0800, you wrote:
Hi!!
I am trying to change the size of my tablespace TEMP, I am not an
Administrator but we really need to make this tablespace smaller.
Already the size is 13214 Mgs, and this tablaspace is on a disk that is
full, so if we can
Hi!!
I am trying to change the size of my tablespace TEMP, I am not
an Administrator but we really need to make this tablespace
smaller.
Already the size is 13214 Mgs, and this tablaspace is on a
disk that is full, so if we can not make it smaller we are going to be in a
serius trouble ( our
Title: RE: Nosort parallel dml uses TEMP tablespace
You're welcome, please let me know the
results.
It was news to me as well, that so much temp space
would be used in your type of parallel direct load insert...
Btw, you can use nologging hint as well in your DML
if you haven'
Title: RE: Nosort parallel dml uses TEMP tablespace
Thanks
for having a look Tanel; that makes great sense.
I'll
have a quick play to convince myself but I'd say its a lesson
learned.
BTW
did you too experience more temp allocation than you would have
expected?
Thanks
aga
Title: RE: Nosort parallel dml uses TEMP tablespace
Hi!
Btw, I did a little testing with PARALLEL 2, and
yes it seems to be a parallel slave communications issue, despite the segments
show type "SORT".
When i traced sorting with 10032 & 10033, I saw
sort segment allocatio
Title: RE: Nosort parallel dml uses TEMP tablespace
Hi!
It could be that parallel slaves are passing
intermediate results using TEMP tablespace for some reason. (When table queues
are full in some cases or smth like that). It can depend on parallel execution
plan as well (whether it&#
all
trailing extents being trimmed - Note: we DO trim the temporary segment that we
are merging into. "
So apparently "Each slave creates a TEMPORARY segment in target tablespace" but I am
getting them appearing in the TEMP tablespace, not the tablespaces containing the
parti
Title: RE: Nosort parallel dml uses TEMP tablespace
I'm even more confused now.
TEMP ran out of space at 20GB - I'm only inserting 12.2GB!
So I kicked it off again with the hint just as /*+ APPEND */ and it completed successfully in 1/6th the time to failure of the paral
Title: Nosort parallel dml uses TEMP tablespace
Apologies if this has been covered before but metalink is not clear on the reasons behind it
The database is running version 9204 EE on WinNT Sp6; and the statement is a parallel direct load into partitioned table selecting from a 12.2GB
> bash-2.03$ rm templmt*
>
> bash-2.03$ df -k|grep /oracle/u02
> /dev/dsk/c1t2d0s070592505 44244651 24230079
> 65%/oracle/u02
>
> I thought I should get 10GB (2097160192 x 5) back,
> but instead I got only
> 1.3MB ( 24230079 - 22924927) released. Could
>
k, but instead I got only
1.3MB ( 24230079 - 22924927) released. Could someone explain? BTW, when I
created the temp files (templmt0[1-5]) for locally-managed temp tablespace,
I found they were created extremely fast, so I suspected that not real disk
space were allocated. But the "ls -l&q
temp tablespace,
I found they were created extremely fast, so I suspected that not real disk
space were allocated. But the "ls -l" command still showed 10GB were
allocated.
TIA.
Guang Mei
[EMAIL PROTECTED]
http://www.geocities.co
> Sent: Wednesday, November 06, 2002 10:56 AM
> To: Multiple recipients of list ORACLE-L
>
>
> Hey all,
>
> I've got some downtime coming up on an 8.1.6 DB on Solaris, and I'd
> like to
> take the opportunity to convert the datafiles of the TEMP tablespa
Message-
> > From: Jared Still [mailto:jkstill@;cybcon.com]
> > Sent: Thursday, November 07, 2002 1:19 PM
> > To: Multiple recipients of list ORACLE-L
> > Subject: Re: TEMP/RBS LMTs (was: Convert TEMP tablespace...)
> >
> >
> >
> > 10M? Hardly. Th
: TEMP/RBS LMTs (was: Convert TEMP tablespace...)
>
>
>
> 10M? Hardly. That was just a test script to make sure
> the syntax was correct. 10m just happens to be created
> very quickly.
>
> The sort_area_size equal or be a multiple of your TEMP
> extent size.
>
>
#x27;t
let you create temporary segments there.
Mike
-Original Message-
Sent: Wednesday, November 06, 2002 10:56 AM
To: Multiple recipients of list ORACLE-L
Hey all,
I've got some downtime coming up on an 8.1.6 DB on Solaris, and I'd
like to
take the opportunity to convert th
System/Database Administrator
> [EMAIL PROTECTED] Quad/Tech International, Sussex, WI
> USA
>
> > -Original Message-
> > From: [EMAIL PROTECTED] [mailto:Jared.Still@;radisys.com]
> > Sent: Wednesday, November 06, 2002 3:35 PM
> &
nts of list ORACLE-L
Hey all,
I've got some downtime coming up on an 8.1.6 DB on Solaris, and I'd like to
take the opportunity to convert the datafiles of the TEMP tablespace to
tempfiles. My reason for this change is primarily to get the TEMP
tablespace LMT, but also to shrink our h
m/Database Administrator
[EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:Jared.Still@;radisys.com]
> Sent: Wednesday, November 06, 2002 3:35 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: Con
o: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject: Re: Convert TEMP tablespace from datafiles to tempfiles
List,
Would you please explain to me how you are able to get TEMP and LMT
combined together. I use 8.1.7 and it is not allowed.
&
System/Database Administrator
[EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA
> -Original Message-
> From: Mercadante, Thomas F [mailto:NDATFM@;labor.state.ny.us]
> Sent: Wednesday, November 06, 2002 11:59 AM
> To: Multiple recipients of list ORACLE-L
&
oled file:
Select 'Alter User ' || UserName || ' Temporary Tablespace NewTemp ;'
>From DBA_Users;
After a day or two, or when you can determine that no one is using the
old
Temp tablespace, offline and drop Temp.
If you've just got to have the Temp tablespace named Tem
If have the space, create the new TEMP tablespace first, alter all users
that have the old one to now use the new one, drop the old tablespace.
Jared
"Jesse, Rich" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
11/06/2002 07:56 AM
Please respond to ORACLE-L
|| ' Temporary Tablespace NewTemp ;'
>From DBA_Users;
After a day or two, or when you can determine that no one is using the old
Temp tablespace, offline and drop Temp.
If you've just got to have the Temp tablespace named Temp, repeat the above
steps to create a new Temp
). Go have a beer.
The only "negative" here is that your TEMP tablespace is called TEMPLMT, but
it just doesn't matter. If you want, you can do it again, this time
creating the tablespace as TEMP if it makes you feel better.
Your method would work just fine. Not sure if the users
Jesse,
When you drop the temp tablespace everyone who had it assigned as their temp
space will have that changed to SYSTEM. The following should fix that:
declare
s varchar2(200);
begin
for a in (select username from dba_users) loop
s := 'alter
Hey all,
I've got some downtime coming up on an 8.1.6 DB on Solaris, and I'd like to
take the opportunity to convert the datafiles of the TEMP tablespace to
tempfiles. My reason for this change is primarily to get the TEMP
tablespace LMT, but also to shrink our hotbacks w/o modifying t
Hello all,
DB: 8172
I have a dictionary managed temp tablespace, size 22
Gig. When I see the free space in dba_free_space, it
is showing only 18 Gig as free. But there is no usage
found in v$sort_usage, v$sort_segment.
I bounced the DB to reclaim to free-up TEMP. But no
use. Its free
Hamid,
1) Do not let TEMP tablespace have autoextend set to on - my .02 is to never
have this set to on for any tablespace, but to monitor and expand as
necessary. Other DBAs like autoextend, so you may want that for other
tablespaces, but not for TEMP.
2) A nice trick to get TEMP cleared of
Hi List,
I have two data files for my TEMP tablespace, & i just find out one of the
data file "AUTO EXTEND" is set to on is it right??
I beleive for TEMP tablespace autoextend shoudn't be ON, AM I RIGHT or NOT?
Now my data file almost full for TEMP tablespace how can I Clean
then merged with the table segment. I confused
the two since they both involved "temp".
I don't have a specific solution to your problem, but my survival
instincts as a crusty old DBA (but still employed) say "don't make your TEMP
tablespace autoextend". It j
14, 2002 5:08 PM
To: Multiple recipients of list ORACLE-L
Yes,
But this shouldn't warrant 'indefinite extension' of the TB ?!?
-Original Message-
Sent: Tuesday, May 14, 2002 9:39 PM
To: Multiple recipients of list ORACLE-L
Do you have auto extend on the temp tab
Dennis,
I haven't seen Tim's posting !!? as regards my woos
-Original Message-
Sent: Tuesday, May 14, 2002 10:13 PM
To: Multiple recipients of list ORACLE-L
Simon - I think Tim has given you a good answer to your TEMP tablespace
growth. I just wanted to warn you to be caut
TEMPORARY
-Original Message-
Sent: Tuesday, May 14, 2002 9:39 PM
To: Multiple recipients of list ORACLE-L
Is your TEMP tablespace set to TEMPORARY or PERMANENT?
-Original Message-
Sent: Tuesday, May 14, 2002 11:14 AM
To: Multiple recipients of list ORACLE-L
Forgot to tell
Yes,
But this shouldn't warrant 'indefinite extension' of the TB ?!?
-Original Message-
Sent: Tuesday, May 14, 2002 9:39 PM
To: Multiple recipients of list ORACLE-L
Do you have auto extend on the temp tablespace?
Bryan
-Original Message-
Sent: Tuesday, May 14,
ginal Message-
Sent: Tuesday, May 14, 2002 8:02 PM
To: '[EMAIL PROTECTED]'
Hi all,
Having a bad start of week.
My temp tablespace is growing abnormally -from 3GB -> 32 GB (Filled up
disk).
DB is 81700 on Tru64 Unix, 120GB in size, appx 150 front-End users running
billing application for
Simon - I think Tim has given you a good answer to your TEMP tablespace
growth. I just wanted to warn you to be cautious about extremely large sizes
of SORT_AREA_SIZE. This is a per-process setting, which means that if you
have several processes, each process may acquire a lot of memory and the
Do you have auto extend on the temp tablespace?
Bryan
-Original Message-
Sent: Tuesday, May 14, 2002 2:10 PM
To: Multiple recipients of list ORACLE-L
Hi all,
Having a bad start of week.
My temp tablespace is growing abnormally -from 3GB -> 32 GB (Filled up
disk).
DB is 81700 on Tr
Is your TEMP tablespace set to TEMPORARY or PERMANENT?
-Original Message-
Sent: Tuesday, May 14, 2002 11:14 AM
To: Multiple recipients of list ORACLE-L
Forgot to tell you that myparameter for sort_area_size= apx. 8GB
-Original Message-
Sent: Tuesday, May 14, 2002 8:02 PM
To
Hi all,
Having a bad start of week.
My temp tablespace is growing abnormally -from 3GB -> 32 GB (Filled up disk).
DB is 81700 on Tru64 Unix, 120GB in size, appx 150 front-End users running
billing application for appx 200,000 customer base.
Initially set-up as OPS but undone though init.ora f
Forgot to tell you that myparameter for sort_area_size= apx. 8GB
-Original Message-
Sent: Tuesday, May 14, 2002 8:02 PM
To: '[EMAIL PROTECTED]'
Hi all,
Having a bad start of week.
My temp tablespace is growing abnormally -from 3GB -> 32 GB (Filled up disk).
DB is 81700
t;[EMAIL PROTECTED]>
Subject: Re: Large record count in fet$
for TEMP tablespace
Sent by:
r
PROTECTED]> wrote: >
When trying to select * from
> DBA_FREE_SPACE_COALESCED the query hangs. It also
> hangs when trying to calculate free space from the
> DBA_FREE_SPACE view. I looked in the sys.fet$ table
> and found that the TEMP tablespace has 21423
> entries and I be
When trying to select * from
DBA_FREE_SPACE_COALESCED the query hangs. It also hangs when
trying to calculate free space from the DBA_FREE_SPACE view. I looked in
the sys.fet$ table and found that the TEMP tablespace has 21423 entries
and I believe this is my problem.
Now for my
And yes, as I keep saying, I am paranoid.
Dave
Tom wrote:
> steps just to save yourself some time during backups? Why stop at backing
> up the TEMP tablespace - why not the ROLLBACK tablespace - this could be
> dropped and re-created also. Why not INDEX tablespaces - heck, if you have
Hum, I apologize. Did not read well enough.
-Original Message-
Thomas F
Sent: Monday, January 28, 2002 9:16 AM
To: Multiple recipients of list ORACLE-L
Kimberly,
That is an excellent point! But the original writer was taking a hot backup
of the TEMP tablespace, so she must be using
shorten the time frame that it takes to complete our
> > Oracle hot backups, and the subsequent file copies to tape.
> > I have read
> > that it is ok to skip the TEMP tablespace, and then do an
> > off-line drop of
> > the datafile(s) in the temporary tablespace, drop t
will not be able to
drop the TEMP tablespace.
Add to this the fact that Oracle applies archive logs based on the file
header SCNs. If you restore an old copy of the TEMP tablespace's datafiles,
the recovery will require that *all* the archive logs since the last backup
of TEMP. This implies
Kimberly,
That is an excellent point! But the original writer was taking a hot backup
of the TEMP tablespace, so she must be using an older version of Oracle.
Maybe she should migrate to 8i? :)
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Monday, January
On Mon, 28 Jan 2002, Mercadante, Thomas F wrote:
> Do you really want to be in the position of performing "extra"
> recovery steps just to save yourself some time during backups? Why
> stop at backing up the TEMP tablespace - why not the ROLLBACK
> tablespace - this c
If you are using a temp tablespace with a temp file you really are not
suppose to back it up. This comes from Oracle, not folks trying to save
time. You cannot put them into backup mode so how do you recommend backing
them up?
-Original Message-
Thomas F
Sent: Monday, January 28, 2002
ck in the window - it works, but its really not right.
Do you really want to be in the position of performing "extra" recovery
steps just to save yourself some time during backups? Why stop at backing
up the TEMP tablespace - why not the ROLLBACK tablespace - this could be
dropped and
blespaces and tempfiles means you can skip backing up
the temp tablespace, and when you need to recover it you can recreate the
temp tablespace fast. Otherwise, recreating it can take a long time,
meaning the time to recover a crashed database may take longer.
Check Jonathan Lewis's book (P
are trying to shorten the time frame that it takes to complete our
> Oracle hot backups, and the subsequent file copies to tape. I have read
> that it is ok to skip the TEMP tablespace, and then do an off-line drop of
> the datafile(s) in the temporary tablespace, drop the tablespace,
You are right.
Excluding TEMP tablespace from hot backups is not a problem at all.
Your in-house instructions/docs about recovering the database should spell
out what to do after performaing the recovery.
Also if your version of Oracle supports the TEMPFILEs and TEMPORARY
tablespaces
I was wondering if anyone could offer any suggestions to this issue, or the
pro's and con's...
We are trying to shorten the time frame that it takes to complete our
Oracle hot backups, and the subsequent file copies to tape. I have read
that it is ok to skip the TEMP tablespace, and
TED]>
wrote: > What is the best way to convert a
dictionary-managed
> TEMP tablespace to
> locally managed?
>
> Here's my situation, I created an 8.1.7 database
> with all dictionary-managed
> tablespaces. Then, I converted all tablespaces to
> locally managed, except
ert TEMP to LMT so
> it seems that I must drop the TEMP tablespace and
> re-create it as LMT. My
> question is, do I need to create an intermediate,
> like TEMP2, and point
> everything to it while I'm dropping and re-creating
> TEMP?
>
> Thanks for your advice,
>
What is the best way to convert a dictionary-managed TEMP tablespace to
locally managed?
Here’s my situation, I created an 8.1.7 database with all
dictionary-managed tablespaces.
Then, I converted all tablespaces to locally managed, except SYSTEM and
TEMP. The conversion packaged
Ken - I assume you dropped the TEMP tablespace, which doesn't delete the
datafile. I'm assuming you are on Unix. Just remove the data file and
recreate the TEMP tablespace the same way as you originally did. I believe
that the temp tablespace settings for all users will be unaffecte
TED]>
Sent by: rootcc:
Subject: TEMP Tablespace P
Hi
Assuming that you actually use the TEMP tablespace as a real "temp"
tablespace and didn't put any actual data in it, you can just go ahead
recreate it by reusing the old datafile.
Ken Janusz schrieb:
>
> Somehow I deleted the TEMP tablespace but not the datafile.
Somehow I deleted the TEMP tablespace but not the datafile. How do I go
about recreating this tablespace?
Thanks,
Ken Janusz, CPIM
Database Conversion
Lead Sufficient System, Inc.
Minneapolis, MN
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ken Janusz
INET
worry about. The rollback space is
for mods to the data dictionary as your segments are
created.
hth
connor
--- "Tatireddy, Shrinivas (MED, Keane)"
<[EMAIL PROTECTED]> wrote: > Hi lists,
>
>
> Can anybody clarify this:
>
> Do the sort/idx rebuild etc.,(
space is
for mods to the data dictionary as your segments are
created.
hth
connor
--- "Tatireddy, Shrinivas (MED, Keane)"
<[EMAIL PROTECTED]> wrote: > Hi lists,
>
>
> Can anybody clarify this:
>
> Do the sort/idx rebuild etc.,(tasks that use temp
> tab
t;
> Can anybody clarify this:
>
> Do the sort/idx rebuild etc.,(tasks that use temp
> tablespace), use
> rollback segments?
>
> I need to rebuild indexes of 20 Gig to a new
> tablespace.
>
> Do I need to verify the RBS free space for this.?
>
> Thnx and Rega
Hi lists,
Can anybody clarify this:
Do the sort/idx rebuild etc.,(tasks that use temp tablespace), use
rollback segments?
I need to rebuild indexes of 20 Gig to a new tablespace.
Do I need to verify the RBS free space for this.?
Thnx and Regards,
Srinivas
--
Please see the official
Granaman
> (OraSaurus - Honk if you remember OPS ;-)
>
> - Original Message -
> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> Sent: Tuesday, October 16, 2001 5:15 PM
> "temporary" ta
>
>
> > Environment:
> > Oracle v8.
Title: RE: TEMP Tablespace
> -Original Message-
> From: Connie Milliken [mailto:[EMAIL PROTECTED]]
>
> TEMP tablespace is not listed when I query dba_segments. However, it
> does show up in OEM and
> through OEM it does appear to be online. Yesterday, I
> br
Title: RE: TEMP Tablespace
Hi Connie,
Because there isn't anything stored in there (a segment) permanently. But when I look at my db (well, my horsing-around-and-breaking-stuff db) I see this. My temp tablespace is not permanent.
1 select segment_name from dba_segments
2*
What tablespace are the temp segments showing up in? It may not be in TEMP.
HTH,
Ruth
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, September 25, 2001 11:10 AM
> TEMP tablespace is not listed when I query dba_seg
How was your TEMP tablespace created? Was it created using
a temp datafile? Not all information that is normally available
with tablespaces are valid when using a temporary tablespace
with a temporary datafile.
-Original Message-
Sent: Tuesday, September 25, 2001 8:10 AM
To: Multiple
Wouldn't it need to have something in it?
-Original Message-
Sent: 25 September 2001 16:10
To: Multiple recipients of list ORACLE-L
TEMP tablespace is not listed when I query dba_segments. However, it
does show up in OEM and
through OEM it does appear to be online. Yesterd
TEMP tablespace is not listed when I query dba_segments. However, it
does show up in OEM and
through OEM it does appear to be online. Yesterday, I briefly took the
TEMP tablespace offline and then back online again to make sure it was
completely cleared out (did not appear to be any active
What about mount point on same controller? Split them on different
controller if not ? What is the maximum usage of your TEMP tablespace ? and
size of datafiles...? Try to reduce size of your temp tablespace as it looks
very large
Better solution is
Datfiles of 501MB each split on
Hi All,
We have data warehouse which uses arround 34 GB of
temporary tablespace. The datafiles for this are
tempfiles and the tablespace is LMT.
We use EMC storage.
The tempfiles are on two file systems which inturn are
mirrored and striped across three 8 GB disks.
We are seeing heavy IO on t
1 - 100 of 148 matches
Mail list logo
