Re: How to create an outlines to another database on Toad
Lisa Hu <[email protected]>
| Newsgroups | gmane.comp.db.oracle.toad.free |
|---|---|
| Message-ID | <[email protected]> |
By the way, we don't have Quest SQL Optimizer licensed. We only have Standard Toad license. For Oracle EM, we have oracle performance diagnostic package. They are RAC DBs. Thanks, Lisa From: Lisa Hu <[email protected]> To: "[email protected]" <[email protected]> Sent: Monday, July 16, 2012 4:51 PM Subject: [toad] How to create an outlines to another database on Toad Dear Toad experts, I need help on how to create an outline from one database to another in toad (not sure if it uses Plan Control in Toad). I am running into a situation that a new SQL runs in 20 secs on Test DB, while 40 mints on Prod. It’s same SQL but data is a little bit different. All parameters, indexes, tables are same on both DBs. Both are 10.2.0.5 on similar hardware. I am trying to export a stored outline on Test , and import to Prod Db (it's a fast fix because users are waiting to migrate SQL to production DB). I heard Toad has tools to copy execution plan from one DB to other. Can anyone instruct me to accomplish this task? Any help will be greatly appreciated. Lisa