Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: copy export plan from one database to another
copy export plan from one database to anotherApproximately,
1) you can import and export statistics
2) you can too use optimizer plan stability (chapter 11 expert one on one Tom kyte)
What happen before the problem, you update statiscs, update staticis in sys schema, what happened?
Hi there,
We are in a bit of a panic right now, and I am busily searching the manuals,
But is it possible to copy the explain plan that looks good in your dev/test database to the production database and force your production database to use that explain plan ??
I will figure out what went wrong with the production plan once the panic is over.
Thanks
Darren
Darren Browett P.Eng This message was transmitted Data Administrator using 100% recycled electronsInformation and Communication Technology City of Coquitlam