I will have to check your question on 'fewer sorts'.
As far as changes to the SQL statements, there were 1 or 2 sql statements
changed in the application because they no longer worked efficiently with
the change to 8.1.7. But, on the whole (lets say 98%+ of the time) no
changes were made.
Dan;
Everything remained the same on the DB except the version. No changes
made.
-Original Message-
Sent: Monday, March 10, 2003 5:34 PM
To: Multiple recipients of list ORACLE-L
Kevin,
The ORA-01555 errors are almost certainly symptoms, not the actual
problem. It has been a few
Kevin,
The ORA-01555 errors are almost certainly symptoms, not the actual
problem. It has been a few years since I tested an 8.0.x db, but I do
not recall seeing any changes in rollback segments from 7.3 to 8.1.
Have you converted from Dictionary to Locally managed RBS
tablespaces? When
Did any of the rollback segment storage parameters (i.e. INITIAL, NEXT,
PCTINCREASE, MINEXTENTS, MAXEXTENTS, OPTIMAL) or the number of rollback
segments change between 8.0.5 and 8.1.7? Changes to any of these variables
could impact the space available for storing inactive undo blocks for
I
stopped attending the EOUG after Amsterdam (1996) because I've crossed the pond
and moved out of Europe.
May
favorite EOUG were in Cannes and Amsterdam. Boy, was it fun. They should
organize one in Munich in October.
That
is probably the only place time that could top both Cannes and
time that could top both Cannes and
Amsterdam.
-Original Message-
From: Mogens Nrgaard[mailto:[EMAIL PROTECTED]]
Sent: Saturday, February 23, 2002 10:33PM
To: Multiple recipients of list ORACLE-L
Subject: Re:Rollback Segments
And I'm sitting at my
And I'm sitting at my (the) oaktable right now thinking about a few things
Jonathan Lewis said an hour ago, sorrounded by good whiskies brought in by
Kyle Hailey and Connor McDonald and Jonathan. We still have a few seats available
for his Master Class on Monday. You're of course all invited to
To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
cc: (bcc: CHITALE Hemant Krishnarao/IT/CHRT/ST Group)
Subject: RE: Rollback Segments
UFI no, but the rest... that's where I started in Oracle --
version 5
--- Conboy, Jim [EMAIL
] 19/02/2002 06:18 AM
Sent by: [EMAIL PROTECTED]
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED] cc: (bcc: CHITALE Hemant Krishnarao/IT/CHRT/ST
Group) Subject: RE: Rollback Segments
UFI no, but the rest... that's where
PROTECTED] 19/02/2002 06:18 AM
Sent by: [EMAIL PROTECTED]
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
cc: (bcc: CHITALE Hemant Krishnarao/IT/CHRT/ST Group)
Subject: RE: Rollback Segments
] 19/02/2002 06:18 AM
Sent by: [EMAIL PROTECTED]
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED] cc: (bcc: CHITALE Hemant Krishnarao/IT/CHRT/ST
Group) Subject: RE: Rollback Segments
UFI no, but the rest... that's where
On Tuesday 19 February 2002 20:53, bill thater wrote:
i had to do a bunch with SQL*Calc because damagement understood
Lotus123. it was less than enjoyable.;-)
I was porting SQL*Calc to Unix - that was even less than enjoyable!
Rgds, Bjørn.
--
Please see the official ORACLE-L FAQ:
[EMAIL PROTECTED]
cc: (bcc: CHITALE Hemant Krishnarao/IT/CHRT/ST Group)
Subject: RE: Rollback Segments
UFI no, but the rest... that's where I started in Oracle -- version 5
--- Conboy, Jim [EMAIL PROTECTED] wrote:
Holy cow Mladen, what a memory!
Does anybody
/2002 06:18 AM
Sent by: [EMAIL PROTECTED]
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
cc: (bcc: CHITALE Hemant Krishnarao/IT/CHRT/ST Group)
Subject: RE: Rollback Segments
UFI
)
Subject: Re: Rollback Segments
Carmichael [EMAIL PROTECTED] 19/02/2002 06:18 AM
Sent by: [EMAIL PROTECTED]
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED] cc: (bcc: CHITALE Hemant Krishnarao/IT/CHRT/ST
Group) Subject: RE: Rollback Segments
UFI no, but the rest
Actually, the Hercules graphics is able to generate graphics. I had to
settle for Hercules since I could not afford a color monitor(using a CGA
card) back then. So I looked for games, etc. that had a Hercules graphics
mode. And, Hercules used twice the amount of pixels then CGA did, so I was
Man, I remember those days. When I talk to teenagers about having actually
worked with such machines, I get a deeper appreciation for the word 'old'.
And you actually had a 20MB hard drive. *sigh*
On Monday 18 February 2002 06:23 pm, you wrote:
I do. User Friendly Interface. Hush, don't
[EMAIL PROTECTED] 19/02/2002 06:18 AM
Sent by: [EMAIL PROTECTED]
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED] cc: (bcc: CHITALE Hemant Krishnarao/IT/CHRT/ST
Group) Subject: RE: Rollback Segments
UFI no, but the rest... that's
] 19/02/2002 06:18 AM
Sent by: [EMAIL PROTECTED]
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
cc: (bcc: CHITALE Hemant Krishnarao/IT/CHRT/ST Group)
Subject: RE: Rollback Segments
UFI no, but the rest
[EMAIL PROTECTED] cc: (bcc: CHITALE Hemant Krishnarao/IT/CHRT/ST
Group) Subject: RE: Rollback Segments
UFI no, but the rest... that's where I started in Oracle -- version 5
--- Conboy, Jim [EMAIL PROTECTED] wrote:
Holy cow Mladen, what a memory!
Does anybody else remember
I had a Hercules card too. I needed it to play some RPG game. Funny how
many geeks had amber. I was so sick of the green on the VT and Vulcan
boxes, I would sniff around for a tvi912c or tvi925 with it's baby blue.
And then, of course the VT2xx series came out with its amber and everything
was
[EMAIL PROTECTED] wrote:
SQL*Menu wasn't around in V5. IAP/IAG were there, and IAD came out in v5.1
(it was the first of the SQL*Forms). RPT/RPF were there too. And there was
something called SQL*Calc which I never used (cuz you could do anything you
i had to do a bunch with SQL*Calc because
I was s excited when I got my Hercules card! That computer was a 10 MHz
speed-monster with a gigantic 83 KB hard drive. And WOW, graphics with my
new Hercules card! I had such fun running stupid little programs that would
make a globe turn, not to mention being able to type in Arabic and
: Rollback Segments
[EMAIL PROTECTED] wrote:
SQL*Menu wasn't around in V5. IAP/IAG were there, and IAD came out in v5.1
(it was the first of the SQL*Forms). RPT/RPF were there too. And there was
something called SQL*Calc which I never used (cuz you could do anything you
i had to do
Title: RE: Rollback Segments
Does anyone have older copies of Oracle 4, and the equivalent version of forms? PVT Email me, please.
-Original Message-
From: Michael Kline [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 19, 2002 3:20 PM
To: Multiple recipients of list ORACLE-L
Hi Witold,
This is exactly the way it is documented to work. After each
commit you must reissue the
set transaction use rollback segment rbs_01
statement.
John
[EMAIL PROTECTED] wrote:
Hello DBAs
Is there a command that tells me which rollback segment is being
used by current
select r.name
from v$rollname r, v$session s, v$lock l
where r.usn = trunc(l.id1/65536)
and l.type = 'TX'
and l.sid = s.sid
and s.sid = the sid
--- Witold Iwaniec [EMAIL PROTECTED] wrote:
Hello DBAs
Is there a command that tells me which rollback
segment is being
used by current
Witold:
This will show which rollback segment is being used by a current transation.
(Also shows current sql as well as a time stamp. You can get rid of that
stuff if you don't need it.)
There's no way I know of to force a user to a particular rollback segment.
Barb
select
It's very simple: don't use rollback segments. Set up your UNDO_TABLESPACE
and let oracle handle it. If you use oracle managed datafiles, oracle will
create as much room as it needs. The parameters that you need to look at
are:
DB_CREATE_FILE_DEST
DB_CREATE_ONLINE_LOG_DEST_n
UNDO_MANAGEMENT
Holy cow Mladen, what a memory!
Does anybody else remember (or admit to) using UFI?
Jim
**
...does anybody still remember VAX/VMS, ORACLE$BI, IOR and ODT?...
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
UFI no, but the rest... that's where I started in Oracle -- version 5
--- Conboy, Jim [EMAIL PROTECTED] wrote:
Holy cow Mladen, what a memory!
Does anybody else remember (or admit to) using UFI?
Jim
**
...does anybody
HI All,
My first experience with Oracle was version 4 in a Computer Class in
1986 or 1987. The class was taught on a Harris Minicomputer and we
used UFI - User Friendly Interface to enter our queries. The thing I
remember the most was that if you issued a sql statement incorrectly and
I do. User Friendly Interface. Hush, don't tell anybody, but I started with
Oracle 4 on PC/XT with a huge, 20MB Winchester hard drive. The whole
machine has had a Hercules screen card (text only, no graphics) and 512KB
(no, it's not a mistake, it really is the letter K) of memory. I still
have
)
Subject: RE: Rollback Segments
to ORACLE-L
To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
cc: (bcc: CHITALE Hemant Krishnarao/IT/CHRT/ST Group)
Subject: RE: Rollback Segments
UFI no, but the rest... that's where I started in Oracle -- version 5
--- Conboy, Jim [EMAIL
-
From: Jared Still [mailto:[EMAIL PROTECTED]]
Sent: Sunday, September 30, 2001 12:40 AM
To: Multiple recipients of list ORACLE-L
Subject: Re: rollback segments during export
Chris,
Just because there is a PK/FK between tables, it does not
mean they will be
exported in the same transaction
Yes, under CONSISTENT=N they are exported as separate transactions, under
CONSISTENT=Y it is a large single transaction to keep read consistency
across the entire export. Hence the redo generated is similar to a large
report and read consistent views.
Do not criticize someone until you walked a
**
-Original Message-
From: Jared Still [mailto:[EMAIL PROTECTED]]
Sent: Sunday, September 30, 2001 12:40 AM
To: Multiple recipients of list ORACLE-L
Subject: Re: rollback segments during export
Chris,
Just because there is a PK/FK between tables, it does not
mean
Title: RE: rollback segments during export
-Original Message-
From: Jared Still [mailto:[EMAIL PROTECTED]]
Just because there is a PK/FK between tables, it does not
mean they will be
exported in the same transaction. And thus, possibly out of sync.
I didn't say
in this message are entirely mine
and do not reflect those of my employer or customers **
-Original Message-
From: Jared Still [mailto:[EMAIL PROTECTED]]
Sent: Sunday, September 30, 2001 12:40 AM
To: Multiple recipients of list ORACLE-L
Subject: Re: rollback segments during export
Chris,
Just because there is a PK/FK between tables, it does not mean they will be
exported in the same transaction. And thus, possibly out of sync.
I didn't say there was. My implication was that your
tables would get out of sync. Setting 'consistent=y'
won't prevent that:
: If you
Don, I hate to be a stick in the mud but there are some
things I think need to clarified.
I can think of no practical(?) use except for parallel server.
In parallel server an instance will aquire private rollback
segments specified in init.ora. If none (or too few) are
specified, it
I think that is essentially what I said ... with a lot less detail.
I seem to have muddied it up a bit by not saying but only for Oracle7.
The specific case in point for the first correction was indeed
Oracle7. Later, in the discussion of rollback segments, you say
that can't happen, then
Nixon,
While SET TRANSACTION can be used to assign a rollback
segment to a transaction, it cannot be assigned exclusively to
that transaction as you have found.
The ability to assign a rollback segment to a transaction and
make it read-only for all others is something I've wanted myself
for
On Wed, 9 May 2001,Jared Still scribbled on the wall in glitter crayon:
-
-Maybe 9i? Anyone know?
AFAIR, I heard that RBS go away in 9i.
--
Bill Thater Certifieable ORACLE DBA
Telergy, Inc.[EMAIL PROTECTED]
~~
You gotta
Kevin !
PRivate Rollback segments are coming in to picture
if you use Parallel Server (or Real APplication CLusters ??).
Basically it is assigned to a particular instance in case
of OPS and the other instance can NOT acquire that rollback
segments.
But the other instance Can READ from that
Hi all,
This brings me to a stupid question then. What is the true difference
between a public and a private rollback segment? Because if I just think
about it like a normal human being I would think that if a user made a
Private rollback segment then only that user could use it, but of
Hi !
Not very much. In 9i you have an option to have
AUTOMATIC_UNDO_MANAGEMENT where you specify a huge
undo tablespace and the undo is managed by oracle.
But you can still have the rollback segments.
Best Regards,
K Gopalakrishnan
Bangalore, INDIA
-Original Message-
William
Sent:
Kevin,
This is a common misconception.
On startup Oracle determines the number of rollback
segments to bring on line based on the init.ora
parameters:
TRANSACTIONS / TRANSACTIONS_PER_ROLLBACK_SEGMENT
If the number of rollback segments specified by
ROLLBACK_SEGMENTS is less than that
Isn't the concept of a private RBS only applicable to parallel server
setups?
- Mike.
-Original Message-
Sent: 09 May 2001 16:21
To: Multiple recipients of list ORACLE-L
Hi all,
This brings me to a stupid question then. What is the true
difference
between a public and a
Kev,
PUBLIC and PRIVATE Rollback segments are not specified for ALL or SPECIFIC
USER use. You can specify a certain transaction to use a specific rollback
segment, as stated in the post below. PUBLIC and PRIVATE Rollback Segments
have to do with the instances that utilize them. For example,
PROTECTED]
Subject: Re: Rollback Segments
Date: Wed, 09 May 2001 06:40:52 -0800
On Wed, 9 May 2001,Jared Still scribbled on the wall in glitter crayon:
-
-Maybe 9i? Anyone know?
AFAIR, I heard that RBS go away in 9i.
--
Bill Thater Certifieable ORACLE DBA
Telergy, Inc.[EMAIL
private rollback segments are used mostly with OPS... the rollback segment
is private to an instance (ie, unseen by the other instance(s))
From: Kevin Kostyszyn [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: Rollback
I can think of no practical(?) use except for parallel server.
In parallel server an instance will aquire private rollback
segments specified in init.ora. If none (or too few) are
specified, it will aquire public rollback segments. Public
rollback segments are, in my opinion, only useful in
What are the sizes init/next and what is OPTIMAL set at?
---
TheOracleDBA
[EMAIL PROTECTED]
On Thu, 05 Apr 2001 09:16:17
Nicoll, Iain (metering) wrote:
Can anyone tell me why we would get "unable to extend" errors in rollback
but the segments will shrink when done manually - I thought
Rollback segments do NOT shrink automatically when another rollback segment
needs space.
A rollback segment will shrink (and ONLY if OPTIMAL is set) if and only if
*it* needs to extend. so manual shrinks work fine, but automatic shrinks
only happen when the extended rollback segment needs to
57 matches
Mail list logo