Craig Buchanan craibuc

craibuc / gist:5813835

Created June 19, 2013 12:15

List of Oracle sessions for current user.

	SELECT SID, USERNAME, SCHEMANAME, OSUSER, MACHINE, TERMINAL, PROGRAM, TYPE, MODULE, ACTION, LOGON_TIME
	FROM V$SESSION
	-- current user
	WHERE USERNAME = USER