SELECT c.owner
,c.object
,(SUM(a.blocks)) * 8 / 1024 / 1024 "G"
FROM gv$tempseg_usage a
,gv$session b
,gv$access c
WHERE a.session_addr = b.saddr
AND b.sid = c.sid
AND b.username = c.owner
AND b.inst_id=c.inst_id
GROUP BY c.owner
,c.object;
,c.object
,(SUM(a.blocks)) * 8 / 1024 / 1024 "G"
FROM gv$tempseg_usage a
,gv$session b
,gv$access c
WHERE a.session_addr = b.saddr
AND b.sid = c.sid
AND b.username = c.owner
AND b.inst_id=c.inst_id
GROUP BY c.owner
,c.object;
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/21993926/viewspace-670380/ ，如需转载，请注明出处，否则将追究法律责任。
下一篇：
nvl nvl nullif
请登录后发表评论
登录
全部评论
最新文章
- PARALLEL_EXECUTION_MESSAGE_SIZE
- some suggestions for rac performance
- ORA-01931: cannot grant UNLIMITED TABLESPACE to a role on 10g
- RMAN-06094 Datafile does not exist
- MRP0: Background Media Recovery terminated with error 1274
- set up a standby quickly by duplicate.
- how to mount diskgroup automatically
- alias doesn't work on solaris
- ORA-00600 [Kfgfinalize_2] While Mounting Diskgroups In Rac [ID 418063.1]
- rac installation on Solaris10 x86-64
