Refreshing development with production DB

[vdgr1975]

Hi,


Are there any precautions need to take after refresh is done for development database with production like rebuild indexes like that.

Because we r getting performance problems after we refresh development with production database. When we access production it is good , if we access developemnt it is very slow.

Can any one give me documentation location for refreshing development database with production database.

Thanks,

[ngupta15]

can you tell us how did you refresh Dev DB from Prod???

[Mr.Hanky]

Originally posted by ngupta15
can you tell us how did you refresh Dev DB from Prod???

That is the million dollar question isn't it?

Usually I truncate and import, what are you guys doing?

MH

[blakmk]

I find the problem with truncate and import is that the indexes on the sys tables tend to get fragmented. If this is done a lot it will impact performance so its probably worth rebuilding the development database every once in a while

[hrishy]

Hi

Just in case you r doing export import then you could do statistics=none while exporting..

regards
Hrishy

[TimHall]

Hi.

You could try this:

http://www.databee.com/

It allows you to get referentially correct subsets of production data. I've not tried it but I know someone who has. I think there's a free trial.

Once you've got the data in the tables make sure the stats are up to date.

blakmk:
I can't see how truncating and importing can cause excessive fragmentation of the SYS indexes. This is more likely if you're dropping tables. If you're using LMTs you should have no major problem with extent management. Use automatic segment free space management and the dictionary does even less.

Cheers

Tim...

[Mr.Hanky]

Originally posted by blakmk
I find the problem with truncate and import is that the indexes on the sys tables tend to get fragmented. If this is done a lot it will impact performance so its probably worth rebuilding the development database every once in a while

Can you elaborate on this one, it is news to me.
How can this be confirmed?
How do you check the SYS tables for fragmentation?
Educate me.

MH