OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » Redo generation (Oracle 9i)

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

Redo generation [message #467868]

Tue, 27 July 2010 20:34

caprikar
Messages: 226
Registered: March 2007

Senior Member

Hi,
We have oracle 9i on Unix, we are suddenly seeing lots of redo being generated and want to find the offending SQL that is generating more redo. Is there a way to find which SQL is generating how much of redolog?
Thanks

Report message to a moderator

Re: Redo generation [message #467869 is a reply to message #467868]

Tue, 27 July 2010 20:37

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>Is there a way to find which SQL is generating how much of redolog?
DML generates redo so query V$SQL for INSERT, UPDATE, & DELETE statements

Report message to a moderator

Re: Redo generation [message #467875 is a reply to message #467868]

Tue, 27 July 2010 21:10

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

http://www.orafaq.com/forum/m/463473/42800/#msg_463473

Report message to a moderator

Re: Redo generation [message #467876 is a reply to message #467875]

Tue, 27 July 2010 21:21

rahulvb
Messages: 924
Registered: October 2009
Location: Somewhere Near Equator.

Senior Member

AND you can specify a NOLOGGING clause when creating
tables, indexes, partitions and tablespaces which under certain circumstances
causes REDO generation to be switched off when the object is loaded.

Report message to a moderator

Re: Redo generation [message #467877 is a reply to message #467876]

Tue, 27 July 2010 22:16

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

OP asked
>>want to find the offending SQL that is generating more redo
And you are talking about switching it off?

Report message to a moderator

Re: Redo generation [message #467878 is a reply to message #467877]

Tue, 27 July 2010 23:01

rahulvb
Messages: 924
Registered: October 2009
Location: Somewhere Near Equator.

Senior Member

I know Mahesh, its just added info.

Report message to a moderator

Previous Topic:	undo tablespace 100% full with offline extendes
Next Topic:	ASM Separation

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Dec 01 13:15:36 CST 2024