: Sat, January 26, 2002 1:11 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: ORA-01555 Mystery (Help)
Jared:
The table was analyzed (via estimate) Wednesday night.
I don't know if it was before or after Wednesday
night's attempt at the extract but if the blocks are
getting
1:11 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: ORA-01555 Mystery (Help)
Jared:
The table was analyzed (via estimate) Wednesday night.
I don't know if it was before or after Wednesday
night's attempt at the extract but if the blocks are
getting cleaned out via
Hi,
A user in our data warehousing group is running into
the old ORA-01555 (snapshot too old) error every time
she runs a massive (20 million rows) select against
one table via a view. I confirmed that the view only
translates to the one table.
The user swears that no one would be making any
In Tom Kyte's book Expert 1-on-1
he says to ANALYZE the table BEFORE starting a big query.
Read Chapter 5, starting on page 185 for a complete explanation.
Walter K wrote:
Hi,
A user in our data warehousing group is running into
the old ORA-01555 (snapshot too old) error every time
she
Don't believe your users. Somebody is causing
oracle to read blocks in consistent mode, ie. reading them
from rollback segments. If the user is right, then try
locking the participating tables in the exclusive mode and see
who will complain. Alternatively, go to V$ACCESS table, see who is
!
Barb
--
From: Walter K[SMTP:[EMAIL PROTECTED]]
Reply To: [EMAIL PROTECTED]
Sent: Friday, January 25, 2002 9:15 AM
To: Multiple recipients of list ORACLE-L
Subject: ORA-01555 Mystery (Help)
Hi,
A user in our data warehousing group is running
Is it a simple select statement, or is it a cursor select in an PL/SQL
block? Does her transaction itself perform any DML on those tables?
Raj
Walter K [EMAIL PROTECTED]@fatcity.com on 01/25/2002 11:15:26 AM
Please respond to [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
To:
overwritten.
Good luck!
Barb
--
From: Walter K[SMTP:[EMAIL PROTECTED]]
Reply To:[EMAIL PROTECTED]
Sent: Friday, January 25, 2002 9:15 AM
To: Multiple recipients of list ORACLE-L
Subject: ORA-01555 Mystery (Help)
Hi,
A user in our data warehousing group is running
that the rollback segments don't
get
overwritten.
Good luck!
Barb
--
From: Walter K[SMTP:[EMAIL PROTECTED]]
Reply To: [EMAIL PROTECTED]
Sent: Friday, January 25, 2002 9:15 AM
To: Multiple recipients of list ORACLE-L
Subject:ORA-01555 Mystery (Help)
Hi
Subject: ORA-01555 Mystery (Help)
Hi,
A user in our data warehousing group is running into
the old ORA-01555 (snapshot too old) error every time
she runs a massive (20 million rows) select against
one table via a view. I confirmed that the view only
translates to the one table
Subject:Re:RE: ORA-01555 Mystery (Help)
Barb,
I've tried Steve's idea in the past and although it sorta fixed
the problem
with the large batch job, it created problems elsewhere. It also
did not
totally fix the problem when other applications updated parts
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:RE: ORA-01555 Mystery (Help)
Sure, but the original post concerns a *query*, not a transaction, and
before running the query, the user locked the queried table in
exclusive mode, to ensure
:30 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
cc:
Subject:RE: ORA-01555 Mystery (Help)
Sure, but the original post concerns a *query*, not
a transaction, and
before running the query, the user locked
the grief and find a
resolution.
Barb
--
From: [EMAIL PROTECTED][SMTP:[EMAIL PROTECTED]]
Sent: Friday, January 25, 2002 11:09 AM
To: Baker; Barbara; Multiple recipients of list ORACLE-L
Subject:Re:RE: ORA-01555 Mystery (Help
On Fri, 25 Jan 2002, Kathy Duret wrote:
How about doing a set transaction to a large rollback before running
this query if the analyze doesn't resolve the problem.
That will have no effect.
http://www.speakeasy.org/~jwilton/oracle/snapshot-too-old.html
--
Jeremiah Wilton
.
Jared
Paul Baumgartel [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
01/25/02 09:30 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
cc:
Subject:RE: ORA-01555 Mystery (Help)
Sure, but the original
:
Subject:Re: ORA-01555 Mystery (Help)
I was almost ready to subscribe to the idea of delayed cleanout, but I
cannot understand why really. The necessity for reading a block from the
rollback segments comes from encountering during the course of the
SELECT a block the SCN of which is higher
compute the stats.
But now I'm speculating. :)
Jared
Walter K [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
01/25/02 11:20 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:RE: ORA-01555 Mystery (Help
; Barbara; Multiple recipients of list ORACLE-L
Subject:Re:RE: ORA-01555 Mystery (Help)
Barb,
I've tried Steve's idea in the past and although it sorta fixed
the problem
with the large batch job, it created problems elsewhere. It also
did not
totally fix
][SMTP:[EMAIL PROTECTED]]
Reply To: [EMAIL PROTECTED]
Sent: Friday, January 25, 2002 3:05 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: ORA-01555 Mystery (Help)
I don't have a definitive answer for that.
My guess would be that 'compute' would be required
so
, January 25, 2002 12:30 PM
To: Multiple recipients of list ORACLE-L
Subject:RE: ORA-01555 Mystery (Help)
Another fact, that should be mentioned, is that
the
table in question was built (loaded) two days ago.
The
nightly ETL processes for the warehouse are pretty
substantial
Title: RE: ORA-01555 Mystery (Help)
would Set transaction read only help here?
-Original Message-
From: Baker, Barbara [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 25, 2002 2:35 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: ORA-01555 Mystery (Help)
I think you
]
Sent by: [EMAIL PROTECTED]
01/25/02 10:39 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
cc:
Subject:Re: ORA-01555 Mystery (Help)
I was almost ready to subscribe to the idea of delayed cleanout, but
I
the stats.
But now I'm speculating. :)
Jared
Walter K [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
01/25/02 11:20 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:RE: ORA-01555 Mystery (Help)
Jared
24 matches
Mail list logo