|
-
Do a simple test to check the oracle release is bug free with the LMT.
I found a bug in LMT in 9i.
Create a LMT with initial and next size 16K.
Create a table on this new tablespace.
Insert rows using a PL/SQL block so that number of extents can reach around 30000. Then truncate the table. Wait and watch how much time Oracle needs to truncate the table.
If the table is truncated within 5 to 10 minutes, then you are safe and you can use LMT. If not, do not use LMT.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|
Reply With Quote