Shrinking of rollback segments may result in ORA-1555s. If you need to shrink
them, do so during a slow time.
Not shrinking rollback segments may result in ORA-1562 unable to extend rbs.
"Satav, Pawan" wrote:
> Hi,
> Can anyone point pros/cons of shrinking a rollback segment ? (other
> tha
Daniel,
Thank you again. That clears it up even more. I'll wait for a quiet time and
then proceed.
Mike
-Original Message-
Sent: Monday, December 22, 2003 2:19 PM
To: Multiple recipients of list ORACLE-L
Mike,
When an RBS is taken offline, the undo information is not transfered to
ano
Mike,
When an RBS is taken offline, the undo information is not transfered to another
segment, hence the need to perform these actions at a quiet time. When an rbs
is taken offline, all transactions currently using the rbs are allowed to
complete (either commit or rollback). As these transactions
Daniel,
Thank-you very much for your clear answer. Very helpful. When a RBS is taken
off-line, does it transfer the rollback information to another segment?
Thanks,
Mike
-Original Message-
Sent: Monday, December 22, 2003 1:44 PM
To: Multiple recipients of list ORACLE-L
There is no nee
There is no need to drop the datafiles, just recreate the segments in the
current tablespace.
Pick a slow time to do this as you will significantly increase the likelihood
of 1555s.
1) Offline rbs1
2) Drop rbs1
3) create rbs1
4) Repeat steps 1 - 3 for all rbs2..rbsN.
5) When complete, resize data
c rollback segment, so the only way for us to do it is
to disable all except the one we want it to use.
-Mensaje original-
De: Lee Cullip [mailto:[EMAIL PROTECTED]
Enviado el: miércoles, 16 de julio de 2003 10:54
Para: Multiple recipients of list ORACLE-L
Asunto: RE: Rollback Segs
set trans
llback seg.
Cheers
Lee
-Original Message-From: Fermin Bernaus
[mailto:[EMAIL PROTECTED]Sent: 16 July 2003 11:19To:
Multiple recipients of list ORACLE-LSubject: RE: Rollback
Segs
Yes you are right, sorry but I made a mistake, since we
are using Baan IVc4 which works agai
do it is to
disable all except the one we want it to use.
-Mensaje original-De: Lee Cullip
[mailto:[EMAIL PROTECTED]Enviado el: miércoles, 16 de julio
de 2003 10:54Para: Multiple recipients of list
ORACLE-LAsunto: RE: Rollback Segs
set
transaction use rollback segment
t
me if I'm wrong).
Hope
this helps.
Cheers
Lee
-Original Message-From: Fermin Bernaus
[mailto:[EMAIL PROTECTED]Sent: 16 July 2003 09:09To:
Multiple recipients of list ORACLE-LSubject: RE: Rollback
Segs
Which database version are you using? as long as I know,
Which database version are you using? as long as I know, at
least on Oracle 8.0.6 you can not specify which rollback segment a particular
transaction should use. We disable all rollback segments and only enable those
which we know won't make big updates / deletes crash.
-Mensaj
Ave !
Is there any reason not to
keep maxextents always unlimited :) Extentsize should
be reasonable of
course.
Br.
Jorma
-Original Message-From: ext venkat Rama
[mailto:[EMAIL PROTECTED]Sent: 16 July, 2003 07:34To:
Multiple recipients of list ORACLE-LSubject: Rollback
Segs
Hi
alter rollback segment XXX storage (optimal null);
Regards
Jonathan Lewis
http://www.jlcomp.demon.co.uk
The educated person is not the person
who can answer the questions, but the
person who can question the answers -- T. Schick Jr
One-day tutorials:
http://www.jlcomp.demon.co.uk/tutori
Sometimes the extents should be larger (fewer larger extents, then many
small extents).
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Saturday, April 05, 2003 1:30 AM
> Yes, your assumption is right. Create new rollback
> segments without the
Dear Jonathan,
How are you my friend? Hope all is well with you and
your family in the UK. When we spoke to James Morle
last evening, he drew our attention to a B-52 flying
over his home. Interesting times we live in!
Yes, you are right in your observation, that "in
general" one does not have to
Yes, your assumption is right. Create new rollback
segments without the OPTIMAL clause, bring them
online, take the old ones offline, blow the old ones
away, document the new ones in your init.ora, remove
the old ones from your init.ora. See whether this
solves your problem. My guess is that you sh
Excellent advice, Gaja! Yes, we do have OPTIMAL set. From the docs I don't
see a way to remove the OPTIMAL setting once used. I assume this means new
RBSs?
Rich
Rich JesseSystem/Database Administrator
[EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA
In general, you don't need to do this in
recent versions of Oracle. Oracle knows
that all the data in the tablespace MUST
have been committed before the tablespace
was switched to read-only (you can only
switch a tablspace to readonly when there
are no active transactions that started before
th
Rich,
The overcommiting is a definite suspect and is worth
looking into. ALso, do you by chance have OPTIMAL set
on your rollback segments? If so, I'd suggest you
remove the OPTIMAL clause and try again. In my
experience, I have had my share of hassles with
OPTIMAL. Even when it was sized 'reasona
Rich
For what it's worth, here would be my priorities:
1. Ask the users to run the report at a different time. Maybe plot the
transactions over a 24-hour period to display better time. They won't like
this, and you may want to soften it with "until we get the application
modified".
2.
"Jesse, Rich" wrote:
>
> Hey all,
>
> Fighting with a lot of ORA-1555s lately on 8.1.7.4 on HP/UX. Most of them
> are now coming from long-running Business Objects (B.O.) queries against our
> OLTP DB. I think I need to recreate the RBS tablespace (currently 1MB
> extents in LMT), but until I c
ak,
Here is a query you can run to see if it is currently in use...
SQL> select b.segment_name, a.xacts, a.shrinks, a.wraps, a.extends
2 from v$rollstat a, dba_rollback_segs b
3 where a.usn = b.segment_id
4 /
SEGMENT_NAMEXACTSSHRINKS WRAPSEXTENDS
---
You can take the rollback segment offline. It will not impact any currently
running transactions and no new transactions will be assigned to it. Oracle
will not let you drop a rollback segment while there are any active transactions
writing undo to the rollback segment. IIRC, the v$rollstat.sta
AK
Sometime when your system isn't at its peak, just take the segment
offline. Then wait a little while and check the status. Oracle won't take
the segment offline as long as active processes are using it. Oracle won't
let you drop it until it is able to take it offline.
Dennis Williams
DBA,
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 y
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.
---
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
read-cons
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 yo
Zhu Chao,
Please be aware that rollback segments serve two major purposes:
* recover individual transactions (i.e. rollback)
* provide before-image information for read-consistency
The information you are getting from V$ROLLSTAT and STATSPACK is accurate at
measuring the first purpose on
3 options
1. if possible , put a commit in your procedure to reduce load on rollback
segs
2. ask your dba to increase size of rollback segments. Since rollback
segment allocation is random, u may have to drop the smaller rbs segs and
create new larger segs
3. increase the maxextents of existing rb
Hi Kevin,
Fantastic, thx, just what I was looking for, will event tell the oracle
support person that could not even assist.
George
George Leonard
Oracle Database Administrator
Dimension Data (Pty) Ltd
(Reg. No. 1987/006597/07)
Tel: (+27 11) 575 0
George,
Try this query and check for average_active
select ud.name,
sg.extents ext,
round(sg.blocks * ts.blocksize / 1048576, 2) MB,
round(s.optsize / 1048576, 1) optsize,
round(s.aveactive / 1048576, 1) AVEACT,
round(s.hwmsize / 1048576, 1) HWMSIZE,
s.shrinks
SELECT
r.NAME, -- rbs name
s.sid,
s.serial#,
s.username,
s.machine,
t.status,
t.cr_get, -- consistent gets
t.phy_io, -- physical IO
t.used_ublk, -- Undo blocks used
t.noundo, -- Is a noundo transaction
SUBSTR (s.program, 1, 78) "COMMAND",
s.username "DB User",
t
Use used_ublk, used_urec from v$transaction. You will need to join to
v$session to get the session info.
USED_UBLK USED_UREC
-- --
12918
-Original Message-
Sent: Wednesday, October 23, 2002 11:02 AM
To: Multiple recipients of list ORACLE-L
Hi all,
Try
Why do you think it is "fragmented"?
Why do you think it is a problem?
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Monday, October 07, 2002 10:36 AM
> Hi
> My rollback tablespace is highly fragmented.I am thinking to do like
> following?
before you do all this by fragmented do you mean that there are a
large number of free extents in the tablespace?
If so, are those extents all the same size or at least a multiple of
the same size?
If so, why are you bothering to defragment?
You would only need to defragment the rollback
And you may well use Logminer to determine what that exact point in time is (and then
use tablespace point in time recovery to do the actual recovery).
Bruce Reardon
-Original Message-
Sent: Thursday, 29 August 2002 2:52
There is a way of undoing DDL and it is described in the RMAN man
9 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Re: Rollback !
>
>
> Alexandre - Thanks for posting the link. I read the document.
> It describes
> how to track the DDL statements. Unless I overlooked
> something, it doesn't
> say you can UNDO DDL. I
Oracle definitely *does* generate redo and undo for DDL. The reason you
can't roll back a DDL statement is that each DDL "statement" is actually
a macro for a sequence of DML statements on the data dictionary; that
sequence of DML statements ends in a COMMIT. You cannot roll back a
committed trans
Alexandre - Thanks for posting the link. I read the document. It describes
how to track the DDL statements. Unless I overlooked something, it doesn't
say you can UNDO DDL. I think the reason was explained earlier on this post,
that Oracle doesn't write any redo records. For example, in the case of
For 9i:
http://otn.oracle.com/docs/products/oracle9i/doc_library/901_doc/server.901/
a90117/logminer.htm#18681
For 8i not sure. Has anyone tried DROP undo in 8i? (8i docs are very poor on
LogMiner)
Alexandre
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED
Alexandre Gorbatchev,
As far as i know, you cannot recover from drop using logmnr.It is internal dml to
data dictionary, maybe in 9i it will work, i am not sure.But in 8i, it won't work.
Regards
zhu chao
Eachnet DBA
86-21-32174588-667
[EMAIL PROTECTED]
=== 2002-08-28
> 1.) Can we rollback a drop statement ?
No. However, you can use Log Miner.
Alexandre
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Alexandre Gorbatchev
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, Califor
The long answer is: no.
> -Original Message-
> From: guess who [mailto:[EMAIL PROTECTED]]
> Sent: Monday, August 26, 2002 11:44 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Rollback !
>
>
> 1.) Can we rollback a drop statement ?
>
> for example : drop table emp;
>
> i want
guess who,
hi,
1. Rollback can only rollback dml statement,while drop is a ddl statement,so it is
impossible. To recover from a drop statement, you have to do incomplete recovery. Or
maybe you will try tablespace in time recovery.Or if data is not that important, do
imp from a backup.
Prakash,
1. You cannot rollback a drop statement.
2. I haven't installed 9i on XP but I have read that it can be done.
Suhen
1.) Can we rollback a drop statement ?
for example : drop table emp;
i want to recover this table in a easiest way
rule 4 ALWAYS applies.. no matter what version of the database :)
--- Don Granaman <[EMAIL PROTECTED]> wrote:
> As far as I know, the jury is still out - I haven't had a chance yet
> to see
> if (a) the problems Dan found in 9.0.1.1 are fixed and (2) I like the
> way it
> works. Also, it does r
As far as I know, the jury is still out - I haven't had a chance yet to see
if (a) the problems Dan found in 9.0.1.1 are fixed and (2) I like the way it
works. Also, it does require 9i and I'm not yet ready to go there with
everything. Even with 9i and system managed undo, rule #4 will still be
Don,
9i has system managed undo -- you don't think it works yet?
Rachel
--- Don Granaman <[EMAIL PROTECTED]> wrote:
> I prefer to have OPTIMAL set and deal with "long running large
> transactions"
> another way - setting "OPTIMAL" on the developers! Granted, this
> doesn't
> work for 3rd part
I prefer to have OPTIMAL set and deal with "long running large transactions"
another way - setting "OPTIMAL" on the developers! Granted, this doesn't
work for 3rd party products, but I usually deal with in-house applications.
Getting this to work requires: (1) having enough rollback segments, (2)
cool! thanks!
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, June 27, 2002 10:28 PM
> I do the same thing. No optimal setting, manual (automated job) shrinking
of
> rollback segments when database has no DML activity (mostly just bef
I do the same thing. No optimal setting, manual (automated job) shrinking of
rollback segments when database has no DML activity (mostly just before
midnight). No ORA-1555 in several years now.
About the space for rollback, we are very generous. Tom Kyte explains this
very well in his wonderful b
Tim,
I rebuilt the rollback segments without OPTIMAL in one case because the
shrinks were causing ORA-1555's at bad times. I have a procedure that
is scheduled via DBMS_JOBS to manually shrink the rollback segments to a
preset size. This runs at what we have found is a relatively quiet time
an
I personally prefer to have it set, but I think the
reasoning against setting it has to do with allowing rollback segments to "find
themselves"... :-)
In other words, it is based on the idea that space
allocation (and deallocation) for rollback segment extents is unnecessary and
harmful.
Title: RE: Rollback segment shrinks
Terry,
This query will tell you which process is using which rollback segment, maybe
that'll help you backtrack to find out what's going on.
column "Oracle UserName" FORMAT a15
column "RBS Name" format a15
select r.name &qu
Alternately run this querry to check which rollback segments are in use...
set linesize 120
select substr(a.os_user_name,1,8) "OS User"
, substr(b.object_name,1,30) "Object Name"
, substr(b.object_type,1,8) "Type"
, substr(c.segment_name,1,10) "RBS"
, e.process "PROCESS"
, substr(d.used_urec,1,8)
Title: RE: Rollback segment shrinks
Terry,
This query will tell you which process is using which rollback segment, maybe
that'll help you backtrack to find out what's going on.
column "Oracle UserName" FORMAT a15
column "RBS Name" format a15
select r.name &qu
The rollback segment will not shrink if there are active transactions in
the rollback segment i.e xacts >0 in v$rollstat for that rollback segment.
Check out which transaction is using the rollback segments using
v$transaction where XIDUSN = usn from v$rollname. The ses_addr in
v$transaction shoul
Terry,
What do you have "optimal" set to? I believe shrink only shrinks to the optimal size.
Jim
"Ball, Terry" <[EMAIL PROTECTED]> wrote:
>Oracle 8.1.6.3 on Sun Solaris 2.6.
>
>The rollback tablespace filled up last night and the rollback segments
>became full. I added space to the tablespac
Terry,
Can you see if there are any session(s) (runaway or not) that might be
causing your rollback segments to fill up? Until you can figure out what
sessions are filling up the rollbacks you will be stuck adding more space
until those session(s) end.
Bryan
-Original Message-
Sent: Wed
I find that not setting OPTIMAL seems to be optimal.
Jared
"Sinardy Xing" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
06/02/2002 09:53 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject:Rollback Se
>
>Hi Stephane,=0D
>=0D
>I run the script and I have =0D
>=0D
>OPTIMAL =3D 5 * ceil(max(v$rollstat.aveactive) / 4
>/ sys.ts$.blocksize)* sy=
>s.ts$.blocksize / 1024 =0D
>=0D
>the result is 0 K for my optimal. : )=0D
>=0D
>regards,=0D
>Sinardy=0D
Probably not enough significant activity. It tries
>
>Thanks man,=0D
>=0D
>I mean the minimum optimal size base on the maximum
>transaction size, So th=
>e HWM is the answer ?=0D
>=0D
>=0D
>Sinardy=0D
>=0D
Depends. If activity was 'normal', yes (if HWM is about the same for all RS, you can
be fairly confident with the value). If somebody has ru
Hi Stephane,
I run the script and I have
OPTIMAL = 5 * ceil(max(v$rollstat.aveactive) / 4 / sys.ts$.blocksize)*
sys.ts$.blocksize / 1024
the result is 0 K for my optimal. : )
regards,
Sinardy
-Original Message-
Sent: 03 June 2002 16:53
To: Multiple recipients of list ORACLE-L
Thanks man,
I mean the minimum optimal size base on the maximum transaction size, So the HWM is
the answer ?
Sinardy
-Original Message-
Sent: 03 June 2002 16:53
To: Multiple recipients of list ORACLE-L
>
>Hi all,=0D
>=0D
>How to find out the smallest (minimal) transaction
>size from
>
>Hi all,=0D
>=0D
>How to find out the smallest (minimal) transaction
>size from Dictionary vie=
>w or base tables =0D
>I try to set my OPTIMAL rollback segment base on
>smallest transaction size =
>to prevent ora-1555. since shrinking rollback
>segments may cause ora-1555.=
>=0D
>=0D
>=0D
>Thank
I figured you were, but I didn't want someone to mistakenly get the idea
that
it somehow made copying legal... :-). In fact, I'm not sure whats going to
happen at this point
RF
Robert G. Freeman - Oracle8i OCP
Oracle DBA Technical Lead
CSX Midtier Database Administration
The Cigarette Smoki
I'm just joking with you...
-Original Message-
Sent: Thursday, March 28, 2002 4:25 PM
To: Multiple recipients of list ORACLE-L
<>
Of course not!! :-(
Robert G. Freeman - Oracle8i OCP
Oracle DBA Technical Lead
CSX Midtier Database Administration
The Cigarette Smoking Man: Anyone who c
<>
Of course not!! :-(
Robert G. Freeman - Oracle8i OCP
Oracle DBA Technical Lead
CSX Midtier Database Administration
The Cigarette Smoking Man: Anyone who can appease a man's conscience can
take his freedom away from him.
-Original Message-
Sent: Thursday, March 28, 2002 3:44 PM
To:
Thanks for the FYI.
Do you have any details as to why they are closing up shop? I thought there
Exam Cram and Black books were popular
Does this mean we can freely copy these books now??
-Original Message-
Sent: Thursday, March 28, 2002 3:08 PM
To: Multiple recipients of list O
Alternately run following script and set your optimal nearest to HWMSIZE as
a start. It requires a lot of monitoring to set optimal according to your
application requirement.
select ud.name,
sg.extents ext,
round(sg.blocks * ts.blocksize / 1048576, 2) MB,
round(s.optsize /
Anyone here write books for Coriolis? They are closing up
shop effective today. No more Exam Crams, black books, etc...
RF
Robert G. Freeman - Oracle8i OCP
Oracle DBA Technical Lead
CSX Midtier Database Administration
The Cigarette Smoking Man: Anyone who can appease a man's conscience can
take
Keep the rollback segments out of the cold water. Shrinkage is bad.
Scott Shafer
San Antonio, TX
210-581-6217
"Common sense will not accomplish great things. Simply become insane and
desperate."
> -Original Message-
> From: Seema Singh [SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, March
Don't specify "OPTIMAL" parameter for rollback segment.
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, March 28, 2002 1:38 PM
> Hi
> I am looking lot of shrinkage in rollback segment.please sug
place & time that could top both Cannes and
Amsterdam.
-Original Message-
From: Mogens Nørgaard[mailto:[EMAIL PROTECTED]]
Sent: Saturday, February 23, 2002 10:33PM
To: Multiple recipients of list ORACLE-L
Subject: Re: Rollback Segments
And I
annes and
Amsterdam.
-Original Message-From: Mogens Nørgaard
[mailto:[EMAIL PROTECTED]]Sent: Saturday, February 23, 2002 10:33
PMTo: Multiple recipients of list ORACLE-LSubject: Re:
Rollback SegmentsAnd I'm sitting at my (the) oaktable
right now thinking about a few t
r Manufacturing LtdRachel Carmichael <[EMAIL PROTECTED]> 19/02/2002 06:18 AMSent by: [EMAIL PROTECTED]Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L
<[EMAIL PROTECTED]>
cc: (bcc: CHITALE Hemant Krishnarao/IT/CHRT
Chartered Semiconductor Manufacturing Ltd
> >
> >
> > Rachel Carmichael <[EMAIL PROTECTED]> 19/02/2002 06:18 AM
> > Sent by: [EMAIL PROTECTED]
> >
> > Please respond to ORACLE-L
> >
> > To: Multiple recipients of li
t;
> > 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
> >
> >
> >
age) file, IOR and ODS in Oracle 5.
> >
> > Hemant K Chitale
> > Principal DBA
> > Chartered Semiconductor Manufacturing Ltd
> >
> >
> > Rachel Carmichael <[EMAIL PROTECTED]> 19/02/2002 06:18 AM
> > Sent by: [EMAIL PROTECTED]
> >
&g
nd 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
> >
> >
> >
> >
> >
> >
&g
ease 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
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: http:/
age) file, IOR and ODS in Oracle 5.
> >
> > Hemant K Chitale
> > Principal DBA
> > Chartered Semiconductor Manufacturing Ltd
> >
> >
> > Rachel Carmichael <[EMAIL PROTECTED]> 19/02/2002 06:18 AM
> > Sent by: [EMAIL PROTECTED]
> >
&g
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
ist ORACLE-L
> Subject: Re: 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 calle
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 se
[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 beca
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
>
> 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
or Manufacturing Ltd
>
>
> Rachel 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: CHITAL
or Manufacturing Ltd
>
>
> Rachel 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: CHIT
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 te
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
ab
Manufacturing Ltd
>
>
> Rachel 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 Kris
nt Krishnarao/IT/CHRT/ST Group)
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
>
>
HRT/ST Group)
Subject: RE: Rollb
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
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
rece
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
>
> **
>
> ...doe
1 - 100 of 241 matches
Mail list logo