The session tag has no wiki summary.
0
votes
0answers
11 views
Vote to a db server using session key
I do not know if this is the right stackexchange site to ask this question, but I believe that is relevant.
I am trying to implement an e-voting protocol. At some point the protocol says that server 1 ...
0
votes
2answers
103 views
How are DB locks tied to connections and sessions?
I've heard of page- and row-level locks, but never heard them used with regards to sessions and connections. Today, our (MySQL) DBA was talking about row locks and implied that their scope can be set ...
0
votes
2answers
63 views
Is there a combination of columns in sys.dm_exec_sessions that is unique per the server?
In SQL Server, each session has its own spid. Spids are unique at any given notice, but spids, like process and thread identifiers in the OS are recycled.
However sys.dm_exec_sessions has other ...
3
votes
1answer
785 views
ASPState database locking and growth problems
We use an ASPState database to persist .NET Session state on a SQL Server 2005 cluster. We are seeing some strange behavior during peak periods
The DeleteExpiredSessions proc is run every minute ...
1
vote
0answers
113 views
Oracle locked sessions with ASP.Net
I am connecting to an Oracle database in ASP.Net using SQLDataSource. My connection string is:
<add name="ConnectionString3"
connectionString="Data Source=sml; User ID=sml; Password=sml; ...
2
votes
2answers
645 views
Oracle - How can I find the session id of a shell script (Linux)?
I have a Linux script run periodically from crontab which executes some sql scripts. How can I get/identify the session of that running job?
thanks
4
votes
1answer
339 views
Session in “Sql*net message from client”, but is active
I've Googled around, and my impression is that
Sql*net message from client
suggests the Oracle DBMS is waiting for the client to send new commands to the DBMS, and therefore any time spent in ...
2
votes
1answer
71 views
Associate a piece of data with a session
I think I want to associate a piece of data with each session.
The association must have the following properties:
The data being associated is provided either as a part of connection string (if ...
