Home » RDBMS Server » Performance Tuning » How to avoid redo log entries for a table
How to avoid redo log entries for a table [message #211940] Wed, 03 January 2007 02:59 Go to next message
amit.pandey
Messages: 64
Registered: August 2006
Location: Bangalore, India
Member
Dear All,

I'm working in oracle 9i under unix o/s,I want to avoid redo log entries for a table, i've putted that table into nologging mode, but when normal DML statement fired through my application, it's entry is going into redo log.

I cannot use Insert ... As Select .., because data is inserted into that table through an application, that data is of temporary use and it is deleted after transaction.

I've tried NOLOGGING clause and APPEND hint for that, but it is not working as it will work only with direct load insert.

Is thr any method to avoid that redo log entries, or is thr any way to convert normal DML into direct load insert, by using some hint or something like that.

If i create an index-organized table, then is it possible to avoid redo log entries.

Thanx in Advance
Amit
Re: How to avoid redo log entries for a table [message #211970 is a reply to message #211940] Wed, 03 January 2007 05:08 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
You cannot completely avoid redo generation.
You can just minimize them
http://www.orafaq.com/forum/m/163593/42800/?srch=redo+entries#msg_163549
Re: How to avoid redo log entries for a table [message #211996 is a reply to message #211940] Wed, 03 January 2007 07:28 Go to previous messageGo to next message
michael_bialik
Messages: 611
Registered: July 2006
Senior Member
Try using GLOBAL TEMPORARY table ( if the "data is of temporary use and it is deleted after transaction" ).

HTH
Re: How to avoid redo log entries for a table [message #211998 is a reply to message #211996] Wed, 03 January 2007 07:32 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Still GTT will generate ***some*** redo.
http://www.orafaq.com/forum/m/65992/42800/?srch=GTT+redo#msg_65981
GTT will not directly generate any redo, but will create undo which will inturn create the redo.
Re: How to avoid redo log entries for a table [message #212377 is a reply to message #211998] Fri, 05 January 2007 01:01 Go to previous messageGo to next message
amit.pandey
Messages: 64
Registered: August 2006
Location: Bangalore, India
Member
Hi,

Is this possible that instead of firing insert statement on that table, i call a procedure and write the ouput in a text file, and create a external table to fetch the data from thr. After completion of transaction I remove that flat file or overwrite it when new transaction starts.

Please guide me that i'm on a right step or not?

Thanks
Amit

Re: How to avoid redo log entries for a table [message #212421 is a reply to message #212377] Fri, 05 January 2007 04:41 Go to previous message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
It is an overkill. I am not sure why you are considering redo entries are that bad. In any case, you CANNOT avoid redo geneartion. You can just minimize it.
Previous Topic: tuning
Next Topic: Database Down
Goto Forum:
  


Current Time: Sat Dec 10 07:22:38 CST 2016

Total time taken to generate the page: 0.10604 seconds