1mb del = 1bm archive? -archive generation

[dbaxchangedba]

any possible way of precisely estimating or figuring out how much worth of archive it will generate?

One possibility for you would be to estimate the redo in your test system as follows:

From within your session:

-- Get the starting redo size value
SQL> select value start_value from v$mystat where statistic# = 115;

SQL> Run_your_deletes
-- Get the Ending redo size value

SQL> select value end_value from v$mystat where statistic# = 115;

Your end_value - start_value should give you an idea of how much redo (in bytes) your deletes would generate.

Alternatively, you could do this as well on your test system to get an appoximate idea:

From within your session:

-- Get the starting redo size value
SQL> select value start_value from v$mystat where statistic# = 115;

SQL> Delete_one_row

-- Get the mid redo size value
SQL> select value mid_value from v$mystat where statistic# = 115;

SQL> commit;

-- Get the Ending redo size value
SQL> select value end_value from v$mystat where statistic# = 115;

((mid_value - start_value) * (9 million) ) + ((end_value - mid_value) * no_of_commits_done) should give you an idea on how much redo might be generated for your deletes.

Good luck.....

http://www.dbaxchange.com