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
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, at least
.A.
[EMAIL PROTECTED]
http://www.sammic.com
Telf. +34 - 943 157 331
Fax +34 - 943 151 276
.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Fermin Bernaus
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538
using some sort of RAID device (or don't you have your logical drives
striped across your physical drives)?
There is no easy answer to your question without an understanding of the
reality of your disk layout.
"Fermin Bernaus"
(note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: htt
on (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Fermin Bernaus
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list yo
Well I am quite de-motivated actually!! but at least
it is good to know I was (partially) wrong and that I will feel safer after
reading your comments, thanks!
I am really in doubt now, but I remember when we were
testing we did recover all datafiles (the ones that are stated in t
I've been reading your messages with much interest. I have
some experience with database administration and I have done many tests, but
I've not tried what I am going to expose in this message, maybe you can help. We
do cold backups on a regular basis (every weekend) then just backup th
for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Fermin Bernaus
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hostin
you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Fermin Bernaus
INET: [EMAIL PROTECTED]
Fat City Network Services--
rafaq.net
--
Author: Fermin Bernaus
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this m
different from who you
are logged into SQL*Plus as?
The explanation might be that, through some reason like synonyms pointing in
different directions from the different accounts, the name TTDSLS805501
might be resolving to different tables altogether...
on 9/9/03 10:09 AM, Fermin Bernaus at
orafaq.net
--
Author: Fermin Bernaus
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from th
documented behavior of the CHAR datatype. Use
VARCHAR2 instead if you wish to avoid those pitfalls.
Hope this helps...
-Tim
on 9/10/03 3:29 AM, Fermin Bernaus at [EMAIL PROTECTED] wrote:
>
> Thank you all of you who answered to my first question.
>
> No, the problem has nothing to do
or your answers!
Fermin.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Fermin Bernaus Berraondo
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web h
ded that I only see his PID with the TOP command? I only see the oracle
process, but I don't know how to get the username and the SQL beside him.
Thank you for your answers!
Fermin.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Fermin Bernaus Berr
e the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Fermin Bernaus Berraondo
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
ut I don't know how to get the username and the SQL beside him.
Thank you for your answers!
Fermin.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Fermin Bernaus Berraondo
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.
I just found that v$session.paddr = v$process.addr is the join that has to be
done. Right?
-Mensaje original-
De: Fermin Bernaus Berraondo [mailto:[EMAIL PROTECTED]
Enviado el: lunes, 31 de marzo de 2003 18:01
Para: '[EMAIL PROTECTED]'
Asunto: RE: Which process is ta
n (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Fermin Bernaus Berraondo
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
rom). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Fermin Bernaus Berraondo
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-5
om). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Fermin Bernaus Berraondo
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Die
o. de Informática
SAMMIC, S.A.
[EMAIL PROTECTED]
http://www.sammic.com
Telf. +34 - 943 157 331
Fax +34 - 943 151 276
..
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Fermin Bernaus Berraondo
INET: [EMAIL PROTECTED]
Fat City Ne
your understanding that, for your own protection and ours, we must decline
all legal responsibility for the validity of the statements and comments
given above.
-Ursprüngliche Nachricht-
Von: Fermin Bernaus Berraondo [mailto:[EMAIL PROTECTED]
Gesendet: Donnerstag, 3. April 2003 10:04
An: Mul
redo cannot be
recycled until the checkpoint has completed flushing
out the cache.
A *workaround* is to add redo log (size or number) but
its really a heads-up about your I/O subsystem not
being up to keep up under stress.
hth
connor
--- Fermin Bernaus Berraondo <[EMAIL PROTECTED]>
wrot
ments
given above.
-Ursprüngliche Nachricht-
Von: Fermin Bernaus Berraondo [mailto:[EMAIL PROTECTED]
Gesendet: Donnerstag, 3. April 2003 10:04
An: Multiple recipients of list ORACLE-L
Betreff: Cannot allocate new log - checkpoint not complete
I think I am having problems wi
ld free up redo 1 is not yet finished.
Thus its not a single redo log that is the problem -
the IO rate of the checkpoint is not sufficient quick
to avoid the redo cycling around...If one of your
redo's is on common datafile disk, this could
contribute to this
hth
connor
--- Fermin Bernaus Be
Just substract one to the other and that's
it.
Regards,
Fermin.
-Mensaje original-De: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]En nombre de Santosh VarmaEnviado
el: lunes, 10 de marzo de 2003 11:39Para: Multiple recipients
of list ORACLE-LAsunto: Date differe
y
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Fermin Bernaus Berraondo
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- M
30 matches
Mail list logo