RE: DB Parameters

2003-10-10 Thread Rich Gesler
You may also want to check for any triggers tied to these tables as well... Rich -Original Message- Walid Alkaakati Sent: Friday, October 10, 2003 9:45 AM To: Multiple recipients of list ORACLE-L HI , I have noticed that both deleting and inserting is too slow (about five hours to

RE: DB Parameters

2003-10-10 Thread Cary Millsap
I stand corrected: tracing probably won't work because the cr and cu values would wrap. Just kidding. :) BEFORE YOU TRY disabling indexes (or anything else for that matter), I strongly advise you to trace the program so you can see where it spends its time. Even if you have guessed the solution

RE: DB Parameters

2003-10-09 Thread Sinardy Xing
use bind variable -Original Message- Sent: 09 October 2003 16:29 To: Multiple recipients of list ORACLE-L Hi List , Can you help me please , What are the database parameters that i have to increase or modify in order to increase the speed of my ddl statments ,i have a statment

Re: DB Parameters

2003-10-09 Thread ManojKr Jha
Hi, What is volume of ur table, and 4 records that u want to delete is what % of total records. One thing that u can try is introduce index hint in delete statement. The optimal solution can be find out only if know exact statement and volume of tables and indexes. Also can u check the size

Re Db Parameters

2003-10-09 Thread Walid Alkaakati
Hi Can You please give an example on using bund varables .. THANKS

RE: DB Parameters

2003-10-09 Thread DENNIS WILLIAMS
Walid TRUNCATE Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, October 09, 2003 3:29 AM To: Multiple recipients of list ORACLE-L Hi List , Can you help me please , What are the database parameters that i have to

RE: DB Parameters

2003-10-09 Thread Henry Poras
Lee? -Original Message- Walid Alkaakati Sent: Thursday, October 09, 2003 4:29 AM To: Multiple recipients of list ORACLE-L Hi List , Can you help me please , What are the database parameters that i have to increase or modify in order to increase the speed of my ddl statments ,i have

RE: DB Parameters

2003-10-09 Thread Robertson Lee - lerobe
No -Original Message- Sent: 09 October 2003 14:15 To: Multiple recipients of list ORACLE-L Lee? -Original Message- Walid Alkaakati Sent: Thursday, October 09, 2003 4:29 AM To: Multiple recipients of list ORACLE-L Hi List , Can you help me please , What are the

Re: DB Parameters

2003-10-09 Thread Mladen Gogala
You can try with the _db_perf_silver_bullet=42, which is the straightforward approach, or you can be a backward hick like me and trace your session with 10046, see what events are you waiting for and adjust your application, OS and instance parameters to really solve the problem. On Thu,

Re: DB Parameters

2003-10-09 Thread Wolfgang Breitling
I was tempted to point to the /*+ _try_harder */ hint (revealed by Jonathan Lewis at this year's IOUG), but that won't be available until Oracle 10. Until then we have to use the old methods of identifying where the time is spent and figure out what can be done to eliminate as much of it as

RE: DB Parameters

2003-10-09 Thread Cary Millsap
Walid, It's unlikely that a database parameter will provide the solution to your problem. Trace the DELETE if you can (DBMS_SUPPORT.START_TRACE_IN_SESSION), to see what's taking so long. Odds are that your DELETE is poorly optimized SQL that's simply doing more work than it needs to be doing.

RE: DB Parameters

2003-10-09 Thread Guang Mei
Does the table you are deleting has any child table(s)? If yes, then are the foreign keys in the child table(s) indexed? Guang -Original Message- Wolfgang Breitling Sent: Thursday, October 09, 2003 11:34 AM To: Multiple recipients of list ORACLE-L I was tempted to point to the /*+