Query para db_cache_size

[jspaulonciParticipante]

Query que retorna as sessões top no uso de cache

SQL> SELECT *
2 FROM (SELECT SQL_FULLTEXT, BUFFER_GETS
3 FROM V$SQL
4 ORDER BY BUFFER_GETS DESC)
5 WHERE ROWNUM sysdate) and (next_date < (sysd 50073
select /+ index(idl_ub1$ i_idl_ub11) +/ piece#,length,piece from idl_ub1$ wher 49340
call DECA.CNPJ_SINCRONISMO_MAINFRAME.EXECUTA() 41048
SELECT T1.ID_MAIN_SCR, T1.ID_SOLICITACAO,T1.ID_ESTABELECIMENTO, T1.ID_CONTRIBUIN 40499
select job, nvl2(last_date, 1, 0) from sys.job$ where next_date <= :1 and (field 38023
select u1.user#, u2.user#, u3.user#, failures, flag, interval#, what, nlsenv, 36973
UPDATE tb_dspj_incompatib_solicitacao SET dt_incompatibilidade = sysdate WHERE d 36925
select obj#,type#,ctime,mtime,stime,status,dataobj#,flags,oid$, spare1, spare2 f 36856
select order#,columns,types from access$ where d_obj#=:1 36536
select /+ index(idl_ub2$ i_idl_ub21) +/ piece#,length,piece from idl_ub2$ wher 34709
select /+ index(idl_sb4$ i_idl_sb41) +/ piece#,length,piece from idl_sb4$ wher 34616
select con#,type#,condlength,intcols,robj#,rcon#,match#,refact,nvl(enabled,0),ro 32969
select o.owner#,o.name,o.namespace,o.remoteowner,o.linkname,o.subname,o.dataobj# 32795
select o.owner#,o.name,o.namespace,o.remoteowner,o.linkname,o.subname,o.dataobj# 28977
delete from smon_scn_time where thread=0 and scn = (select min(scn) from smon_s 28062
select name,intcol#,segcol#,type#,length,nvl(precision#,0),decode(type#,2,nvl(sc 23753
select /+ rule */ bucket, endpoint, col#, epvalue from histgrm$ where obj#=:1 a 22930
select type#,blocks,extents,minexts,maxexts,extsize,extpct,user#,iniexts,NVL(lis 22443
select value$ from props$ where name = 'GLOBAL_DB_NAME' 21046
select metadata from kopm$ where name='DB_FDO' 20964
select job, nvl2(last_date, 1, 0) from sys.job$ where (((:1 <= next_date) and (n 20761
select position#,sequence#,level#,argument,type#,charsetid,charsetform,propertie 19064
select /+ rule / bucket_cnt, row_cnt, cache_cnt, null_cnt, timestamp#, sample_ 18932
select t.ts#,t.file#,t.block#,nvl(t.bobj#,0),nvl(t.tab#,0),t.intcols,nvl(t.cluco 18831
select grantee#,privilege#,nvl(col#,0),max(mod(nvl(option$,0),2))from objauth$ w 16664
select grantee#,privilege#,nvl(col#,0),max(mod(nvl(option$,0),2))from objauth$ w 16275
select /+ index(idl_char$ i_idl_char1) +*/ piece#,length,piece from idl_char$ w 15022
select col#, grantee#, privilege#,max(mod(nvl(option$,0),2)) from objauth$ where 13831
select con#,obj#,rcon#,enabled,nvl(defer,0) from cdef$ where robj#=:1 13737
select col#, grantee#, privilege#,max(mod(nvl(option$,0),2)) from objauth$ where 13488
update seq$ set increment$=:2,minvalue=:3,maxvalue=:4,cycle#=:5,order$=:6,cache= 9549
select local_tran_id, global_tran_fmt, global_oracle_id, global_foreign_id, 9482
insert into WRI$_ALERT_OUTSTANDING (reason_id, object_id, subobject_id, internal 8955
select o.name, u.name from obj$ o, user$ u where o.obj# = :1 and o.owner# = u.u 7944
select privilege#,level from sysauth$ connect by grantee#=prior privilege# and p 7502

50 rows selected