RE: Slow SQL*Plus connect.

-Original Message- Sent: Wednesday, January 22, 2003 11:49 AM To: Multiple recipients of list ORACLE-L Subject:RE: Slow SQL*Plus connect. How big is the listener log file?? do you truncate/rename it on regular basis?? just a thought. Sunil Nookala Dell Corp. -Original Message

RE: Slow SQL*Plus connect.

, 2003 11:49 AM To: Multiple recipients of list ORACLE-L Subject:RE: Slow SQL*Plus connect. How big is the listener log file?? do you truncate/rename it on regular basis?? just a thought. Sunil Nookala Dell Corp. -Original Message- Sent: Wednesday, January 22, 2003 4:09 AM

RE: Slow SQL*Plus connect.

: Wednesday, January 22, 2003 11:49 AM To: Multiple recipients of list ORACLE-L Subject:RE: Slow SQL*Plus connect. How big is the listener log file?? do you truncate/rename it on regular basis?? just a thought. Sunil Nookala Dell Corp. -Original Message- Sent: Wednesday, January 22

RE: Slow SQL*Plus connect.

If the box is swapping memory, connections can be slow since memory has to allocated for the connection. Just one possibility. -Original Message- We have experienced a *very* slow connect time to a 9.0.1 database via SQL*Plus (and other apps as well) on a Win2K machine, -- Please

RE: Slow SQL*Plus connect.

How big is the listener log file?? do you truncate/rename it on regular basis?? just a thought. Sunil Nookala Dell Corp. -Original Message- Sent: Wednesday, January 22, 2003 4:09 AM To: Multiple recipients of list ORACLE-L Hi All, We have experienced a *very* slow connect time to a

RE: Slow SQL*Plus connect.

Is otrace enabled? Note: 1020763.6 Note: 45482.1 Tim -Original Message- Sent: Wednesday, January 22, 2003 5:09 AM To: Multiple recipients of list ORACLE-L Hi All, We have experienced a *very* slow connect time to a 9.0.1 database via SQL*Plus (and other apps as well) on a Win2K

RE: slow SQL query, diagnosis using 10046 trace event

Suhen, Look at what you are doing : Query Plan select orgplvee.org_lvl_parent ,prdplvee.prd_lvl_parent , (NVL(invbalee.on_hand_qty,0)+NVL(to_intrn_qty,0)), (NVL(invbalee.on_hand_retl,0)+NVL(to_intrn_retl,0)), (NVL(invbalee.on_hand_cost,0)+NVL(to_intrn_cost,0)) from invbalee ,orgplvee

RE: Slow sql

Hi Roland, I would suggest that it pretty much depends on the number of rows that are being returned from your select statement as well as the way the select statement has been put together. Try cutting the select statement from the insert and running it against an explain plan to determine

Re: Slow sql

Hi, it must be doing full table scan.check your column positions of the indexes in table user_ind_columns and change your where condition according to the column positions. rukmini - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, August

RE: Slow sql

Statistics can in fact hurt. If your queries are tuned for rule based optimizer, it is very possible that cost base will perform suboptimal, perhaps a little, perhaps a lot. You may need to tune the database to be more efficient for CBO by changing parameters. Although adding statistics and