OraFAQ Forum: General

Home » Other » General » logging (10g 10.2.0 RHEL5)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

logging [message #553107]

Tue, 01 May 2012 23:59

smunir362
Messages: 310
Registered: September 2007

Senior Member

AOA

I want to disable redo generation for only insert statements against a specific table.

Report message to a moderator

Re: logging [message #553114 is a reply to message #553107]

Wed, 02 May 2012 00:22

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.

Report message to a moderator

Re: logging [message #553118 is a reply to message #553107]

Wed, 02 May 2012 01:07

John Watson
Messages: 8964
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.

Report message to a moderator

Re: logging [message #553133 is a reply to message #553118]

Wed, 02 May 2012 02:03

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......

Report message to a moderator

Re: logging [message #553138 is a reply to message #553133]

Wed, 02 May 2012 02:42

Michel Cadot
Messages: 68732
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: logging [message #553262 is a reply to message #553138]

Wed, 02 May 2012 23:02

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...

Report message to a moderator

Re: logging [message #553270 is a reply to message #553262]

Thu, 03 May 2012 00:56

Michel Cadot
Messages: 68732
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: logging [message #553286 is a reply to message #553270]

Thu, 03 May 2012 03:51

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....

Report message to a moderator

Re: logging [message #553288 is a reply to message #553286]

Thu, 03 May 2012 03:57

cookiemonster
Messages: 13963
Registered: September 2008
Location: Rainy Manchester

Senior Member

No it is not possible, except for direct load inserts.

Report message to a moderator

Re: logging [message #553294 is a reply to message #553286]

Thu, 03 May 2012 04:45

Michel Cadot
Messages: 68732
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: logging [message #553296 is a reply to message #553294]

Thu, 03 May 2012 04:51

smunir362
Messages: 310
Registered: September 2007

Senior Member

You are right....
But here situation is different..... It is our requirement

Report message to a moderator

Re: logging [message #553298 is a reply to message #553296]

Thu, 03 May 2012 04:53

Michel Cadot
Messages: 68732
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

The first requirement is to retrieve the data you gave NOT to have less logs.

Regards
Michel

Report message to a moderator

Re: logging [message #553308 is a reply to message #553298]

Thu, 03 May 2012 06:08

cookiemonster
Messages: 13963
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.

Report message to a moderator

Re: logging [message #553374 is a reply to message #553308]

Fri, 04 May 2012 00:43

smunir362
Messages: 310
Registered: September 2007

Senior Member

So it is not possible
"No redo generation for insert statements only against a table"

Report message to a moderator

Re: logging [message #553378 is a reply to message #553374]

Fri, 04 May 2012 01:08

Michel Cadot
Messages: 68732
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

cookiemonster wrote on Thu, 03 May 2012 10:57

No it is not possible, except for direct load inserts.

Report message to a moderator

Re: logging [message #565059 is a reply to message #553378]

Thu, 30 August 2012 04:51

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?

Report message to a moderator

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Feb 02 11:48:03 CST 2025