FilesExpand file tree

 main

/

rac_longops.sql

Copy path

BlameMore file actions

BlameMore file actions

Latest commit

 

History

History

History

21 lines (20 loc) · 633 Bytes

 main

/

rac_longops.sql

Top

File metadata and controls

• Code
• Blame

21 lines (20 loc) · 633 Bytes

Raw

Copy raw file

Download raw file

Open symbols panel

Edit and raw actions

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

SET LINESIZE 200

COLUMN sid FORMAT 9999

COLUMN serial# FORMAT 9999999

COLUMN machine FORMAT A30

COLUMN progress_pct FORMAT 99999999.00

COLUMN elapsed FORMAT A10

COLUMN remaining FORMAT A10

SELECT s.inst_id,

s.sid,

s.serial#,

s.username,

s.module,

ROUND(sl.elapsed_seconds/60) || ':' || MOD(sl.elapsed_seconds,60) elapsed,

ROUND(sl.time_remaining/60) || ':' || MOD(sl.time_remaining,60) remaining,

ROUND(sl.sofar/sl.totalwork*100, 2) progress_pct

FROM gv$session s,

gv$session_longops sl

WHERE s.sid = sl.sid

AND s.inst_id = sl.inst_id

AND s.serial# = sl.serial#;