Hi experts,
I have some questions on Oracle partition and truncate. I would be
grateful of any of your experience here.
- Truncate - Concept
Here, I truncate a partition. It takes around 10 seconds. Is it
fast or slow? Is it tunable? For your information, there are 2
partitions: one partition is empty (0 records), while the other
partition has a total of 120,000 records. When I truncate the empty
partition, the statement returns immediately. On the other hand, when
I truncate the other partition, it takes around 10 seconds.
The problem is that I don't know whether the 10 sec is a good
enough figure or not. For Oracle, what are the steps that will be
performed in a "TRUNCATE" statement? How to measure the performance
of each sub-steps? Or, if it is really too slow, any way I can
improve the situation?
- Select a partition while truncating another partition of the same
table
While the statement "ALTER TABLE TEST_PART TRUNCATE PARTITION
part_a" is being issued, I issue a "select" statement concurrently in
another session. In this case, will the select be blocked until the
truncate operation end? If so, any ideas how to prevent such blocking
from happening? Here, I know that my result must not be inside the
partition which is undergoing the truncate statement.
Thanks very much in advance!
Cheers,
Johnny.
Received on Mon Jul 21 2003 - 07:46:20 CDT