This shows you the differences between two versions of the page.
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> |