Question : I’ve heard of page- and row-level locks, but never heard them used with regards to sessions and connections. […]
Tag: session
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. […]
How to find a session with a specific command
Question : I have an Oracle instance with some active sessions from different users. How can I find the SID/SERIAL […]
too many entries for one single session and serila# in V$Session_longops
Question : I have a concern with the entries in v$session_longops. I used a query to identify query running from […]
Oracle – How can I find the session id of a shell script (Linux)?
Question : I have a Linux script run periodically from crontab which executes some sql scripts. How can I get/identify […]
Session in “Sql*net message from client”, but is active
Question : I’ve Googled around, and my impression is that Sql*net message from client suggests the Oracle DBMS is waiting […]
- 1
- 2