RE: Linux file locking question (semi-off topic)
Alright, I sent out a totally innocent question to the list and didn't get a single suggestion. I'm very disappointed in you people. So, let me say that I figured it out without your help. And I ain't saying what I did. So there. PPPHHT!!! -- Walt (my RAM disk is working great) Weaver Bozeman, Montana -Original Message- Sent: Thursday, November 08, 2001 10:39 AM To: Multiple recipients of list ORACLE-L Okay, this doesn't have much to do with Oracle other than the fact that I have been assigned with figuring out why this problem is occurring. We have a live chat application on Linux that uses Tomcat to manage its java servlets. A log is written to by the java processes, and this log can get rather large. Problem is, these java processes keep some sort of a write lock on the log and we can't clear the log out. Using lsof, I can get a listing of the java processes holding a lock on the log. One such process looks like this: java 32180 root6w REG 48,1 186487009 18036 /usr/local/pkg/tomcat/tomcat-3.2.3/logs/servlet.log Bottom line is, how can I clear these write locks without killing the java processes? Somebody must know how. I couldn't possibly the first person on earth to encounter this problem. Thanks, --Walt (learnin about chattr()) Weaver Bozeman, Montana -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Weaver, Walt 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: Weaver, Walt 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: Linux file locking question (semi-off topic)
Walt, but but but.. I didn't know the answer. I didn't even really understand the question! PLEASE tell me the answer, please? Pretty please? Pretty please with whipped cream and TWO maraschino cherries on top? Rachel --- "Weaver, Walt" <[EMAIL PROTECTED]> wrote: > Alright, I sent out a totally innocent question to the list and > didn't get a > single suggestion. I'm very disappointed in you people. > > So, let me say that I figured it out without your help. > > And I ain't saying what I did. > > So there. PPPHHT!!! > > -- Walt (my RAM disk is working great) Weaver >Bozeman, Montana > > -Original Message- > Sent: Thursday, November 08, 2001 10:39 AM > To: Multiple recipients of list ORACLE-L > > > Okay, this doesn't have much to do with Oracle other than the fact > that I > have been assigned with figuring out why this problem is occurring. > > We have a live chat application on Linux that uses Tomcat to manage > its java > servlets. A log is written to by the java processes, and this log can > get > rather large. > > Problem is, these java processes keep some sort of a write lock on > the log > and we can't clear the log out. Using lsof, I can get a listing of > the java > processes holding a lock on the log. One such process looks like > this: > > java 32180 root6w REG 48,1 186487009 18036 > /usr/local/pkg/tomcat/tomcat-3.2.3/logs/servlet.log > > Bottom line is, how can I clear these write locks without killing the > java > processes? Somebody must know how. I couldn't possibly the first > person on > earth to encounter this problem. > > Thanks, > --Walt (learnin about chattr()) Weaver > Bozeman, Montana > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Weaver, Walt > 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: Weaver, Walt > 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). __ Do You Yahoo!? Find a job, post your resume. http://careers.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael 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: Linux file locking question (semi-off topic)
and chocolate obviously !! -Original Message- Sent: 09 November 2001 13:31 To: Multiple recipients of list ORACLE-L Walt, but but but.. I didn't know the answer. I didn't even really understand the question! PLEASE tell me the answer, please? Pretty please? Pretty please with whipped cream and TWO maraschino cherries on top? Rachel --- "Weaver, Walt" <[EMAIL PROTECTED]> wrote: > Alright, I sent out a totally innocent question to the list and > didn't get a > single suggestion. I'm very disappointed in you people. > > So, let me say that I figured it out without your help. > > And I ain't saying what I did. > > So there. PPPHHT!!! > > -- Walt (my RAM disk is working great) Weaver >Bozeman, Montana > > -Original Message- > Sent: Thursday, November 08, 2001 10:39 AM > To: Multiple recipients of list ORACLE-L > > > Okay, this doesn't have much to do with Oracle other than the fact > that I > have been assigned with figuring out why this problem is occurring. > > We have a live chat application on Linux that uses Tomcat to manage > its java > servlets. A log is written to by the java processes, and this log can > get > rather large. > > Problem is, these java processes keep some sort of a write lock on > the log > and we can't clear the log out. Using lsof, I can get a listing of > the java > processes holding a lock on the log. One such process looks like > this: > > java 32180 root6w REG 48,1 186487009 18036 > /usr/local/pkg/tomcat/tomcat-3.2.3/logs/servlet.log > > Bottom line is, how can I clear these write locks without killing the > java > processes? Somebody must know how. I couldn't possibly the first > person on > earth to encounter this problem. > > Thanks, > --Walt (learnin about chattr()) Weaver > Bozeman, Montana > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Weaver, Walt > 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: Weaver, Walt > 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). __ Do You Yahoo!? Find a job, post your resume. http://careers.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael 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). The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robertson Lee - lerobe 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 containi
RE: Linux file locking question (semi-off topic)
OK... it's 42! Nice kitty... -Original Message- Sent: Friday, November 09, 2001 6:31 AM To: Multiple recipients of list ORACLE-L Walt, but but but.. I didn't know the answer. I didn't even really understand the question! PLEASE tell me the answer, please? Pretty please? Pretty please with whipped cream and TWO maraschino cherries on top? Rachel --- "Weaver, Walt" <[EMAIL PROTECTED]> wrote: > Alright, I sent out a totally innocent question to the list and > didn't get a > single suggestion. I'm very disappointed in you people. > > So, let me say that I figured it out without your help. > > And I ain't saying what I did. > > So there. PPPHHT!!! > > -- Walt (my RAM disk is working great) Weaver >Bozeman, Montana > > -Original Message- > Sent: Thursday, November 08, 2001 10:39 AM > To: Multiple recipients of list ORACLE-L > > > Okay, this doesn't have much to do with Oracle other than the fact > that I > have been assigned with figuring out why this problem is occurring. > > We have a live chat application on Linux that uses Tomcat to manage > its java > servlets. A log is written to by the java processes, and this log can > get > rather large. > > Problem is, these java processes keep some sort of a write lock on > the log > and we can't clear the log out. Using lsof, I can get a listing of > the java > processes holding a lock on the log. One such process looks like > this: > > java 32180 root6w REG 48,1 186487009 18036 > /usr/local/pkg/tomcat/tomcat-3.2.3/logs/servlet.log > > Bottom line is, how can I clear these write locks without killing the > java > processes? Somebody must know how. I couldn't possibly the first > person on > earth to encounter this problem. > > Thanks, > --Walt (learnin about chattr()) Weaver > Bozeman, Montana > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Weaver, Walt > 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: Weaver, Walt > 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). __ Do You Yahoo!? Find a job, post your resume. http://careers.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael 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: Orr, Steve 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: Linux file locking question (semi-off topic)
well duh the answer to EVERYTHING is 42 --- "Orr, Steve" <[EMAIL PROTECTED]> wrote: > OK... it's 42! Nice kitty... > > > > -Original Message- > Sent: Friday, November 09, 2001 6:31 AM > To: Multiple recipients of list ORACLE-L > > > Walt, > > but but but.. I didn't know the answer. I didn't even really > understand > the question! PLEASE tell me the answer, please? Pretty please? > Pretty > please with whipped cream and TWO maraschino cherries on top? > > Rachel > > --- "Weaver, Walt" <[EMAIL PROTECTED]> wrote: > > Alright, I sent out a totally innocent question to the list and > > didn't get a > > single suggestion. I'm very disappointed in you people. > > > > So, let me say that I figured it out without your help. > > > > And I ain't saying what I did. > > > > So there. PPPHHT!!! > > > > -- Walt (my RAM disk is working great) Weaver > >Bozeman, Montana > > > > -Original Message- > > Sent: Thursday, November 08, 2001 10:39 AM > > To: Multiple recipients of list ORACLE-L > > > > > > Okay, this doesn't have much to do with Oracle other than the fact > > that I > > have been assigned with figuring out why this problem is occurring. > > > > We have a live chat application on Linux that uses Tomcat to manage > > its java > > servlets. A log is written to by the java processes, and this log > can > > get > > rather large. > > > > Problem is, these java processes keep some sort of a write lock on > > the log > > and we can't clear the log out. Using lsof, I can get a listing of > > the java > > processes holding a lock on the log. One such process looks like > > this: > > > > java 32180 root6w REG 48,1 186487009 18036 > > /usr/local/pkg/tomcat/tomcat-3.2.3/logs/servlet.log > > > > Bottom line is, how can I clear these write locks without killing > the > > java > > processes? Somebody must know how. I couldn't possibly the first > > person on > > earth to encounter this problem. > > > > Thanks, > > --Walt (learnin about chattr()) Weaver > > Bozeman, Montana > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Weaver, Walt > > 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: Weaver, Walt > > 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). > > > __ > Do You Yahoo!? > Find a job, post your resume. > http://careers.yahoo.com > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Rachel Carmichael > 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: Orr, Steve > 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 subscrib
RE: Linux file locking question (semi-off topic)
NOTE. According to Tony Jambu author of "Oracle's New Pricing, Oracle 9i Features and Some Good Utilities" article in the 4qtr 2001 issue of Select. Page 42 (ironic about the page number) "The answer is 50 not 42 (for those HGTTG fans, you know what I mean)." Just another spin in the galaxy. ROR mô¿ôm >>> [EMAIL PROTECTED] 11/09/01 01:28PM >>> well duh the answer to EVERYTHING is 42 --- "Orr, Steve" <[EMAIL PROTECTED]> wrote: > OK... it's 42! Nice kitty... > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers 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: Linux file locking question (semi-off topic)
(Acually 4X10 is THE answer for us. Walt's on a 4X10-4-days-off weekend and is probably flying around somewhere as I write. We have a 4X10 schedule and we get to arrange the days to maximize our weekends. Hmmm... I was the one who made out the schedule so how is it that Walt got the 4 day weekend? Oh well, I get a 3 dayer for my B-Day next Friday.) ANYWAY... We got the RAM disk running just fine but we haven't developed any comparative benchmarks just yet. We have this home built utility and Walt used it to simulate 1,000 users doing stuff a couple of days ago. (The utility was called "pounder" but has been enhanced and renamed to "hell bore.") We loaded sample data from one of our largest sites for our first "test" and everything worked fine even when we submitted a "report from hades" with a query that returns 2.2 million rows. (Don't ask!) For a first pass we put the redo on the RAM disk together with a tablespace dedicated to some particularly busy indexes. Maybe we'll get some time to be more thorough about this and do some before and after comparisons but probably not... NUMBERS! We need numbers! Sigh... Will keep you advised on this. Clueless in Montana, Steve Orr -Original Message- Sent: Friday, November 09, 2001 11:28 AM To: Multiple recipients of list ORACLE-L well duh the answer to EVERYTHING is 42 --- "Orr, Steve" <[EMAIL PROTECTED]> wrote: > OK... it's 42! Nice kitty... > > > > -Original Message- > Sent: Friday, November 09, 2001 6:31 AM > To: Multiple recipients of list ORACLE-L > > > Walt, > > but but but.. I didn't know the answer. I didn't even really > understand > the question! PLEASE tell me the answer, please? Pretty please? > Pretty > please with whipped cream and TWO maraschino cherries on top? > > Rachel > > --- "Weaver, Walt" <[EMAIL PROTECTED]> wrote: > > Alright, I sent out a totally innocent question to the list and > > didn't get a > > single suggestion. I'm very disappointed in you people. > > > > So, let me say that I figured it out without your help. > > > > And I ain't saying what I did. > > > > So there. PPPHHT!!! > > > > -- Walt (my RAM disk is working great) Weaver > >Bozeman, Montana > > > > -Original Message- > > Sent: Thursday, November 08, 2001 10:39 AM > > To: Multiple recipients of list ORACLE-L > > > > > > Okay, this doesn't have much to do with Oracle other than the fact > > that I > > have been assigned with figuring out why this problem is occurring. > > > > We have a live chat application on Linux that uses Tomcat to manage > > its java > > servlets. A log is written to by the java processes, and this log > can > > get > > rather large. > > > > Problem is, these java processes keep some sort of a write lock on > > the log > > and we can't clear the log out. Using lsof, I can get a listing of > > the java > > processes holding a lock on the log. One such process looks like > > this: > > > > java 32180 root6w REG 48,1 186487009 18036 > > /usr/local/pkg/tomcat/tomcat-3.2.3/logs/servlet.log > > > > Bottom line is, how can I clear these write locks without killing > the > > java > > processes? Somebody must know how. I couldn't possibly the first > > person on > > earth to encounter this problem. > > > > Thanks, > > --Walt (learnin about chattr()) Weaver > > Bozeman, Montana > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Weaver, Walt > > 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: Weaver, Walt > > 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). > > > __ > Do You Yahoo!? > Find a job, post your resume. > http://careers.yahoo.com > -- > Please see the official ORACLE-L FAQ: http:
RE: Linux file locking question (semi-off topic)
Wait...so...you got the SDS stuff goingand it works...but you can't tell if it's faster? Aching for results, etc. -Original Message- Sent: Friday, November 09, 2001 2:35 PM To: Multiple recipients of list ORACLE-L (Acually 4X10 is THE answer for us. Walt's on a 4X10-4-days-off weekend and is probably flying around somewhere as I write. We have a 4X10 schedule and we get to arrange the days to maximize our weekends. Hmmm... I was the one who made out the schedule so how is it that Walt got the 4 day weekend? Oh well, I get a 3 dayer for my B-Day next Friday.) ANYWAY... We got the RAM disk running just fine but we haven't developed any comparative benchmarks just yet. We have this home built utility and Walt used it to simulate 1,000 users doing stuff a couple of days ago. (The utility was called "pounder" but has been enhanced and renamed to "hell bore.") We loaded sample data from one of our largest sites for our first "test" and everything worked fine even when we submitted a "report from hades" with a query that returns 2.2 million rows. (Don't ask!) For a first pass we put the redo on the RAM disk together with a tablespace dedicated to some particularly busy indexes. Maybe we'll get some time to be more thorough about this and do some before and after comparisons but probably not... NUMBERS! We need numbers! Sigh... Will keep you advised on this. Clueless in Montana, Steve Orr -Original Message- Sent: Friday, November 09, 2001 11:28 AM To: Multiple recipients of list ORACLE-L well duh the answer to EVERYTHING is 42 --- "Orr, Steve" <[EMAIL PROTECTED]> wrote: > OK... it's 42! Nice kitty... > > > > -Original Message- > Sent: Friday, November 09, 2001 6:31 AM > To: Multiple recipients of list ORACLE-L > > > Walt, > > but but but.. I didn't know the answer. I didn't even really > understand > the question! PLEASE tell me the answer, please? Pretty please? > Pretty > please with whipped cream and TWO maraschino cherries on top? > > Rachel > > --- "Weaver, Walt" <[EMAIL PROTECTED]> wrote: > > Alright, I sent out a totally innocent question to the list and > > didn't get a > > single suggestion. I'm very disappointed in you people. > > > > So, let me say that I figured it out without your help. > > > > And I ain't saying what I did. > > > > So there. PPPHHT!!! > > > > -- Walt (my RAM disk is working great) Weaver > >Bozeman, Montana > > > > -Original Message- > > Sent: Thursday, November 08, 2001 10:39 AM > > To: Multiple recipients of list ORACLE-L > > > > > > Okay, this doesn't have much to do with Oracle other than the fact > > that I > > have been assigned with figuring out why this problem is occurring. > > > > We have a live chat application on Linux that uses Tomcat to manage > > its java > > servlets. A log is written to by the java processes, and this log > can > > get > > rather large. > > > > Problem is, these java processes keep some sort of a write lock on > > the log > > and we can't clear the log out. Using lsof, I can get a listing of > > the java > > processes holding a lock on the log. One such process looks like > > this: > > > > java 32180 root6w REG 48,1 186487009 18036 > > /usr/local/pkg/tomcat/tomcat-3.2.3/logs/servlet.log > > > > Bottom line is, how can I clear these write locks without killing > the > > java > > processes? Somebody must know how. I couldn't possibly the first > > person on > > earth to encounter this problem. > > > > Thanks, > > --Walt (learnin about chattr()) Weaver > > Bozeman, Montana > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Weaver, Walt > > 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: Weaver, Walt > > 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 com
OT : RE: Linux file locking question (semi-off topic)
"pounder", "hell bore." & "report from hades" sounds like an interesting place to work. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Friday, November 09, 2001 3:05 PM To: Multiple recipients of list ORACLE-L Wait...so...you got the SDS stuff goingand it works...but you can't tell if it's faster? Aching for results, etc. -Original Message- Sent: Friday, November 09, 2001 2:35 PM To: Multiple recipients of list ORACLE-L (Acually 4X10 is THE answer for us. Walt's on a 4X10-4-days-off weekend and is probably flying around somewhere as I write. We have a 4X10 schedule and we get to arrange the days to maximize our weekends. Hmmm... I was the one who made out the schedule so how is it that Walt got the 4 day weekend? Oh well, I get a 3 dayer for my B-Day next Friday.) ANYWAY... We got the RAM disk running just fine but we haven't developed any comparative benchmarks just yet. We have this home built utility and Walt used it to simulate 1,000 users doing stuff a couple of days ago. (The utility was called "pounder" but has been enhanced and renamed to "hell bore.") We loaded sample data from one of our largest sites for our first "test" and everything worked fine even when we submitted a "report from hades" with a query that returns 2.2 million rows. (Don't ask!) For a first pass we put the redo on the RAM disk together with a tablespace dedicated to some particularly busy indexes. Maybe we'll get some time to be more thorough about this and do some before and after comparisons but probably not... NUMBERS! We need numbers! Sigh... Will keep you advised on this. Clueless in Montana, Steve Orr -Original Message- Sent: Friday, November 09, 2001 11:28 AM To: Multiple recipients of list ORACLE-L well duh the answer to EVERYTHING is 42 --- "Orr, Steve" <[EMAIL PROTECTED]> wrote: > OK... it's 42! Nice kitty... > > > > -Original Message- > Sent: Friday, November 09, 2001 6:31 AM > To: Multiple recipients of list ORACLE-L > > > Walt, > > but but but.. I didn't know the answer. I didn't even really > understand > the question! PLEASE tell me the answer, please? Pretty please? > Pretty > please with whipped cream and TWO maraschino cherries on top? > > Rachel > > --- "Weaver, Walt" <[EMAIL PROTECTED]> wrote: > > Alright, I sent out a totally innocent question to the list and > > didn't get a > > single suggestion. I'm very disappointed in you people. > > > > So, let me say that I figured it out without your help. > > > > And I ain't saying what I did. > > > > So there. PPPHHT!!! > > > > -- Walt (my RAM disk is working great) Weaver > >Bozeman, Montana > > > > -Original Message- > > Sent: Thursday, November 08, 2001 10:39 AM > > To: Multiple recipients of list ORACLE-L > > > > > > Okay, this doesn't have much to do with Oracle other than the fact > > that I > > have been assigned with figuring out why this problem is occurring. > > > > We have a live chat application on Linux that uses Tomcat to manage > > its java > > servlets. A log is written to by the java processes, and this log > can > > get > > rather large. > > > > Problem is, these java processes keep some sort of a write lock on > > the log > > and we can't clear the log out. Using lsof, I can get a listing of > > the java > > processes holding a lock on the log. One such process looks like > > this: > > > > java 32180 root6w REG 48,1 186487009 18036 > > /usr/local/pkg/tomcat/tomcat-3.2.3/logs/servlet.log > > > > Bottom line is, how can I clear these write locks without killing > the > > java > > processes? Somebody must know how. I couldn't possibly the first > > person on > > earth to encounter this problem. > > > > Thanks, > > --Walt (learnin about chattr()) Weaver > > Bozeman, Montana > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Weaver, Walt > > 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: Weaver, Walt > > 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
RE: OT : RE: Linux file locking question (semi-off topic)
I still like the bit about the Tower Controller knowing Walt. -Original Message- Sent: Friday, November 09, 2001 3:26 PM To: Multiple recipients of list ORACLE-L "pounder", "hell bore." & "report from hades" sounds like an interesting place to work. Tom Mercadante Oracle Certified Professional -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross 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).