Home » RDBMS Server » Server Administration » slow truncate in 10.2.0.2
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;...

Previous Topic: Oracle on linux - is it free?
Next Topic: blocking user
Goto Forum:
  


Current Time: Fri Dec 02 12:10:59 CST 2016

Total time taken to generate the page: 0.11913 seconds