Microsoft Windows [版本 6.1.7601]
版权所有 (c) 2009 Microsoft Corporation。保留所有权利。
C:\Users\e>sqlplus
SQL*Plus: Release 10.2.0.3.0 - Production on 星期三 8月 8 09:52:46 2012
Copyright (c) 1982, 2006, Oracle. All Rights Reserved.
请输入用户名: sys as sysdba
输入口令:
连接到:
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Production
With the Partitioning, OLAP and Data Mining options
SQL> select snap_id,undoblks from wrh$_undostat
2 where snap_id <= 118 order by snap_id;
SNAP_ID UNDOBLKS
---------- ----------
114 433
114 15
114 14
114 12
114 61
115 15
115 13
115 13
115 15
115 91
115 11
SNAP_ID UNDOBLKS
---------- ----------
116 15
116 13
116 16
116 12
116 71
117 18
118 17
118 71
118 10
118 15
118 15
SNAP_ID UNDOBLKS
---------- ----------
118 9
已选择23行。
SQL> select snap_id,WMSYS.WM_CONCAT(undoblks)
2 from wrh$_undostat where snap_id <= 118
3 group by snap_id;
SNAP_ID
----------
WMSYS.WM_CONCAT(UNDOBLKS)
--------------------------------------------------------------------------------
114
61,433,14,15,12
115
91,15,13,15,11,13
116
71,13,15,12,16
SNAP_ID
----------
WMSYS.WM_CONCAT(UNDOBLKS)
--------------------------------------------------------------------------------
117
18
118
71,17,15,15,9,10
SQL> col WMSYS.WM_CONCAT(UNDOBLKS) for a30;
SQL> select snap_id,WMSYS.WM_CONCAT(undoblks)
2 from wrh$_undostat where snap_id <= 118
3 group by snap_id;
SNAP_ID WMSYS.WM_CONCAT(UNDOBLKS)
---------- ------------------------------
114 61,433,14,15,12
115 91,15,13,15,11,13
116 71,13,15,12,16
117 18
118 71,17,15,15,9,10
SQL> select version from v$instance;
VERSION
-----------------
10.2.0.3.0
SQL>
WMSYS.WM_CONCAT函数
最新推荐文章于 2021-01-30 14:56:00 发布