| Use of NOLOGGING ...!!! [message #143709] |
Fri, 21 October 2005 10:27  |
balavignesh
Messages: 180
Registered: March 2005
|
Senior Member |
|
|
hai,
i would like to know the purpose of NOLOGGING option while creating tablespace and database objects like tables etc..
can u plz help out..?
i know that no redo history would be generated when this is set...in addition to this is there anything other info..?
regards
bala
|
|
|
|
|
|
| Re: Use of NOLOGGING ...!!! [message #143810 is a reply to message #143709] |
Sat, 22 October 2005 16:22  |
rkl1
Messages: 97
Registered: June 2005
|
Member |
|
|
My belief is that use the nologging option when you don't care about the data recovery potential and rather choose the speed. Best part of nologging is perphas when you rebuild or create the index. When you load data ie, direct loading which goes over the high water mark, nologging could improve your data loading speed. And if you fail, you still have the file to go load again. However nologging is not used when you run your regular dml like insert,update and delete transactions. They will be going through the logging cycle even if you either explicit or implicitly choose the nologging option.
My recommendation would be no need to choose the nologging option explicitly. Rather use it when you doing some stuffs like index building or loading data using the append hints etc.
thanks.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
