OraFAQ Forum: Server Administration » Which is better for a lot of sessions in oracle database?

Home » RDBMS Server » Server Administration » Which is better for a lot of sessions in oracle database?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Which is better for a lot of sessions in oracle database? [message #624879]

Sat, 27 September 2014 10:06

compuscience
Messages: 97
Registered: September 2012

Member

Which is better for a lot of sessions in oracle database dedicated or shared server?

And difference between them
Thanks

Edited by Lalit : Removed unnecessary extra lines between two statements.

[Updated on: Sat, 27 September 2014 11:26] by Moderator

Report message to a moderator

Re: Which is better for a lot of sessions in oracle database? [message #624880 is a reply to message #624879]

Sat, 27 September 2014 10:10

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>Which is better for a lot of sessions in oracle database dedicated or shared server?

which metric measures "better"?

>And difference between them

Consider to actually Read The Fine Manual for answers yourself

http://docs.oracle.com/database/121/CNCPT/toc.htm

Report message to a moderator

Re: Which is better for a lot of sessions in oracle database? [message #624881 is a reply to message #624880]

Sat, 27 September 2014 10:16

compuscience
Messages: 97
Registered: September 2012

Member

BlackSwan wrote on Sat, 27 September 2014 13:10

>Which is better for a lot of sessions in oracle database dedicated or shared server?

which metric measures "better"?

>And difference between them

Consider to actually Read The Fine Manual for answers yourself

http://docs.oracle.com/database/121/CNCPT/toc.htm

Better for performance

Report message to a moderator

Re: Which is better for a lot of sessions in oracle database? [message #624882 is a reply to message #624881]

Sat, 27 September 2014 10:21

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>Better for performance

what is unit of measure for "performance"?

which metric measures performance?

Which do your own benchmark test show is better?

Report message to a moderator

Re: Which is better for a lot of sessions in oracle database? [message #624883 is a reply to message #624881]

Sat, 27 September 2014 10:23

EdStevens
Messages: 1376
Registered: September 2013

Senior Member

As in all things related to ANY db, the answer is "it depends". If the answer were as simple as your question there would be no need for multiple methods.

Report message to a moderator

Re: Which is better for a lot of sessions in oracle database? [message #624884 is a reply to message #624883]

Sat, 27 September 2014 10:29

compuscience
Messages: 97
Registered: September 2012

Member

Sirs,
I mean with alot of no. of sessions which is better for me
Dedicated server or shared server

Report message to a moderator

Re: Which is better for a lot of sessions in oracle database? [message #624885 is a reply to message #624884]

Sat, 27 September 2014 10:32

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>I mean with alot of no. of sessions which is better for me

at what value does number of sessions become "a lot"?

which metric measures "better"?

If you don't answer our questions, why should we answer yours?

Report message to a moderator

Re: Which is better for a lot of sessions in oracle database? [message #624890 is a reply to message #624885]

Sat, 27 September 2014 11:28

Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web

Senior Member

@OP, do you have SPL/Full load testing? If yes, it gives complete information about the load and whether you really need more hardware and other aspects.

Report message to a moderator

Re: Which is better for a lot of sessions in oracle database? [message #624897 is a reply to message #624890]

Sat, 27 September 2014 11:46

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

I bet this is just an interview question.

Report message to a moderator

Re: Which is better for a lot of sessions in oracle database? [message #624899 is a reply to message #624897]

Sat, 27 September 2014 11:58

Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web

Senior Member

I just viewed OP's previous topics, all seem to be a one-liner too generic questions. Probably, you are right.

Report message to a moderator

Re: Which is better for a lot of sessions in oracle database? [message #624900 is a reply to message #624899]

Sat, 27 September 2014 12:01

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

A database can support both shared server and dedicated server connections simultaneously. For example, one client can connect using a dedicated server while a different client connects to the same database using a shared server.

The choice of shared server or dedicated server is up to the client & NOT the DB Server itself.

So how do you measure which is better?

Report message to a moderator

Re: Which is better for a lot of sessions in oracle database? [message #624942 is a reply to message #624900]

Mon, 29 September 2014 03:04

Roachcoach
Messages: 1576
Registered: May 2010
Location: UK

Senior Member

>Which is better for a lot of sessions in oracle database

Probably to cut the numbers down Confused

[Updated on: Mon, 29 September 2014 03:05]

Report message to a moderator

Previous Topic:	Simulator transaction in oracle 11g
Next Topic:	How to set NULL on LOG_ARCHIVE_DEST_N

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Feb 22 17:30:36 CST 2025