| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.misc -> Re: Operations in huge transaction slow down suddenly. Why?
Some things to idly wonder about:
Which version of Oracle and platform? CBO?
How many indices on the table?
Are you using DMT? Perhaps there is some contention and thrashing going on as indices and tables get more segments.
Are you using a journalled file system?
Tried oraperf.com?
jg
-- @home.com is bogus. http://www.ftc.gov/os/2004/12/041216canspamfrn.pdfReceived on Fri Dec 17 2004 - 18:42:52 CST
 |
 |