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 difference

RE: Oracle Enterprise vs Standard

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

Which process is taking up so much CPU???

! 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 hosting services

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

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 Berraondo INET: [EMAIL

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

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 - To REMOVE yourself from this mailing list, send

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

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.fatcity.com San

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 taking up so

RE: how to calculate table size

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

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-- Mailing list and web hosting services

RE: Virus.

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

Cannot allocate new log - checkpoint not complete

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

RE: Cannot allocate new log - checkpoint not complete

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

RE: Cannot allocate new log - checkpoint not complete

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] wrote: I think I am

RE: Cannot allocate new log - checkpoint not complete

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

RE: Cannot allocate new log - checkpoint not complete

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 Berraondo [EMAIL