Sunday Mar 24, 2013

Exadata Smartscan For IAS

Hello all, In this post we will present an issue, we faced a few weeks ago, when one of our customers run annual job batches on Exadata. During those operations they realized that  'Insert as select (IAS)' was dramatically slower than 'Create table as select (CTAS)' for the same tables and application. There was a really huge difference on duration between them, whilst CTAS was taking 40 seconds, IAS took almost 6 minutes!

We've checked the execution plans of those queries and saw that CTAS was doing Smart Scan, it's wait event was "cell smart table scan" and Cell Offload Effiency %91 but IAS was not doing !

[Read More]
About

Oracle ECEMEA Partner Hubs Migration Center Team

We share our skills to maximize your revenue!
Our dedicated team of consultants can rapidly and successfully assist you to adopt and implement the latest of Oracle Technology in your solutions.

Stay Connected
partner.imc
@
beehiveonline.oracle-DOT-com
Google+

Search

Archives
« April 2014
SunMonTueWedThuFriSat
  
2
3
4
5
6
9
10
11
12
13
14
16
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today