Re: Getting my Oracle SID

Thanks for the information.

>select sid
>from v$session
>where username = <your_login>
>or osuser = <your_osuser>

This solution won't work because i'm using a middleware called CILINK which does the connection by using the same UNIX user and the same connection username (The 'osuser' and 'username' are not single).

In fact, what i want to do is to keep track of my application connection (10 users can use this program at the same time) by writing informations in a table (to limit the number of connections) and delete these informations after user's disconnection. But if there's a crash of the program, the table isn't modified. So what i want to do is to keep the connection SID in my table and, with a batch program (CRON or other), looking for difference between this table and v$session.

>> If i can get this SID, how can i find my
>> connection ?

>What do you mean with this question?

I wrote my question incorrectly. It was "If i can't get this SID" and not "If i can get this SID". I mean, if i can't use the SID information, is there another way to indentify my connection among all the connections.

If you've got an idea ?

Thanks in advance

Received on Thu Nov 19 1998 - 01:58:57 CST