Home » SQL & PL/SQL » SQL & PL/SQL » does rebuild indexs generates a redo
does rebuild indexs generates a redo [message #302122] Sat, 23 February 2008 14:15 Go to next message
sheldon1982
Messages: 59
Registered: February 2008
Location: india
Member
Hi Experts,
when we rebuild a indexes, lots of redo gets generated at that time??
Re: does rebuild indexs generates a redo [message #302131 is a reply to message #302122] Sat, 23 February 2008 16:37 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Lots, if the objects are in logging mode.
Much much less, if the objects are in nologging mode.

[Updated on: Sat, 23 February 2008 17:59]

Report message to a moderator

Re: does rebuild indexs generates a redo [message #302139 is a reply to message #302122] Sun, 24 February 2008 01:19 Go to previous messageGo to next message
sheldon1982
Messages: 59
Registered: February 2008
Location: india
Member
thanks..
how i will come to know whether the objects is in login mode or not??
Re: does rebuild indexs generates a redo [message #302140 is a reply to message #302139] Sun, 24 February 2008 01:22 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
DBA_INDEXES.LOGGING but it may be overwrite by V$DATABASE.FORCE_LOGGING.

Regards
Michel
Previous Topic: Latest Record
Next Topic: How can I continue insertion by skipping invalid records?
Goto Forum:
  


Current Time: Sat Dec 03 11:44:02 CST 2016

Total time taken to generate the page: 0.04879 seconds