SQL Id | SQL Text |
00a0rtu0xhh01 | select recsite0_.SITEID as col_0_0_ from REC_SITE recsite0_ where recsite0_.RECID=:1 |
02qhsazjq77wp | select count(*) as y0_ from NCSS.STU_SEARCHJOB this_ where this_.SITEID=:1 and this_.IS_AUDITED=:2 |
08v35uwaj38aa | select * from ( select row_.*, rownum rownum_ from ( select trunc(POSTDATE, 'dd') AS days, this_.JOBID as y1_, this_.SITEID as y2_, this_.HEADCOUNT as y3_, this_.RECMAIL as y4_, this_.POSTDATE as y5_, this_.PRIORITY as y6_, this_.INDUSTRY as y7_, this_.INDUSTRY_CODE as y8_, this_.JOBTITLE as y9_, this_.AREA as y10_, this_.DEGREE as y11_, this_.FROMTYPE as y12_, this_.RECID as y13_, this_.RECNAME as y14_, this_.NATURE as y15_, this_.REC_SCALE as y16_, this_.JOBTYPE as y17_, this_.AREACODE as y18_, this_.CREATEDATE as y19_, this_.ENDDATE as y20_, this_.DEGREECODE as y21_, this_.CATEGORY as y22_, this_.CATEGORYNAME as y23_, this_.MAJORCODE as y24_, this_.MAJOR as y25_, this_.ZIPCODE as y26_, this_.WEBSITE as y27_, this_.ADDRESS as y28_, this_.FROMNAME as y29_, this_.FROMURL as y30_, this_.IS_AUDITED as y31_, this_.JOBFAIRID as y32_, this_.VIEW_COUNT as y33_ from NCSS.STU_SEARCHJOB this_ where this_.siteId = :1 and this_.IS_AUDITED = :2 order by y6_ desc, days desc, y12_ asc, y5_ desc ) row_ ) where rownum_ <= :3 and rownum_ > :4 |
0k8522rmdzg4k | select privilege# from sysauth$ where (grantee#=:1 or grantee#=1) and privilege#>0 |
0nn3rt489dkqz | select * from ( select row_.*, rownum rownum_ from ( select trunc(POSTDATE, 'dd') AS days, this_.JOBID as y1_, this_.SITEID as y2_, this_.HEADCOUNT as y3_, this_.RECMAIL as y4_, this_.POSTDATE as y5_, this_.PRIORITY as y6_, this_.INDUSTRY as y7_, this_.INDUSTRY_CODE as y8_, this_.JOBTITLE as y9_, this_.AREA as y10_, this_.DEGREE as y11_, this_.FROMTYPE as y12_, this_.RECID as y13_, this_.RECNAME as y14_, this_.NATURE as y15_, this_.REC_SCALE as y16_, this_.JOBTYPE as y17_, this_.AREACODE as y18_, this_.CREATEDATE as y19_, this_.ENDDATE as y20_, this_.DEGREECODE as y21_, this_.CATEGORY as y22_, this_.CATEGORYNAME as y23_, this_.MAJORCODE as y24_, this_.MAJOR as y25_, this_.ZIPCODE as y26_, this_.WEBSITE as y27_, this_.ADDRESS as y28_, this_.FROMNAME as y29_, this_.FROMURL as y30_, this_.IS_AUDITED as y31_, this_.JOBFAIRID as y32_, this_.VIEW_COUNT as y33_ from NCSS.STU_SEARCHJOB this_ where this_.areaCode like :1 and this_.siteId = :2 and this_.IS_AUDITED = :3 order by y6_ desc, days desc, y12_ asc, y5_ desc ) row_ ) where rownum_ <= :4 and rownum_ > :5 |
0ws7ahf1d78qa | select SYS_CONTEXT('USERENV', 'SERVER_HOST'), SYS_CONTEXT('USERENV', 'DB_UNIQUE_NAME'), SYS_CONTEXT('USERENV', 'INSTANCE_NAME'), SYS_CONTEXT('USERENV', 'SERVICE_NAME'), INSTANCE_NUMBER, STARTUP_TIME, SYS_CONTEXT('USERENV', 'DB_DOMAIN') from v$instance where INSTANCE_NAME=SYS_CONTEXT('USERENV', 'INSTANCE_NAME') |
34hggv6gbvc7a | insert into NCSS.REC_JOB (RECID, RECNAME, JOBNAME, JOBCODE, HEADCOUNT, APPLYCOUNT, JOBAREACODE, JOBAREANAME, JOBTYPE, CATEGORY, CATEGORYNAME, DEGREEREQCODE, DEGREE, DESCRIPTION, RECMAIL, DAYLIMIT, STATUS, CREATEDATE, MODIFYDATE, MODIFYBYID, MODIFYBYNAME, SOURCECODE, MAJOR, MAJORCODE, SITE_COUNT, JOBID) values (:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , :20 , :21 , :22 , :23 , :24 , :25 , :26 ) |
350f5yrnnmshs | lock table sys.mon_mods$ in exclusive mode nowait |
459f3z9u4fb3u | select value$ from props$ where name = 'GLOBAL_DB_NAME' |
4pxrrbxm6024k | select job0_.JOBID as JOBID70_0_, job0_.RECID as RECID70_0_, job0_.RECNAME as RECNAME70_0_, job0_.JOBNAME as JOBNAME70_0_, job0_.JOBCODE as JOBCODE70_0_, job0_.HEADCOUNT as HEADCOUNT70_0_, job0_.APPLYCOUNT as APPLYCOUNT70_0_, job0_.JOBAREACODE as JOBAREAC8_70_0_, job0_.JOBAREANAME as JOBAREAN9_70_0_, job0_.JOBTYPE as JOBTYPE70_0_, job0_.CATEGORY as CATEGORY70_0_, job0_.CATEGORYNAME as CATEGOR12_70_0_, job0_.DEGREEREQCODE as DEGREER13_70_0_, job0_.DEGREE as DEGREE70_0_, job0_.DESCRIPTION as DESCRIP15_70_0_, job0_.RECMAIL as RECMAIL70_0_, job0_.DAYLIMIT as DAYLIMIT70_0_, job0_.STATUS as STATUS70_0_, job0_.CREATEDATE as CREATEDATE70_0_, job0_.MODIFYDATE as MODIFYDATE70_0_, job0_.MODIFYBYID as MODIFYBYID70_0_, job0_.MODIFYBYNAME as MODIFYB22_70_0_, job0_.SOURCECODE as SOURCECODE70_0_, job0_.MAJOR as MAJOR70_0_, job0_.MAJORCODE as MAJORCODE70_0_, job0_.SITE_COUNT as SITE26_70_0_ from NCSS.REC_JOB job0_ where job0_.JOBID=:1 |
4rrtsdhkzfph5 | DELETE FROM ONLINE_USER WHERE LAST_ACTIVE_TIME+ 1/(24*3) < SYSDATE AND PTP_ID IS NULL |
4vs91dcv7u1p6 | insert into sys.aud$( sessionid, entryid, statement, ntimestamp#, userid, userhost, terminal, action#, returncode, obj$creator, obj$name, auth$privileges, auth$grantee, new$owner, new$name, ses$actions, ses$tid, logoff$pread, logoff$lwrite, logoff$dead, comment$text, spare1, spare2, priv$used, clientid, sessioncpu, proxy$sid, user$guid, instance#, process#, xid, scn, auditid, sqlbind, sqltext, obj$edition, dbid) values(:1, :2, :3, SYS_EXTRACT_UTC(SYSTIMESTAMP), :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21, :22, :23, :24, :25, :26, :27, :28, :29, :30, :31, :32, :33, :34, :35, :36) |
52xdu6bpaxhyh | select * from ( select row_.*, rownum rownum_ from ( select trunc(POSTDATE, 'dd') AS days, this_.JOBID as y1_, this_.SITEID as y2_, this_.HEADCOUNT as y3_, this_.RECMAIL as y4_, this_.POSTDATE as y5_, this_.PRIORITY as y6_, this_.INDUSTRY as y7_, this_.INDUSTRY_CODE as y8_, this_.JOBTITLE as y9_, this_.AREA as y10_, this_.DEGREE as y11_, this_.FROMTYPE as y12_, this_.RECID as y13_, this_.RECNAME as y14_, this_.NATURE as y15_, this_.REC_SCALE as y16_, this_.JOBTYPE as y17_, this_.AREACODE as y18_, this_.CREATEDATE as y19_, this_.ENDDATE as y20_, this_.DEGREECODE as y21_, this_.CATEGORY as y22_, this_.CATEGORYNAME as y23_, this_.MAJORCODE as y24_, this_.MAJOR as y25_, this_.ZIPCODE as y26_, this_.WEBSITE as y27_, this_.ADDRESS as y28_, this_.FROMNAME as y29_, this_.FROMURL as y30_, this_.IS_AUDITED as y31_, this_.JOBFAIRID as y32_, this_.VIEW_COUNT as y33_ from NCSS.STU_SEARCHJOB this_ where this_.jobType = :1 and this_.areaCode like :2 and this_.siteId = :3 and this_.IS_AUDITED = :4 order by y6_ desc, days desc, y12_ asc, y5_ desc ) row_ ) where rownum_ <= :5 and rownum_ > :6 |
55u237k35a317 | select * from ( select rownum no , t.* from ( select a.studentid, a.realname, a.language, a.gender, a.degree, a.majorname, a.school, a.modifydate , a.department, a.edustartdate, a.graduatedate from STU_BASICINFO a inner join STU_SITE b on a.studentid = b.studentid where b.siteid = :1 and a.openstate!='1' and a.language='cn' and a.ISAUTHED = :2 order by a.createDate desc, a.schoolCode asc) t where rownum< 13) where no>0 |
5902s014jdg6n | select * from ( select trunc(POSTDATE, 'dd') AS days, this_.JOBID as y1_, this_.SITEID as y2_, this_.HEADCOUNT as y3_, this_.RECMAIL as y4_, this_.POSTDATE as y5_, this_.PRIORITY as y6_, this_.INDUSTRY as y7_, this_.INDUSTRY_CODE as y8_, this_.JOBTITLE as y9_, this_.AREA as y10_, this_.DEGREE as y11_, this_.FROMTYPE as y12_, this_.RECID as y13_, this_.RECNAME as y14_, this_.NATURE as y15_, this_.REC_SCALE as y16_, this_.JOBTYPE as y17_, this_.AREACODE as y18_, this_.CREATEDATE as y19_, this_.ENDDATE as y20_, this_.DEGREECODE as y21_, this_.CATEGORY as y22_, this_.CATEGORYNAME as y23_, this_.MAJORCODE as y24_, this_.MAJOR as y25_, this_.ZIPCODE as y26_, this_.WEBSITE as y27_, this_.ADDRESS as y28_, this_.FROMNAME as y29_, this_.FROMURL as y30_, this_.IS_AUDITED as y31_, this_.JOBFAIRID as y32_, this_.VIEW_COUNT as y33_ from NCSS.STU_SEARCHJOB this_ where this_.jobfairId = :1 and this_.IS_AUDITED = :2 order by y6_ desc, days desc, y12_ asc, y5_ desc ) where rownum <= :3 |
5dpdd7s28hnaa | select * from ( select row_.*, rownum rownum_ from ( select trunc(POSTDATE, 'dd') AS days, this_.JOBID as y1_, this_.SITEID as y2_, this_.HEADCOUNT as y3_, this_.RECMAIL as y4_, this_.POSTDATE as y5_, this_.PRIORITY as y6_, this_.INDUSTRY as y7_, this_.INDUSTRY_CODE as y8_, this_.JOBTITLE as y9_, this_.AREA as y10_, this_.DEGREE as y11_, this_.FROMTYPE as y12_, this_.RECID as y13_, this_.RECNAME as y14_, this_.NATURE as y15_, this_.REC_SCALE as y16_, this_.JOBTYPE as y17_, this_.AREACODE as y18_, this_.CREATEDATE as y19_, this_.ENDDATE as y20_, this_.DEGREECODE as y21_, this_.CATEGORY as y22_, this_.CATEGORYNAME as y23_, this_.MAJORCODE as y24_, this_.MAJOR as y25_, this_.ZIPCODE as y26_, this_.WEBSITE as y27_, this_.ADDRESS as y28_, this_.FROMNAME as y29_, this_.FROMURL as y30_, this_.IS_AUDITED as y31_, this_.JOBFAIRID as y32_, this_.VIEW_COUNT as y33_ from NCSS.STU_SEARCHJOB this_ where this_.jobType = :1 and this_.areaCode like :2 and this_.siteId = :3 and postDate > trunc(sysdate , 'dd')-30 and this_.IS_AUDITED = :4 order by y6_ desc, days desc, y12_ asc, y5_ desc ) row_ ) where rownum_ <= :5 and rownum_ > :6 |
5ur69atw3vfhj | select decode(failover_method, NULL, 0 , 'BASIC', 1, 'PRECONNECT', 2 , 'PREPARSE', 4 , 0), decode(failover_type, NULL, 1 , 'NONE', 1 , 'SESSION', 2, 'SELECT', 4, 1), failover_retries, failover_delay, flags from service$ where name = :1 |
6g6vfy6x3mcsd | SELECT COUNT(*) FROM ONLINE_USER WHERE USER_ID = :B1 |
6jn011b6rp1m2 | select * from ( select trunc(POSTDATE, 'dd') AS days, this_.JOBID as y1_, this_.SITEID as y2_, this_.HEADCOUNT as y3_, this_.RECMAIL as y4_, this_.POSTDATE as y5_, this_.PRIORITY as y6_, this_.INDUSTRY as y7_, this_.INDUSTRY_CODE as y8_, this_.JOBTITLE as y9_, this_.AREA as y10_, this_.DEGREE as y11_, this_.FROMTYPE as y12_, this_.RECID as y13_, this_.RECNAME as y14_, this_.NATURE as y15_, this_.REC_SCALE as y16_, this_.JOBTYPE as y17_, this_.AREACODE as y18_, this_.CREATEDATE as y19_, this_.ENDDATE as y20_, this_.DEGREECODE as y21_, this_.CATEGORY as y22_, this_.CATEGORYNAME as y23_, this_.MAJORCODE as y24_, this_.MAJOR as y25_, this_.ZIPCODE as y26_, this_.WEBSITE as y27_, this_.ADDRESS as y28_, this_.FROMNAME as y29_, this_.FROMURL as y30_, this_.IS_AUDITED as y31_, this_.JOBFAIRID as y32_, this_.VIEW_COUNT as y33_ from NCSS.STU_SEARCHJOB this_ where this_.siteId = :1 and this_.IS_AUDITED = :2 order by y6_ desc, days desc, y12_ asc, y5_ desc ) where rownum <= :3 |
6nxtvwbnujh7t | select this_.SITE_ID as SITE1_52_0_, this_.SITE_NAME as SITE2_52_0_, this_.SITE_URL as SITE3_52_0_, this_.SITE_TYPE as SITE4_52_0_, this_.PARENT_ID as PARENT5_52_0_, this_.SERVICE_IP as SERVICE6_52_0_, this_.SERVICE_KEY as SERVICE7_52_0_, this_.IS_EFFECTIVE as IS8_52_0_, this_.CREATE_DATE as CREATE9_52_0_, this_.MODIFY_DATE as MODIFY10_52_0_, this_.CONTACT_NAME as CONTACT11_52_0_, this_.TELEPHONE as TELEPHONE52_0_, this_.FEX as FEX52_0_, this_.MOBILEPHONE as MOBILEP14_52_0_, this_.EMAIL as EMAIL52_0_, this_.DESCRIPTION as DESCRIP16_52_0_, this_.IS_ALLOW as IS17_52_0_, this_.TAGS as TAGS52_0_, this_.AREA_CODE as AREA19_52_0_, this_.AREA_NAME as AREA20_52_0_, this_.HAVE_THEME as HAVE21_52_0_, this_.PARENT_NAME as PARENT22_52_0_, this_.JOB_NEED_AUDIT as JOB23_52_0_, this_.WEB_NAME as WEB24_52_0_, this_.WEB_URL as WEB25_52_0_ from NCSS.PUB_SITE this_ where this_.SITE_URL like :1 and this_.IS_EFFECTIVE=:2 |
6rhp7mz3vugaw | update stu_searchjob set VIEW_COUNT = :1 where jobid = :2 and siteid = :3 and jobfairid = :4 |
7c8s9hzb0jn1h | UPDATE ONLINE_USER SET LAST_ACTIVE_TIME = SYSDATE WHERE USER_ID = :B1 |
8tptxzh309raz | select this_.PID as PID10_0_, this_.YEAR as YEAR10_0_, this_.C_NAME as C3_10_0_, this_.GENDER as GENDER10_0_, this_.RACE_CODE as RACE5_10_0_, this_.RACE as RACE10_0_, this_.POLICY as POLICY10_0_, this_.BIRTH as BIRTH10_0_, this_.IDCARD as IDCARD10_0_, this_.PHOTO as PHOTO10_0_, this_.FROM_AREA as FROM11_10_0_, this_.EDUCATION_CODE as EDUCATION12_10_0_, this_.EDUCATION as EDUCATION10_0_, this_.DEGREE_CODE as DEGREE14_10_0_, this_.DEGREE as DEGREE10_0_, this_.GRADUATE_SCHOOL as GRADUATE16_10_0_, this_.MAJOR as MAJOR10_0_, this_.IS_FRESH as IS18_10_0_, this_.IS_PEDAGOGIC as IS19_10_0_, this_.GRADUATE_DATE as GRADUATE20_10_0_, this_.EDUCATION_NO as EDUCATION21_10_0_, this_.TEACHER_KIND_CODE as TEACHER22_10_0_, this_.TEACHER_KIND as TEACHER23_10_0_, this_.TEACHER_NO as TEACHER24_10_0_, this_.MANDARIN as MANDARIN10_0_, this_.FOREIGN as FOREIGN10_0_, this_.POST_CODE as POST27_10_0_, this_.MOBILE as MOBILE10_0_, this_.TELEPHONE as TELEPHONE10_0_, this_.EMAIL as EMAIL10_0_, this_.FAMILY_ADDR as FAMILY31_10_0_, this_.RESUME as RESUME10_0_, this_.BEGIN_DATE as BEGIN33_10_0_, this_.AREA_CODE as AREA34_10_0_, this_.AREA as AREA10_0_, this_.LEVEL_CODE as LEVEL36_10_0_, this_.LEVEL_NAME as LEVEL37_10_0_, this_.SUBJECT_CODE as SUBJECT38_10_0_, this_.SUBJECT as SUBJECT10_0_, this_.LANGUAGE_CODE as LANGUAGE40_10_0_, this_.LANGUAGE as LANGUAGE10_0_, this_.REC_SCHOOL as REC42_10_0_, this_.POLICY_KIND as POLICY43_10_0_, this_.TEACHER_OFFICE as TEACHER44_10_0_, this_.NOTICE_TAG as NOTICE45_10_0_, this_.TEACH_STATE as TEACH46_10_0_ from stpsuser.TEACHER_INFO this_ where this_.IDCARD like :1 |
93c5cqqysuvgm | select count(*) as y0_ from NCSS.STU_SEARCHJOB this_ where this_.JOBTYPE=:1 and this_.AREACODE like :2 and this_.SITEID=:3 and postDate > trunc(sysdate , 'dd')-3 and this_.IS_AUDITED=:4 |
9dhn1b8d88dpf |
select OBJOID, CLSOID, RUNTIME, PRI, JOBTYPE, SCHLIM, WT, INST, RUNNOW, ENQ_SCHLIM from ( select a.obj# OBJOID, a.class_oid CLSOID, decode(bitand(a.flags, 16384), 0, a.next_run_date, a.last_enabled_time) RUNTIME, (2*a.priority + decode(bitand(a.job_status, 4), 0, 0, decode(a.running_instance, :1, -1, 1))) PRI, 1 JOBTYPE, decode(a.schedule_limit, NULL, decode(bitand(a.flags, 4194304), 4194304, p.schedule_limit, NULL), a.schedule_limit) SCHLIM, a.job_weight WT, decode(a.running_instance, NULL, 0, a.running_instance) INST, decode(bitand(a.flags, 16384), 0, 0, 1) RUNNOW, decode(bitand(a.job_status, 8388608), 0, 0, 1) ENQ_SCHLIM from sys.scheduler$_job a, sys.scheduler$_program p, v$database v, v$instance i where a.program_oid = p.obj#(+) and bitand(a.job_status, 515) = 1 and bitand(a.flags, 1048576) = 0 and ((bitand(a.flags, 134217728 + 268435456) = 0) or (bitand(a.job_status, 1024) <> 0)) and bitand(a.flags, 4096) = 0 and (a.next_run_date <= :2 or bitand(a.flags, 16384) <> 0) and a.instance_id is null and (a.class_oid is null or (a.class_oid is not null and a.class_oid in (select b.obj# from sys.scheduler$_class b where b.affinity is null))) and (a.database_role = v.database_role or (a.database_role is null and v.database_role = 'PRIMARY')) and ( i.logins = 'ALLOWED' or bitand(a.flags, 17179869184) <> 0 ) union all select l.obj#, l.class_oid, decode(bitand(l.flags, 16384), 0, l.next_run_date, l.last_enabled_time), (2*decode(bitand(l.flags, 8589934592), 0, q.priority, pj.priority) + decode(bitand(l.job_status, 4), 0, 0, decode(l.running_instance, :3, -1, 1))), 1, decode(bitand(l.flags, 8589934592), 0, q.schedule_limit, decode(pj.schedule_limit, NULL, q.schedule_limit, pj.schedule_limit)), decode(bitand(l.flags, 8589934592), 0, q.job_weight, pj.job_weight), decode(l.running_instance, NULL, 0, l.running_instance), decode(bitand(l.flags, 16384), 0, 0, 1), decode(bitand(l.job_status, 8388608), 0, 0, 1) from sys.scheduler$_lightweight_job l, sys.scheduler$_program q, (select sl.obj# obj#, decode(bitand(sl.flags, 8589934592), 0, sl.program_oid, spj.program_oid) program_oid, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.priority) priority, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.job_weight) job_weight, decode(bitand(sl.flags, 8589934592), 0, NULL, spj.schedule_limit) schedule_limit from sys.scheduler$_lightweight_job sl, scheduler$_job spj where sl.program_oid = spj.obj#(+)) pj , v$instance i where pj.obj# = l.obj# and pj.program_oid = q.obj#(+) and (:4 = 0 or l.running_instance = :5) and bitand(l.job_status, 515) = 1 and ((bitand(l.flags, 134217728 + 268435456) = 0) or (bitand(l.job_status, 1024) <> 0)) and bitand(l.flags, 4096) = 0 and (l.next_run_date <= :6 or bitand(l.flags, 16384) <> 0) and l.instance_id is null and (l.class_oid is null or (l.class_oid is not null and l.class_oid in (select w.obj# from sys.scheduler$_class w where w.affinity is null))) and ( i.logins = 'ALLOWED' or bitand(l.flags, 17179869184) <> 0 ) union all select c.obj#, 0, c.next_start_date, 0, 2, c.duration, 1, 0, 0, 0 from sys.scheduler$_window c , v$instance i where bitand(c.flags, 1) <> 0 and bitand(c.flags, 2) = 0 and bitand(c.flags, 64) = 0 and c.next_start_date <= :7 and i.logins = 'ALLOWED' union all select d.obj#, 0, d.next_start_date + d.duration, 0, 4, numtodsinterval(0, 'minute'), 1, 0, 0, 0 from sys.scheduler$_window d , v$instance i where bitand(d.flags, 1) <> 0 and bitand(d.flags, 2) = 0 and bitand(d.flags, 64) = 0 and d.next_start_date <= :8 and i.logins = 'ALLOWED' union all select f.obj#, 0, e.attr_tstamp, 0, decode(bitand(e.flags, 131072), 0, 2, 3), e.attr_intv, 1, 0, 0, 0 from sys.scheduler$_global_attribute e, sys.obj$ f, sys.obj$ g, v$instance i where e.obj# = g.obj# and g.owner# = 0 and g.name
= 'CURRENT_OPEN_WINDOW' and e.value = f.name and f.type# = 69 and e.attr_tstamp is not null and e.attr_intv is not null and i.logins = 'ALLOWED' union all select i.obj#, 0, h.attr_tstamp + h.attr_intv, 0, decode(bitand(h.flags, 131072), 0, 4, 5), numtodsinterval(0, 'minute'), 1, 0, 0, 0 from sys.scheduler$_global_attribute h, sys.obj$ i, sys.obj$ j, v$instance ik where h.obj# = j.obj# and j.owner# = 0 and j.name = 'CURRENT_OPEN_WINDOW' and h.value = i.name and i.type# = 69 and h.attr_tstamp is not null and h.attr_intv is not null and ik.logins = 'ALLOWED') order by RUNTIME, JOBTYPE, CLSOID, PRI, WT DESC, OBJOID |
9dpwkhfwnqfqa | select * from (select JOBID, SITEID, JOBFAIRID, RECID, RECNAME, JOBTITLE, HEADCOUNT, AREACODE, AREA, JOBTYPE, '' AS DESCRIPTION, RECMAIL, CREATEDATE, POSTDATE, ENDDATE, FROMNAME, FROMURL, FROMTYPE, DEGREECODE, "DEGREE", "CATEGORY", CATEGORYNAME, MAJOR, MAJORCODE, NATURE_CODE, INDUSTRY_CODE, REC_SCALE, INDUSTRY, NATURE, IS_AUDITED, ZIPCODE, ADDRESS, WEBSITE, PRIORITY, row_number() over(partition by RECNAME order by PRIORITY desc, POSTDATE desc) rn from STU_SEARCHJOB where IS_AUDITED='1' and SITEID=:1 order by PRIORITY desc, trunc(POSTDATE, 'dd') desc, FROMTYPE asc, POSTDATE desc) where rn=1 and rownum<:2 |
aar221wh7tqqz | update NCSS.REC_JOB set STATUS=:1 , JOBNAME=:2 , JOBCODE=:3 , JOBTYPE=:4 , HEADCOUNT=:5 , JOBAREACODE=:6 , JOBAREANAME=:7 , CATEGORY=:8 , DEGREEREQCODE=:9 , DEGREE=:10 , DESCRIPTION=:11 , RECMAIL=:12 , MODIFYDATE=:13 , CATEGORYNAME=:14 , MODIFYBYID=:15 , MODIFYBYNAME=:16 , DAYLIMIT=:17 , SITE_COUNT=:18 where JOBID=:19 |
b53ms3cpq9mky | select this_.SITE_ID as SITE1_241_0_, this_.SITE_NAME as SITE2_241_0_, this_.SITE_URL as SITE3_241_0_, this_.SITE_TYPE as SITE4_241_0_, this_.PARENT_ID as PARENT5_241_0_, this_.SERVICE_IP as SERVICE6_241_0_, this_.SERVICE_KEY as SERVICE7_241_0_, this_.IS_EFFECTIVE as IS8_241_0_, this_.CREATE_DATE as CREATE9_241_0_, this_.MODIFY_DATE as MODIFY10_241_0_, this_.CONTACT_NAME as CONTACT11_241_0_, this_.TELEPHONE as TELEPHONE241_0_, this_.FEX as FEX241_0_, this_.MOBILEPHONE as MOBILEP14_241_0_, this_.EMAIL as EMAIL241_0_, this_.DESCRIPTION as DESCRIP16_241_0_, this_.IS_ALLOW as IS17_241_0_, this_.TAGS as TAGS241_0_, this_.AREA_CODE as AREA19_241_0_, this_.AREA_NAME as AREA20_241_0_, this_.HAVE_THEME as HAVE21_241_0_, this_.PARENT_NAME as PARENT22_241_0_, this_.JOB_NEED_AUDIT as JOB23_241_0_, this_.WEB_NAME as WEB24_241_0_, this_.WEB_URL as WEB25_241_0_ from NCSS.PUB_SITE this_ where this_.SITE_URL like :1 and this_.IS_EFFECTIVE=:2 |
btn84j9rhuf4h | select * from ( select row_.*, rownum rownum_ from ( select trunc(POSTDATE, 'dd') AS days, this_.JOBID as y1_, this_.SITEID as y2_, this_.HEADCOUNT as y3_, this_.RECMAIL as y4_, this_.POSTDATE as y5_, this_.PRIORITY as y6_, this_.INDUSTRY as y7_, this_.INDUSTRY_CODE as y8_, this_.JOBTITLE as y9_, this_.AREA as y10_, this_.DEGREE as y11_, this_.FROMTYPE as y12_, this_.RECID as y13_, this_.RECNAME as y14_, this_.NATURE as y15_, this_.REC_SCALE as y16_, this_.JOBTYPE as y17_, this_.AREACODE as y18_, this_.CREATEDATE as y19_, this_.ENDDATE as y20_, this_.DEGREECODE as y21_, this_.CATEGORY as y22_, this_.CATEGORYNAME as y23_, this_.MAJORCODE as y24_, this_.MAJOR as y25_, this_.ZIPCODE as y26_, this_.WEBSITE as y27_, this_.ADDRESS as y28_, this_.FROMNAME as y29_, this_.FROMURL as y30_, this_.IS_AUDITED as y31_, this_.JOBFAIRID as y32_, this_.VIEW_COUNT as y33_ from NCSS.STU_SEARCHJOB this_ where this_.jobType = :1 and this_.siteId = :2 and this_.IS_AUDITED = :3 order by y6_ desc, days desc, y12_ asc, y5_ desc ) row_ ) where rownum_ <= :4 and rownum_ > :5 |
btyq1q2d6hd92 | insert into STU_RESUMEITEM (studentId, language, ITEMLABEL, ITEMCONTENT, ITEMID) values (:1 , :2 , :3 , :4 , :5 ) |
ca76md7xwcbmc | select this_.ID as ID176_0_, this_.WORD as WORD176_0_ from NCSS.REC_BLACKDICT this_ |
cm5vu20fhtnq1 | select /*+ connect_by_filtering */ privilege#, level from sysauth$ connect by grantee#=prior privilege# and privilege#>0 start with grantee#=:1 and privilege#>0 |
cp9wdanzmzj4q | select * from (select JOBID, SITEID, JOBFAIRID, RECID, RECNAME, JOBTITLE, HEADCOUNT, AREACODE, AREA, JOBTYPE, '' AS DESCRIPTION, RECMAIL, CREATEDATE, POSTDATE, ENDDATE, FROMNAME, FROMURL, FROMTYPE, DEGREECODE, "DEGREE", "CATEGORY", CATEGORYNAME, MAJOR, MAJORCODE, NATURE_CODE, INDUSTRY_CODE, REC_SCALE, INDUSTRY, NATURE, IS_AUDITED, ZIPCODE, ADDRESS, WEBSITE, PRIORITY, row_number() over(partition by RECNAME order by PRIORITY desc, POSTDATE desc) rn from STU_SEARCHJOB where IS_AUDITED='1' and SITEID=:1 and JOBTYPE=:2 order by PRIORITY desc, trunc(POSTDATE, 'dd') desc, FROMTYPE asc, POSTDATE desc) where rn=1 and rownum<:3 |
d1515xp5t2xtw | select * from (select JOBID, SITEID, JOBFAIRID, RECID, RECNAME, JOBTITLE, HEADCOUNT, AREACODE, AREA, JOBTYPE, '' AS DESCRIPTION, RECMAIL, CREATEDATE, POSTDATE, ENDDATE, FROMNAME, FROMURL, FROMTYPE, DEGREECODE, "DEGREE", "CATEGORY", CATEGORYNAME, MAJOR, MAJORCODE, NATURE_CODE, INDUSTRY_CODE, REC_SCALE, INDUSTRY, NATURE, IS_AUDITED, ZIPCODE, ADDRESS, WEBSITE, PRIORITY, row_number() over(partition by RECNAME order by PRIORITY desc, POSTDATE desc) rn from STU_SEARCHJOB where IS_AUDITED='1' and SITEID=:1 and JOBTYPE=:2 and postDate > sysdate-:3 order by PRIORITY desc, trunc(POSTDATE, 'dd') desc, FROMTYPE asc, POSTDATE desc) where rn=1 and rownum<:4 |
djkdcyhxzmzv1 | insert into NCSS.STU_SEARCHJOB (RECID, RECNAME, JOBTITLE, HEADCOUNT, AREACODE, AREA, JOBTYPE, DESCRIPTION, RECMAIL, CREATEDATE, POSTDATE, ENDDATE, FROMNAME, FROMURL, FROMTYPE, DEGREECODE, DEGREE, CATEGORY, CATEGORYNAME, MAJOR, MAJORCODE, NATURE_CODE, NATURE, INDUSTRY_CODE, INDUSTRY, REC_SCALE, IS_AUDITED, WEBSITE, ZIPCODE, ADDRESS, PRIORITY, VIEW_COUNT, HAVA_BLACKWORD, JOBID, SITEID, JOBFAIRID) values (:1 , :2 , :3 , :4 , :5 , :6 , :7 , :8 , :9 , :10 , :11 , :12 , :13 , :14 , :15 , :16 , :17 , :18 , :19 , :20 , :21 , :22 , :23 , :24 , :25 , :26 , :27 , :28 , :29 , :30 , :31 , :32 , :33 , :34 , :35 , :36 ) |
dzr6gkrqft36c | select count(*) as y0_ from NCSS.STU_SEARCHJOB this_ where this_.JOBTYPE=:1 and this_.AREACODE like :2 and this_.SITEID=:3 and this_.IS_AUDITED=:4 |
f711myt0q6cma | insert into sys.aud$( sessionid, entryid, statement, ntimestamp#, userid, userhost, terminal, action#, returncode, logoff$lread, logoff$pread, logoff$lwrite, logoff$dead, logoff$time, comment$text, spare1, clientid, sessioncpu, proxy$sid, user$guid, instance#, process#, auditid, dbid) values(:1, :2, :3, SYS_EXTRACT_UTC(SYSTIMESTAMP), :4, :5, :6, :7, :8, :9, :10, :11, :12, cast(SYS_EXTRACT_UTC(systimestamp) as date), :13, :14, :15, :16, :17, :18, :19, :20, :21, :22) |
fqjyuzjgm89qv | select * from ( select trunc(POSTDATE, 'dd') AS days, this_.JOBID as y1_, this_.SITEID as y2_, this_.HEADCOUNT as y3_, this_.RECMAIL as y4_, this_.POSTDATE as y5_, this_.PRIORITY as y6_, this_.INDUSTRY as y7_, this_.INDUSTRY_CODE as y8_, this_.JOBTITLE as y9_, this_.AREA as y10_, this_.DEGREE as y11_, this_.FROMTYPE as y12_, this_.RECID as y13_, this_.RECNAME as y14_, this_.NATURE as y15_, this_.REC_SCALE as y16_, this_.JOBTYPE as y17_, this_.AREACODE as y18_, this_.CREATEDATE as y19_, this_.ENDDATE as y20_, this_.DEGREECODE as y21_, this_.CATEGORY as y22_, this_.CATEGORYNAME as y23_, this_.MAJORCODE as y24_, this_.MAJOR as y25_, this_.ZIPCODE as y26_, this_.WEBSITE as y27_, this_.ADDRESS as y28_, this_.FROMNAME as y29_, this_.FROMURL as y30_, this_.IS_AUDITED as y31_, this_.JOBFAIRID as y32_, this_.VIEW_COUNT as y33_ from NCSS.STU_SEARCHJOB this_ where this_.jobType = :1 and this_.siteId = :2 and this_.IS_AUDITED = :3 order by y6_ desc, days desc, y12_ asc, y5_ desc ) where rownum <= :4 |
fx40qmjn4x0bg | select this_.SITE_ID as SITE1_72_0_, this_.SITE_NAME as SITE2_72_0_, this_.SITE_URL as SITE3_72_0_, this_.SITE_TYPE as SITE4_72_0_, this_.PARENT_ID as PARENT5_72_0_, this_.SERVICE_IP as SERVICE6_72_0_, this_.SERVICE_KEY as SERVICE7_72_0_, this_.IS_EFFECTIVE as IS8_72_0_, this_.CREATE_DATE as CREATE9_72_0_, this_.MODIFY_DATE as MODIFY10_72_0_, this_.CONTACT_NAME as CONTACT11_72_0_, this_.TELEPHONE as TELEPHONE72_0_, this_.FEX as FEX72_0_, this_.MOBILEPHONE as MOBILEP14_72_0_, this_.EMAIL as EMAIL72_0_, this_.DESCRIPTION as DESCRIP16_72_0_, this_.IS_ALLOW as IS17_72_0_, this_.TAGS as TAGS72_0_, this_.AREA_CODE as AREA19_72_0_, this_.AREA_NAME as AREA20_72_0_, this_.HAVE_THEME as HAVE21_72_0_, this_.PARENT_NAME as PARENT22_72_0_, this_.JOB_NEED_AUDIT as JOB23_72_0_, this_.WEB_NAME as WEB24_72_0_, this_.WEB_URL as WEB25_72_0_ from NCSS.PUB_SITE this_ where this_.SITE_URL like :1 and this_.IS_EFFECTIVE=:2 |
gb9fpmh2fzxbn | INSERT INTO ONLINE_USER VALUES(:B3 , :B2 , SYSDATE, '', :B1 , '') |
Statistic | Total | per Second | per Trans |
Batched IO (bound) vector count | 0 | 0.00 | 0.00 |
Batched IO (full) vector count | 0 | 0.00 | 0.00 |
Batched IO block miss count | 0 | 0.00 | 0.00 |
Batched IO buffer defrag count | 0 | 0.00 | 0.00 |
Batched IO double miss count | 0 | 0.00 | 0.00 |
Batched IO same unit count | 0 | 0.00 | 0.00 |
Batched IO single block count | 0 | 0.00 | 0.00 |
Batched IO slow jump count | 0 | 0.00 | 0.00 |
Batched IO vector block count | 0 | 0.00 | 0.00 |
Batched IO vector read count | 0 | 0.00 | 0.00 |
Block Cleanout Optim referenced | 269 | 0.07 | 0.02 |
CCursor + sql area evicted | 38 | 0.01 | 0.00 |
CPU used by this session | 2,235,102 | 619.95 | 128.06 |
CPU used when call started | 2,234,650 | 619.83 | 128.04 |
CR blocks created | 19,476 | 5.40 | 1.12 |
Cached Commit SCN referenced | 2,409 | 0.67 | 0.14 |
Commit SCN cached | 340 | 0.09 | 0.02 |
DB time | 5,661,336 | 1,570.30 | 324.38 |
DBWR checkpoint buffers written | 70,450 | 19.54 | 4.04 |
DBWR checkpoints | 1 | 0.00 | 0.00 |
DBWR object drop buffers written | 0 | 0.00 | 0.00 |
DBWR revisited being-written buffer | 0 | 0.00 | 0.00 |
DBWR tablespace checkpoint buffers written | 0 | 0.00 | 0.00 |
DBWR thread checkpoint buffers written | 0 | 0.00 | 0.00 |
DBWR transaction table writes | 127 | 0.04 | 0.01 |
DBWR undo block writes | 7,805 | 2.16 | 0.45 |
DFO trees parallelized | 0 | 0.00 | 0.00 |
Effective IO time | 18,987,313 | 5,266.55 | 1,087.91 |
HSC Heap Segment Block Changes | 72,934 | 20.23 | 4.18 |
HSC IDL Compressed Blocks | 0 | 0.00 | 0.00 |
Heap Segment Array Inserts | 141 | 0.04 | 0.01 |
LOB table id lookup cache misses | 0 | 0.00 | 0.00 |
Misses for writing mapping | 0 | 0.00 | 0.00 |
Number of read IOs issued | 12,937 | 3.59 | 0.74 |
OS Integral shared text size | 0 | 0.00 | 0.00 |
OS Integral unshared data size | 0 | 0.00 | 0.00 |
OS Involuntary context switches | 0 | 0.00 | 0.00 |
OS Maximum resident set size | 0 | 0.00 | 0.00 |
OS Page reclaims | 0 | 0.00 | 0.00 |
OS Signals received | 0 | 0.00 | 0.00 |
OS System time used | 0 | 0.00 | 0.00 |
OS User time used | 0 | 0.00 | 0.00 |
OS Voluntary context switches | 0 | 0.00 | 0.00 |
PX local messages recv'd | 0 | 0.00 | 0.00 |
PX local messages sent | 0 | 0.00 | 0.00 |
Parallel operations not downgraded | 0 | 0.00 | 0.00 |
Requests to/from client | 2,501,419 | 693.82 | 143.32 |
RowCR - row contention | 2 | 0.00 | 0.00 |
RowCR attempts | 644 | 0.18 | 0.04 |
RowCR hits | 643 | 0.18 | 0.04 |
SMON posted for dropping temp segment | 0 | 0.00 | 0.00 |
SMON posted for undo segment recovery | 0 | 0.00 | 0.00 |
SMON posted for undo segment shrink | 0 | 0.00 | 0.00 |
SQL*Net roundtrips to/from client | 2,501,398 | 693.82 | 143.32 |
TBS Extension: bytes extended | 0 | 0.00 | 0.00 |
TBS Extension: files extended | 0 | 0.00 | 0.00 |
TBS Extension: tasks created | 0 | 0.00 | 0.00 |
TBS Extension: tasks executed | 0 | 0.00 | 0.00 |
active txn count during cleanout | 17,275 | 4.79 | 0.99 |
application wait time | 507 | 0.14 | 0.03 |
auto extends on undo tablespace | 0 | 0.00 | 0.00 |
background checkpoints completed | 1 | 0.00 | 0.00 |
background checkpoints started | 1 | 0.00 | 0.00 |
background timeouts | 23,693 | 6.57 | 1.36 |
branch node splits | 0 | 0.00 | 0.00 |
buffer is not pinned count | 541,403,096 | 150,170.04 | 31,020.63 |
buffer is pinned count | 501,187,020 | 139,015.23 | 28,716.38 |
bytes received via SQL*Net from client | 725,758,884 | 201,305.17 | 41,583.62 |
bytes sent via SQL*Net to client | 2,594,021,636 | 719,508.88 | 148,628.98 |
calls to get snapshot scn: kcmgss | 917,477 | 254.48 | 52.57 |
calls to kcmgas | 77,261 | 21.43 | 4.43 |
calls to kcmgcs | 3,436,905 | 953.30 | 196.92 |
cell physical IO interconnect bytes | 3,626,024,960 | 1,005,757.68 | 207,759.41 |
change write time | 2,040 | 0.57 | 0.12 |
cleanout - number of ktugct calls | 17,331 | 4.81 | 0.99 |
cleanouts and rollbacks - consistent read gets | 11,446 | 3.17 | 0.66 |
cleanouts only - consistent read gets | 135 | 0.04 | 0.01 |
cluster key scan block gets | 17,891 | 4.96 | 1.03 |
cluster key scans | 14,893 | 4.13 | 0.85 |
commit batch performed | 0 | 0.00 | 0.00 |
commit batch requested | 0 | 0.00 | 0.00 |
commit batch/immediate performed | 65 | 0.02 | 0.00 |
commit batch/immediate requested | 65 | 0.02 | 0.00 |
commit cleanout failures: block lost | 0 | 0.00 | 0.00 |
commit cleanout failures: buffer being written | 0 | 0.00 | 0.00 |
commit cleanout failures: callback failure | 89 | 0.02 | 0.01 |
commit cleanout failures: cannot pin | 362 | 0.10 | 0.02 |
commit cleanouts | 127,490 | 35.36 | 7.30 |
commit cleanouts successfully completed | 127,039 | 35.24 | 7.28 |
commit immediate performed | 65 | 0.02 | 0.00 |
commit immediate requested | 65 | 0.02 | 0.00 |
commit txn count during cleanout | 2,730 | 0.76 | 0.16 |
concurrency wait time | 2,735 | 0.76 | 0.16 |
consistent changes | 23,460 | 6.51 | 1.34 |
consistent gets | 2,387,073,254 | 662,107.20 | 136,771.52 |
consistent gets - examination | 7,600,159 | 2,108.07 | 435.46 |
consistent gets direct | 13,508 | 3.75 | 0.77 |
consistent gets from cache | 2,387,059,758 | 662,103.46 | 136,770.74 |
consistent gets from cache (fastpath) | 2,225,869,528 | 617,393.81 | 127,535.07 |
cursor authentications | 1,532 | 0.42 | 0.09 |
data blocks consistent reads - undo records applied | 23,344 | 6.47 | 1.34 |
db block changes | 684,553 | 189.88 | 39.22 |
db block gets | 995,204 | 276.04 | 57.02 |
db block gets direct | 1,186 | 0.33 | 0.07 |
db block gets from cache | 994,018 | 275.71 | 56.95 |
db block gets from cache (fastpath) | 221,443 | 61.42 | 12.69 |
deferred (CURRENT) block cleanout applications | 40,676 | 11.28 | 2.33 |
dirty buffers inspected | 1 | 0.00 | 0.00 |
enqueue conversions | 727 | 0.20 | 0.04 |
enqueue deadlocks | 0 | 0.00 | 0.00 |
enqueue releases | 156,126 | 43.30 | 8.95 |
enqueue requests | 156,125 | 43.30 | 8.95 |
enqueue timeouts | 0 | 0.00 | 0.00 |
enqueue waits | 30 | 0.01 | 0.00 |
exchange deadlocks | 0 | 0.00 | 0.00 |
execute count | 774,865 | 214.93 | 44.40 |
failed probes on index block reclamation | 2 | 0.00 | 0.00 |
file io service time | 0 | 0.00 | 0.00 |
file io wait time | 53,802,125 | 14,923.20 | 3,082.69 |
flashback cache read optimizations for block new | 113 | 0.03 | 0.01 |
flashback direct read optimizations for block new | 0 | 0.00 | 0.00 |
flashback log write bytes | 499,875,840 | 138,651.55 | 28,641.26 |
flashback log writes | 2,163 | 0.60 | 0.12 |
free buffer inspected | 8,323 | 2.31 | 0.48 |
free buffer requested | 34,977 | 9.70 | 2.00 |
global undo segment hints helped | 0 | 0.00 | 0.00 |
heap block compress | 6,880 | 1.91 | 0.39 |
hot buffers moved to head of LRU | 14,981 | 4.16 | 0.86 |
immediate (CR) block cleanout applications | 11,581 | 3.21 | 0.66 |
immediate (CURRENT) block cleanout applications | 16,178 | 4.49 | 0.93 |
in call idle wait time | 12,933,065 | 3,587.27 | 741.02 |
index crx upgrade (positioned) | 4,005 | 1.11 | 0.23 |
index crx upgrade (prefetch) | 0 | 0.00 | 0.00 |
index fast full scans (full) | 374 | 0.10 | 0.02 |
index fetch by key | 5,774,404 | 1,601.66 | 330.85 |
index scans kdiixs1 | 557,987 | 154.77 | 31.97 |
leaf node 90-10 splits | 72 | 0.02 | 0.00 |
leaf node splits | 258 | 0.07 | 0.01 |
lob reads | 54,592 | 15.14 | 3.13 |
lob writes | 11,784 | 3.27 | 0.68 |
lob writes unaligned | 9,738 | 2.70 | 0.56 |
logical read bytes from cache | 19,562,936,696,832 | 5,426,210,235.42 | 1,120,892,493.95 |
logons cumulative | 4,443 | 1.23 | 0.25 |
max cf enq hold time | 2 | 0.00 | 0.00 |
messages received | 79,289 | 21.99 | 4.54 |
messages sent | 79,289 | 21.99 | 4.54 |
min active SCN optimization applied on CR | 56 | 0.02 | 0.00 |
no buffer to keep pinned count | 70 | 0.02 | 0.00 |
no work - consistent read gets | 2,376,273,695 | 659,111.71 | 136,152.74 |
non-idle wait count | 2,757,198 | 764.77 | 157.98 |
non-idle wait time | 74,575 | 20.69 | 4.27 |
opened cursors cumulative | 794,277 | 220.31 | 45.51 |
parse count (describe) | 0 | 0.00 | 0.00 |
parse count (failures) | 0 | 0.00 | 0.00 |
parse count (hard) | 12,371 | 3.43 | 0.71 |
parse count (total) | 76,138 | 21.12 | 4.36 |
parse time cpu | 3,543 | 0.98 | 0.20 |
parse time elapsed | 10,012 | 2.78 | 0.57 |
physical read IO requests | 25,012 | 6.94 | 1.43 |
physical read bytes | 207,724,544 | 57,616.97 | 11,901.94 |
physical read total IO requests | 34,524 | 9.58 | 1.98 |
physical read total bytes | 803,490,304 | 222,865.69 | 46,037.37 |
physical read total multi block requests | 438 | 0.12 | 0.03 |
physical reads | 25,357 | 7.03 | 1.45 |
physical reads cache | 10,643 | 2.95 | 0.61 |
physical reads cache prefetch | 1 | 0.00 | 0.00 |
physical reads direct | 14,714 | 4.08 | 0.84 |
physical reads direct (lob) | 14,070 | 3.90 | 0.81 |
physical reads direct temporary tablespace | 0 | 0.00 | 0.00 |
physical reads for flashback new | 6,728 | 1.87 | 0.39 |
physical reads prefetch warmup | 0 | 0.00 | 0.00 |
physical write IO requests | 50,895 | 14.12 | 2.92 |
physical write bytes | 587,243,520 | 162,884.89 | 33,647.14 |
physical write total IO requests | 153,111 | 42.47 | 8.77 |
physical write total bytes | 2,822,534,656 | 782,891.99 | 161,722.03 |
physical write total multi block requests | 2,853 | 0.79 | 0.16 |
physical writes | 71,685 | 19.88 | 4.11 |
physical writes direct | 1,233 | 0.34 | 0.07 |
physical writes direct (lob) | 981 | 0.27 | 0.06 |
physical writes direct temporary tablespace | 0 | 0.00 | 0.00 |
physical writes from cache | 70,452 | 19.54 | 4.04 |
physical writes non checkpoint | 11,420 | 3.17 | 0.65 |
pinned buffers inspected | 0 | 0.00 | 0.00 |
pinned cursors current | 194 | 0.05 | 0.01 |
prefetch clients - default | 0 | 0.00 | 0.00 |
prefetch clients - keep | 0 | 0.00 | 0.00 |
prefetch warmup blocks aged out before use | 0 | 0.00 | 0.00 |
prefetch warmup blocks flushed out before use | 0 | 0.00 | 0.00 |
prefetched blocks aged out before use | 1 | 0.00 | 0.00 |
process last non-idle time | 3,601 | 1.00 | 0.21 |
queries parallelized | 0 | 0.00 | 0.00 |
recursive aborts on index block reclamation | 0 | 0.00 | 0.00 |
recursive calls | 1,379,841 | 382.73 | 79.06 |
recursive cpu usage | 3,974 | 1.10 | 0.23 |
redo KB read | 435,690 | 120.85 | 24.96 |
redo blocks checksummed by FG (exclusive) | 168,735 | 46.80 | 9.67 |
redo blocks written | 418,102 | 115.97 | 23.96 |
redo buffer allocation retries | 1 | 0.00 | 0.00 |
redo entries | 452,789 | 125.59 | 25.94 |
redo log space requests | 1 | 0.00 | 0.00 |
redo log space wait time | 5 | 0.00 | 0.00 |
redo ordering marks | 11,255 | 3.12 | 0.64 |
redo size | 199,341,856 | 55,291.84 | 11,421.64 |
redo size for direct writes | 9,768,836 | 2,709.60 | 559.72 |
redo subscn max counts | 16,563 | 4.59 | 0.95 |
redo synch long waits | 509 | 0.14 | 0.03 |
redo synch poll writes | 0 | 0.00 | 0.00 |
redo synch polls | 0 | 0.00 | 0.00 |
redo synch time | 31,027 | 8.61 | 1.78 |
redo synch time (usec) | 310,470,247 | 86,115.74 | 17,788.93 |
redo synch writes | 25,378 | 7.04 | 1.45 |
redo wastage | 7,871,588 | 2,183.36 | 451.02 |
redo write time | 29,081 | 8.07 | 1.67 |
redo writes | 28,127 | 7.80 | 1.61 |
rollback changes - undo records applied | 184 | 0.05 | 0.01 |
rollbacks only - consistent read gets | 7,360 | 2.04 | 0.42 |
root node splits | 0 | 0.00 | 0.00 |
rows fetched via callback | 1,730,696 | 480.05 | 99.16 |
scheduler wait time | 0 | 0.00 | 0.00 |
session connect time | 0 | 0.00 | 0.00 |
session cursor cache hits | 650,986 | 180.57 | 37.30 |
session logical reads | 2,388,068,143 | 662,383.16 | 136,828.52 |
shared hash latch upgrades - no wait | 28,903 | 8.02 | 1.66 |
shared hash latch upgrades - wait | 111 | 0.03 | 0.01 |
sorts (disk) | 0 | 0.00 | 0.00 |
sorts (memory) | 478,469 | 132.71 | 27.41 |
sorts (rows) | 4,962,872,241 | 1,376,561.64 | 284,356.40 |
sql area evicted | 13,053 | 3.62 | 0.75 |
sql area purged | 1 | 0.00 | 0.00 |
summed dirty queue length | 1 | 0.00 | 0.00 |
switch current to new buffer | 4,741 | 1.32 | 0.27 |
table fetch by rowid | 500,228,316 | 138,749.31 | 28,661.45 |
table fetch continued row | 7,733,143 | 2,144.96 | 443.08 |
table scan blocks gotten | 1,851,177,574 | 513,464.77 | 106,066.44 |
table scan rows gotten | 9,365,913,121 | 2,597,841.75 | 536,636.29 |
table scans (direct read) | 0 | 0.00 | 0.00 |
table scans (long tables) | 0 | 0.00 | 0.00 |
table scans (rowid ranges) | 0 | 0.00 | 0.00 |
table scans (short tables) | 183,315 | 50.85 | 10.50 |
temp space allocated (bytes) | 0 | 0.00 | 0.00 |
total cf enq hold time | 11,921 | 3.31 | 0.68 |
total number of cf enq holders | 583 | 0.16 | 0.03 |
total number of times SMON posted | 9 | 0.00 | 0.00 |
transaction rollbacks | 63 | 0.02 | 0.00 |
transaction tables consistent read rollbacks | 0 | 0.00 | 0.00 |
transaction tables consistent reads - undo records applied | 0 | 0.00 | 0.00 |
undo change vector size | 53,459,388 | 14,828.14 | 3,063.05 |
user I/O wait time | 4,788 | 1.33 | 0.27 |
user calls | 3,185,123 | 883.46 | 182.50 |
user commits | 17,448 | 4.84 | 1.00 |
user rollbacks | 5 | 0.00 | 0.00 |
workarea executions - multipass | 0 | 0.00 | 0.00 |
workarea executions - onepass | 0 | 0.00 | 0.00 |
workarea executions - optimal | 630,545 | 174.90 | 36.13 |
write clones created in background | 0 | 0.00 | 0.00 |
write clones created in foreground | 0 | 0.00 | 0.00 |