AW: Re: AW: Re: Large index creation speed up / issues with direct path read temp / direct path write temp
Date: Sun, 05 Jul 2015 17:23:44 +0200
Message-ID: <o1kt99psta9dobbabq0i2aqj.1436109824891_at_email.android.com>
Hi Stefan
you are right. It scares me too. Guess there will be a way, can't be the first time something like that happens.
Von meinem Samsung Gerät gesendet.
- Ursprüngliche Nachricht -------- Von: Stefan Koehler <contact_at_soocs.de> Datum: 05.07.2015 12:19 (GMT+01:00) An: oracle-l_at_freelists.org, GG <grzegorzof_at_interia.pl>, l.flatz_at_bluewin.ch Betreff: Re: AW: Re: Large index creation speed up / issues with direct path read temp / direct path write temp
Hi GG,
i am also a performance specialist, but had to deal with such situations in my "permanent employment" era.
_at_Lothar:
Unfortuanately it is not so easy in case of physical standby databases :)
In addition these databases usually run in "force logging" mode so that a "create index .... nologging" would have no effect anyway. There are some
special cases (like BI ETLs, etc.) where nologging is also an option in case of physical standby database, but this is not the common stuff.
However if you just run this index creation with nologging (and database is not in force logging mode), you can use RMAN incremental backups to roll forward a physical standby database: http://docs.oracle.com/cd/E11882_01/server.112/e41134/rman.htm#SBYDB00759
Almost anything is possible with Oracle - scary :)
Best Regards
Stefan Koehler
Freelance Oracle performance consultant and researcher
Homepage: http://www.soocs.de
Twitter: _at_OracleSK
> "l.flatz" <l.flatz_at_bluewin.ch> hat am 5. Juli 2015 um 11:45 geschrieben:
>
> Oh, I see. Thanks for letting me know. I am a performance specialist. Therefore I am not aware how to deal with this situation. Maybe our
> colleagues will give you some advice.
> I would simply create the index on both sides which is probably pretty naive. ☺
>
> -------- Ursprüngliche Nachricht --------
> Von: GG <grzegorzof_at_interia.pl>
> Datum: 05.07.2015 11:07 (GMT+01:00)
> An: l.flatz_at_bluewin.ch, oracle-l_at_freelists.org
> Betreff: Re: Large index creation speed up / issues with direct path read temp / direct path write temp
>
> > > Standby involved (production HA) no way :( .
-- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-lReceived on Sun Jul 05 2015 - 17:23:44 CEST