RE: Rollback Segs

  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

RE: Rollback Segs

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

TOAD vs BMC's XRAY

.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

RE: Multiple Datafiles and performance?

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"

RE: Change based recovery

(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

RE: Multiple Datafiles and performance?

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

RE: Multiple Datafiles and performance?

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

RE: Change based recovery

      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

RE: Change based recovery

      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

RE: Semaphore problem

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

RE: Change based recovery

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--

ORA-01403 error, help!!!

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

Weird behavior with VARCHAR fields (was: ORA-01403 error, help!!!)

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

RE: Replication in Oracle RDBMS

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

RE: Weird behavior with VARCHAR fields (was: ORA-01403 error,

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

Which process is taking up so much CPU???

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

RE: Which process is taking up so much CPU???

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

RE: Which process is taking up so much CPU???

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

RE: Which process is taking up so much CPU???

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.

RE: Which process is taking up so much CPU???

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

RE: how to calculate table size

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 -

RE: how to calculate table size

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

RE: Virus.

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

Cannot allocate new log - checkpoint not complete

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

RE: Cannot allocate new log - checkpoint not complete

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

RE: Cannot allocate new log - checkpoint not complete

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

RE: Cannot allocate new log - checkpoint not complete

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

RE: Cannot allocate new log - checkpoint not complete

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

RE: Date difference function

      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

RE: Oracle Enterprise vs Standard

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