ADSM-L

Size of TDP for ORACLE objects

2000-05-19 13:10:49
Subject: Size of TDP for ORACLE objects
From: Thiha Than <Thiha_Than AT TIVOLI DOT COM>
Date: Fri, 19 May 2000 10:10:49 -0700
hi Thomas,

you can use select command from the server:

> select * from contents where node_name='CapitalizedNodeName' AND
filespace_name='/fsnameAsItIs'

It will take a while before it comes back.

regards,
Thiha

>I back up our ORACLE databases on AIX with the TDP for >ORACLE 2.1.9b.
>DSMO_AVG is set to 200 MB.
>When I do a
>  DSMC QUERY BACKUP "/adsmorc/*" -SUBDIR=YES >-VIRTUALN=RS53_ORA
>all objects are listed with a size of 209715 KB.

>Does anyone know how I can get the real size of this objects?

>Kind regards
>Thomas Rupp
>Vorarlberger Illwerke AG
>MAIL:   thomas.rupp AT illwerke DOT at
>TEL:    ++43/5574/4991-251
>FAX:    ++43/5574/4991-820-8251
<Prev in Thread] Current Thread [Next in Thread>