Need info about DCTM internal query

Hi All,

We are working with DBA team to find the performance issues in our Documentum system. DBA found that following query is executing thousands of time in span of 1 hour and they suggested that caching the dm_folder_sp view would imporve the performance. It has around 1.2 million rows in it.

select all dm_folder.r_object_id from dm_folder_sp dm_folder where (dm_folder.r_object_id in (select r_object_id from dm_folder_r where r_folder_path=:"SYS_B_0")) and (dm_folder.i_has_folder = :"SYS_B_1" and dm_folder.i_is_deleted = :"SYS_B_2")

I am trying to find when this query gets executed by Documentum.Is it wise to cache the view?

Any ideas or inputs greatly appreciated.

Thanks in advance for your response.

Kind regards,

Raju

Find more posts tagged with

Note:

If there are Accepted Answers, those will be shown by default. You can switch to 'All Replies' by selecting the tab below.

Accepted answers

mszurap

This query does not seems like a standard Documentum job's query, it's rather one of your custom job (which is querying folders by path).

It's not recommended to cache the view in the database, I would prefer to update the table and index stats, or even a table and index rebuild would be a reasonable move.

Or if you have the code of program which is executing the queries, then you should think about what could be tuned there.

All comments

mszurap

This query does not seems like a standard Documentum job's query, it's rather one of your custom job (which is querying folders by path).

It's not recommended to cache the view in the database, I would prefer to update the table and index stats, or even a table and index rebuild would be a reasonable move.

Or if you have the code of program which is executing the queries, then you should think about what could be tuned there.