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> | ||