| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Problem running a report
If the report was creating a large output file on the client (remote) PC,
that would explain
the waits on SQL*Net message from client. [the client would be SQL*Plus or
Reports
on the PC]. Depending on the network latency, the perceived runtime of the
report
can vary between sites.
Does the report file have to be created on the client PCs ?
Can you run it as a server process, ZIP the output file on the server and
then FTP it
to the clients ?
If the report has to run from the PC, try tuning SQLNet (SDU, TDU) and the
Buffer size.
If you are using SQL*Plus, just doing a SET TERMOUT OFF with a SPOOL
<myoutputfile>
will make a big difference.
Hemant K Chitale
Principal DBA
Chartered Semiconductor Manufacturing Ltd
"Babich , Sergey" <SBabich_at_handexmail.com> 27/02/2002 04:30 AM Sent by: root_at_fatcity.com
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
cc: (bcc: CHITALE Hemant Krishnarao/IT/CHRT/ST Group)
Subject: RE: Problem running a report
Thanks to everyone who responded. The database is centralized. Yesterday I
PINGed some machines in different offices (and TRACERTed, too) right from
the server, and the response time was under 100 msec. However, some offices
reported it to have run normally. That particular report creates a big file
on C: (local machine) which raises the question if the machine had enough
space on that drive and how fragmented it was... Oh, users....
Best regards to everyone,
Sergey
-----Original Message-----
Sent: Tuesday, February 26, 2002 2:54 PM
To: Multiple recipients of list ORACLE-L
Are you using remote connections to a centralized database, or does each office have its own database?
Tracert and netstat commands should help you figure out if its a network issue.
Regards
Raj
"Babich ,
Sergey" To: Multiple recipients of
list ORACLE-L <ORACLE-L_at_fatcity.com>
<SBabich_at_hande cc:
xmail.com> Subject: Problem running a
report
Sent by:
root_at_fatcity.c
om
February 26,
2002 02:18 PM
Please respond
to ORACLE-L
Hi, ladies and gentlemen,
Here is a good one. We have 25 offices nation wide, running similar
reports. At the headquarters the one in consideration takes 12 min to
complete. Any other office (WAN) it gets stuck and takes a few hours if it
completes at all. Here is the output from V$SESSION_WAIT for the session:
SID SEQ# EVENT P1TEXT P1 P1RAW P2TEXT P2 P2RAW P3TEXT P3 P3RAW WAIT_TIMESEC_WT STATE
SID SEQ# EVENT P1TEXT P1 P1RAW P2TEXT P2 P2RAW P3TEXT P3 P3RAW WAIT_TIMESEC_WT STATE
At the headquarters (LAN) it shows the same event after scattered read and
it is done. Could that be a SQL*Net issue between LAN and WAN?
Any ideas are appreciated as always.
TIA,
Sergey
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: Rajesh.Rao_at_jpmchase.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing ListsReceived on Wed Feb 27 2002 - 23:33:20 CST
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (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: Babich , Sergey INET: SBabich_at_handexmail.com 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: ListGuru_at_fatcity.com (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: INET: hemantchitale_at_charteredsemi.com 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: ListGuru_at_fatcity.com (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).
 |
 |