Thursday, June 16, 2011

Difference between dedicated and shared server configuration:

In order to communicate with oracle database, oracle users need a program such as SQL *Plus which can issue SQL statements and few processes which can execute these SQL statements. These processes are divided into User Process, Server Process and Background Processes. User process runs user application like SQL *Plus. Server process manages oracle user process’s requests. Server process executes SQL statements and returns result to user process. Background processes are the core of oracle database which handle over all database operations.

Dedicated server connection:

A dedicated process has one to one relationship with user process. The user connected with dedicated server connection has the dedicated resource that is whether or not the user is doing work the connection remains allocated to that user. Thus if your user is not working and if there is less network resource then this user is blocking another user to connect or to execute the user request by making this user works queued. This connection is preferable when you have lot of resource or to some administrative user like "SYS" , "SYS" for administrative works and for batch jobs,


Shared server connection: 

Shared server architecture consists of Listener Process, Dispatcher Process, Request Queue, Shared server process and Response Queue. Network Listener process listens the user process request. If user process request requires a dedicated server process, listener process starts a dedicated server process. If the request can be assigned to a shared server process, then the request is forwarded to dispatcher process. Shared server configuration requires at least on dispatcher process. Dispatcher process places the request on request queue. Request Queue is created in SGA and shared by all dispatcher processes. On of free Shared server process picks up the request from request queue. After processing the request, shared server process places the result in response queue. Each dispatcher process has its own response queue in SGA. Dispatcher knows about the user process which placed the request, so the response is returned back to user process.

When there is shared server the user connection is shared, that is user is connecting by dispatchers and when a user is idle his resource can be used by other users, thus lessen the load on system, this is more likely in a environment where user is mostly idle, like in a order entry system.

So, what should I choose?

If your environment is OLTP then shared is preferable because the tasks need short time. Whether is Warehouse, OLAP, Data Mining the users are running time consuming and heavy load query where it is best to use dedicated server.

How to configure a shared server configuration?

Below are the two links that helps in configuring the same.


56 comments:

Anonymous said...

whoah this blog is great i really like reading your articles.
Keep up the good work! You recognize, a lot of individuals are hunting round for this information, you can aid
them greatly.

Here is my weblog: http://designskala.com

Anonymous said...

You mustiness hold on in thinker that while feeding low cholesterol
to indulgent drinks, cordials and other beverages tied with clams, is Putting green
tea. This includes any solid food that is to lodge to the walls of the arteries.
Don't discipline your children to eat but white Rice an estimated 37.2 gazillion adults are depicted object to senior high-risk cholesterol levels to a higher place 240mg/dL. Even so, the panel is inactive of treating mettle diseases is identical expensive. reduction your consumption of saturated letting down Indian foods to your center-healthy diet.

Here is my web-site: treatment guidelines for high cholesterol

Anonymous said...

What's Taking place i am new to this, I stumbled upon this I have discovered It absolutely helpful and it has helped me out loads. I'm hoping to give
a contribution & aid different customers like its helped
me. Good job.

Look into my web blog; vexxhost comments

Anonymous said...

At this time I am going to do my breakfast, later than having my breakfast coming again to read additional news.


Look at my weblog :: phaser 8560 mfp

Anonymous said...

I adore the birds and heart necklace <3 So cute! All of the jewellery is beautiful <3 <3

Look into my web site :: silver jewellery
for women

Anonymous said...

extremely practical information. specifically for ones that don't print photos but just utilize the computer as a word processing program, which is a massive number.

Take a look at my homepage; http://hypetechnews.wordpress.com

Anonymous said...

Whаt's up to every one, it'ѕ іn
fаct a niсe for me tο go to seе thіs
wеb page, it cοntaіns priceless ӏnformation.


Revieω mу blоg - facebook proxy sites

Anonymous said...

Yes! Fіnallу somеthing about ρc pitstoρ.


Аlѕo νiѕit mу web-ѕite; kate dircksen

Anonymous said...

What's up, everything is going well here and ofcourse every one is sharing information, that's genuinely excellent,
κeep up writing.

Feel freе to ѕurf to my web page :: videos.sweethazzard.com

Anonymous said...

Good post. I learn something new and challenging on blogs I stumbleupon every day.
It will always be interesting to read content from other writers and practice a little something from other web sites.


My web blog: anne hultquist jewellery

Anonymous said...

I like it when individuals come together and share ideas.
Great blog, stick with it!

My web-site; hultquist

Anonymous said...

Download file configuration HP LaserJet P1005.

Here is my page - xerox phaser 8560 Ink

Anonymous said...

The jewellery is amazing, and Mel is usually a lovely lady too x

Here is my web site :: ,cheap earring sets women

Anonymous said...

I was suggestеd thіs wеb site thrоugh my cousin.

I am now not positiѵe ωhеthеr or not thіs
ѕubmit is wгittеn bу
way оf him аs no one еlse rеalizе ѕuch specified аррroхimаtely mу prοblеm.
You aгe ωonderful! Τhanks!

My blog post: facebook market

Anonymous said...

When are planning to post again? You inform many!

Also visit my homepage: silver jewellery uk

Anonymous said...

Youre so awesome, man! I cant believe I missed this website for so very
long. Its just great stuff complete. Your design,
man...too amazing! I cant wait to learn what youve got next.
I love exactly what youre saying and desire more, more, MORE!
Save this up, man! Its just too good.

Feel free to surf to my page: ,cheap stud earrings uk

Anonymous said...

Pretty nice post. I just stumbled upon your weblog and wanted to say that I've truly enjoyed surfing around your blog posts. In any case I'll be subscribing
to your rss feed and I hope you write again soon!



Stop by my homepage: xerox 8560 cartridges

Anonymous said...

Thanks to you in this awesome short article; it is a form
of post that keeps me going through the day. Appears
exploring this web site when i discovered them from the friend and was thrilled as i found it after trying to find time.
Becoming an avid blogger, I'm thrilled to see others taking initiative and causing the city. I desired to comment to signify my appreciation to your are it's very
encouraging, and a lot of bloggers do not get the loan they
deserve. I think We will be back and definately will send some of
my pals.

Here is my homepage: danon jewellery israel

Anonymous said...

I'd like to win this book!

Here is my page ... ,silver jewellery discount (http://isolve.com.br/neodroid/index.php?title=Usu%C3%A1rio:DorieEver)

Anonymous said...

hello,
we are trying to publish some buisiness cards
with thermosensitive ink that would respond with the warmth.


My web page - xerox phaser 8560 ink

Anonymous said...

though that deserved a lot more deeper attention and I'll manage them in separate blog posts: 3D printing, and mobile application.

Feel free to surf to my blog; xerox phaser 8560 maintenance kit (freeupdatenews.blogspot.fr)

Anonymous said...

Yes, "top-of-the-line" around that time did include a digital tuner, but the
price difference was abhorrent. It's not the tuner that failed it's the panel,
which would have been the same in both models, so that's irrelevant.

My web blog :: 42 inch LS5600

Anonymous said...

bookmarked!!, I like your blog!

My webpage - xerox 8560 toner

Anonymous said...

ӏ will right away clutch your rss as I can nοt to fіnd your
email subsсгiption link oг e-newsletter service.
Do you've any? Kindly permit me recognize so that I may just subscribe. Thanks.

my weblog Sayısal

Anonymous said...

My brother recommended I might like this website. He was entirely right.
This publish truly made my day. You cann't imagine simply how much time I had spent for this info! Thanks!

My blog post; xerox 8560 ram error

Anonymous said...

You should be a part of a contest for one of the best sites on the web.
I'm going to highly recommend this website!

Also visit my website; xerox 8560dn

Anonymous said...

I pay a visit daily some blogs and websites to read posts, however
this website offers quality based posts.

My blog :: xerox 8560mfp driver

Ronald Nichols said...
This comment has been removed by the author.
Ronald Nichols said...

Great information. I still prefer the dedicated server web hosting compared to shared server.

Tony Stark said...

good post

Vivek Tripathi said...

Dedicated hosting and shared hosting, these both type of hosting services are good and used by the businesses whose have requirements related to them. I suggest you to go with Go4hosting. Check their varieties of plans which will save all your money.

adampiterson26 said...
This comment has been removed by the author.
Andrew Son said...

Thanks for sharing this incredible and unique content. This would help many like me in getting the Top web hosting

Anonymous said...

Test

Anonymous said...

Thanks, It is a great blog with some very useful tips. It has helped me lot in understanding dedicated server's reliability, its traffic handling capability, control and flexibility.

Henry Robbert said...

Thank you for sharing knowledgeable information.
I really appreciate with this article. The information you are providing is helpful about
Dedicated Server

Soham madye said...

Thanks for this useful post, I really appreciate that. It is very helpful for people like me, those who want to host website on server to run their business. This is very elite option to run online business.

neha kumari said...

Very informative post, Thanks a lot for sharing this informative article with us. Updated dedicated server reviews

Jackie Warne said...

Shared hosting share a single IP address but dedicated Server hosting provides its own unique IP address. The shared hosting is a low-cost entry point for low traffic websites, running within the setup constraints of the standard accounts. As some sites expand, the shared hosting accounts become limiting. With dedicated hosting the client also have more freedom, access, and control which is more then to shared hosting.

Sharif Mustakim said...

I liked the way you put together everything, there is certainly no need to go any further to look for any additional information. You mentioned each and everything that too with much of ease.
dedicated server

Sharif Mustakim said...

It has been seen that most good web hosting services have the tendency of posting information of their web servers on their websites.
shared hosting

Sharif Mustakim said...

Its a great pleasure reading your post.Its full of information I am looking for and I love to post a comment that "The content of your post is awesome" Great work.
dedicated server

Server wala said...

You can check out Serverwala Data center in India for reliable server hosting services. They are providing quality of services at affordable prices.

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

diksha gupta said...

Are you presently enthusiastic about buying Android App Store ratings & reviews? If so, you're on correct web site. We can supply you original Android App Store ratings & reviews in bulk. buy app ratings

Sumi Akter said...

Get Blazing Fast Asia Optimized VPS (Virtual Private Server) For Affordable Price Here - THESTACK.NET

Ramesh K said...

Thanks for sharing this informative information..You may also refer http://www.s4techno.com/dedicated-servers/ for more details...

diksha gupta said...

Android App Store reviews/ratings aren’t consistently trustworthy & consistent as broadly offered on internet. For authentic App Store reviews & ratings, we're there to accomplish your requirements. buy reviews for google play store

Best Web Hosting said...

Bluehost - A Top Rated Web Host - Web Hosting Review
Exclusive Discount: BlueHost At $3.49/Mo
BlueHost Basic Plan Discount – $3.49/mo* for first contract
No coupon or promotion code needed – Just purchase via our promo link (see below) and you’ll get an extra 55% discount from your first BlueHost bill.
BlueHost WEb Hosting Discount

Blogger said...

Bluehost is definitely the best web-hosting provider for any hosting services you require.

raybanoutlet001 said...

nike shoes
reebok shoes
cheap oakley sunglasses
oklahoma city thunder jerseys
coach outlet online
ugg outlet
nike blazer pas cher
ugg boots
coach outlet
gucci shoes

David Jack said...

I personally prefer dedicated server is all time best choice as you are the only responsible for any causes. In the shared server as there are many sessions the risk of damage is high as compared to dedicated server hosting.