RE: What to check?

2003-03-03 Thread Whittle Jerome Contr NCI
Title: RE: What to check? David, I'd check that they are using the same exact script on all three machines. Jerry Whittle ASIFICS DBA NCI Information Systems Inc. [EMAIL PROTECTED] 618-622-4145 -Original Message- From: Nguyen, David M [SMTP:[EMAIL PROTECTED] Someone

RE: What to check?

2003-03-03 Thread Nguyen, David M
Title: RE: What to check? All three machines having the same amount of CPUs and memory, and he uses the same script to run on three machines, some of tables containing hundred thousands of records. Below is a portion of his script. Is there a way to improve his SQL command? @Dumptables.sql

RE: What to check?

2003-03-03 Thread Mark Richard
: [EMAIL PROTECTED]Subject: RE: What to check? Sent

Re: What to check?

2003-03-02 Thread Mark Richard
David, Have you checked the most obvious... The number of rows in the table? Also, you say three different Solaris8 machines... How different are they? Are the disk subsystems the same on all three? How identical are their configurations? How similar are the init.ora files on all three

Re: What to check?

2003-03-01 Thread Jared Still
David, You need to see what is taking all the time on the 'slow' machine. Ask the person with the script to put this at the top of the script for the next run: alter session set events '10046 trace name context forever, level 8'; Explanation of level: -- level 4 is bind values -- level 8 is

RE: What to check?

2003-03-01 Thread Khedr, Waleed
Are they dumping the table over the network or locally? If it's over the network, then probably there is a slow network connection or/and small array fetch. Checking the number of fetches in a trace/tkprof file could help. Also pre-compiled languages have many bugs that disable array fetch.

Re: What to check?

2003-02-28 Thread Stephane Faroult
Nguyen, David M wrote: Someone writes a SQL script to dump a table on three different database on three different Solaris8 machines, he complaines one of machines took 6 hours to dump a table while other two's only take one hour. He asks me to investigate why. I log into the machine in

Re: What to check?

2003-02-28 Thread Jeremiah Wilton
The wait events. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Fri, 28 Feb 2003, Nguyen, David M wrote: Someone writes a SQL script to dump a table on three different database on three different Solaris8 machines, he complaines one of machines took 6 hours to dump a table while

RE: what to check in alert.log

2001-09-06 Thread Srini . Chavali
by Jared. - Kirti -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, September 05, 2001 7:20 PM To: Multiple recipients of list ORACLE-L Subject: Re: what to check in alert.log Alex, Here's what I currently look

RE: what to check in alert.log

2001-09-05 Thread Taylor, Shirley
I check for these strings: ORA- TNS- trc cannot exceeded That works well for me. Systems Admin Operations | Admin. et Exploit. des systèms Technology Services | Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des

Re: what to check in alert.log

2001-09-05 Thread Arich Henneman
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Arich Henneman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Re: what to check in alert.log

2001-09-05 Thread Arich Henneman
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Arich Henneman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Re: what to check in alert.log

2001-09-05 Thread Jared . Still
Alex, Here's what I currently look for: At the begging of a line ORA or TNS Anywhere in the line 'crash' or 'recovery'; Sometimes generates more mail than I care for. :) Jared

Re: what to check in alert.log

2001-09-05 Thread Arich Henneman
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Arich Henneman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Re: what to check in alert.log

2001-09-05 Thread Arich Henneman
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Arich Henneman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

RE: what to check in alert.log

2001-09-05 Thread Deshpande, Kirti
I also add 'corrupt' in the list by Jared. - Kirti -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, September 05, 2001 7:20 PM To: Multiple recipients of list ORACLE-L Subject: Re: what to check in alert.log Alex, Here's what I

Re: what to check in alert.log

2001-09-05 Thread Arich Henneman
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Arich Henneman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Re: what to check in alert.log

2001-09-05 Thread Joe Testa
please turn off the autoresponder(or doing it manually) and sending empty messages. joe Arich Henneman wrote: -- Joe Testa Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) IM: n8xcthome or joen8xct

RE: what to check in alert.log

2001-09-05 Thread Arich Henneman
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Arich Henneman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

RE: what to check in alert.log

2001-09-05 Thread Arich Henneman
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Arich Henneman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists