The views expressed on this blog are my own and do not necessarily reflect the views of Oracle.

Saturday, 2 March 2013

Maintaining Trees

Often there are chances that your tree goes out of sync with the physical objects as the tree ages. This can happen due to deletion of a record from the application designer but not updating the same in the query tree. Also bad sql’s on Meta tables can also the tree in a bad shape.

If you are to find and repair these errors in the tree manually, then it is going to be a nightmare for the maintenance team.

Although not used by many, Peoplesoft has delivered a page solely for the purpose of repairing the trees. This page has variety options to repair various kinds of damages to the tree. You need to select the option and run the process so that the tree is repaired in the background.

The navigation to this page is : Tree Manager > Tree Utilities > Repair Tree

The various options to repair the tree includes

1.       Tree Audits – Run audit on selected tree.

2.       Correct Level Numbers – Corrects the nodes level number if it is wrong.

3.       Correct Parent node numbers – Corrects the node numbers of parent nodes.

4.       Delete Orphan Tree Objects – Deletes orphan objects from the tree.

5.       Remove Tree Branches – To remove all branches from a tree.

6.       Remove tree reservations – Removes reservations on a tree so that other actions can be performed on it.

7.       Reset Tree node gap – Evenly re-distributes tree node and their node numbers.

               8. Update Tree Table Statistics – Whenever a large dml changes are happened on the tree, run this utility to impro


  1. I had to call up the Centurion tree cutters to remove a tree which was weekend by a huge storm, so that it could help preventing some serious accident.

  2. Not a solitary second abandoned abandoning me in absolute shock.
    Hobby Plants

  3. Those on tree tops are controlled to develop upwards against gravity(geotropic).Tree Trimming Roseville

  4. In a space that is overgrazed, cows not just undermine the populaces of the regular grasses that contend with mesquite trees for water, yet they additionally help the mesquites spread by eating and scattering the seeds. As Frank Dobie puts it, "The white man planted with over-touching; Emergency Tree Service Elk Grove

  5. Go for registered contractors that are permitted by your local state to operate. You can do an online search to find tree removal services or you can ask referrals from friends. Stump Removal Rocklin

  6. A decent tree evacuation specialist organization offers a total help: managing, pruning, expulsion, stump expulsion, land clearing, and even crisis tidy up. removing small and big trees

  7. Great thanks for sharing this article post. Really thank you! Really Cool.Long Beach Tree Pruning