Technical Notes
We're all on the same page!
Showing posts with label
session
.
Show all posts
Showing posts with label
session
.
Show all posts
Tuesday, 11 April 2017
How to find and investigate a process in top command output?
›
Total connection by machine: SQL> select machine, count(*) from v$session group by machine order by 2; Total number of database user ...
Thursday, 9 March 2017
How to define "idle_time" ?
›
Check parameter of resource_limit SQL> show parameter resource; If it is 'False' SQL> alter system set resource_limit = t...
Thursday, 12 January 2017
How to kill inactive session for non-background oracle processes?
›
At first, check the sessions SQL> SELECT DISTINCT spid, b.username, osuser FROM sys.dba_ddl_locks a, sys.v_$session B, v$process ...
Monday, 17 October 2016
How to kill remote sessions or specific sessions?
›
Observe remote sessions $ ps -ef | grep LOCAL=NO | grep ALPERDB| awk '{print $2}' $ ps -ef | grep LOCAL=NO | grep ALPERDB| wc -l ...
›
Home
View web version