User Tools

Site Tools


tsm:tsm_select

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
tsm:tsm_select [2023/11/13 09:10]
manu
tsm:tsm_select [2023/11/13 09:14] (current)
manu
Line 569: Line 569:
 cont> count( bk.bfsize ) as number_of_objects FROM  backups b, backup_objects bk WHERE b.object_id=bk.objid and b.class_name='​MC_ORA'​ GROUP BY b.node_name,​ b.filespace_name,​ b.class_name cont> count( bk.bfsize ) as number_of_objects FROM  backups b, backup_objects bk WHERE b.object_id=bk.objid and b.class_name='​MC_ORA'​ GROUP BY b.node_name,​ b.filespace_name,​ b.class_name
  
 +NODE_NAME ​     FILESPACE_NAME ​    ​CLASS_NAME ​         SIZE_GB ​            ​NUMBER_OF_OBJECTS
 +------------- ​ -------------- ​    ​----------------- ​  ​----------------- ​  ​-------------------
 +APP-ORA01 ​     /​tsmorc ​           MC_ORA ​             158.1               12600
 +APP-ORA02 ​     /​tsmorc ​           MC_ORA ​             208.1               12800
 </​cli>​ </​cli>​
tsm/tsm_select.1699863009.txt.gz · Last modified: 2023/11/13 09:10 by manu