Search
 
SCRIPT & CODE EXAMPLE
 

SQL

oracle list of long running queries

SELECT SID, to_char(START_TIME, 'hh24:mi:ss') STIME, MESSAGE, (SOFAR / TOTALWORK) * 100 PERCENT
FROM V$SESSION_LONGOPS
WHERE SOFAR / TOTALWORK < 1;
Comment

PREVIOUS NEXT
Code Example
Sql :: alter table 
Sql :: mysql round 
Sql :: mysql root localhost run 
Sql :: how to add default constraint in mysql 
Sql :: backup ms sql database table data to file 
Sql :: show tables sql 
Sql :: sql empty table 
Sql :: oracle list privileges 
Sql :: HOW TO FIND MEDIAN IN SQL FOR BOTH IDD AND EVEN 
Sql :: add new column not null sql server 
Sql :: wsl centos 8 mysql 
Sql :: where to locate set password for mysql 
Sql :: if not exists insert sql 
Sql :: get all db sizes in mysql server 
Sql :: restore postgres database from sql file 
Sql :: minus vs intersect in sql 
Sql :: cast to float with .2 sql 
Sql :: psql datetime grather than 
Sql :: change old domain to new domain name wordpress 
Sql :: t sql get foreign key 
Sql :: sql in sublime 
Sql :: sql where contains 
Sql :: drop multiple databases mysql 
Sql :: how to add CHECK constraint to a column in postgres 
Sql :: input in mysql 
Sql :: convert date to dd/mm/yyyy sql 
Sql :: mysql CAST(amount as float) 
Sql :: (PDOException(code: 2002): SQLSTATE[HY000] [2002] Permission denied at 
Sql :: insert output identity 
Sql :: sql count null 
ADD CONTENT
Topic
Content
Source link
Name
8+6 =