Re: Sending email from Unix
I use uuencode in a AIX 4.3.2 environment, see below... # cat | uuencode | mail Thanks, cj "Sona" il.com> cc: Sent by: Subject: Sending email from Unix [EMAIL PROTECTED] om 02/01/2002 02:06 PM Please respond to ORACLE-L Hi I want to send an email from Unix with an attachment .does anyone know how to do this? TIA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Casey Jorda INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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 you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Database Performance Question
You may want to look at using materialized views. They are easy to setup and can be refreshed manualy or automaticaly. Thanks, cj SRAJENDRAN@nlf s.comTo: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent by: cc: [EMAIL PROTECTED] Subject: Database Performance Question om 01/29/2002 10:25 AM Please respond to ORACLE-L Hello all: We have an application that is having slow response time against an 8i database, I would like to improve the response time. This is a web based application accessing the database with about 2000 users. Most of the application queries are based on complex joins on 4 big tables with each having over 5 million rows( biggest table has 18 million rows). I have tuned the Package queries for the best explain plan possible, but still do not seem to make dramatic change in the response time. Though, I was able to make significant headway tuning these packages by bringing down response times from 7 minutes to under 3 minutes. But this is not an acceptable response time from a web-application perspective. I am considering creating data cubes based on the most frequently used join conditions and pre-populate them on a nightly basis or use triggers to update the cube simultaneously. I am hoping that this enhance the response times. I would greatly appreciate your suggestions or opinions on this idea. If you have an alternative/better way of achiving this please enlighten me. Thank very much. Srini Rajendran. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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 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.com -- Author: Casey Jorda INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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 you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: How to prevent Oracle 9i for Windows from starting?
Use the Oracle Admin Assistant for Windows NT. It will make all the necessary changes to the registry. Csillag Zsolt rware.hu>cc: Sent by: Subject: How to prevent Oracle 9i for Windows from starting? [EMAIL PROTECTED] om 01/12/2002 10:05 AM Please respond to ORACLE-L Hi, How can I prevent Oracle 9i (for Windows) to start automatically at Windows startup? I want Oracle to start _only_ when I want to ( as the Oracle under Linux). Thank you in advance Zsolt Csillag, Hungary -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Csillag Zsolt INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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 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.com -- Author: Casey Jorda INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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 you want to be removed from). You may also send the HELP command for other information (like subscribing).
Rollback Question
Is there anyway to find out if a long running concurrent program is rolling back its transactions? Thanks Casey