Dan Horne wrote: > I've seen this issue rasied several times, and it's always suprised me. I > don't see how forking could work with Oracle. A dedicated connections is > given a session id and and a serial number that relate to the specific > connection. The sid and serial# must be unique, hence these values must be > unique for the child, and I don't see how that could happen with forking, > espcially since these values are allocated by Oracle. In the case of the > Multi-threaded server architecture, there are other issues, as some of the > user memory is stored in the SGA not the in a dedicated process space. How > would Oracle know which memory space within the SGA is now for the parent > and which is for the child, as it didn't create the connections? > > I presume most other databases allocate unique connection information too. > > Dan >
You can make a simple program to try it not only your supposition. If I am wrong I will say sorry to everybody.
