Home » Other » General » logging (10g 10.2.0 RHEL5)
logging [message #553107] Tue, 01 May 2012 23:59 Go to next message
smunir362
Messages: 310
Registered: September 2007
Senior Member
AOA

I want to disable redo generation for only insert statements against a specific table.
Re: logging [message #553114 is a reply to message #553107] Wed, 02 May 2012 00:22 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>I want to disable redo generation for only insert statements against a specific table.

I want to win the lottery.

Guess What?
I have a better chance than you do for my wish to come true.
Re: logging [message #553118 is a reply to message #553107] Wed, 02 May 2012 01:07 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
You can disable redo for direct load inserts. Look up the NOLOGGING clause and the /*+ APPEND */ hint. There are some implications for concurrency and data integrity that need to be aware of.
Re: logging [message #553133 is a reply to message #553118] Wed, 02 May 2012 02:03 Go to previous messageGo to next message
smunir362
Messages: 310
Registered: September 2007
Senior Member
NOLOGGING clause can be used at the end of insert statement.... But I am using an application which insert data to a table...
Is there any way that I solve this problem at server side means any trigger or other setting......
Re: logging [message #553138 is a reply to message #553133] Wed, 02 May 2012 02:42 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
NOLOGGING clause can be used at the end of insert statement


What does this mean?

Quote:
Is there any way that I solve this problem at server side means any trigger or other setting......


Which ACTUAL problem?

Regards
Michel
Re: logging [message #553262 is a reply to message #553138] Wed, 02 May 2012 23:02 Go to previous messageGo to next message
smunir362
Messages: 310
Registered: September 2007
Senior Member
Actually I am using purchased application which insert data in a database table......
Now by default logging is enabled and all the operations are going well.
I want that no redo should be generated against a specific table only for insert statement.... because this cause heavy archived log and ultimately flash recovery area full...........
Please guide me to solve this issue...
Re: logging [message #553270 is a reply to message #553262] Thu, 03 May 2012 00:56 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Do you understand that no logging means not recoverable?
That is if you lose a disk or a file you lose your data, is this what you want?
If yes, then just put your database in NOARCHIVELOG mode.

Regards
Michel
Re: logging [message #553286 is a reply to message #553270] Thu, 03 May 2012 03:51 Go to previous messageGo to next message
smunir362
Messages: 310
Registered: September 2007
Senior Member
Yes I understand what means by nologging.......

But I want to ask "is it possible to set nologging for insert statements against a single table"
If yes then how to do it....
Re: logging [message #553288 is a reply to message #553286] Thu, 03 May 2012 03:57 Go to previous messageGo to next message
cookiemonster
Messages: 13917
Registered: September 2008
Location: Rainy Manchester
Senior Member
No it is not possible, except for direct load inserts.
Re: logging [message #553294 is a reply to message #553286] Thu, 03 May 2012 04:45 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
smunir362 wrote on Thu, 03 May 2012 10:51
Yes I understand what means by nologging.......


No I don't think you REALLY understand what this means otherwise you would not ask for this.
Do you REALLY understand that means inconsistencies in your data after a failure?
Do you REALLY understand that your application will no more work?
Do you REALLY understand that means your customers will go away and find a more reliable entreprise?
What do you think if you go to your bank to ask for your money and the answer is "You have no account in this bank!"?

Regards
Michel

Re: logging [message #553296 is a reply to message #553294] Thu, 03 May 2012 04:51 Go to previous messageGo to next message
smunir362
Messages: 310
Registered: September 2007
Senior Member
You are right....
But here situation is different..... It is our requirement
Re: logging [message #553298 is a reply to message #553296] Thu, 03 May 2012 04:53 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
The first requirement is to retrieve the data you gave NOT to have less logs.

Regards
Michel
Re: logging [message #553308 is a reply to message #553298] Thu, 03 May 2012 06:08 Go to previous messageGo to next message
cookiemonster
Messages: 13917
Registered: September 2008
Location: Rainy Manchester
Senior Member
Your requirement is impossible, and so it is meaningless.

You need to cope with the fact that you are getting lots of redo.
Re: logging [message #553374 is a reply to message #553308] Fri, 04 May 2012 00:43 Go to previous messageGo to next message
smunir362
Messages: 310
Registered: September 2007
Senior Member
So it is not possible
"No redo generation for insert statements only against a table"
Re: logging [message #553378 is a reply to message #553374] Fri, 04 May 2012 01:08 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
cookiemonster wrote on Thu, 03 May 2012 10:57
No it is not possible, except for direct load inserts.

Re: logging [message #565059 is a reply to message #553378] Thu, 30 August 2012 04:51 Go to previous message
Tomokofreer
Messages: 3
Registered: August 2012
Junior Member
That is if you lose a disk or a file you lose your data, is this what you want?
Previous Topic: char(1 byte) vs char(2 byte)
Next Topic: To be a Oracle Apps DBA is it mandatory one should be core DBA professional
Goto Forum:
  


Current Time: Fri Mar 29 05:38:32 CDT 2024