Oracle RDBMS Space

[tlawrence]

Anyone Shadowing Files ?

Any help would be greatly appreciated.

When shadowing files to Oracle from p4, how much space is needed on the Oracle side?
Files include the activity file with 560,000 records and the problem file with over 370,000 record.

I'm having issues with the initial shadowing process terminating with a signal 11 when creating the temp file.

Thanks for any help

[pcasey]

Well, 3k is a good conservative guess for an activity record, and 10k is a decent guess for a record out of the problem file (10k per page that is).

So, just do the math:

560,000 * 3k = 1.5 G
370,000 * 10k = 3.7 G

So, I'd say ball park 5 Gb if I didn't drop a decimal place in there. Realistically, you'll probably come in lower than this, but you're very unlikely to need more.

--- Pat