Home » RDBMS Server » Networking and Gateways » How to Create Multisession on single connection(dedicated server) (10g R2)
How to Create Multisession on single connection(dedicated server) [message #306827] Mon, 17 March 2008 00:44 Go to next message
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
Re: How to Create Multisession on single connection(dedicated server) [message #306828 is a reply to message #306827] Mon, 17 March 2008 00:53 Go to previous messageGo to next message
BlackSwan
Messages: 22905
Registered: January 2009
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?
Re: How to Create Multisession on single connection(dedicated server) [message #306834 is a reply to message #306828] Mon, 17 March 2008 01:18 Go to previous messageGo to next message
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
Re: How to Create Multisession on single connection(dedicated server) [message #306836 is a reply to message #306827] Mon, 17 March 2008 01:24 Go to previous messageGo to next message
BlackSwan
Messages: 22905
Registered: January 2009
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?
Re: How to Create Multisession on single connection(dedicated server) [message #306838 is a reply to message #306836] Mon, 17 March 2008 01:37 Go to previous messageGo to next message
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
Re: How to Create Multisession on single connection(dedicated server) [message #306858 is a reply to message #306834] Mon, 17 March 2008 02:16 Go to previous message
Michel Cadot
Messages: 59422
Registered: March 2007
Location: Nanterre, France, http://...
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
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:
  


Current Time: Thu Oct 23 13:46:10 CDT 2014

Total time taken to generate the page: 0.08495 seconds