Question : I have an application that is going down as a result of timeouts. During these times we see […]
Tag: session
How to capture all user’s query on Oracle database
Question : I have an Oracle Database installed over Unix system. On this single instance database I have a lot […]
User connections without a login
Question : I was looking at SQL Server performance and noticed that CPU utilization goes high when the number of […]
database connection and sessions in an example of social media
Question : I am referring to MS SQL connection and sessions. I know that each application should make a connection […]
How are DB locks tied to connections and sessions?
Question : I’ve heard of page- and row-level locks, but never heard them used with regards to sessions and connections. […]
Best approach for basic PHP DB session data storage
Question : I’ve decided to switch from PHP’s native session management based on $_SESSION to use my own, due to […]
How to capture all user’s query on Oracle database
Question : I have an Oracle Database installed over Unix system. On this single instance database I have a lot […]
Can an active session in oracle be dead?
Question : I have a time consuming query which populates a materialized view. It has been running for 18 hours […]
Cannot remove idle connections to a Postgres database
Question : I need to delete a database. But the database cannot be deleted due to some active sessions using […]
MSSQL – Uniquely identify an application connecting SQL Server
Question : we are implementing a database firewall on Oracle based on a unique value associated to a given application. […]