Search
 
SCRIPT & CODE EXAMPLE
 

SQL

oracle job session

-- Get Job session IDs
SELECT jr.JOB, s.USERNAME, s.SID, s.SERIAL#, p.SPID, s.LOCKWAIT, s.LOGON_TIME
FROM DBA_JOBS_RUNNING jr, V$SESSION s, V$PROCESS p
WHERE jr.SID = s.SID AND s.PADDR = p.ADDR
ORDER BY jr.JOB;
Comment

PREVIOUS NEXT
Code Example
Sql :: find the names of sailors who have reserved at least one boat 
Sql :: Write an SQL query to determine the 5th highest salary without using TOP or limit method. 
Sql :: sqlstate[hy000] [2006] mysql server has gone away laravel 
Sql :: import mysql db 
Sql :: how to reset autoincrement in sqlite java 
Sql :: if exist column in table drop sql query mysql 
Sql :: mysql trigger to delete old data 
Sql :: how to start postgresql laravel 
Sql :: sql not 
Sql :: psql view databases 
Sql :: sql output parameters 
Sql :: mysql select empty string 
Sql :: SQL MIN() Function 
Sql :: create domain sql 
Sql :: timestamp type in sql 
Sql :: sql select distinct 
Sql :: postgres isnull 
Sql :: postgresql cast string to int 
Sql :: ring MySQL commit updates to the database 
Sql :: TITLE: SQL Server principal "dbo" does not exist 
Sql :: knex last insert id mysql 
Sql :: modularity meaning in plsql 
Sql :: db connection using sql client in dot net 
Sql :: SQL ANY and ALL Operators 
Sql :: postgresql between month 
Sql :: trigger value from maltiple table to single table mysql 
Sql :: postgresql not in alternative 
Sql :: interview experience as a call? 
Sql :: create user oracle hash by value 
Sql :: SQL RIGHT JOIN With AS Alias 
ADD CONTENT
Topic
Content
Source link
Name
1+8 =