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.


71 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

Unknown 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.

Unknown said...

good post

Unknown 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.
Unknown 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.

Anonymous 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

Unknown 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.

Unknown 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

Unknown 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

Unknown 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 Data Centers Pvt. Ltd. said...

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

Unknown 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

Unknown 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

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.

surat chennai expressway said...

Thanks for sharing great post.. Once you have a dedicated server you can fix the cPanel on your own and to your penchant. This will make it stretchier and you get to personalize it, putting your own symbol and appending other attributes.

nameplates said...

Nice information about the dedicated server and the shared sever configuration. Keep blogging regularly.

William Hurt said...

I have found that this site is very informative, interesting and very well written. keep up the nice high quality writing. Dedicated Server

Jon Sigurdsson said...

Thanks for the comparison on web hosting!

Web Hosting Services

5689 said...

zzzzz2018.8.31
moncler online outlet
pandora
ferragamo shoes
pandora charms outlet
vibram five fingers
adidas football soldes
louboutin shoes
nike factory store
kate spade outlet online
mbt shoes outlet

Unknown said...

michael kors handbags
polo ralph lauren
cheap jordans
air force 1
coach handbags
adidas nmd
moncler jackets
hermes handbags
jordan 11
cheap nfl jerseys

Mejbahul Alam said...

Intriguing post. I Have Been pondering about this issue, so a debt of gratitude is in order for posting. Entirely cool post. It 's extremely exceptionally decent and Useful post. dedicated server web hosting Thanks.

DedicatedHosting4u said...

Dedicated Servers with No Setup Fee, No Contracts, No UAP, Additional IP Available, 100% Uptime Guarantee, 24*7 Customer Support, Enterprise Hardware, Free 6 Hours Express Delivery, Free 32 GB RAM Upgrade with all dedicated Server plans available now and get a secure and stable platform for your business. We supply with the quality hardware along with high level of customer support. your best choice for a dedicated server. If you are looking for a Server and reliable internet connectivity as well as top notch, no excuses support, you have reached the right place-Our fully redundant network and experienced technical support staff will have you up and running in no time with fine gear. We will always be when you need us, a partner in your success.

success

John said...

hermes
michael kors outlet clearance
ugg boots women
air jordan 14
coach outlet sale
hydro flask lids
canada goose outlet
christian louboutin sale
miu miu handbags
cheap snapbacks
yolo

Digital Marketing Pro said...

An excellent piece of content I can see here. Thanks, sir.Awesome writing bro, You are doing a good job, thanks for save my time.Very good stuff with good ideas and concepts, lots of great information and inspiration, both of which we all need.thanks for sharing!
Full Digital Marketing Services & Training
Digital Marketing Training & Services
Best Social midea Marketing Training
Best Soical Media Marketing Services

jawahar s said...

Thanks for sharing,get an affordable dedicated hosting at best prices.

yanmaneee said...

moncler jackets
jordan sneakers
curry 4 shoes
yeezy boost
kate spade handbags
yeezy supply
supreme new york
yeezy
kd shoes
air max 270

Anonymous said...

Thank you for sharing a great video and post. I really liked your Information. Keep up the good work. I would like to tell you that If you want the best and cheapest VPS Server, dedicated server hosting, and web hosting services with amazing features then choose Onlive Server web hosting company. Apart from that, your blog is awesome.
Thank You...
France VPS Server

Anonymous said...

Hi!! Very interesting information glad that I came across such an informative post. I really liked your Information. Keep up the good work friend.
Finland VPS Server

Onlive Server said...

As you are providing information about "Difference between dedicated and shared server configuration:". that is extremely good for everyone. Basically, we want to say that your knowledge really impressive that should be spread all over the world. Basically, We are leading server hosting Company. There are lots of companies available in the market that provides the hosting solution. if you want any other information about server hosting Contact us without any hesitation. Onlive Server and Onlive Infotech here are available multiple types of server hosting solutions. for more information Click here - USA VPS Hosting.

jawahar s said...

Nice blog.
vps hosting chennai

Megha Rajput said...

Hey, You always making a different blog from others and this thing makes you different. If you are looking for the fastest and cheapest UK Dedicated Serveryou can ask us for more details and services.

Anonymous said...

It Is really a Mind-blowing blog Nice way to understand it. thank you for it, carry on. Choose a Spain Dedicated Server to ensure your performance, security by Onlive Server.

Anonymous said...

Excellent Blog
Thank you for sharing a great post.Really the most valuable and high-quality blog. this will surely help to boost up the ranking.
Canada Dedicated Server Hosting

Onlive Server said...

Firstly you are explain very well in this article.
You are providing such a good information i really like your writing skills. I am really impressed with your blog article. I appreciate your work. Thanks for sharing and keep it up like this.
South Korea Dedicated Server

Anonymous said...

Wonderful!! Nice blog, all information is very good. I like this blog. If you want to get the best and cheap Ukraine Dedicated Server you visit this. you can ask us for more details.
Thank you

Anonymous said...

Hi!
I have read this post and find it really informative for me. Thanks for sharing it, I hope I can find more in the future. Thanks for sharing this type of post. Dubai Dedicated Server Hosting

Anonymous said...

Nice blog
Thanks for sharing this blog, I really appreciate with this article. The information you are providing is helpful about India Dedicated Server Hosting

Sesli Chat said...

Sesli chat 18 sohbet etme sitesi