Update Statements and Exadata

From: coskan gundogar <coskan_at_gmail.com>
Date: Sun, 9 Dec 2012 09:43:15 +0000
Message-ID: <CAGLGTvO1VZgyrfn_mz-t-Ah7CsoQOd4HNVpw3xO+ZZyUix1u0w_at_mail.gmail.com>

All,
Can anybody let me know the difference for the internal mechanism on parallel update and serial update

When I run serial update Oracle can't offload the statement (I assume this is due to dealing with undo)

If I run the statement parallel (no partitioning) it can offload the scanning part.

I would really appreciate if somebody can walk me through the difference between serial and parallel and why serial is no go.

Regards

--
--

Coskan GUNDOGAR

Oracle DBA

Email: coskan_at_gmail.com

Blog: http://coskan.wordpress.com
Twitter: http://www.twitter.com/coskan
Linkedin: http://uk.linkedin.com/in/coskan

--
http://www.freelists.org/webpage/oracle-l

Received on Sun Dec 09 2012 - 10:43:15 CET