RE: ORA-01652: unable to extend temp segment
- From: "Ian Cary (C)" <Ian.Cary@xxxxxxxxxxxxxxxxxxxx>
- To: <roger_xu@xxxxxxxxxxx>, "Oracle-L@Freelists. Org (E-mail)" <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 24 Jan 2006 08:55:37 -0000
Roger,
The temporary segment you are seeing will become the index once the
statement has been completed.
I suspect you are running out of space because you are running the
operation in parallel. When you do this each parallel thread creates its
own extents so if, for example, the initial extent of the index is 6Gb
by specifying the degree of parallelism as 3 you automatically require
18Gb while the index is being built. Once the parallel slaves have
completed these temporary index segments are then coalesced down to give
an index of the same size (roughly) as would have been created by a
single threaded process.
Hope this helps,
Cheers,
Ian
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Roger Xu
Sent: 23 January 2006 19:31
To: Oracle-L@Freelists. Org (E-mail)
Subject: ORA-01652: unable to extend temp segment
SQL> alter index "SAPR3"."VBFA~0" rebuild online parallel 3 tablespace
PSAPREROGI;
*
ERROR at line 1:
ORA-12801: error signaled in parallel query server P001
ORA-01652: unable to extend temp segment by 89595 in tablespace
PSAPREROGI
I got ORA-01652 while rebuilding the 14 GB index to a new tablespace and
the tablespace
has 16 GB free space. Before the error occurred, the 31 GB temp
tablespace had 13.5 GB
used.
Any idea why it created temp segments in the target tablespace?
How big the target tablespace would be? I thought 16 GB is enough.
Thanks,
Roger
This e-mail is intended solely for the person or entity to which it is
addressed and may contain confidential and/or privileged information.
Any review, dissemination, copying, printing or other use of this e-mail
by persons or entities other than the addressee is prohibited. If you
have received this e-mail in error, please contact the sender
immediately and delete the material.
____________________________________________________________________
This email has been scanned for all viruses by the MessageLabs Email
Security System. Any questions please call 972-721-8257 or email your
request to tech_support@xxxxxxxxxxxx
.
This email is only intended for the person to whom it is addressed and may
contain confidential information. If you have received this email in error,
please notify the sender and delete this email which must not be copied,
distributed or disclosed to any other person.
Unless stated otherwise, the contents of this email are personal to the writer
and do not represent the official view of Ordnance Survey. Nor can any contract
be formed on Ordnance Survey's behalf via email. We reserve the right to
monitor emails and attachments without prior notice.
Thank you for your cooperation.
Ordnance Survey
Romsey Road
Southampton SO16 4GU
Tel: 023 8079 2000
http://www.ordnancesurvey.co.uk
Other related posts:
