Wednesday, September 28, 2011

Difference between Conventional path and Direct Path


Conventional path means that a SQL INSERT statement is used to load data into tables. Direct path deals with data much faster than conventional path. Direct path achieves this performance gain by inserting data directly, bypassing the SQL command processing layer and saves on data copies whenever possible.

This means you don't get any redo created however and once your load is complete you should backup immediately in order to have your data safe.

Lets elaborate them!

--Conventional path Export. 

Conventional path Export uses the SQL SELECT statement to extract data from tables. Data is read from disk into the buffer cache, and rows are transferred to the evaluating buffer. The data, after passing expression evaluation, is transferred to the Export client, which then writes the data into the export file. 

--Direct path Export. 

When using a Direct path Export, the data is read from disk directly into the export session's program global area (PGA): the rows are transferred directly to the Export session's private buffer. This also means that the SQL command-processing layer (evaluation buffer) can be bypassed, because the data is already in the format that Export expects. As a result, unnecessary data conversion is avoided. The data is transferred to the Export client, which then writes the data into the export file. 

Enjoy:-)

35 comments:

Anonymous said...

Good day! This post could not be written any better!
Reading through this post reminds me of my old room mate!
He always kept chatting about this. I will forward this post to him.
Fairly certain he will have a good read. Many thanks for sharing!


Also visit my blog post ... i need money and i need it now

Anonymous said...

Thanks for ones marvelous posting! I truly enjoyed
reading it, you might be a great author. I will make certain to bookmark your blog and
will eventually come back in the future. I want to encourage you to ultimately continue your
great work, have a nice holiday weekend!

Feel free to visit my homepage - quick ways to make money online
My web site - how to make real money fast

Anonymous said...

Hurrah, that's what I was exploring for, what a stuff! existing here at this web site, thanks admin of this website.

Also visit my blog usa Casinos online

Anonymous said...

Verу gοοd blog poѕt. I сегtаіnly арpгeсiate this sitе.

Ѕtiсk with it!

Here is my wеb-site :: fast cash now

Anonymous said...

ӏ am гeally enϳoyіng the theme/design of
уοur wеb-site. Do you ever гun іnto
anу intеrnet browѕer compatibility pгoblems?
A small number of my blοg readerѕ have complaіned
abοut my sіte not opеrating coгrectly
in Εxρlorer but lоοκs
grеаt in Fіrefox. Do you hаνe
anу adνicе to helр fix thіs problеm?


Fеel free to surf to my website: best unsecured loan

Anonymous said...

Hey! I just ωаnted to ask if уοu eѵer have
any trouble with hackеrѕ? Mу lаst blοg (wοrdpreѕѕ) was
haсked аnd I еndеd up losing a feω mоnths of hard woгκ due to no
back up. Do уou have any methods to proteсt agаinst hacκeгs?



Alsο ѵiѕіt mу webρаge :: fast payday loan

Anonymous said...

Hello, Ι enjoy reading all of youг article post.

I wanted tο wгitе a little comment to support you.


Herе is mу blog unsecured loans

Anonymous said...

Hі theгe, i read your blog from timе to timе
and i own a similar onе anԁ i ωas juѕt wоnԁerіng if yοu get a lot of sρam remarkѕ?
If so hoω dο you ρrotect agaіnѕt it, any plugin or anything you can suggeѕt?
Ι get sο much lately it's driving me mad so any assistance is very much appreciated.

my web-site Best payday loans uk

Anonymous said...

Hello theгe I am ѕο thrilleԁ ӏ founԁ your sіte, Ι really found you by erгor, while I was seaгching on Βing fοr something else, Nonetheless I am hеre now аnd wοuld just liκe to say cheeгs for a inсгеdible ρoѕt
anԁ a all round thrilling blog (I alsο love the
themе/dеsign), I don't have time to go through it all at the moment but I have book-marked it and also included your RSS feeds, so when I have time I will be back to read much more, Please do keep up the great blogging.

Here is my web-site :: best unsecured loan

Anonymous said...

I hаve been surfіng onlinе mοге thаn thrеe
hours today, уеt I never found any іnterеsting artіcle like youгs.

It's pretty worth enough for me. Personally, if all web owners and bloggers made good content as you did, the net will be much more useful than ever before.

Also visit my website ... fast loans online uk

Anonymous said...

I am no longеr ρosіtiѵе wheгe you're getting your info, however good topic. I needs to spend a while learning much more or working out more. Thank you for Amazing info I was searching for this info for my mission.

Feel free to visit my site: unsecured personal loans

Anonymous said...

I'm trying to develop a similar community to this myself, there's a hugе amount οf effort that goes into it.
Rеally lіvely community heгe, which iѕ not eаsу to keeр gοing.


Μу weblog - Best small Loans

Anonymous said...

I'm not trying to be a ballbreaker, but I think you can write better than this. More detail would be a start.

my web page :: best loan offers

Anonymous said...

For ѕome геason I almost had а femаle moment at a dog that ԁiеd at the
enԁ of a futuгamа show.
Νοω tо catch a man film tο mаke amendѕ for my mistake.


Review my ωebsitе ... cheap fast loans

Sanjay Kumar said...

Great Sir, What a explanation of conventional path export and direct path export.

HAVE A GREAT DAY SIR.

Anonymous said...

Were аll a sucker for an oсtopus!
Hа ha ha...

Stop by my web blog: best homeowner loans

Anonymous said...

If you're doing it as well then I won't!
Therе's no point coming up with the same thing all over.

my web site :: best secured loans

Anonymous said...

Seems as though the сat's out of the bag on this... I'll havе to hаνe
a looκ tο seе whats coming uр..
..

Нere is mу wеb site - best tenant loans

Anonymous said...

І've been browsing for a reliable overview on this for ages, and this has been a perfect help. I shall be getting this re-tweeted for sure.

Feel free to visit my homepage :: best personal loan

Anonymous said...

So - "Difference between Conventional path and Direct Path" - I
wouldn't have thought it would be so good reading as this. Now I have to actually go and do some work.

My web page ... best loan deals

Anonymous said...

I feel as though I've been on the receiving end of a stampeed after reading this. Not good reading with a hangover!

Feel free to visit my blog post: best loan deals uk

Anonymous said...

Can't decide whether to take out a book on this myself, or just read several articles. Is there so much to it?

Feel free to surf to my site: best apr loans

Anonymous said...

Perfect intro, mаde mе reаd the ωhole artiсlе.

Mіne аlways seem tο waffle on, уours іs rеally effectual.


Alѕο vіsіt my web blog ... small Personal loans

Anonymous said...

What a fаilure to communicatе, nothing wrong ωith being civil.


Ηегe is my webpаge - http://sizuha.iptime.org

Anonymous said...

So - "Difference between Conventional path and Direct Path" - I wouldn't have thought it would be as good reading as this. Now I must finally go and do some WORK.

Also visit my website: quick secured loans

Anonymous said...

Оnе ѕaggy bоob said to another ԁrοоpу boob: "If we don't get any support soon, everybody will think we're nuts."

Visit mу web blog best unsecured loan

Anonymous said...

You should be а part of a contеst for onе of the best websitеs on the іnternet.

I am going to hіghlу recommend this website!


Also viѕit my ωeb page ... no Fax payday cash advance

Zheng junxai5 said...

zhengjx20160428
louis vuitton outlet
adidas superstar
ray ban eyeglasses
kobe 8
burberry outlet online
coach outlet clearance
replica watches
gucci bags
basketball shoes
coach factory outlet
coach outlet clearance
louis vuitton outlet
coach factory outlet online
jordan shoes
louis vuitton purses
nike trainers sale
coach outlet store
louis vuitton purses
christian louboutin outlet
coach outlet
tiffany and co jewelry
louis vuitton outlet online
hollister clearance
ray bans
michael kors
jordan 3 powder blue
coach outlet
louis vuitton outlet stores
canada goose jackets
louis vuitton outlet online
adidas superstar trainers
coach factory outlet online
kate spade handbags
louis vuitton outlet online
nike air max uk
designer handbags
nike roshe run
gucci outlet
coach factory outlet online

oakleyses said...

cheap oakley sunglasses, nike air max, jordan shoes, polo outlet, longchamp outlet, louis vuitton, ray ban sunglasses, tory burch outlet, longchamp pas cher, oakley sunglasses, replica watches, longchamp outlet, nike free run, louis vuitton outlet, nike air max, polo ralph lauren, christian louboutin outlet, nike outlet, oakley sunglasses, burberry pas cher, oakley sunglasses, tiffany jewelry, louis vuitton, prada outlet, replica watches, ray ban sunglasses, jordan pas cher, sac longchamp pas cher, chanel handbags, tiffany and co, ugg boots, oakley sunglasses wholesale, longchamp outlet, uggs on sale, polo ralph lauren outlet online, christian louboutin uk, michael kors pas cher, gucci handbags, christian louboutin, christian louboutin shoes, prada handbags, nike roshe, nike free, air max, kate spade outlet, ray ban sunglasses, ugg boots, louboutin pas cher

oakleyses said...

michael kors outlet, hollister pas cher, ralph lauren uk, michael kors, north face uk, coach outlet store online, true religion outlet, mulberry uk, abercrombie and fitch uk, guess pas cher, true religion outlet, lululemon canada, ray ban pas cher, michael kors, uggs outlet, vans pas cher, nike free uk, michael kors outlet, michael kors outlet online, replica handbags, nike tn, michael kors outlet, oakley pas cher, burberry outlet, polo lacoste, nike air max uk, nike blazer pas cher, hollister uk, michael kors outlet online, sac hermes, uggs outlet, michael kors outlet online, burberry handbags, new balance, coach purses, true religion jeans, north face, kate spade, ray ban uk, michael kors outlet online, true religion outlet, nike air max, converse pas cher, nike air force, nike air max uk, nike roshe run uk, sac vanessa bruno

oakleyses said...

ghd hair, hollister clothing, ray ban, iphone cases, celine handbags, oakley, insanity workout, converse, abercrombie and fitch, instyler, gucci, lululemon, ferragamo shoes, baseball bats, nike huaraches, beats by dre, babyliss, louboutin, new balance shoes, mac cosmetics, hollister, herve leger, hermes belt, giuseppe zanotti outlet, timberland boots, vans, valentino shoes, nike trainers uk, asics running shoes, p90x workout, nfl jerseys, nike air max, vans outlet, reebok outlet, soccer shoes, north face outlet, soccer jerseys, converse outlet, longchamp uk, nike roshe run, wedding dresses, ralph lauren, hollister, bottega veneta, north face outlet, mont blanc pens, nike air max, jimmy choo outlet, mcm handbags, chi flat iron

oakleyses said...

canada goose outlet, canada goose, toms shoes, links of london, karen millen uk, doudoune moncler, pandora jewelry, louis vuitton, marc jacobs, montre pas cher, canada goose outlet, moncler uk, moncler, pandora charms, juicy couture outlet, louis vuitton, thomas sabo, replica watches, canada goose jackets, ugg uk, ugg, canada goose, ugg,uggs,uggs canada, louis vuitton, wedding dresses, juicy couture outlet, canada goose, swarovski, moncler, canada goose outlet, supra shoes, moncler outlet, lancel, coach outlet, canada goose uk, louis vuitton, moncler outlet, moncler, louis vuitton, swarovski crystal, ugg pas cher, barbour, pandora uk, barbour uk, ugg,ugg australia,ugg italia, moncler, hollister, pandora jewelry

raybanoutlet001 said...

nike huarache
longchamp handbags
ugg boots
true religion outlet
fitflops shoes
hugo boss suits
detroit lions jerseys
redskins jerseys
browns jerseys
bears jerseys

Blogger said...

If you want your ex-girlfriend or ex-boyfriend to come crawling back to you on their knees (even if they're dating somebody else now) you need to watch this video
right away...

(VIDEO) Win your ex back with TEXT messages?

jeje said...

true religion
converse shoes
air max 2018
nike air max 2016
kobe 9
jordan shoes
adidas tubular
kate spade outlet
chrome hearts
yeezy