OraFAQ Forum: Performance Tuning » Using 9i stored outlines by 11g SPM

Home » RDBMS Server » Performance Tuning » Using 9i stored outlines by 11g SPM (11g , solaris9)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Using 9i stored outlines by 11g SPM [message #451080]

Mon, 12 April 2010 06:03

orafacjublu
Messages: 95
Registered: May 2006
Location: KOLKATA

Member

Is there any way I can use a stored outline of 9i by 11g SPM.
I need the steps.
Thanks

Report message to a moderator

Re: Using 9i stored outlines by 11g SPM [message #451084 is a reply to message #451080]

Mon, 12 April 2010 06:18

Michel Cadot
Messages: 68650
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

11gR1 or 11gR2?

Regards
Michel

Report message to a moderator

Re: Using 9i stored outlines by 11g SPM [message #451087 is a reply to message #451084]

Mon, 12 April 2010 06:23

orafacjublu
Messages: 95
Registered: May 2006
Location: KOLKATA

Member

11g R1. Tablespace copy has already been in 11g. But same queries takin long time using different explain plan.
So thought of using the 9i explain plan by creating the outlines in 9i and making 11g use it
thanks

Report message to a moderator

Re: Using 9i stored outlines by 11g SPM [message #451155 is a reply to message #451087]

Mon, 12 April 2010 13:09

John Watson
Messages: 8931
Registered: January 2010
Location: Global Village

Senior Member

With 11.1, you can't do it. With 11.2 you would have the dbms_spm.migrate_stored_outline procedure.

Report message to a moderator

Previous Topic:	awr snapshots
Next Topic:	SQL Logic (merged by CM)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon May 13 00:14:40 CDT 2024