Skip to main content

INSERT /*+ direct */

  • June 14, 2015
  • 0 replies
  • 3 views

deb0687
Forum|alt.badge.img+1

Hi ,

 

 

INSERT /*+ direct */ into Table Writes the data directly to disk (ROS) bypassing memory (WOS).

 

Please tell me the advantage & disadvantage of this.

 

If in my system the RAM is less then can I insert always using /*+direct*/.

 

Please give me some more details.