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
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
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
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
Hi
Can You please give an example on using bund varables ..
THANKS
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
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
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
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,
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
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.
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 /*+
12 matches
Mail list logo