[Search for users] [Overall Top Noters] [List of all Conferences] [Download this site]

Conference orarep::nomahs::repository

Title:Oracle CDD/Repositorynce
Notice:Current versions are V7.0-01 and V6.1-03eld Test 3
Moderator:8292::PJACOBN
Created:Thu Jan 21 1993
Last Modified:Fri Jun 06 1997
Last Successful Update:Fri Jun 06 1997
Number of topics:1094
Total number of notes:4913

1074.0. "How to shrink CDD$DATABASE?" by M5::GHODSON () Mon Mar 24 1997 18:20

Hi:

I have a customer using CDD 6.1.  Their .rdb and two .rda files for their
repository have grown to over 2 milion blocks.  They have moved the .snp 
files to other disks to handle the large files.  They would like to compress 
this repository.  They did a purge in CDO to delete multiple versions
of fields, records, etc, and the result was that the rdb files grew in
size.  

Is there anything they can do to shrink these rdb files?  Like remove
the history information?

Thanks for any advice.

--Gary Hodson
T.RTitleUserPersonal
Name		DateLines
1074.1NOVA::SMITHIDon't understate or underestimate Rdb!Mon Mar 24 1997 18:554
Maybe an EXPORT and IMPORT is required (using SQL).  Use smaller ALLOCATION
for the .RDA files.

Ian
1074.2some solutions8292::PJACOBPatrick JACOB-pjacob@fr.oracle.comTue Mar 25 1997 08:1226
Hi Gary,

>this repository.  They did a purge in CDO to delete multiple versions
>of fields, records, etc, and the result was that the rdb files grew in
>size.  

	Do you have the logical name CDD$KEEP_HISTORY_ON_DELETE defined to any
	value ? Which Rdb files grew in size, SNP or RDA ? I am curious to 
	know why your purge makes the Rdb files grow so much. To compress the
	snapshot files you can use CDO VERIFY/COMPRESS .

>Is there anything they can do to shrink these rdb files?  Like remove
>the history information?

	Procedures exist to physically remove obsolete history information. 
	For example, note 324.12 has an SQL script which can be the source of
	inspiration to achieve this. This has to be reviewed against CDD/R 6.1
	with CDD$$O_HISTORY and CDD$$O_HISTORY_LIST . 
	I wrote a STARS article ( How to shrink the Size of CDD$DATABASE ) to 
	show an example of the IMPORT command you should specify to reorganize 
	your database.

Hope this helps.

Patrick
1074.3ThanksM5::GHODSONWed Mar 26 1997 21:001
    Thanks Patrick and Ian.  This is great info, just what I needed.