: Multiple recipients of list ORACLE-LSubject: RE:
Redo Logs Problem
Just
Out of curiosity.
How
come changing the TS to LMT would reduce the excessive Redo
generation.
Regards,
Rajesh
-Original
Message-From:
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf
PROTECTED]
Sent: Monday, August 04, 2003 11:59 AM
To: Multiple recipients of list
ORACLE-L
Subject: RE: Redo Logs Problem
Just Out of
curiosity.
How come changing
the TS to LMT would reduce the excessive Redo generation.
Regards,
Rajesh
-Original
Message-
From: [EMAIL PROTECTED
To: Multiple recipients of list
ORACLE-L
Subject: RE: Redo Logs Problem
Just Out of curiosity.
How come changing the TS to
LMT would reduce the excessive Redo generation.
Regards,
Rajesh
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]On Behalf
On Sun, 3 Aug 2003, Naveen Nahata wrote:
This will reduce the updates and inserts to the Data-Dictionary tables since
in LMTs extent information is stored locally and not in Data-Dictionary
I do not believe that there are real practical examples of this making
any signifgicant difference.
ORACLE-L
Subject: RE: Redo Logs Problem
On Sun, 3 Aug 2003, Naveen Nahata wrote:
This will reduce the updates and inserts to the
Data-Dictionary tables since
in LMTs extent information is stored locally and not in
Data-Dictionary
I do not believe that there are real practical
Naveen
-Original Message-
From: Jeremiah Wilton [mailto:[EMAIL PROTECTED]
Sent: Monday, August 04, 2003 2:36 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Redo Logs Problem
On Sun, 3 Aug 2003, Naveen Nahata wrote:
This will reduce the updates and inserts
Subject: Redo Logs Problem
Hi Listers,
One of my remote Clients is facing a problem with Redo Logs. The Redo Logs
and the Archive logs in turn have suddenly started to generate at an
alarming Rate. This has suddenly started from the last 1 week without any
changes to Database Configuration or any
Convert Tablespaces
to LMT (Locally Managed) if in 8i , to reduce excessive Redo generation
-Original
Message-
From: Munish Bajaj
[mailto:[EMAIL PROTECTED]
Sent: Friday, August 01, 2003 4:04 PM
To: Multiple recipients of list
ORACLE-L
Subject: Redo Logs Problem
Hi
of list
ORACLE-L
Subject: RE: Redo Logs Problem
Convert Tablespaces to LMT (Locally Managed) if in 8i , to reduce
excessive Redo generation
-Original
Message-
From: Munish Bajaj
[mailto:[EMAIL PROTECTED]
Sent: Friday, August 01, 2003 4:04
PM
To: Multiple recipients of list
ORACLE-L
for your enlightening answers. This list is
great.
Regards
Munish
Bajaj
-Original Message-From: VIVEK_SHARMA
[mailto:[EMAIL PROTECTED]Sent: Monday, August 04, 2003
11:19To: Multiple recipients of list ORACLE-LSubject:
RE: Redo Logs Problem
Convert
Tablespaces to LMT
Hi Listers,
One of my remote
Clients is facing a problem with Redo Logs. The Redo Logs and the Archive logs
in turn have suddenly started to generate at an alarming Rate. This has suddenly
started from the last 1 week without any changes to Database Configuration or
any other system
,
August 01, 2003 1:34
PM
To: Multiple recipients of list
ORACLE-L
Subject: Redo Logs Problem
Hi
Listers,
One of
my remote Clients is facing a problem with Redo Logs. The Redo Logs and the
Archive logs in turn have suddenly started to generate at an alarming Rate.
This has suddenly
TABLESPACE name END
BACKUP"???
You can check that using the view
sys.v_$backup
Regards
Naveen
-Original Message-From: Munish Bajaj
[mailto:[EMAIL PROTECTED]Sent: Friday, August 01, 2003 4:04
PMTo: Multiple recipients of list ORACLE-LSubject: Redo
Logs Problem
Hi Lis
August 01, 2003
16:44To: Multiple recipients of list ORACLE-LSubject:
RE: Redo Logs Problem
Redo is not effected by database
configuration but by database activity.
Has the no. of transactions increased
significantly?
If the activity is the same,a wild
guess -Has some
]Gesendet: Freitag, 1. August 2003
12:34An: Multiple recipients of list ORACLE-LBetreff:
Redo Logs Problem
Hi Listers,
One of my remote
Clients is facing a problem with Redo Logs. The Redo Logs and the Archive logs
in turn have suddenly started to generate at an alarming Rate
You didnt answer. Do u have more
load?
You canmake outthat info from
v$archived_log
Regards
Naveen
-Original Message-From: Munish Bajaj
[mailto:[EMAIL PROTECTED]Sent: Friday, August 01, 2003 4:54
PMTo: Multiple recipients of list ORACLE-LSubject: RE:
Redo Logs Problem
You don't mention the database version, but if it is 8i or later, you could use
logminer to view the contents of the redo logs.
-Original Message-
Sent: Friday, August 01, 2003 6:34 AM
To: Multiple recipients of list ORACLE-L
Hi Listers,
One of my remote Clients is facing a problem
of archives, however the amount in bytes remains the same.
Tanel.
- Original Message -
From:
Munish Bajaj
To: Multiple recipients of list ORACLE-L
Sent: Friday, August 01, 2003 1:34
PM
Subject: Redo Logs Problem
Hi Listers,
One of my remote
Clients
Title: RE: Redo Logs Problem
This has suddenly started from the last 1 week without any changes to Database Configuration or any other system settings (as per client).
Clients lie.
Jerry Whittle
ASIFICS DBA
NCI Information Systems Inc.
[EMAIL PROTECTED]
618-622-4145
-Original
recipients of list
ORACLE-LSubject: RE: Redo Logs Problem
This has suddenly started from the last 1 week without any
changes to Database Configuration or any other system settings (as per
client).
Clients
lie.
Jerry Whittle ASIFICS DBA NCI Information Systems Inc.
[EMAIL PROTECTED
Probably an application has started generating lots of changes,
causing the jump in redo generation rate. The client needs to get a
delta of each session's value for 'redo size' in v$sesstat when this
is happening, then they can identify the culprit session.
There is one bug that could cause
check this
before
they start.
Kurt
-Original Message-From:
Smith, Ron L. [mailto:[EMAIL PROTECTED]Sent: Friday, August 01, 2003
11:29 AMTo: Multiple recipients of list ORACLE-LSubject:
RE: Redo Logs Problem
This
may have already been asked, but is it possible there is a datafile
Hi,
you may be able to identify the sessions that are generating a lot of redo
by running this query. It will list the amount of redo generated by eash
session.
select s.sid,s.value
from v$sesstat s
where s.statistic#=99
and s.value!=0
Cheers,
Mike Hately
-Original Message-
Sent: 01
Title: RE: Redo Logs Problem
<DEFANGED_!DOCTYPE EN? 3.2 HTML DTD W3C ?- PUBLIC>
Update activity is
obviously occuring at an alarming rate. Look at the times of the log
switches
and you should be able to pinpoint the 'when' Then, catch them in the
act!Look at v$sess_io and
One more thing to look at , if there were any object or tablespace in
nologging mode earlier ?
-ak
- Original Message -
From:
Munish Bajaj
To: Multiple recipients of list ORACLE-L
Sent: Friday, August 01, 2003 4:24
AM
Subject: RE: Redo Logs Problem
I've
are full, thus increasing the
number of archives, however the amount in bytes remains the same.
Tanel.
- Original Message -
From: Munish Bajaj
To: Multiple recipients of list ORACLE-L
Sent: Friday, August 01, 2003 1:34 PM
Subject: Redo Logs Problem
Hi Listers,
One of my
Hi!
Statistic#'s vary between versions (and possibly platforms), so one should
use statistic names instead of numbers in scripts.
Statistic# 99 is physical reads direct (lob) in my test environment for
example.
Tanel.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL
Not only that, but the query shown will show redo generation for the
entire life of a session. So if a daemon has been logged in for a
long time but generating redo slowly, it can still look like the top
redo generator. To do this in a purely analytical way, a delta of two
selects from v$sesstat
Tanel Poder wrote:
Hi!
Statistic#'s vary between versions (and possibly platforms), so one should
use statistic names instead of numbers in scripts.
Statistic# 99 is physical reads direct (lob) in my test environment for
example.
Tanel.
An alternative is to use v$sess_io and examine
29 matches
Mail list logo