| slow truncate in 10.2.0.2 [message #238355] |
Thu, 17 May 2007 09:59 |
mjschwenger
Messages: 137
Registered: July 2005
Location: US
|
Senior Member |
|
|
I have the quesry below executing over 35,000 times when our test suits are running on 10.2.0.2 which causes a lot of time and CPU consumption. The same tests (no difference) are running on 10.1.0.4 with no problem for years now.
What is new to 10.2 version and how can I fix this?
(the tests suit creates populates, selects from tables, truncates them - I found out that the truncate statements is slow in 10.2)
The audit is turned off on the server.
Thanks a lot, mj
BEGIN
BEGIN
IF (xdb.DBMS_XDBZ0.is_hierarchy_enabled_internal(sys.dictionary_obj_owner, sys.dictionary_obj_name, sys.dictionary_obj_owner))
THEN
xdb.XDB_PITRIG_PKG.pitrig_truncate(sys.dictionary_obj_owner, sys.dictionary_obj_name);
END IF;...
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
