OraFAQ Forum: Networking and Gateways » How to Create Multisession on single connection(dedicated server)

Home » RDBMS Server » Networking and Gateways » How to Create Multisession on single connection(dedicated server) (10g R2)

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

How to Create Multisession on single connection(dedicated server) [message #306827]

Mon, 17 March 2008 00:44

kukreja
Messages: 33
Registered: February 2007

Member

Hi

Can anyone tell how to manually create multisession on single connection in dedicated server apart from autotrace(which is created internally)?

Thanks

Report message to a moderator

Re: How to Create Multisession on single connection(dedicated server) [message #306828 is a reply to message #306827]

Mon, 17 March 2008 00:53

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>Can anyone tell how to manually create multisession on single connection in dedicated server apart from autotrace(which is created internally)?

HUH?

What is the input?
What do you expect for output?
What OS name & version?
What version of Oracle to 4 decimal places?

Report message to a moderator

Re: How to Create Multisession on single connection(dedicated server) [message #306834 is a reply to message #306828]

Mon, 17 March 2008 01:18

kukreja
Messages: 33
Registered: February 2007

Member

My Query is :
suppose I put a command

Sqlplus Scott/tiger

This will create both session and connection.

Now on this same connection, i want to create more sessions.

OS Name : Enterprise Linux Enterprise Linux AS release 4 (October Update 5)

Oracle Version: 10.1.0.2.0

Thanks

Report message to a moderator

Re: How to Create Multisession on single connection(dedicated server) [message #306836 is a reply to message #306827]

Mon, 17 March 2008 01:24

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>Now on this same connection, i want to create more sessions.
I want a million dollars a year.
Neither will get what we "want".
How will more sessions benefit you?

What business problem are you really trying to solve?

Report message to a moderator

Re: How to Create Multisession on single connection(dedicated server) [message #306838 is a reply to message #306836]

Mon, 17 March 2008 01:37

kukreja
Messages: 33
Registered: February 2007

Member

Anacedent

Due to some limitation on no. of connections, we cann't create more than specific no. of conn, but we need more sessions on dedicated server as it is business requirement.
(Actual Business need, i cannot reveal due to internal policy.

thanks

Report message to a moderator

Re: How to Create Multisession on single connection(dedicated server) [message #306858 is a reply to message #306834]

Mon, 17 March 2008 02:16

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

Senior Member
Account Moderator

You can't do it in SQL*Pus, you have to write your program to do it like SQL*Plus does.

Regards
Michel

Report message to a moderator

Previous Topic:	ORA-12514: TNS:listener does not currently know of service requested in connect
Next Topic:	ORA-12518: TNS:listener could not hand off client connection

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Feb 19 17:08:55 CST 2025