Home » RDBMS Server » Server Administration » slow truncate in
slow truncate in [message #238355] Thu, 17 May 2007 09:59
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 which causes a lot of time and CPU consumption. The same tests (no difference) are running on 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

IF (xdb.DBMS_XDBZ0.is_hierarchy_enabled_internal(sys.dictionary_obj_owner, sys.dictionary_obj_name, sys.dictionary_obj_owner))
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: Wed Jul 26 18:08:59 CDT 2017

Total time taken to generate the page: 0.36090 seconds