Home Forums Wiki Doc Install Extras Screenshots Source Code Projects Blog Users Groups Register
Glx-Dock / Cairo-Dock List of forums Technical discussions | Discussions techniques ora - 1628 Error for Insert Query.
The latest stable release is the *3.4.0* : How to install it here.
Note: We just switched from BZR to Git on Github! (only to host the code and your future pull requests)
Technical discussions | Discussions techniques

Subjects Author Language Messages Last message
ora - 1628 Error for Insert Query.
Williamhawk English 1 Guest [Read]
13 November 2017 à 23:18

Williamhawk, Saturday 11 November 2017 à 12:44 | Quote


Subscription date : 05 October 2017
Messages : 70
Helllo,

We are using version 11.2.0.4 of oracle version and its EXADATA 4 node. We have one INSERT query failing with "ORA-01628: max # extents (32765) reached for rollback segment _SYSSMU57_14975051$". We have AUTO undo management ON with this UNDO tablespace having size ~200GB and during the error i saw the undo utilization was below ~100GB. and UNDO retention set as 3hr. this insert query failed after running ~45 minutes. Also i see multiple time this query failing with same error.

I found in internet there are few bugs associated with this error, so want to know expert suggestion if above scenario/setup has some issue and can result into ORA-01628 or we are facing some bug here, how to validate?

Below is the Insert query plan, its insert into a global temporary table.I do see there is gap in estimation so plan may be better than current one which is getting pickedup by optimizer. But for now i want to understand why this error is popping up each time this query runs and how can i fix.

Thank You!!!

I didn't find the right solution from the Internet.
References
https://community.oracle.com/thread/4096999
animation videos

Guest, Monday 13 November 2017 à 23:18 | Quote

1

Technical discussions | Discussions techniques

Subjects Author Language Messages Last message
ora - 1628 Error for Insert Query.
Williamhawk English 1 Guest [Read]
13 November 2017 à 23:18

Post a message

Anti-spam filter 3 (*) times (*) 7 =
            
Did you know ? The Code tag can do syntax colouring based in the languages : [code=php][/code]. It will work with : php,c,c++,c#,sql,bash


Glx-Dock / Cairo-Dock List of forums Technical discussions | Discussions techniques ora - 1628 Error for Insert Query. Top

Online users :

Powered by ElementSpeak © 2007 Adrien Pilleboue, 2009-2013 Matthieu Baerts.
Dock based on CSS Dock Menu (Ndesign) with jQuery. Icons by zgegball
Cairo-Dock is a free software under GNU-GPL3 licence. First stable version created by Fabounet.
Many thanks to TuxFamily for the web Hosting and Mav for the domain name.